+- ZenphotoCMS Forum (https://forum.zenphoto.org)
+-- Forum: Support (https://forum.zenphoto.org/forum-1.html)
+--- Forum: Plugins (https://forum.zenphoto.org/forum-6.html)
+--- Thread: ZenPage - Error deleting or sorting pages (/thread-7732.html)
ZenPage - Error deleting or sorting pages - redkobold - 19-10-2010
I somehow ended up with a "Untitled page" page in the pages I have created. If I try to move it to the end or move the order of any of my pages I get the following error when I click on Apply.
"MySQL Query ( UPDATE zp_zenpage_pages SET sort_order = '000', parentid= NULL WHERE id= ) failed. MySQL returned the 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 try to delete it I get:
"MySQL Query ( DELETE FROM zp_obj_to_tagWHERE type='zenpage_pages' AND objectid= ) failed. MySQL returned the 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 "
ZenPage - Error deleting or sorting pages - acrylian - 19-10-2010
I can't reproduce that neither with the 1.3.1.2 nor the nightly/svn.
ZenPage - Error deleting or sorting pages - sbillard - 19-10-2010
Older versions of Zenpage could end up making these "phantom" pages. You will have to delete the database record manually. Since you got this error, I presume you are not on the current version, so I suggest you upgrade as well.
ZenPage - Error deleting or sorting pages - redkobold - 25-10-2010
I am on the current version but still had to edit MySQL database to remove it. I would have just left the phantom page because it did not show up on the front end but it kept me from custom sorting my visible pages so I could not ignore it.
Thanks.