[solved] Error while registering - Easysocial

I am using the auto friend plugin with Easysocial 1.4.2. If I select either request or automatic friend request, I am getting the following error when submitting my registration form on my website. The user is still created, but the user is given the error and never taken to the confirmation page to let them know that they have completed the registration and that they will need to wait for Admin approval.

1062 Duplicate entry '623' for key 'PRIMARY' SQL=INSERT INTO `iox_social_users` (`user_id`,`state`) VALUES ('623','1')

Stackideas has confirmed that the error is triggered by your plugin.

Hello

I'm affraid this is not correct:
Our plugin doesn't insert anything on that #__social_users table.
It does not create users.

It only creates friendships.
It only inserts data in #__social_friends

that query
INSERT INTO `#__social_users` (`user_id`,`state`)
does not appear anywhere in our plugin code
have a look in the only php file of our plugin:
plugins/user/autofriend/autofriend.php

search for
#__social_users
you'll only find SELECT queries (reading) and no INSERT
INSERT will only be processed for #__social_friends table.

Let me know if I can be of any help.

So it looks like I fixed the issue by moving the plugin to the bottom of the User plugin list. Originally it was up at the top before the User - Easysocial plugin. Now I am able to register on my site without getting the error.

Interesting, thanks for reporting.