Getting Eror
Posted: 10 Feb 2013, 23:10
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
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