500 - An error has occurred.
Posted: 21 Mar 2012, 14:32
Iam using phoca gallery 3.2.0 Beta
While creating categories in phoca gallery version 3.2.0 (joomla 2.5 website) the following error is coming, please guide me.
500 - An error has occurred.
JDatabaseMySQLi::query: 1146 - Table 'thakur77_pr0apt.j25_phocagallery_categories' doesn't exist 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
Premarajan
While creating categories in phoca gallery version 3.2.0 (joomla 2.5 website) the following error is coming, please guide me.
500 - An error has occurred.
JDatabaseMySQLi::query: 1146 - Table 'thakur77_pr0apt.j25_phocagallery_categories' doesn't exist 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
Premarajan