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
Joomla 3.2 Phoca 4.0.4 create categories
-
sayasani
- Phoca Newbie

- Posts: 1
- Joined: 21 Nov 2013, 08:56
- Jan
- Phoca Hero

- Posts: 49144
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Joomla 3.2 Phoca 4.0.4 create categories
Hi, I see no error there, it is just listed the SQL, try to enable debug mode and see the debug information if you get there some more information 
Jan
Jan
If you find Phoca extensions useful, please support the project