Error unknown columns in phocagallery after upgrading

[fisherski]

I upgraded to joomla 3.3 from 1.5 and now I have big problems with phoca gallery and phoca download I get the following errors:
Would it be easier to just delete the tables and reinstall the two components again or run some scripts on the DB tables? Either way I don't know how.

Phoca gallery ERRORS
1- 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 `eadbc_phocagallery_categories` AS a LEFT JOIN `eadbc_languages` AS l ON l.lang_code = a.language LEFT JOIN eadbc_users AS uc ON uc.id=a.checked_out LEFT JOIN eadbc_viewlevels AS ag ON ag.id = a.access LEFT JOIN eadbc_phocagallery_categories AS c ON c.id = a.parent_id LEFT JOIN eadbc_users AS ua ON ua.id = a.owner_id LEFT JOIN eadbc_phocagallery_votes_statistics AS v ON v.catid = a.id LEFT JOIN (SELECT cc.parent_id, count(*) AS countid FROM eadbc_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

2. Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,ua.id AS ratinguserid, ua.username AS ratingusername, ua.name AS ratingname,uc.name AS editor,c.title AS category_title, c.id AS category_id FROM `eadbc_phocagallery_votes` AS a LEFT JOIN `eadbc_languages` AS l ON l.lang_code = a.language LEFT JOIN eadbc_users AS ua ON ua.id=a.userid LEFT JOIN eadbc_users AS uc ON uc.id=a.checked_out LEFT JOIN eadbc_phocagallery_categories AS c ON c.id = a.catid GROUP BY a.id ORDER BY ua.username asc Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,ua.id AS ratinguserid, ua.username AS ratingusername, ua.name AS ratingname,uc.name AS editor,c.title AS category_title, c.id AS category_id FROM `eadbc_phocagallery_votes` AS a LEFT JOIN `eadbc_languages` AS l ON l.lang_code = a.language LEFT JOIN eadbc_users AS ua ON ua.id=a.userid LEFT JOIN eadbc_users AS uc ON uc.id=a.checked_out LEFT JOIN eadbc_phocagallery_categories AS c ON c.id = a.catid GROUP BY a.id ORDER BY ua.username asc LIMIT 0, 20 Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,ua.id AS ratinguserid, ua.username AS ratingusername, ua.name AS ratingname,uc.name AS editor,c.title AS category_title, c.id AS category_id FROM `eadbc_phocagallery_votes` AS a LEFT JOIN `eadbc_languages` AS l ON l.lang_code = a.language LEFT JOIN eadbc_users AS ua ON ua.id=a.userid LEFT JOIN eadbc_users AS uc ON uc.id=a.checked_out LEFT JOIN eadbc_phocagallery_categories AS c ON c.id = a.catid GROUP BY a.id ORDER BY ua.username asc LIMIT 0, 20

[Jan]

Hi, as the sql errors say - the a.language column is missing.

Try to see this guide:

https://www.phoca.cz/documents/50-phoca/ ... -joomla-25

It is guide for 1.5 to 2.5 but it should be similar for 3

When the component will be installed, it will add the a.language columns and then the data will be set by import.

Jan