Title: WordPress database error Last modified: August 18, 2016 --- # WordPress database error * [Tom Murphy](https://wordpress.org/support/users/tfmurphhk/) * (@tfmurphhk) * [18 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-error-2-2/) * Can anyone shed some light on this error that I am suddenly getting? I don’t know that I have done anything to cause it… it just suddenly appeared. * Also (obviously) do you have a solution… * Thanks * ================================ * WordPress database error: [You have an error in your SQL syntax near ‘.* FROM wp_posts WHERE 1=1 AND (post_type = ‘post’ AND (post_status = ‘publish’ at line 1] SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND (post_type = ‘post’ AND (post_status = ‘publish’ OR post_author = 1 AND post_status = ‘private’)) ORDER BY post_date DESC LIMIT 0, 10 * ================================== Viewing 8 replies - 1 through 8 (of 8 total) * [moshu](https://wordpress.org/support/users/moshu/) * (@moshu) * [18 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-error-2-2/#post-585575) * Somebody might have a solution if you help them… Link, where exactly, what did you do right before, etc.? Did your host upgrade any software/hardware? * Thread Starter [Tom Murphy](https://wordpress.org/support/users/tfmurphhk/) * (@tfmurphhk) * [18 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-error-2-2/#post-585577) * Hmmm, to the best of my knowledge I did nothing. I had not updated my blog in several days, when I went to do so, I got this message. I tried to fix it (blindly) and it only got worse. * The message comes up right from the get-go at [http://www.pga-auctions.com/wordpress](http://www.pga-auctions.com/wordpress) * I have no idea what my host may have done. Do you suspect the problem is at the host? * Tom * [whooami](https://wordpress.org/support/users/whooami/) * (@whooami) * [18 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-error-2-2/#post-585578) * Your current default theme needs to be upgraded. * upload the default theme inside the 2.2.1 zip — making sure to either overwrite the existing files, or deleting the old files first. * [moshu](https://wordpress.org/support/users/moshu/) * (@moshu) * [18 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-error-2-2/#post-585579) * Did you try deactivate all the plugins? Also, I can see you are using WP 2.2.1– but was your theme ever updated during the upgrades? * Thread Starter [Tom Murphy](https://wordpress.org/support/users/tfmurphhk/) * (@tfmurphhk) * [18 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-error-2-2/#post-585604) * Well, a new problem has arisen. * I wanted to try deleting the plugins as suggested but when I logged in I got this message: * ERROR: WordPress 2.2.1 requires MySQL 4.0.0 or higher * so now I can not get in to admin rights. I am assuming taht MySQL is on the server, over which I have no control?? * The problem seems to have worsened! * Tom * Thread Starter [Tom Murphy](https://wordpress.org/support/users/tfmurphhk/) * (@tfmurphhk) * [18 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-error-2-2/#post-585607) * OK, here is what I have done… and still no resolution. * I deleted the entire wordpress folder on my server and then uploaded a full new clean version of WP 2.2.1 fresh from download. * I then tried to run [http://www.pga-auctions.com/wordpress](http://www.pga-auctions.com/wordpress) and of course got a message that there was no wp-config.php file, only a wp-config- sample.php * So I then uploaded only one file… the OLD wp-config.php file that had been in use prior to all these problems. * And now when I run [http://www.pga-auctions.com/wordpress](http://www.pga-auctions.com/wordpress) I get the message referred to earlier… “WordPress 2.2.1 requires MySQL 4.0.0 or higher”. * So I am guessing that the problem is NOT on my side, but rather on the Server Side. I will try to get some resolution from my server… but that is never easy. * Anyone have any ideas for me?? * Tom * [moshu](https://wordpress.org/support/users/moshu/) * (@moshu) * [18 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-error-2-2/#post-585609) * It is quite a clear message. Your host has an older version of MySQL. And if you click About on the top of this page and from there Requirements on the left: [http://wordpress.org/about/requirements/](http://wordpress.org/about/requirements/) You can read this: * > To run WordPress your host just needs a couple of things: > * PHP version 4.2 or greater > * MySQL version 4.0 or greater * You will have to use the 2.0.x branch (2.0.10 being the latest stable) – or find a new host. * Thread Starter [Tom Murphy](https://wordpress.org/support/users/tfmurphhk/) * (@tfmurphhk) * [18 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-error-2-2/#post-585619) * Thanks Moshu… you came up with the solution just a bit before my server did. * I spoke to them and they advised that the server I was on was not capable of handling 2.2.1 Their solution is to switch me to a different server in their “ farm”. * Before I do that I will look at downloading 2.0 and seeing if I can get the blog to run with that. If so, then it will surely confirm the 2.2.1 issue and I can make a decision as to whether to have them switch me to another server. * Can you advise (in general terms) what I get or lose… by being on 2.0 versus 2.2? Remember, I am not all that tech savy so just some simple layman’s explanation please. * Thanks (everyone here) for all the support and help. * Tom Viewing 8 replies - 1 through 8 (of 8 total) The topic ‘WordPress database error’ is closed to new replies. ## Tags * [WordPress database error](https://wordpress.org/support/topic-tag/wordpress-database-error/) * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 8 replies * 3 participants * Last reply from: [Tom Murphy](https://wordpress.org/support/users/tfmurphhk/) * Last activity: [18 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-error-2-2/#post-585619) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics