• So I have been using the statistics for over a year now and decided to start using “Purge Old Data Daily” set to “Purge Data Older Than: 365”

    And every time it runs I am getting PHP errors….

    WordPress database error Duplicate entry '0' for key 'page_id' for query INSERT INTOw3p8w4z_statistics_historical(value,category,uri,page_id) VALUES ('78', 'uri', '/xmlrpc.php', '0') made by do_action_ref_array('wp_statistics_dbmaint_hook'), WP_Hook->do_action, WP_Hook->apply_filters, WP_STATISTICS\Schedule->dbmaint_event, WP_STATISTICS\Purge::purge_data

    WordPress database error Duplicate entry '6282' for key 'page_id' for query INSERT INTOw3p8w4z_statistics_historical(value,category,uri,page_id) VALUES ('3', 'uri', '/reduced-price-listings/', '6282') made by do_action_ref_array('wp_statistics_dbmaint_hook'), WP_Hook->do_action, WP_Hook->apply_filters, WP_STATISTICS\Schedule->dbmaint_event, WP_STATISTICS\Purge::purge_data

    There are 8 different ones every time but here are two of them, they are pretty much the same.

    I am on….
    WordPress 5.8.3
    PHP 7.4

    Please advice…
    Thanks.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter Seath

    (@seath)

    Anybody?

    Plugin Author Mostafa Soufi

    (@mostafas1990)

    Hi,

    Sorry for the delayed reply, this is weird why occurred. any way you can get rid of that error by deleting those rows manually from the phpMyAdmin

    
    DELETE FROM w3p8w4z_statistics_historical where page_id = 78;
    DELETE FROM w3p8w4z_statistics_historical where page_id = 3;
    
    • This reply was modified 2 years, 9 months ago by Mostafa Soufi.
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘PHP errors’ is closed to new replies.