Sometimes LAST UPLOADS gives me an error

[altenae]

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

[Joachim Müller]

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.

[altenae]

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

[Joachim Müller]

what mySQL version are you running?

[altenae]

what mySQL version are you running?

MySQL 3.23.58

Edward

[altenae]

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