Getting Eror

Phoca Gallery modules - modules for Phoca Gallery extension
naveed
Phoca Newbie
Phoca Newbie
Posts: 1
Joined: 10 Feb 2013, 23:07

Getting Eror

Post by naveed »

i install 4.0.0 Alpha3 version and its showing this erors if i click in admin panel
images , category or any where


0 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 `jos_phocagallery_categories` AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_phocagallery_categories AS c ON c.id = a.parent_id LEFT JOIN jos_users AS ua ON ua.id = a.owner_id LEFT JOIN jos_phocagallery_votes_statistics AS v ON v.catid = a.id LEFT JOIN (SELECT cc.parent_id, count(*) AS countid FROM jos_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




0 SQL=SELECT COUNT(a.id) AS count FROM jos_phocagallery AS a WHERE approved = 0 LIMIT 0, 1
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48386
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Getting Eror

Post by Jan »

Hi, do you get some specific error there (e.g. if you enable debug mode and php error reporting) ... running both sql queries in my phpMyAdmin shows outcomes, so the queries are Ok ... check if your phoca gallery tables are installed in your database.
https://www.phoca.cz/documents/16-joomla ... ent-errors
Jan
If you find Phoca extensions useful, please support the project
Post Reply