Support » Plugin: WP Statistics » 2 MySQL errors

  • Resolved szabesz



    I do not knot how serious these issue are, but I thought I should report it, just in case:
    Table ‘…_statistics_historical’ doesn’t exist
    SHOW COLUMNS FROM …_statistics_historical LIKE ‘key’ … activate_plugin, include_once(‘/plugins/wp-statistics/wp-statistics.php’), include_once(‘/plugins/wp-statistics/wps-install.php’)
    It is one and only log entry, during(?) or after(?) installation.

    Later I also got one of this:
    Duplicate entry ‘…’ for key ‘date_2’ … INSERT INTO csi_statistics_pages (uri, date, count, id) VALUES (‘/…/‘, ‘2016-12-05′, 1, ’12’) … shutdown_action_hook, do_action(‘shutdown’), wp_statistics_shutdown_action, Hits->Pages

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


    The first one was probably during setup, a race condition between the setup routine and the first visitor hitting your site.

    The second is a race condition which you may see again during the first hit of the day, if two users hit the site at almost the exact same time, both will try and create the same row in the database. You can safely ignore this, it will drop a single visit to your site but otherwise all subsequent visitors will be recorded correctly.

    Thank you for you clarification! I am new to this plugin, but I like what I’ve seen so far. Keep up the good work!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘2 MySQL errors’ is closed to new replies.