Home› General support

Zenphoto Error MySQL Query - 1.2.7 upgrade to 1.2.8

mangg Member
in General support
I recently upgraded from 1.2.7 to 1.2.8 and I keep getting the following error message:

Zenphoto Error
MySQL Query ( INSERT INTO `zp_obj_to_tag`(`objectid`, `tagid`, `type`) VALUES (20,,'images') ) 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 ''images')' at line 1

TIA

Comments

  • sbillard Member
    Somehow a query on some tag is comming back with an empty `id`. This should be impossible. Perhaps there is a problem with your zp_tags table and some `id` field(s) are empty? Can you determine what the tag is that is being stored? That would be the one to check on.
  • mangg Member
    I am not a programmer and don't understand what to look for... Where would I find that?
  • acrylian Administrator, Developer
    In the database of your server. Ask your host if you don't know how to access that. Also it would be interessting to know when and where you get that error actually.
  • mangg Member
    I am hosted with Godaddy so I don't control the MySQL server.

    The error happens when I click on a gallery AND on the images themselves.
  • acrylian Administrator, Developer
    Even on shared hosting you should be able to access the database content via tools like phpmyadmin. Ask your host.
  • mangg Member
    Upgraded to 1.2.9 and the problem no longer exists. =)
Sign In or Register to comment.