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?
http://forum.coppermine-gallery.net/index.php?topic=28266.0
upgrade... a lot of problems got fixed. That's why there are upgrades
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.
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?
sorry, moving back
Merged threads.