Error unknown columns in phocagallery after upgrading
Posted: 20 Nov 2014, 20:57
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
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