I tried to upgrade Coppermine from 1.4.22 to 1.4.26 at www.sarahwaynecallies.net
Since my upgrade, I have an error every time I try to load a page of the gallery: "There was an error while processing a database query". I contacted my host and there is nothing wrong with this server at the moment.
PS. Here is what I tried to do to solve the problem:
- tried to reupload all the Coppermine 1.4.26 files and run the update.php page (it worked but when I went back to the index.php, I had the same error)
- tried to go to phpMyAdmin and check/repair all the tables
- tried to install the Stramm modpack 1.4.24, hoping it would overwrite a possible corrupted file, and run the update.php page (same error)
Btw, I tried to log off, then log in. When I was logged in, I was brought back to the index.php and saw my pictures and albums, everything was working. But when I tried to access any category, I had the "error while processing a database query" problem.
Here is the Debug info:
While executing query "SELECT count(cpg1410_albums.aid) FROM cpg1410_pictures,cpg1410_albums WHERE cpg1410_pictures.aid = cpg1410_albums.aid AND approved = 'YES' AND cpg1410_pictures.cpg1410_pictures.aid IN (15,16,17,36,41,65,85,86,140) GROUP BY cpg1410_pictures.aid" on 0
mySQL error: Unknown column 'cpg1410_pictures.cpg1410_pictures.aid' in 'where clause'
File: /home2/sarahway/public_html/gallery2/include/functions.inc.php - Line: 248
Any idea? Thanks a lot!