Home› General support

SQL syntax - hitcounter

amucklow Member
in General support
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?

Comments

  • sbillard Member
    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?
  • amucklow Member
    I went into the database and deleted the rows referencing missing images - now it all works fine.
  • sbillard Member
    You can also use the link on the admin page to clean up the database.
Sign In or Register to comment.