WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Upgrade from 2.6 to 2.6.5 breaks any db save function in admin section. (7 posts)

  1. dolemite
    Member
    Posted 5 years ago #

    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

  2. dolemite
    Member
    Posted 5 years ago #

    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.

  3. dolemite
    Member
    Posted 5 years ago #

    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

  4. dolemite
    Member
    Posted 5 years ago #

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

  5. dolemite
    Member
    Posted 5 years ago #

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

    ../wp-admin/post.php

  6. ulfben
    Member
    Posted 5 years ago #

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

  7. WebDev WaxLotus LLC
    Member
    Posted 5 years ago #

    Thanks Ulfben!

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

    Thanks.

Topic Closed

This topic has been closed to new replies.

About this Topic