Getting error when click on category

Phoca Gallery - image gallery extension
ismaelhaider
Phoca Newbie
Phoca Newbie
Posts: 1
Joined: 04 Apr 2013, 12:58

Getting error when click on category

Post by ismaelhaider »

You can Access my admin panel , I need to resolve this issue urgently,

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/content/50/8458850/html/developmentway/libraries/joomla/database/database/mysql.php on line 293

After Debug On, Below is errors which will be shown,

500 - An error has occurred.
JDatabaseMySQL::query: 1146 - Table 'developmentway.w2med_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 `w2med_phocagallery_categories` AS a LEFT JOIN `w2med_languages` AS l ON l.lang_code = a.language LEFT JOIN w2med_users AS uc ON uc.id=a.checked_out LEFT JOIN w2med_viewlevels AS ag ON ag.id = a.access LEFT JOIN w2med_phocagallery_categories AS c ON c.id = a.parent_id LEFT JOIN w2med_users AS ua ON ua.id = a.owner_id LEFT JOIN w2med_phocagallery_votes_statistics AS v ON v.catid = a.id LEFT JOIN (SELECT cc.parent_id, count(*) AS countid FROM w2med_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
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Getting error when click on category

Post by Jan »

Hi, your server misses some tables in your database, see:
https://www.phoca.cz/documents/16-joomla ... ent-errors
Jan
If you find Phoca extensions useful, please support the project
Post Reply