SOLVED: Empty list of pictures in back-end (administrator)

[jeroenkl]

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.

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

Please some advice how to solve this problem,

Regards,

Jeroen

[jeroenkl]

Problem solved by:

- uninstalling component;
- installing component;
- Import Phoca-gallery SQL tables;
- Continue installing component by selecting 'update'
- Repair menu items
- Done

[Benno]

Well done!

Kind regards,
Benno

[viktorg]

i have tried this : ALTER TABLE jos_phocagallery ADD userid int(11) NOT NULL default '0' and it works. Viktor

[Benno]

OK.

Kind regards,
Benno