forum.coppermine-gallery.net

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Miscellaneous => Topic started by: altenae on January 08, 2006, 07:17:00 pm

Title: Sometimes LAST UPLOADS gives me an error
Post by: altenae on January 08, 2006, 07:17:00 pm

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

Title: Re: Sometimes LAST UPLOADS gives me an error
Post by: Joachim Müller 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.

Title: Re: Sometimes LAST UPLOADS gives me an error
Post by: altenae on January 09, 2006, 08:46:38 am

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

Title: Re: Sometimes LAST UPLOADS gives me an error
Post by: Joachim Müller on January 09, 2006, 09:01:23 am

what mySQL version are you running?

Title: Re: Sometimes LAST UPLOADS gives me an error
Post by: altenae on January 09, 2006, 01:10:29 pm

Quote from: GauGau on January 09, 2006, 09:01:23 am

what mySQL version are you running?

MySQL 3.23.58

Edward

Title: Re: Sometimes LAST UPLOADS gives me an error
Post by: altenae on January 12, 2006, 07:25:11 pm

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