Member
Member
mangg   2010-01-04, 22:27
#1

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

Member
Member
sbillard   2010-01-05, 02:37
#2

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.

Member
Member
mangg   2010-01-08, 13:53
#3

I am not a programmer and don't understand what to look for... Where would I find that?

Administrator
Administrator
acrylian   2010-01-08, 16:21
#4

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.

Member
Member
mangg   2010-01-11, 18:32
#5

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.

Administrator
Administrator
acrylian   2010-01-11, 18:45
#6

Even on shared hosting you should be able to access the database content via tools like phpmyadmin. Ask your host.

Member
Member
mangg   2010-03-02, 01:24
#7

Upgraded to 1.2.9 and the problem no longer exists. =)

  
Powered By MyBB, © 2002-2026 MyBB Group.
Made with by Curves UI.