Home› Plugins

ZenPage - Error deleting or sorting pages

redkobold Member
in Plugins
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_tag`WHERE `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 "

Comments

  • acrylian Administrator, Developer
    I can't reproduce that neither with the 1.3.1.2 nor the nightly/svn.
  • sbillard Member
    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.
  • redkobold Member
    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.
Sign In or Register to comment.