SQL errors after upgrade to 2.1.1

  • selder2

    (@selder2)


    18 years ago

    I wanted to upgrade my 2.0.5 installation to 2.1.1 and got this at the top of the page, and the blog isn’t working…

    WordPress database error: [You have an error in your SQL syntax near '.* FROM xbar01_wp_posts WHERE 1=1 AND (post_type = 'post' AND (post_status = '' at line 1]
SELECT SQL_CALC_FOUND_ROWS xbar01_wp_posts.* FROM xbar01_wp_posts WHERE 1=1 AND (post_type = 'post' AND (post_status = 'publish')) ORDER BY post_date DESC LIMIT 0, 10

WordPress database error: [You have an error in your SQL syntax near '()' at line 1]
SELECT FOUND_ROWS()

    You can see it at https://weyland.be/weblog2 – original working version with same DB is at https://weyland.be/weblog

    I don’t even know where to begin looking to fix this problem :/

    (just saw that there was a 2.1.2, same issue)

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter selder2

    (@selder2)

    Oh, seems to be theme related! investigating :p

    Thread Starter selder2

    (@selder2)

    Sorry! No aval with the default theme …

    Running upgrade.php doesn’t give any errors, but doesn’t work either, the upgrade wizard just starts over again :/

    inove

    (@inove)

    I try to install the same version 2.1.2 and apear the same error.
    I don’t know where to fix this problem too.

    Moderator Samuel Wood (Otto)

    (@otto42)

    www.remarpro.com Admin

    What version of mySQL are you running?

    WordPress 2.1 and up requires mySQL version 4.0 or later. Earlier versions won’t cut it.

    Thread Starter selder2

    (@selder2)

    I went from MySQL 3.23.49 to 5.0.24a

    But I solved it by first installing 2.0.5 on the new server, injecting the MySQL dump from the old server, and then upgrade it to 2.1.2 ??

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘SQL errors after upgrade to 2.1.1’ is closed to new replies.

Tags