Lots of duplicate entries

Can you follow these following steps to debug the issue?
This should be done on development environment only.

1) Disable the User Login History plugin

2) Copy and paste the following script at the end of your theme functions.php file.

function wp_login_test() {
ini_set(‘error_log’, WP_CONTENT_DIR . ‘/user-login-history-test.log’);
error_log(“test”);
}

add_action(‘wp_login’, ‘wp_login_test’);

3) Now do login only for once

4) Remove the script that you pasted in step #2

5) Share the content of the file wp-content/user-login-history-test.log

Aug 05, 09:08:15

test

Aug 05, 09:08:14

test

Since you got two log entries, it means that there is some conflict in your existing plugins (not User Login History because it is already disabled) or theme due to which wp_login hook is called two times on login.
This is the reason that User Login History plugin is saving the record multiple times.

• This reply was modified 5 years, 7 months ago by Faiyaz Alam.

You’re stating the obvious by pointing to another plugin or the theme. I wasn’t blaming the plugin for the cause of duplicate entries, but having entries *exactly* the same serves no purpose and is preventable if you choose to code in a dupe check.

I think that this is not an good idea to fix an issue occurred by conflict of another plugin or theme. You are right that exact same records serves no purpose.
To fix this I have to modify the table structure by adding a unique constant key for all the columns (not one or two columns) of the table and have to do PHP code to check if already the same record exists or not for all the columns again. Due to these changes, the code become complex and hence login would be slow which is not good. This is the reason I should not do anything for this.

Hope this helps.