WordPress.org

Ready to get started?Download WordPress

Forums

Traffic Stats Widget
WordPress database error Duplicate entry (1 post)

  1. ReactorShop
    Member
    Posted 1 year ago #

    This is the error being logged in my production server (replaced IP with X's):

    [11-Jan-2014 14:05:20 UTC] WordPress database error Duplicate entry 'XXX.XXX.XXX.XXX-1389449120' for key 'PRIMARY' for query INSERT INTOwp_tsw_log(IP,Time,IS_BOT,IS_HIT`) VALUES ('XXX.XXX.XXX.XXX',1389449120,0,1) made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), call_user_func_array, wpsc_all_products_on_page, include('/themes/customizr/index.php'), do_action('__after_main_wrapper'), call_user_func_array, get_footer, locate_template, load_template, require_once('/themes/customizr/footer.php'), do_action('__footer'), call_user_func_array, TC_footer_main->tc_widgets_footer, dynamic_sidebar, call_user_func_array, WidgetCache->widget_cache_redirected_callback, call_user_func_array, widget_traffic_stats, view, dbrc_wpdb->query, dbrc_wpdb->dbcr_query
    [11-Jan-2014 14:05:20 UTC] WordPress database error Duplicate entry 'XXX.XXX.XXX.XXX-1389449120' for key 'PRIMARY' for query SELECT COUNT(*) FROM wp_tsw_log where Time > 1389362720 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), call_user_func_array, wpsc_all_products_on_page, include('/themes/customizr/index.php'), do_action('__after_main_wrapper'), call_user_func_array, get_footer, locate_template, load_template, require_once('/themes/customizr/footer.php'), do_action('__footer'), call_user_func_array, TC_footer_main->tc_widgets_footer, dynamic_sidebar, call_user_func_array, WidgetCache->widget_cache_redirected_callback, call_user_func_array, widget_traffic_stats, view, get_traffic, dbrc_wpdb->query, dbrc_wpdb->dbcr_query
    [11-Jan-2014 14:05:20 UTC] WordPress database error Duplicate entry 'XXX.XXX.XXX.XXX-1389449120' for key 'PRIMARY' for query SELECT COUNT(*) FROM wp_tsw_log where Time > 1388844320 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), call_user_func_array, wpsc_all_products_on_page, include('/themes/customizr/index.php'), do_action('__after_main_wrapper'), call_user_func_array, get_footer, locate_template, load_template, require_once('/themes/customizr/footer.php'), do_action('__footer'), call_user_func_array, TC_footer_main->tc_widgets_footer, dynamic_sidebar, call_user_func_array, WidgetCache->widget_cache_redirected_callback, call_user_func_array, widget_traffic_stats, view, get_traffic, dbrc_wpdb->query, dbrc_wpdb->dbcr_query
    [11-Jan-2014 14:05:20 UTC] WordPress database error Duplicate entry 'XXX.XXX.XXX.XXX-1389449120' for key 'PRIMARY' for query SELECT COUNT(*) FROM wp_tsw_log where Time > 1386857120 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), call_user_func_array, wpsc_all_products_on_page, include('/themes/customizr/index.php'), do_action('__after_main_wrapper'), call_user_func_array, get_footer, locate_template, load_template, require_once('/themes/customizr/footer.php'), do_action('__footer'), call_user_func_array, TC_footer_main->tc_widgets_footer, dynamic_sidebar, call_user_func_array, WidgetCache->widget_cache_redirected_callback, call_user_func_array, widget_traffic_stats, view, get_traffic, dbrc_wpdb->query, dbrc_wpdb->dbcr_query
    [11-Jan-2014 14:05:20 UTC] WordPress database error Duplicate entry 'XXX.XXX.XXX.XXX-1389449120' for key 'PRIMARY' for query SELECT COUNT(DISTINCT IP) FROM wp_tsw_log where Time > 1389448520 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), call_user_func_array, wpsc_all_products_on_page, include('/themes/customizr/index.php'), do_action('__after_main_wrapper'), call_user_func_array, get_footer, locate_template, load_template, require_once('/themes/customizr/footer.php'), do_action('__footer'), call_user_func_array, TC_footer_main->tc_widgets_footer, dynamic_sidebar, call_user_func_array, WidgetCache->widget_cache_redirected_callback, call_user_func_array, widget_traffic_stats, view, get_traffic, dbrc_wpdb->query, dbrc_wpdb->dbcr_query`

    It doesn't happen that often, but as I recall, it does happen when I'm logged in 2 separate browser pages/browsers to both my WordPress website and my WordPress dashboard or twice to my WordPress website or twice to my WordPress Dashboard.

    It's not a showstopper, but it does generate a server error log entry, so I hope a check can be added to avoid trying to insert a duplicate user IP into the db.

    http://wordpress.org/plugins/traffic-stats-widget/

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic