Hi all,
Do You know how to solve below problem? When I upload any phots to my server, there is a error message as below:

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

Edmond

Can you provide some more details of your problem? The Query you seem to be having a problem with should not be involved at all with the image upload.

What zenphoto version
What theme
Exact sequence of steps that result in this error.

Hi,

I've just come across this problem on a clients site. I logged in to the admin section, selected 4 jpgs to upload to the selected folder which through up an error. Went back to look at the site and there are images missing :/ Went to edit the album and after the 4 images that work it says -

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

! I've not added images for ages, but when I left it all was well.

Any help greatly appreciated! I don't want to take the gallery down, but its a live client site!

Ok - Thought I would just delete the album and then create a new one. And it says this:

Warning: unlink(/var/www/vhosts/windows-are-us.co.uk/httpdocs/gallery/albums/Doors/Door_2.jpg): Permission denied in /var/www/vhosts/windows-are-us.co.uk/httpdocs/gallery/zp-core/class-image.php on line 414

Any ideas?

EDIT - line 414 is: $result = unlink($this->localpath);