+- 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: Zenphoto Error MySQL Query - 1.2.7 upgrade to 1.2.8 (/thread-6386.html)
Zenphoto Error MySQL Query - 1.2.7 upgrade to 1.2.8 - mangg - 2010-01-04
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
Zenphoto Error MySQL Query - 1.2.7 upgrade to 1.2.8 - sbillard - 2010-01-05
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.
Zenphoto Error MySQL Query - 1.2.7 upgrade to 1.2.8 - mangg - 2010-01-08
I am not a programmer and don't understand what to look for... Where would I find that?
Zenphoto Error MySQL Query - 1.2.7 upgrade to 1.2.8 - acrylian - 2010-01-08
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.
Zenphoto Error MySQL Query - 1.2.7 upgrade to 1.2.8 - mangg - 2010-01-11
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.
Zenphoto Error MySQL Query - 1.2.7 upgrade to 1.2.8 - acrylian - 2010-01-11
Even on shared hosting you should be able to access the database content via tools like phpmyadmin. Ask your host.
Zenphoto Error MySQL Query - 1.2.7 upgrade to 1.2.8 - mangg - 2010-03-02
Upgraded to 1.2.9 and the problem no longer exists. =)