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: [Solved]: There was an error while processing a database query Please help  (Read 2386 times)

0 Members and 1 Guest are viewing this topic.

spikeeds

  • Coppermine newbie
  • Offline Offline
  • Posts: 3

Here is the Debug info


While executing query "SELECT * FROM cpg_pictures WHERE approved = 'YES' AND aid IN (1,3,4,5,9)  ORDER BY RAND() LIMIT -1" on 0

mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1' at line 1
« Last Edit: May 21, 2009, 04:43:57 pm by Joachim Müller »
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47844
  • aka "GauGau"
    • gaugau.de
Re: There was an error while processing a database query Please help
« Reply #1 on: May 20, 2009, 09:55:10 am »

Post even less information - we're mind readers and just need to look into our magic crystal balls... ::)
Logged

spikeeds

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: There was an error while processing a database query Please help
« Reply #2 on: May 20, 2009, 11:09:32 am »

Every time i click a picture it says There was an error while processing a database query.  I already activated the debug mode. And that's what it came out. How to fix it?
Logged

Hein Traag

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: nl
  • Offline Offline
  • Gender: Male
  • Posts: 2166
  • A, B, Cpg
    • Personal website - Spintires.nl
Re: There was an error while processing a database query Please help
« Reply #3 on: May 20, 2009, 12:35:49 pm »

Post some more info such as website URL, which cpg version you are using. What were you doing when you got this error? Were you uploading or what else?
Logged

spikeeds

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: There was an error while processing a database query Please help
« Reply #4 on: May 21, 2009, 07:26:08 am »

Problem solved. There was a problem with the lightbox plugin i remove it and the error was gone. I love that plugin, anyways have you guys experience that problem in lightbox?
Logged

Hein Traag

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: nl
  • Offline Offline
  • Gender: Male
  • Posts: 2166
  • A, B, Cpg
    • Personal website - Spintires.nl
Re: There was an error while processing a database query Please help
« Reply #5 on: May 21, 2009, 11:57:14 am »

Not to my knowledge. Try the EnlargeIT plugin.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47844
  • aka "GauGau"
    • gaugau.de
Re: There was an error while processing a database query Please help
« Reply #6 on: May 21, 2009, 04:42:34 pm »

Problem solved.
Marking as solved then (something that you should have done).
One issue per thread as per board rules - you shouldn't have asked another question in this thread. Locking.
Logged
Pages: [1]   Go Up
 

Page created in 0.016 seconds with 19 queries.