|
Title: [Solved] [SVN:509] Database error when clicked on Manage Images Post by: mikeho1980 on December 26, 2006, 02:19:20 am Following message appear when clicked on 'Manage Images' in backend
Code: DB function failed with error number 1054 Any idea?Unknown column 'a.checked_out' in 'on clause' SQL=SELECT a.*, cc.name AS category, u.name AS editor FROM jos_rsgallery2_files AS a LEFT JOIN jos_rsgallery2_galleries AS cc ON cc.id = a.gallery_id LEFT JOIN jos_users AS u ON u.id = a.checked_out ORDER BY a.gallery_id, a.ordering LIMIT 0, 50 Title: Re: [SVN:509] Database error when clicked on Manage Images Post by: Ronald Smit on December 26, 2006, 05:40:50 am Mike,
I have an idea where this might come from. You probably did an upgrade. in this particular case there are some database changes(I know we promised no DB changes in Nightly Builds ;D). In the SQL folder of the install file there is an entry called upgrade_1.11.11_to_1.11.12.sql. Apply this manually to the database and you will be fine. If this is too much, do a complete deinstall and install a clean version of the latest Nightly Build. Good luck, Title: Re: [SVN:509] Database error when clicked on Manage Images Post by: mikeho1980 on December 26, 2006, 12:55:34 pm okay
let me try and see then report thx Updated: Thx that work great now. It's cool~~~ |