SOLVED: Empty list of pictures in back-end (administrator)
Posted: 09 Aug 2011, 18:01
After updating Phoca Gallery to version 2.8.0 and updating Joomla to version 1.5.23, I can no longer view and organize pictures from the backend (in the administrator part of the site). I have no problem viewing pictures in the frontend. Also, no problems adding more pictures etc.
The problem is just, that I can't see / view pictures from the backend. This is the error I get when debugging.
Regards,
Jeroen
The problem is just, that I can't see / view pictures from the backend. This is the error I get when debugging.
Please some advice how to solve this problem,JDatabaseMySQL::query: 1054 - Unknown column 'a.userid' in 'on clause' SQL=SELECT a.*, cc.title AS category, cc.owner_id AS ownerid, u.name AS editor, v.average AS ratingavg, ua.username AS usercatname, uua.id AS uploaduserid, uua.username AS uploadusername, uua.name AS uploadname FROM jos_phocagallery AS a LEFT JOIN jos_phocagallery_categories AS cc ON cc.id = a.catid LEFT JOIN jos_phocagallery_img_votes_statistics AS v ON v.imgid = a.id LEFT JOIN jos_users AS u ON u.id = a.checked_out LEFT JOIN jos_users AS ua ON ua.id = cc.owner_id LEFT JOIN jos_users AS uua ON uua.id = a.userid ORDER BY category, a.ordering LIMIT 0, 20
Regards,
Jeroen