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