Title: WordPress database error Duplicate entry Last modified: August 21, 2016 --- # WordPress database error Duplicate entry * [ReactorShop](https://wordpress.org/support/users/reactorshop/) * (@reactorshop) * [12 years, 4 months ago](https://wordpress.org/support/topic/wordpress-database-error-duplicate-entry-3/) * 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 INTO`wp_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/](http://wordpress.org/plugins/traffic-stats-widget/) The topic ‘WordPress database error Duplicate entry’ is closed to new replies. * ![](https://s.w.org/plugins/geopattern-icon/traffic-stats-widget.svg) * [Plugin Name: Traffic Stats Widget Plugin](https://wordpress.org/plugins/traffic-stats-widget/) * [Frequently Asked Questions](https://wordpress.org/plugins/traffic-stats-widget/#faq) * [Support Threads](https://wordpress.org/support/plugin/traffic-stats-widget/) * [Active Topics](https://wordpress.org/support/plugin/traffic-stats-widget/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/traffic-stats-widget/unresolved/) * [Reviews](https://wordpress.org/support/plugin/traffic-stats-widget/reviews/) * 0 replies * 1 participant * Last reply from: [ReactorShop](https://wordpress.org/support/users/reactorshop/) * Last activity: [12 years, 4 months ago](https://wordpress.org/support/topic/wordpress-database-error-duplicate-entry-3/) * Status: not resolved