Member
Member
redkobold   19-10-2010, 18:21
#1

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 "

Administrator
Administrator
acrylian   19-10-2010, 19:19
#2

I can't reproduce that neither with the 1.3.1.2 nor the nightly/svn.

Member
Member
sbillard   19-10-2010, 23:11
#3

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.

Member
Member
redkobold   25-10-2010, 19:55
#4

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.

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