Random picture error / database query error

[brannvesenet]

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?

[Stramm]

http://forum.coppermine-gallery.net/index.php?topic=28266.0

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

[brannvesenet]

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.

[brannvesenet]

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?

[Stramm]

sorry, moving back

[Joachim Müller]

Merged threads.