mySQL error: Unknown column 'position' in 'order clause

[argosnomo]

Hi,

I recently upgraded Coppermine to v 1.4.8 from v.1.3.2 and have been having trouble accessing my pictures as any user other than the admin, as well as uploading new ones. I have run the upgrade.php file and have run the versioncheck file which shows me that everything has been updated properly.

The problem I get is a "Critical error: There was an error while processing a database query"

The debug output I get is the following:

While executing query "SELECT aid, pid, filename FROM cpg132_pictures WHERE aid = 0 ORDER BY position ASC, pid" on 0

mySQL error: Unknown column 'position' in 'order clause'

My site is available at www.carvajal.ca/pictures and I have created a test account usename: test passwrd: test1

I am no expert on these issues and computer language but have been able to maintain my site by reading posts on boards like this, so simple instructions would be greatly appreciated.

Thanks

[Tranz]

Hmm... I'm not sure if you really ran upgrade.php instead of update.php, but I ran update.php and the error no longer shows.

[argosnomo]

Wow, thanks so much! I just checked the files I had run yesterday and I had in fact run update.php as I was supposed to and not upgrade.

No idea what happended there, but thanks again for solving the problem.