Error while Migration from Joomla 1.5 to Joomla 2.5

[chrissie]

Hello,

i upgraded my joomla from Joomla 1.5 to joomla 2.5 and also of course my phocagallery.
So i did everything step by step like it is written in your documentation.
First i updated the phocagallery in joomla 1.5 to the newsest version, than i installed the new version in joomla 2.5
and imported the tables in my new database. Than i took the "upgrade" button and now i have the following errors
in my component under the button "categories":

Code: Select all

JDatabaseMySQLi::query: 1054 - Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS parentcat_title, c.id AS parentcat_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno,v.average AS ratingavg,cc.countid AS countid FROM `j25_phocagallery_categories` AS a LEFT JOIN `j25_languages` AS l ON l.lang_code = a.language LEFT JOIN j25_users AS uc ON uc.id=a.checked_out LEFT JOIN j25_viewlevels AS ag ON ag.id = a.access LEFT JOIN j25_phocagallery_categories AS c ON c.id = a.parent_id LEFT JOIN j25_users AS ua ON ua.id = a.owner_id LEFT JOIN j25_phocagallery_votes_statistics AS v ON v.catid = a.id LEFT JOIN (SELECT cc.parent_id, count(*) AS countid FROM j25_phocagallery_categories AS cc GROUP BY cc.parent_id ) AS cc ON a.parent_id = cc.parent_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc

Under the button "images" i have the following error:

Code: Select all

JDatabaseMySQLi::query: 1054 - Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor,uua.id AS uploaduserid, uua.username AS uploadusername, uua.name AS uploadname,c.title AS category_title, c.id AS category_id, c.owner_id AS category_owner_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno,v.average AS ratingavg FROM `j25_phocagallery` AS a LEFT JOIN `j25_languages` AS l ON l.lang_code = a.language LEFT JOIN j25_users AS uc ON uc.id=a.checked_out LEFT JOIN j25_users AS uua ON uua.id=a.userid LEFT JOIN j25_phocagallery_categories AS c ON c.id = a.catid LEFT JOIN j25_users AS ua ON ua.id = c.owner_id LEFT JOIN j25_phocagallery_img_votes_statistics AS v ON v.imgid = a.id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc

Is it possible to help me with that? Would be great!

[Jan]

Hi, in your tables, language columns are missing?

But did you follow the guide exactly, there is written, that you should install the component in Joomla! 2.5 and while installation, the columns are normally created

Jan

[chrissie]

Yes i installes it , of course, but took the upgrade button. Otherwise i dont know how to integrate the old data in my new version?
Was that wrong?

[Jan]

Hi, just follow this guide:
https://www.phoca.cz/documents/50-phoca/ ... -joomla-25
Jan

[chrissie]

so i did, but it doesnt work.

[Jan]

Hi, in the guide, there is written, that the component should be installed not upgraded in Joomla! 2.5 which means, that the columns cannot be missing as installation procedure adds them

Jan