WordPress.org

Support

Support » Installation » [Resolved] Upgrade from 2.6 to 2.6.5 breaks any db save function in admin section.

[Resolved] Upgrade from 2.6 to 2.6.5 breaks any db save function in admin section.

  • I just upgraded my 2.6 server to the latest rev (2.6.5) and everything seemed to go just fine until I attempted to save my first post.

    I followed the directions as normal for an upgrade (delete the wp-admin and wp-includes directories) upload the root, wp-admin and wp-includes directories.

    That part went fine and was able to login…after wordpress prompted me to upgrade my database (I think that’s where things went wrong).

    Not really sure what to do here. I’m dead in the water for publishing and I have deadlines. I’m thinking about downgrading to the last version but don’t know if that will cause more trouble than it’s worth.

    Here’s the error messages that appear when I attempt to publish the article:

    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 ” at line 1]
    SELECT ID AS ‘ID’, post_date AS ‘post_date’, post_title AS ‘post_title’ FROM wp_posts WHERE post_date > ‘2008-11-01 00:00:00’ AND post_date < ‘2008-12-01 00:00:00’ AND post_status = ‘publish’ AND post_type = ‘post’ ORDER BY

    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 ” at line 1]
    SELECT ID AS ‘ID’, post_date AS ‘post_date’, post_title AS ‘post_title’ FROM wp_posts WHERE post_date > ‘2008-10-01 00:00:00’ AND post_date < ‘2008-11-01 00:00:00’ AND post_status = ‘publish’ AND post_type = ‘post’ ORDER BY

    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 ” at line 1]
    SELECT ID AS ‘ID’, post_date AS ‘post_date’, post_title AS ‘post_title’ FROM wp_posts WHERE post_date > ‘2008-09-01 00:00:00’ AND post_date < ‘2008-10-01 00:00:00’ AND post_status = ‘publish’ AND post_type = ‘post’ ORDER BY

    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 ” at line 1]
    SELECT ID AS ‘ID’, post_date AS ‘post_date’, post_title AS ‘post_title’ FROM wp_posts WHERE post_date > ‘2008-08-01 00:00:00’ AND post_date < ‘2008-09-01 00:00:00’ AND post_status = ‘publish’ AND post_type = ‘post’ ORDER BY

    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 ” at line 1]
    SELECT ID AS ‘ID’, post_date AS ‘post_date’, post_title AS ‘post_title’ FROM wp_posts WHERE post_date > ‘2008-07-01 00:00:00’ AND post_date < ‘2008-08-01 00:00:00’ AND post_status = ‘publish’ AND post_type = ‘post’ ORDER BY

    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 ” at line 1]
    SELECT ID AS ‘ID’, post_date AS ‘post_date’, post_title AS ‘post_title’ FROM wp_posts WHERE post_date > ‘2008-06-01 00:00:00’ AND post_date < ‘2008-07-01 00:00:00’ AND post_status = ‘publish’ AND post_type = ‘post’ ORDER BY

    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 ” at line 1]
    SELECT ID AS ‘ID’, post_date AS ‘post_date’, post_title AS ‘post_title’ FROM wp_posts WHERE post_date > ‘2008-11-01 00:00:00’ AND post_date < ‘2008-12-01 00:00:00’ AND post_status = ‘publish’ AND post_type = ‘post’ ORDER BY

    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 ” at line 1]
    SELECT ID AS ‘ID’, post_date AS ‘post_date’, post_title AS ‘post_title’ FROM wp_posts WHERE post_date > ‘2008-10-01 00:00:00’ AND post_date < ‘2008-11-01 00:00:00’ AND post_status = ‘publish’ AND post_type = ‘post’ ORDER BY

    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 ” at line 1]
    SELECT ID AS ‘ID’, post_date AS ‘post_date’, post_title AS ‘post_title’ FROM wp_posts WHERE post_date > ‘2008-09-01 00:00:00’ AND post_date < ‘2008-10-01 00:00:00’ AND post_status = ‘publish’ AND post_type = ‘post’ ORDER BY

    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 ” at line 1]
    SELECT ID AS ‘ID’, post_date AS ‘post_date’, post_title AS ‘post_title’ FROM wp_posts WHERE post_date > ‘2008-08-01 00:00:00’ AND post_date < ‘2008-09-01 00:00:00’ AND post_status = ‘publish’ AND post_type = ‘post’ ORDER BY

    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 ” at line 1]
    SELECT ID AS ‘ID’, post_date AS ‘post_date’, post_title AS ‘post_title’ FROM wp_posts WHERE post_date > ‘2008-07-01 00:00:00’ AND post_date < ‘2008-08-01 00:00:00’ AND post_status = ‘publish’ AND post_type = ‘post’ ORDER BY

    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 ” at line 1]
    SELECT ID AS ‘ID’, post_date AS ‘post_date’, post_title AS ‘post_title’ FROM wp_posts WHERE post_date > ‘2008-06-01 00:00:00’ AND post_date < ‘2008-07-01 00:00:00’ AND post_status = ‘publish’ AND post_type = ‘post’ ORDER BY

    Warning: Cannot modify header information – headers already sent by (output started at <absolute path on server>/wp-includes/wp-db.php:517) in <absolute path on server>/wp-includes/pluggable.php on line 770

