Wordpress Database Error

by 6 replies
8
I keep getting this error when I am logged into my admin panel all of a sudden. Does anyone know how I an fix it? I already tried running the repair table under both myphpadmin and mysqldatabase and am still getting the error. I am just learning all of this so it is a little overwhelming.

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 ''%living fit fitness %' at line 1]
SELECT * FROM wp_posts WHERE LOWER(post_content) like '%living fit fitness %' OR LOWER(post_title) like '%living fit fitness %

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 ''%what happened to loving fit blog%' at line 1]
SELECT * FROM wp_posts WHERE LOWER(post_content) like '%what happened to loving fit blog%' OR LOWER(post_title) like '%what happened to loving fit blog%


Warning: Cannot modify header information - headers already sent by (output started at /home/michgil/public_html/livingfitblog.com/wp-includes/wp-db.php:941) in /home/michgil/public_html/livingfitblog.com/wp-includes/pluggable.php on line 934


Thanks
#programming #database #error #wordpress
  • Is this a new setup? Did you just transferred to a new wordpress system? It looks like there is a conflict and the database is corrupted. Did you just installed something new? Are u using the latest wordpress and are the themes or database you use, compatible with it?

    I need more information...
  • Banned
    [DELETED]
  • The number one troubleshooting advice for WordPress errors (including this type and also the dreaded "blank page" in the admin area) is to first disable all plugins. If the error goes away, you know that a plugin is to blame -- or a conflict between plugins. Then re-enable them one at a time until the error re-appears, and you have your culprit.

    By the way, if you get the blank page or are otherwise unable to get to the plugins page to disable them, you can FTP to your site and delete the entire contents of the /wp-content/plugins/ folder. (Back it up first, of course.) Then you can reinstall the plugins one by one.

    Hope this helps.

    Steve
  • Banned
    [DELETED]
  • Many cause that you met this error, one of which is you just install not supporting plugin with your wordpress version. To overcome this condition, you can only solved trough your cPanel, go to File Manager, and deleted any plugin that you just installed. Hope this will help your problem.
  • It was happen when any new setup done in wordpress database and mysql server error will seen. So please check once your hosting services and then update database.
  • have you recently updated or added new plugin? that could be the culprit, you might want to disable all plugins by renaming the plugin folder then try to activate one by one.
  • I'd start out with disabling all your plugins and see whether the problem still exists. If it's still there, also change the theme you're using. If it still exists, make sure to update your WordPress to the most recent version (or if you're already on the most recent version, re-upload all files to make sure they're not corrupt).

    Whenever the error is gone, start enabling the plugins (or theme) one by one to see which one gives the error.

    You could also try to repair the DB if none of the above works: WordPress Maintenance 101: How to Optimize and Repair Database Tables

    Good luck!
  • Banned
    [DELETED]

Next Topics on Trending Feed

  • 8

    I keep getting this error when I am logged into my admin panel all of a sudden. Does anyone know how I an fix it? I already tried running the repair table under both myphpadmin and mysqldatabase and am still getting the error. I am just learning all of this so it is a little overwhelming. 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 ''%living fit fitness %' at line 1]