MySQL problem when viewing picture

cewan

Joined: 2007-01-30
Posts: 17
Posted: Fri, 2009-07-10 09:50

I added an album from web server, then opened the album, then tried to show the second picture. I got this:
So here's the error:
There was an SQL error: Unknown column 'weight' in 'where clause' - SELECT COUNT(*) AS position FROM items WHERE parent_id = 2 AND `weight` < (SELECT `weight` FROM items WHERE id = 4) ORDER BY `weight` ASC

File: system/libraries/drivers/Database/Mysqli.php, line: 142

I am using the latest version from GIT (master branch)

 
bharat
bharat's picture

Joined: 2002-05-21
Posts: 7994
Posted: Mon, 2009-07-13 03:59

Is this a fresh install? We added the weight column sometime before alpha 4. If you had alpha 3, you have to reinstall because we only support upgrades from beta 1 forward.
---
Problems? Check gallery3/var/logs
bugs/feature req's | upgrade to the latest code | use git | help! vote!

 
cewan

Joined: 2007-01-30
Posts: 17
Posted: Mon, 2009-07-13 06:46

Alright, maybe I used the same database that got generated when I tried the alpha. Thanks for the reply!