WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] WordPress database error / SQL Syntax error (4 posts)

  1. indietravel
    Member
    Posted 1 year ago #

    I'm not sure where to start looking to diagnose the following errors in WP3.5 w/ multisite on, and BuddyPress too:

    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 'WHERE blog_id = 1 AND meta_key = 'last_activity'' at line 1 for query SELECT * FROM WHERE blog_id = 1 AND meta_key = 'last_activity' made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, wpms_init, wp_publish_post, wp_update_post, wp_insert_post, do_action('save_post'), call_user_func_array, bp_blogs_record_post, bp_blogs_update_blogmeta

    Similar errors are cropping up with every 'publish' activity on the site, including comments, etc.

    I haven't found any similar examples, has anyone seen this before?

  2. techonda
    Member
    Posted 1 year ago #

    You can use the database repair option

  3. indietravel
    Member
    Posted 1 year ago #

    Thanks - just ran that now; will keep a further eye on eye on error logs to see if it clears up.

  4. indietravel
    Member
    Posted 1 year ago #

    Yes, that seems to have cleared things up. Thanks @techonda.

Topic Closed

This topic has been closed to new replies.

About this Topic