Joomla 3.2 Phoca 4.0.4 create categories
Posted: 21 Nov 2013, 09:10
Hai, i just install phocagallery 4.0.4 inside joomla 3.2 and whenever i click categories, i get this error. Please help. Tq
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 `mo9c7_phocagallery_categories` AS a LEFT JOIN `mo9c7_languages` AS l ON l.lang_code = a.language LEFT JOIN mo9c7_users AS uc ON uc.id=a.checked_out LEFT JOIN mo9c7_viewlevels AS ag ON ag.id = a.access LEFT JOIN mo9c7_phocagallery_categories AS c ON c.id = a.parent_id LEFT JOIN mo9c7_users AS ua ON ua.id = a.owner_id LEFT JOIN mo9c7_phocagallery_votes_statistics AS v ON v.catid = a.id LEFT JOIN (SELECT cc.parent_id, count(*) AS countid FROM mo9c7_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
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 `mo9c7_phocagallery_categories` AS a LEFT JOIN `mo9c7_languages` AS l ON l.lang_code = a.language LEFT JOIN mo9c7_users AS uc ON uc.id=a.checked_out LEFT JOIN mo9c7_viewlevels AS ag ON ag.id = a.access LEFT JOIN mo9c7_phocagallery_categories AS c ON c.id = a.parent_id LEFT JOIN mo9c7_users AS ua ON ua.id = a.owner_id LEFT JOIN mo9c7_phocagallery_votes_statistics AS v ON v.catid = a.id LEFT JOIN (SELECT cc.parent_id, count(*) AS countid FROM mo9c7_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
