Uncaught mysqli_sql_exception: Duplicate entry
-
Hello,
I use koko analytics for quite some time (over 1 year) on my blog without any issues. Recnetly I git an error, when opening the “Analytics page” – I don’t remember the error message in detail, but it was something like: “an uncaught error occured. Please contact your administrator”.
After reloading the page everything works as expected.On my server I see the following error at the time in my logs:
Nginx [2969]: 2022/01/23 21:37:46 [error] 37#37: *5163798 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught mysqli_sql_exception: Duplicate entry 'https://r.search.yahoo.com/_ylt=AwrXXXXXXXX.;_ylu=Y2' for key 'wp_koko_analytics_referrer_urls.url' in /var/www/html/wp-includes/wp-db.php:2056 Nginx [2969]: Stack trace: Nginx [2969]: #0 /var/www/html/wp-includes/wp-db.php(2056): mysqli_query() Nginx [2969]: #1 /var/www/html/wp-includes/wp-db.php(1945): wpdb->_do_query() Nginx [2969]: #2 /var/www/html/wp-content/plugins/koko-analytics/src/class-aggregator.php(198): wpdb->query() Nginx [2969]: #3 /var/www/html/wp-includes/class-wp-hook.php(303): KokoAnalytics\Aggregator->aggregate() Nginx [2969]: #4 /var/www/html/wp-includes/class-wp-hook.php(327): WP_Hook->apply_filters() Nginx [2969]: #5 /var/www/html/wp-includes/plugin.php(470): WP_Hook->do_action() Nginx [2969]: #6 /var/www/html/wp-content/plugins/koko-analytics/src/class-admin.php(111): do_action() Nginx [2969]: #7 /var/www/html/wp-includes/class-wp-hook.php(303): KokoAnalytics\Admin->show_page() Nginx [2969]: #8 /var/www/html/wp-includes/class-wp-hook.php(327): WP_Hook->apply_filters() Nginx [2969]: #9 /var/www/html/wp-includes/plugin.php(470): WP_Hook->do_action() Nginx [2969]: #10 /var/www/html/wp-admin/admin.php(259): do_action() Nginx [2969]: #11 /var/www/html/wp-admin/index.php(10): require_once('/var/www/html/w...') Nginx [2969]: #12 {main} Nginx [2969]: thrown in /var/www/html/wp-includes/wp-db.php on line 2056" while reading upstream, client: XX.XX.XX.XX, server: MYSERVER.net, request: "GET /wp-admin/index.php?page=koko-analytics HTTP/1.0", upstream: "fastcgi://XX.XX.XX.XX:9000", host: "MYSERVER.net", referrer: "MYREFERRER"
I use WordPress 5.8.3 with PHP 8.1.1.
Maybe someone can help me here with this?Thanks and greetings
Mathse
Viewing 7 replies - 1 through 7 (of 7 total)
Viewing 7 replies - 1 through 7 (of 7 total)
- The topic ‘Uncaught mysqli_sql_exception: Duplicate entry’ is closed to new replies.