coppermine-gallery.com/forum

Sometimes when clicking on last uploads I receive the following error:

There was an error while processing a database query

After a few more clicks it suddenly works.

ANy idea why sometimes this error appears ?

edward

enable debug mode then to get the actual error message (the query that failed), not the debug_ouput. Post the error message here. A link to your page might help as well.

Quote from: GauGau on January 09, 2006, 08:11:21 AM
enable debug mode then to get the actual error message (the query that failed), not the debug_ouput. Post the error message here. A link to your page might help as well.

Here is de debug ouput (it took a wile when the error came)

While executing query "SELECT *, a.title as album_name, p.filename as filename FROM cpg132_pictures as p, cpg132_albums as a LEFT JOIN cpg132_exif as e ON concat('albums/',p.filepath,p.filename) = e.filename WHERE p.aid = a.aid AND approved = 'YES' AND aid IN (5)  ORDER BY pid DESC  LIMIT 0 ,12" on 0

mySQL error: Column: 'aid' in where clause is ambiguous


Anyone any idea what this means ??

Also it seems that the last uploads gives only an error when you are in an album.


Edward

what mySQL version are you running?

Quote from: GauGau on January 09, 2006, 09:01:23 AM
what mySQL version are you running?

MySQL 3.23.58

Edward

Quote from: GauGau on January 09, 2006, 09:01:23 AM
what mySQL version are you running?

I cannot find why this error is happening al the time. Does anyone knows what could be wrong ????

Edward