500 error in phocagallery 3.0.2
Posted: 15 Oct 2011, 10:28
Installed the PG component 3.0.2 on a Joomla 1.7.1.
Clicking on "Category Ratings" or "Users" (perhaps others?) in the control panel, brings up the following page:
Clicking on "Category Ratings" or "Users" (perhaps others?) in the control panel, brings up the following page:
500 - An error has occurred.
Table 'dhhisunm_jdb.ha17_phocagallery_votes' doesn't exist 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 `ha17_phocagallery_votes` AS a LEFT JOIN `ha17_languages` AS l ON l.lang_code = a.language LEFT JOIN ha17_users AS ua ON ua.id=a.userid LEFT JOIN ha17_users AS uc ON uc.id=a.checked_out LEFT JOIN ha17_phocagallery_categories AS c ON c.id = a.catid GROUP BY a.id ORDER BY ua.username asc Table 'dhhisunm_jdb.ha17_phocagallery_votes' doesn't exist 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 `ha17_phocagallery_votes` AS a LEFT JOIN `ha17_languages` AS l ON l.lang_code = a.language LEFT JOIN ha17_users AS ua ON ua.id=a.userid LEFT JOIN ha17_users AS uc ON uc.id=a.checked_out LEFT JOIN ha17_phocagallery_categories AS c ON c.id = a.catid GROUP BY a.id ORDER BY ua.username asc LIMIT 0, 20 Table 'dhhisunm_jdb.ha17_phocagallery_votes' doesn't exist 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 `ha17_phocagallery_votes` AS a LEFT JOIN `ha17_languages` AS l ON l.lang_code = a.language LEFT JOIN ha17_users AS ua ON ua.id=a.userid LEFT JOIN ha17_users AS uc ON uc.id=a.checked_out LEFT JOIN ha17_phocagallery_categories AS c ON c.id = a.catid GROUP BY a.id ORDER BY ua.username asc Table 'dhhisunm_jdb.ha17_phocagallery_votes' doesn't exist 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 `ha17_phocagallery_votes` AS a LEFT JOIN `ha17_languages` AS l ON l.lang_code = a.language LEFT JOIN ha17_users AS ua ON ua.id=a.userid LEFT JOIN ha17_users AS uc ON uc.id=a.checked_out LEFT JOIN ha17_phocagallery_categories AS c ON c.id = a.catid GROUP BY a.id ORDER BY ua.username asc
Return to Control Panel