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: [Solved]: There was an error while processing a database query Please help  (Read 2972 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: 47843
  • 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: 47843
  • 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.017 seconds with 19 queries.