Visit count is only stat that is working

  • Resolved Zepfanman

    (@zepfanman)


    8 years ago

    I haven’t been able to get most of my website stats for several months. I noticed that my php was out of date a few weeks ago, so I thought that would fix the stats. I updated it and the wp-statistics interface reappeared in WordPress, but the stats aren’t updating properly. The ONLY thing that shows is the Visit count. Not Visitors, Search Engine Referrals, etc.
    php 5.4.19
    11.0.3

    I’ve tried disabling all my other plugins. Is there an easy fix, or should uninstall and reinstall the plugin. Will I lose my stats if I do that?

    Thanks,
    J. J.

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

    (@gregross)

    Have you checked your settings to make sure the other stats collections are enabled?

    Thread Starter Zepfanman

    (@zepfanman)

    Under Statistics > Settings > General? Yes, they’re all Active.

    Plugin Contributor Greg Ross

    (@gregross)

    The next thing to check is your PHP logs and see if there are any related error messages.

    Thread Starter Zepfanman

    (@zepfanman)

    Looks like these are the 3 main errors I’m getting:
    [16-Feb-2017 20:52:08 UTC] WordPress database error Table './caowplive/wp_statistics_visitor' is marked as crashed and last (automatic?) repair failed for query SELECT * FROM wp_statistics_visitor WHERElast_counter` = ‘2017-02-16’ made by do_action(‘wp_ajax_wp_statistics_get_widget_contents’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, wp_statistics_get_widget_contents_callback, wp_statistics_generate_quickstats_postbox_content, wp_statistics_generate_hits_postbox_content, wp_statistics_visitor

    [16-Feb-2017 20:52:08 UTC] WordPress database error Table ‘./caowplive/wp_statistics_visitor’ is marked as crashed and last (automatic?) repair failed for query SELECT count(last_counter) FROM wp_statistics_visitor WHERE last_counter = ‘2017-02-16’ made by do_action(‘wp_ajax_wp_statistics_get_widget_contents’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, wp_statistics_get_widget_contents_callback, wp_statistics_generate_quickstats_postbox_content, wp_statistics_visitor

    [16-Feb-2017 20:52:34 UTC] WordPress database error Table ‘./caowplive/wp_statistics_visitor’ is marked as crashed and last (automatic?) repair failed for query SELECT count(last_counter) FROM wp_statistics_visitor made by do_action(‘wp_ajax_wp_statistics_get_widget_contents’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, wp_statistics_get_widget_contents_callback, wp_statistics_generate_quickstats_postbox_content, wp_statistics_visitor`

    Plugin Contributor Greg Ross

    (@gregross)

    That would be a problem, do you have access to phpMyAdmin to see if you can repair the table?

    Thread Starter Zepfanman

    (@zepfanman)

    Aha! Thank you. I followed these instructions for the wp_statistics_visitor table and it looks like it’s working now. https://www.a2hosting.com/kb/cpanel/cpanel-database-features/optimizing-and-repairing-mysql-databases-with-phpmyadmin

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Visit count is only stat that is working’ is closed to new replies.