+- 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: SQL syntax - hitcounter (/thread-2252.html)
SQL syntax - hitcounter - amucklow - 2008-02-19
I just upgraded to version 1.1, and everything works fine EXCEPT in one album:
http://www.hand-embroidery.co.uk/showcase/index.php?album=accoutrements
It looks like images previously cached have been dropped from the album. In the edit page for this album I get this error at the bottom of the page:
`Zenphoto Error
MySQL Query ( SELECT `hitcounter FROM zp_images WHERE id = ) Failed. 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 '' at line 1
If I upload images into this album, they are uploaded but don't show up on the edit page. Any ideas?
SQL syntax - hitcounter - sbillard - 2008-02-19
There is no image name in the link of the images that are failing. Not sure why that would be. Have you tried one of the zenphoto themes to see if it also fails?
SQL syntax - hitcounter - amucklow - 2008-02-20
I went into the database and deleted the rows referencing missing images - now it all works fine.
SQL syntax - hitcounter - sbillard - 2008-02-20
You can also use the link on the admin page to clean up the database.