WPIntell

Source evidence

WordPress database error Duplicate entry

Plugin Name: Traffic Stats Widget Plugin · support · 2014-01-25T21:24:00+00:00

complaintsentiment
mediumseverity
0.81relevance
0replies
Evidence onlycommercial context

Proof Health

Open evidence

Commercial opportunities need traceable source links before they are treated as build-worthy.

1 / 1 rows with source links

100.0% of this page's analysis has direct source links.

0 build-decision rows missing links

0 rows here require auditable proof before promotion.

0 rows with no attached evidence

0 rows have source counts but still need direct links.

Conversation

support
ReactorShop unresolved
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/

Comments

0 shown

No comments were stored for this source.