• I just upgraded from WP 2.0 to 2.0.1. When I tried to go back to older posts and edit them, I would get the following error after hitting “Save” or “Save and continue editing”

    WordPress database 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 ‘….]

    I figured out the problem occurs only with older posts and happens whenever there is an apostrophe (‘) in the text of the post. Any idea how to fix this or what it could be?

    My second problem is that at the bottom of the page it says:

    Warning: Cannot modify header information – headers already sent by (output started at /home/beautyst/public_html/wp-includes/wp-db.php:102) in /home/beautyst/public_html/wp-admin/post.php on line 122

    Any thoughts?

Viewing 2 replies - 16 through 17 (of 17 total)
  • RavanH and others –

    If you’re seeing the 404 problem after you have used the save-and-continue feature (with the long mySQL error string at the end of the URL), there has already been considerable discussion on this matter, and a fix has been entered for testing.

    Check this post from Ryan in the other thread for the developers’ proposed change to correct the problem.

    Same here too… Mine happens when editing a particular page (not post), plus I also have permalinks set to “date and name based”

    Dickie

Viewing 2 replies - 16 through 17 (of 17 total)
  • The topic ‘Error when editing old posts after updating to 2.0.1’ is closed to new replies.