• Resolved mathse

    (@mathse)


    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)
  • Plugin Support Lap

    (@lapzor)

    Strange!

    Do you have direct access to your database, eg via PhpMyAdmin?
    Maybe you can manually correct the issue there, although that still wouldn’t explain what caused it in the first place…

    Thread Starter mathse

    (@mathse)

    Hello,

    yes, I have direct access to the database, but the error rarely occurs (I just got it 2 times during the last weeks). So I don’t know if I should really change the database by hand?

    Greetings and thanks for the support

    Mathse

    Plugin Author Danny van Kooten

    (@dvankooten)

    Hello,

    We’ve just released an update to the plugin (version 1.0.29) in which this issue should be addressed.

    Hope that helps!

    Thread Starter mathse

    (@mathse)

    Wow!!! That was fast – and unexpected.
    Thank you so much for this quick help and fix. I just installed the update (and hope the error is gone). Since I rarely saw the error before, I’m not quite sure yet, but since you say it’s fixed, I’m quite optimistic.

    Thank you so much for this great Plugin and the great support here!

    Greetings

    Mathse

    Plugin Support Lap

    (@lapzor)

    Do let us know if the issue comes up again anyway. Thanks!

    Hello my friend i wish you all the best i may have the solution to your problem, maybe i think its because that you made the attribut “wp_koko_analytics_referrer_urls.url”
    you need to disable unique constraint from it or raise an exception in php to avoid the error and show the user an suitable error for this problem so he can avoid typing in an duplicate value

    Plugin Support Lap

    (@lapzor)

    hi @brahimalloud , did you already update your koko plugin? what version of koko Analytics are you using currently where you are experiencing this issue? Thanks for letting me know.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Uncaught mysqli_sql_exception: Duplicate entry’ is closed to new replies.