Error on multi-site

  • Resolved maxcsa

    (@maxcsa)


    11 years, 4 months ago

    wp-statistics seems to generate the following error while editing a post on a multi-site installation (french):
    ===============
    [Mon Jan 12 12:02:03 2015] [error] [client XXX.XXX.XXX.XXX] Erreur de la base de donn\xc3\xa9es WordPress Table ‘wordpress.wp_0_options’ doesn’t exist pour la requ\xc3\xaate SELECT option_value FROM wp_0_options WHERE option_name = ‘home’ LIMIT 1 faite par shutdown_action_hook, do_action(‘shutdown’), call_user_func_array, wp_statistics_shutdown_action, Hits->__construct, get_home_url, get_option, referer: http://mymultisitewp.com/dummysite/wp-admin/post.php?post=103&action=edit
    ===============
    Any idea?

    Thanks

    https://ww.wp.xz.cn/plugins/wp-statistics/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Contributor Greg Ross

    (@gregross)

    11 years, 4 months ago

    Try changing line 133 of wp-statitics/includes/classes/hits.class.php from:

    if( $ua_string == "WordPress/" . $wp_version . "; " . get_home_url("/") ) { $this->exclusion_match = TRUE; $this->exclusion_reason = "self referral"; }

    to

    if( $ua_string == "WordPress/" . $wp_version . "; " . get_home_url(null, "/") ) { $this->exclusion_match = TRUE; $this->exclusion_reason = "self referral"; }
    Thread Starter maxcsa

    (@maxcsa)

    11 years, 4 months ago

    Hi Greg,

    Thanks for answering so fast! Looks like it fixes my problem!

    However, it seems like the database schema for you plugin is not up to date on all site using your plugin. I tried to disable and re-enable your plugin and it fixes the problem. Is there another way to ensure that all tables (wp_XXX_statistics_visitors for exemple) are up to date?

    Thanks

    Plugin Contributor Greg Ross

    (@gregross)

    11 years, 4 months ago

    No at this time, we don’t “officially” support multi-site so the database update code doesn’t look for anything but the current site.

    The only option you have, instead of disabling/enabling, is to go each site and then to the optimization page, database tab and then re-run the install.

    I’ll include the above fix in the next release.

    Thread Starter maxcsa

    (@maxcsa)

    11 years, 4 months ago

    Hi,

    Sounds like a fair work-around for the moment.

    Thanks for your support.

    Regards

    Plugin Contributor Greg Ross

    (@gregross)

    11 years, 4 months ago

    No problem.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Error on multi-site’ is closed to new replies.