Database error Duplicate Entries

  • WordPress database error Duplicate entry ‘1cb8588b0f4b7f7ce4956ffebe72aba6’ for key ‘PRIMARY’ for query INSERT INTO PREFIX_domain_mapping_logins ( id, user_id, blog_id, t ) VALUES( ‘1cb8588b0f4b7f7ce4956ffebe72aba6’, 0, SITEID, NOW() ) made by require(‘wp-load.php’), require_once(‘FOLDER/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

    Numerous error_log entries, different ID values, for all the Sites on the multi-site.

    https://www.ads-software.com/plugins/better-wp-security/

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

  • @lernerconsulting

    Google this:

    site:www.ads-software.com/support/ “ithemes security” wp_domain_mapping_logins

    Even though iThemes claims this plugin supports Multi Site I would not recommend using it in a Multi Site WP env …
    This plugin Multi Site support is C R A P and needs a LOT of work … which I haven’t seen happening in the last 11 months …

    dwinden

    Thread Starter lernerconsulting

    (@lernerconsult)

    dwinden, I have been using iThemes security without problem on several multi-site installations.

    Many of the problems that query you posted finds, are from two users who complain repeatedly. I won’t take their griping as a reason to not use this plugin. You shouldn’t either.

    The error I posted is Very Minor. I run my site with maximum error reporting for my development and troubleshooting needs, or I wouldn’t see it.

    The error is from common programming practice of making a MySQL Insert command without first checking if the record exists. Simply using INSERT instead of INSERT … ON DUPLICATE KEY UPDATE syntax. Very likely no affect on the plugin working. Minor programming sloppiness.

    The only problem is this very minor error adds entries to the error log file, on the relatively rare sites that have detailed error reporting on.

    @lernerconsulting

    I’m happy to hear that you have “been using iThemes security without problem on several multi-site installations.”

    I assure you that my opinion is not based on just 1 or 2 users “griping”.
    In general my opinion is well founded.

    Read these posts:

    https://www.ads-software.com/support/topic/bug-fix-for-lost-password-page-in-hide-login-area

    https://www.ads-software.com/support/topic/http-404-with-hide-backend-and-multisite-not_found-potential-fix

    https://www.ads-software.com/support/topic/wrong-url-for-multisite-installs-in-daily-security-digest

    I have another 10 MU bugs if you are interested and I’m not even using multi site …

    But the biggest issue of the iTSec plugin in Multi Site is the incorrect design of the Settings and other pages … It needs to be completely redesigned.

    You need to be a WordPress developer to understand where the problem is.

    But there are some symptoms that should make you scratch your head.
    Ever noticed there is no Screen Options button in the upper right corner of the Settings page when in Multi Site …
    So you can’t switch off the display of metaboxes or change the screen layout from 2 to 1 column …
    Ever noticed there is no “Settings Updated” confirmation msg displayed at the top of the Settings page when Saving All Changes in Multi Site …

    And this is just the free iTSec plugin. The fun really starts in the iTSec Pro release …
    Notice my opinion is based on MU issues of the free iTSec plugin as well as the Pro plugin …

    In general yes it mostly works in MU. But if you look at the code MU support is poorly implemented. And for that reason it’s C R A P.
    Everyone is entitled to his\her own opinion. If you think it’s fine I’m
    ok with that. I will respect your opinion.

    Oh one last thing. Next time you open a topic please provide as much info as possible. Don’t just dump an error and a short one line description …

    Makes it easier for the community to respond to it adequately …
    Crappy topics tend to get likewise responds from me ??

    dwinden

    Since it’s been a while working with MU I didn’t correctly describe one of the MU issues.

    The Settings screen does have a Screen Options button, and you can choose to display 1 or 2 columns, but you cannot disable any metaboxes. There are no metabox checkboxes …

    Apologies for the confusion.

    dwinden

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Database error Duplicate Entries’ is closed to new replies.