Database errors Duplicate key name 'date_ip_agent' & Can't DROP 'date_ip&#03

  • Resolved undergroundnetwork

    (@undergroundnetwork)


    11 years, 2 months ago

    Hi I cam getting the following database errors from the plugin:

    WordPress Database error Duplicate key name ‘date_ip_agent’
    &
    Can’t DROP ‘date_ip’

    Here are the full messages:
    [Fri Mar 20 14:41:25 2015] [error] [client x.x.x.x] WordPress database error Duplicate key name 'date_ip_agent' for query ALTER TABLE wp_statistics_visitor ADD UNIQUE KEY date_ip_agent (last_counter,ip,agent (75),platform (75),version (75)) /* From [websitex.com/wp-admin/admin.php?page=wp-statistics/optimization&install=1&tab=database] in [/nas/wp/www/cluster/websitex/wp-content/plugins/wp-statistics/wps-install.php:99] */ made by do_action('statistics_page_wp-statistics/optimization'), call_user_func_array, wp_statistics_optimization, include_once('/plugins/wp-statistics/includes/optimization/wps-optimization.php'), include('/plugins/wp-statistics/wps-install.php'), dbDelta, referer: https://websitesx.com/wp-admin/admin.php?page=wp-statistics/optimization

    and

    [Fri Mar 20 14:41:25 2015] [error] [client 10.189.246.5] WordPress database error Can't DROP 'date_ip'; check that column/key exists for query DROP INDEXdate_ipON wp_statistics_visitor /* From [websitex.com/wp-admin/admin.php?page=wp-statistics/optimization&install=1&tab=database] in [/nas/wp/www/cluster/websitex/wp-content/plugins/wp-statistics/wps-install.php:104] */ made by do_action('statistics_page_wp-statistics/optimization'), call_user_func_array, wp_statistics_optimization, include_once('/plugins/wp-statistics/includes/optimization/wps-optimization.php'), include('/plugins/wp-statistics/wps-install.php'), referer: https://websitex.com/wp-admin/admin.php?page=wp-statistics/optimization

    Do you know what I should do?

    Thanks!

    Charles

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

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

    (@gregross)

    11 years, 2 months ago

    These are warnings only. They happen during the upgrade process as the WordPress database upgrade function (for the first one) doesn’t recognize the index already exists and tries to re-add it.

    The second is because we drop an old index from the table and it’s faster to just execute the drop instead of executing two database commands, one to check to see if it exists and a second to drop it if it does.

    Both can safely be ignored.

    You’ll see them each time you upgrade WP Statistics.

Viewing 1 replies (of 1 total)

The topic ‘Database errors Duplicate key name 'date_ip_agent' & Can't DROP 'date_ip&#03’ is closed to new replies.