WordPress database error Duplicate entry

  • Resolved salih24by7

    (@salih24by7)


    8 months ago

    Getting WordPress database error Duplicate entry a lot in my server error log, I am using latest version of the Plugin with PHP 8.2, Is there any fix for this?

    [Fri Jul 25 06:27:19.728441 2025] [proxy_fcgi:error] [pid 2xxxxxxx] [client xx.xxx.x.xx:xxxxx] AH01071: Got error ‘PHP message: WordPress database error Duplicate entry ‘8388607’ for key ‘wp3y_sbb_visitorslog.PRIMARY’ for query INSERT INTO wp3y_sbb_visitorslog\n\t\t\t(ip, date, human, response, bot, method, url, referer, ua, access, reason)\n\t\t\tVALUES (‘xx.xxx.x.xx’, CURRENT_TIMESTAMP(), ‘Maybe’, ‘200’, ‘?’, ‘GET’, ‘/event-directory/2024-06-08/’, ”, ‘meta-externalagent/1.1 (+https://developers.facebook.com/docs/sharing/webmasters/crawler)’, ‘Masked’, ”) made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), WP_Hook->do_action, WP_Hook->apply_filters, stopbadbots_record_log’

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author sminozzi

    (@sminozzi)

    8 months ago

    Hello,
    I’m sorry to hear about the issues you’re experiencing.

    There are several possibilities that could cause table insertion errors, such as:

    1. Insufficient memory (either WordPress or PHP server memory).
    2. A corrupted database table or index.
    3. Lack of space on the server’s hard drive.
    4. An overloaded server.
    5. Malware on the site.
    6. Among other factors.

    I suggest you install our free Site Checkup plugin. It will likely provide more detailed information about the cause of these errors. I have this plugin running on approximately 50 sites, and I don’t see this type of error on them.
    https://wordpress.org/plugins/site-checkup

    Please post your findings here, and I’ll do my best to help.
    Regards,
    Bill
    Plugin Developer

    Thread Starter salih24by7

    (@salih24by7)

    8 months ago

    Thank you for the quick response, let me check and get back to you.

    Plugin Author sminozzi

    (@sminozzi)

    8 months ago

    Hello,
    You are welcome.
    To keep things organized, I’m marking this as resolved. Feel free to post new information if you need anything.
    Regards,

    Bill

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘WordPress database error Duplicate entry’ is closed to new replies.