Viewing 6 replies - 1 through 6 (of 6 total)
  • I should also note the following:

    – Front end works fine…so far.

    – Posts that are written and run into the error when attempts at publishing are made are saved as a draft.

    I also get this error message when I’m writing or editing a post in the admin panel. This error appears between the save/publish button and the word count counter:

    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 ” at line 1]
    SELECT ID AS ‘ID’, post_date AS ‘post_date’, post_title AS ‘post_title’ FROM wp_posts WHERE post_date > ‘2008-12-01 00:00:00’ AND post_date < ‘2009-01-01 00:00:00’ AND post_status = ‘publish’ AND post_type = ‘post’ ORDER BY

    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 ” at line 1]
    SELECT ID AS ‘ID’, post_date AS ‘post_date’, post_title AS ‘post_title’ FROM wp_posts WHERE post_date > ‘2008-11-01 00:00:00’ AND post_date < ‘2008-12-01 00:00:00’ AND post_status = ‘publish’ AND post_type = ‘post’ ORDER BY

    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 ” at line 1]
    SELECT ID AS ‘ID’, post_date AS ‘post_date’, post_title AS ‘post_title’ FROM wp_posts WHERE post_date > ‘2008-10-01 00:00:00’ AND post_date < ‘2008-11-01 00:00:00’ AND post_status = ‘publish’ AND post_type = ‘post’ ORDER BY

    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 ” at line 1]
    SELECT ID AS ‘ID’, post_date AS ‘post_date’, post_title AS ‘post_title’ FROM wp_posts WHERE post_date > ‘2008-09-01 00:00:00’ AND post_date < ‘2008-10-01 00:00:00’ AND post_status = ‘publish’ AND post_type = ‘post’ ORDER BY

    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 ” at line 1]
    SELECT ID AS ‘ID’, post_date AS ‘post_date’, post_title AS ‘post_title’ FROM wp_posts WHERE post_date > ‘2008-08-01 00:00:00’ AND post_date < ‘2008-09-01 00:00:00’ AND post_status = ‘publish’ AND post_type = ‘post’ ORDER BY

    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 ” at line 1]
    SELECT ID AS ‘ID’, post_date AS ‘post_date’, post_title AS ‘post_title’ FROM wp_posts WHERE post_date > ‘2008-07-01 00:00:00’ AND post_date < ‘2008-08-01 00:00:00’ AND post_status = ‘publish’ AND post_type = ‘post’ ORDER BY

    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 ” at line 1]
    SELECT ID AS ‘ID’, post_date AS ‘post_date’, post_title AS ‘post_title’ FROM wp_posts WHERE post_date > ‘2008-06-01 00:00:00’ AND post_date < ‘2008-07-01 00:00:00’ AND post_status = ‘publish’ AND post_type = ‘post’ ORDER BY

    Warning: Cannot modify header information – headers already sent by (output started at <absolute path on server>/wp-includes/wp-db.php:517) in <absolute path on server>/wp-includes/classes.php on line 806

    Tried to downgrade back to 2.6 and I get the same error. Wonderful.

    Forgot to add the page that this error appears on is:

    ../wp-admin/post.php

    This is not an issue with WordPress, but with a plugin. Further discussions on this topic should be held here.

    Thanks Ulfben!

    Dolemite, if this fixes your issue please mark the topic ‘resolved’ as it’s one less alarm bell ringing!

    Thanks.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘[Resolved] Upgrade from 2.6 to 2.6.5 breaks any db save function in admin section.’ is closed to new replies.