Title: SQL errors after upgrade to 2.1.1
Last modified: August 18, 2016

---

# SQL errors after upgrade to 2.1.1

 *  [selder2](https://wordpress.org/support/users/selder2/)
 * (@selder2)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/sql-errors-after-upgrade-to-211/)
 * 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 [http://weyland.be/weblog2](http://weyland.be/weblog2) – original
   working version with same DB is at [http://weyland.be/weblog](http://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](https://wordpress.org/support/users/selder2/)
 * (@selder2)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/sql-errors-after-upgrade-to-211/#post-531638)
 * Oh, seems to be theme related! investigating :p
 *  Thread Starter [selder2](https://wordpress.org/support/users/selder2/)
 * (@selder2)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/sql-errors-after-upgrade-to-211/#post-531641)
 * 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](https://wordpress.org/support/users/inove/)
 * (@inove)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/sql-errors-after-upgrade-to-211/#post-532063)
 * 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)](https://wordpress.org/support/users/otto42/)
 * (@otto42)
 * WordPress.org Admin
 * [19 years, 3 months ago](https://wordpress.org/support/topic/sql-errors-after-upgrade-to-211/#post-532066)
 * 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](https://wordpress.org/support/users/selder2/)
 * (@selder2)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/sql-errors-after-upgrade-to-211/#post-532090)
 * 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

 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 5 replies
 * 3 participants
 * Last reply from: [selder2](https://wordpress.org/support/users/selder2/)
 * Last activity: [19 years, 3 months ago](https://wordpress.org/support/topic/sql-errors-after-upgrade-to-211/#post-532090)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics