Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Sometimes LAST UPLOADS gives me an error  (Read 4055 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.02 seconds with 20 queries.