Crashed my multisite install, any idea what went wrong?

  • Resolved Denny

    (@mrcave)


    6 years, 10 months ago

    I love the simplicity and straightforward approach to this plugin. Was excited to try out the free version on multisite with hopes of getting a premium license to unlock the additional features, but then a few hours after installing my site crashed and found this error in my logs:

    [23-May-2018 14:59:18 UTC] 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 ‘) ) AND (
    wp_4c3522705e_usermeta.meta_key = ‘wp_4c3522705e_2_capabilities’
    ) ‘ at line 1 for query SELECT SQL_CALC_FOUND_ROWS wp_4c3522705e_users.* FROM wp_4c3522705e_users INNER JOIN wp_4c3522705e_usermeta ON ( wp_4c3522705e_users.ID = wp_4c3522705e_usermeta.user_id ) WHERE 1=1 AND wp_4c3522705e_users.ID IN ( SELECT DISTINCT wp_4c3522705e_2_posts.post_author FROM wp_4c3522705e_2_posts WHERE wp_4c3522705e_2_posts.post_status = ‘publish’ AND wp_4c3522705e_2_posts.post_type IN ( ) ) AND (
    wp_4c3522705e_usermeta.meta_key = ‘wp_4c3522705e_2_capabilities’
    ) ORDER BY user_login ASC made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/wp-simple-seo/wp-simple-seo.php’), WP_Simple_SEO::get_instance, WP_Simple_SEO->__construct, WP_Simple_SEO_Sitemaps::get_instance, WP_Simple_SEO_Sitemaps->__construct, WP_Simple_SEO_Settings->get_setting, WP_Simple_SEO_Settings->get_plugin_setting, WP_Simple_SEO_Settings->get_plugin_settings, WP_Simple_SEO_Settings->get_default_settings, WP_Simple_SEO_Settings->site_has_multiple_authors, WP_User_Query->__construct, WP_User_Query->query

    Disabling the plugin by renaming the folder resolved the issue and site came back up immediately. Any idea what’s causing this or how it can be corrected?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author WP Simple SEO

    (@wpsimpleseo)

    Hi,

    Can you please talk me through the steps taken to reproduce this – it’s not clear if this is happening on a site wide activation, site specific activation or when trying to do something specific once the Plugin is activated.

    Thanks.

    Thread Starter Denny

    (@mrcave)

    Thanks for the quick follow-up! This was a network wide activation. It didn’t immediately happen after activation – I was able to explore the plugin a bit and configure a few things.

    A few hours later was when the issue came up. I don’t have any specific steps to reproduce beyond that because to my knowledge no one was in the system working on their site when these errors started (we currently only have a few users beta testing).

    That’s why I posted here – I was hoping that error was something you may have seen before or would at least know where to start troubleshooting because I have no clue where to go from here. Didn’t want to reactivate not knowing if the same thing would happen again when I least suspect it ??

    Plugin Author WP Simple SEO

    (@wpsimpleseo)

    Hi,

    We have not seen this error before, and are unable to reproduce.

    Given the error relates to querying WordPress Users, using WP_User_Query, you would need to work with your hosting provider to understand why using a WordPress standard function (i.e. this is not a custom database query) would result in a SQL database query error. To be clear; we are not performing anything specialist here – this is a standard query, called by WordPress’ core.

    This may be caused by, but not limited to, some or all of:
    – server configuration,
    – WordPress version,
    – third party plugin modifying user queries

    Given that you have a multisite environment, you are welcome to setup a staging site, activating the plugin on that site only, and working to reproduce the issue.

    Failing that, I can only recommend using one of the many alternate SEO plugins available on WordPress.

    Thanks.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Crashed my multisite install, any idea what went wrong?’ is closed to new replies.