Topic-icon [solved] Error while registering - Easysocial

  • aaronpie
  • aaronpie's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
28 Jan 2016 20:29 - 29 Jan 2016 00:16 #31205 by aaronpie
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.
Last edit: 29 Jan 2016 00:16 by nordmograph.

Please Log in or Create an account to join the conversation.

More
28 Jan 2016 21:43 - 28 Jan 2016 22:15 #31209 by nordmograph
Replied by nordmograph on topic [solved] Error while registering - Easysocial
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.

- Need help? Post the URL of the related page (eventualy as confidential info), it will help solve your issue faster.
- An error, notice or warning? report the exact message including the line number
- If you get a white page , enable error reporting and / or check your server error logs.
Last edit: 28 Jan 2016 22:15 by nordmograph.

Please Log in or Create an account to join the conversation.

  • aaronpie
  • aaronpie's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
29 Jan 2016 00:11 #31211 by aaronpie
Replied by aaronpie on topic [solved] Error while registering - Easysocial
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.
The following user(s) said Thank You: nordmograph

Please Log in or Create an account to join the conversation.

More
29 Jan 2016 00:15 #31212 by nordmograph
Replied by nordmograph on topic [solved] Error while registering - Easysocial
Interesting, thanks for reporting.

- Need help? Post the URL of the related page (eventualy as confidential info), it will help solve your issue faster.
- An error, notice or warning? report the exact message including the line number
- If you get a white page , enable error reporting and / or check your server error logs.

Please Log in or Create an account to join the conversation.

Powered by Kunena Forum
Disclaimer: Nordmograph is not affiliated with or endorsed by The Joomla! Project™. Any products and services provided through this site are not supported or warrantied by The Joomla! Project or Open Source Matters, Inc. Use of the Joomla!® name, symbol, logo and related trademarks is permitted under a limited license granted by Open Source Matters, Inc.
Copyright © 2022 Nordmograph - Joomla extensions. All Rights Reserved.
Joomla! is Free Software released under the GNU General Public License.
Browser of the future