Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Sometimes LAST UPLOADS gives me an error  (Read 3487 times)

0 Members and 1 Guest are viewing this topic.

altenae

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 254
Sometimes LAST UPLOADS gives me an error
« 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
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Sometimes LAST UPLOADS gives me an error
« Reply #1 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.
Logged

altenae

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 254
Re: Sometimes LAST UPLOADS gives me an error
« Reply #2 on: January 09, 2006, 08:46:38 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
« Last Edit: January 09, 2006, 08:53:38 am by altenae »
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Sometimes LAST UPLOADS gives me an error
« Reply #3 on: January 09, 2006, 09:01:23 am »

what mySQL version are you running?
Logged

altenae

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 254
Re: Sometimes LAST UPLOADS gives me an error
« Reply #4 on: January 09, 2006, 01:10:29 pm »

what mySQL version are you running?


MySQL 3.23.58

Edward
Logged

altenae

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 254
Re: Sometimes LAST UPLOADS gives me an error
« Reply #5 on: January 12, 2006, 07:25:11 pm »

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
Logged
Pages: [1]   Go Up
 

Page created in 0.018 seconds with 20 queries.