8 {{ upvoteCount | shortNum }}
8 {{ upvoteCount | shortNum }}

Wordpress Database Error

by michgil
6 replies
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
#database #error #wordpress
  • Profile picture of the author lovenot
    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...
    {{ DiscussionBoard.errors[4517788].message }}
  • Profile picture of the author Steve Diamond
    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
    Signature
    Mindfulness training & coaching online
    Reduce stress | Stay focused | Keep positive and balanced
    {{ DiscussionBoard.errors[4523966].message }}
  • Profile picture of the author teguhyuliantos
    Originally Posted by michgil View Post


    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
    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.
    Signature
    Specialized Web Hosting for ASP.NET | Latest Hosting Technology Supported
    {{ DiscussionBoard.errors[6324333].message }}
  • Profile picture of the author sufalamtech
    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.
    {{ DiscussionBoard.errors[6324935].message }}
  • Profile picture of the author melovedogs
    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.
    {{ DiscussionBoard.errors[6329742].message }}
  • Profile picture of the author Wilco de Kreij
    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!
    {{ DiscussionBoard.errors[6330091].message }}

Trending Topics