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: Random picture error / database query error  (Read 2824 times)

0 Members and 1 Guest are viewing this topic.

brannvesenet

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Random picture error / database query error
« on: January 24, 2007, 06:50:43 pm »
I´ve recently installed Coppermine 1.4.10, and experiencing some problems when I click on one of the random pictures on the front page.

The debug output is:

While executing query "SELECT * FROM cpg1410_pictures WHERE approved = 'YES'  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

Latest uploads works fine, as well as normal picture viewing in the gallery.
I´ve installed Lightbox in coppermine, but I can´t see how that would affect this function.
My webhost has recently installed the latest version of mysql, does anyone know of any problems regarding this and coppermine?

I still have cpg 1.32 installed, and that works perfectly.

http://www.machineboy.com/photos

Any ideas?
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Random picture error / database query error
« Reply #1 on: January 24, 2007, 06:57:07 pm »
http://forum.coppermine-gallery.net/index.php?topic=28266.0

upgrade... a lot of problems got fixed. That's why there are upgrades
Logged

brannvesenet

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: Random picture error / database query error
« Reply #2 on: January 24, 2007, 07:51:38 pm »
Why did this get moved?

As I said in line 1, I´m running 1.4.10, which is the latest version I´ve found.

I´m also running 1.3.2, I just added that to let people know that the older version is working, but the new one doesn´t.
Logged

brannvesenet

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Random picture error / database query error
« Reply #3 on: January 24, 2007, 08:12:05 pm »
The last topic was moved for some reason, so I´ll repost (hope that´s okay).

I´ve recently installed Coppermine 1.4.10, and experiencing some problems when I click on one of the random pictures on the front page.

The debug output is:

While executing query "SELECT * FROM cpg1410_pictures WHERE approved = 'YES'  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

Latest uploads works fine, as well as normal picture viewing in the gallery.
I´ve installed Lightbox in coppermine, but I can´t see how that would affect this function.
My webhost has recently installed the latest version of mysql, does anyone know of any problems regarding this and coppermine?

http://www.machineboy.com/photos

Any ideas?
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Random picture error / database query error
« Reply #4 on: January 24, 2007, 09:41:03 pm »
sorry, moving back
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Random picture error / database query error
« Reply #5 on: January 24, 2007, 10:42:54 pm »
Merged threads.
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.04 seconds with 16 queries.