[Solved] [SVN:509] Database error when clicked on Manage Images

« on: December 26, 2006, 02:19:20 am »

mikeho1980 Offline

Full Member

Dog Neighbor - http://www.dogneighbor.com

Posts: 161

[Solved] [SVN:509] Database error when clicked on Manage Images

Following message appear when clicked on 'Manage Images' in backend

Code:

DB function failed with error number 1054
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

Any idea?


« Last Edit: January 02, 2007, 10:34:04 am by mikeho1980 »	Logged

Dog Neighbor http://www.dogneighbor.com
Joomla v1.0.12 Stable UTF-8 Traditional Chinese
RS Gallery 2 v1.14.0 SVN:472
Alpha RSItems module v1.4.2
PHP 5.2.0 Apache 2.0 mySQL 5.0.27 utf8_general
Internet Explorer 7.0.6000.16546 Firefox 2.0.0.11

Reply #1

« on: December 26, 2006, 05:40:50 am »

Ronald Smit Offline

Administrator
Hero Member

Posts: 1214

Re: [SVN:509] Database error when clicked on Manage Images

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 Grin

). 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,


	Logged

Ronald Smit
RSGallery2 Developer
FAQ|Known issues

Reply #2

« on: December 26, 2006, 12:55:34 pm »

mikeho1980 Offline

Full Member

Dog Neighbor - http://www.dogneighbor.com

Posts: 161

Re: [SVN:509] Database error when clicked on Manage Images

okay
let me try and see then report
thx

Updated:

Thx that work great now.
It's cool~~~


« Last Edit: December 26, 2006, 01:02:03 pm by mikeho1980 »	Logged