WordPress database error Duplicate entry

  • Resolved dominic_ks

    (@dominic_ks)


    10 years, 9 months ago

    Hi,

    I’ve seen that this error has been asked about many times, but I’m struggling to find a thread with a solution. I’m getting the following error lots in my logs and the mentioned table does indeed contain a large number of duplicated rows. As far as I can see this isn’t producing any adverse affects for my users, but would appreciate if anyone knows how to resolve:

    WordPress database error Duplicate entry '92aa1b8fc02ceb3d76d5f19798d36708' for key 'PRIMARY' for query INSERT INTO wp_domain_mapping_logins (id,user_id,blog_id,t) VALUES( '92aa1b8fc02ceb3d76d5f19798d36708', 0, 3, NOW() ) made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, ITSEC_Lockout->check_lockout, ITSEC_Lockout->execute_lock, wp_logout, do_action('wp_logout'), call_user_func_array, remote_logout_loader

    https://ww.wp.xz.cn/plugins/wordpress-mu-domain-mapping/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Ron Rennick

    (@wpmuguru)

    10 years, 9 months ago

    I think there is a conflict between iThemes Security & domain mapping (possibly the security plugin is re-logging the user in which is triggering a second insert).

    George wp-website-mastery

    (@lernerconsult)

    10 years, 7 months ago

    Simply using INSERT instead of INSERT … ON DUPLICATE KEY UPDATE syntax. Very likely no affect on the plugin working. Minor programming sloppiness.

    “table does indeed contain a large number of duplicated rows” — Check again, the Primary Key can never be duplicate, MySQL blocks duplicates; the error message you got is MySQL reporting it is preventing inserting a record that would cause a duplicate primary key.

    George wp-website-mastery

    (@lernerconsult)

    10 years, 7 months ago

    iThemes Security isn’t “re-logging the user” but rather tracking incorrect login attempts, and 404 File Not Found errors, and other “bad behavior by a visitor” to block hackers.

    This has nothing to do with the Domain Mapping plugin, and should be marked resolved. (I and others have reported this in the iThemes Security plugin support area.)

    Thread Starter dominic_ks

    (@dominic_ks)

    10 years, 7 months ago

    Ok will check out the threads in iThemes Security.

    Thanks all.

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

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

Tags