ZenphotoCMS Forum
printRandomImages - Printable Version

+- ZenphotoCMS Forum (https://forum.zenphoto.org)
+-- Forum: Support (https://forum.zenphoto.org/forum-1.html)
+--- Forum: General support (https://forum.zenphoto.org/forum-4.html)
+--- Thread: printRandomImages (/thread-5899.html)



printRandomImages - fcannata - 2009-09-28

When I use printRandomImages and I am logged in it works flawlessly, however once i log out i get a mySQL error.

Anyone know why this happens?

Calling this:
printRandomImages(4,'randoms','all','',161,137,true);

Error:
MySQL Query ( SELECT COUNT(*) AS row_count FROM zp_images, zp_albums WHERE zp_albums.folder!="" AND zp_images.albumid = zp_albums.id AND zp_albums.show=1 AND zp_images.show=1 ) failed. Error: You have an error in your SQL syntax near 'show=1 AND zp_images.show=1' at line 1




printRandomImages - sbillard - 2009-09-28

What version of Zenphoto? If not 1.2.6 you need to upgrade.