Problem on registering new user
By Giulio Curà on Wednesday, 05 March 2014
Posted in Technical Issues
Likes 0
Views 808
Votes 0
Hello , I set up EASYDISCUSS, but have serious problem on new registration ,

When a new user try registering he get this error :

Attenzione
Registrazione fallita: Registrazione fallita: Duplicate entry '0' for key 'PRIMARY' SQL=INSERT INTO `g6305_discuss_users` (`nickname`,`description`,`url`,`params`,`points`,`location`,`signature`) VALUES ('','','','{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\",\"skype\":\"\"}','0','','')



Existing users have been migrated from a previous Joomla

Could you please help me ??
Hello Allot77,

Sorry for late reply to this,
I have tried to access in your cpanel, it look like you provided that login credential is not working

You also can apply this fixes in your file > JoomlaFolder\plugins\user\easydiscussprofile\easydiscussprofile.php

LINE 195


$profile->params	= $userparams->toString();



				if( !$profile->store() )

				{


Replace with,



    $profile->params	= $userparams->toString();

 

				if( !$profile->id )

				{

					$profile->id 	= $userId;

				}

			

 				if( !$profile->store() )

 				{


Hope this help.
Arlex Wong
·
Monday, 07 April 2014 16:16
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Giulio Curà,

Sorry for late reply to this,
it seems like you hitting that error during the registration is because the system duplicate entry '0' from your database table g6305_discuss_users
see my screenshot : http://screencast.com/t/RBki8wc3aF (can you see that id=0 that user " lucius801 ")
May i know that user is it still available in your site? Because the ID should not be 0.
Maybe when you migrate the user from old site to new site, all the disable user data also migrated in your new site then causing out this error.
Arlex Wong
·
Wednesday, 05 March 2014 18:27
·
0 Likes
·
0 Votes
·
0 Comments
·
Sorry but I cannot understand we'll..

the Lucius user is still available ( see screenshot attached )

This user is not been migrated from the old joomla ( did you added it yourself? ) new id's are highs and start from 1563… so i cannot understand how this user id is set to 0

Can be enough deleting this user ?
Giulio Curà
·
Wednesday, 05 March 2014 18:47
·
0 Likes
·
0 Votes
·
0 Comments
·
hello Giulio Curà,

It okay, if that user id=0 is not valid user from your site, try delete it and see if could help?
Arlex Wong
·
Wednesday, 05 March 2014 19:16
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello !!

During registration two raws are inserted on discuss user table

-one has the right infromations with the right ID ( auto incremented)

-the other comes with id=0 and nulls values


if I do cancel ID=o user from database it gives me successful registration, but if I try a new one it gives me the same error since every registration query insert 2 rows:
as above, one with the right ID and one with ID=0


Any help ??
Giulio Curà
·
Wednesday, 05 March 2014 20:15
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Giulio Curà,

Sorry for late reply to this,
Actually that was known issues, i have help you fixed, please have a check.
Arlex Wong
·
Thursday, 06 March 2014 00:57
·
0 Likes
·
0 Votes
·
0 Comments
·
Thank you so much !!!


I must say again YOU ROCK GUYS !!!!


Stackideas has the best assistance ever found on joomla things !!!!

Continue like this !!!
Giulio Curà
·
Thursday, 06 March 2014 01:11
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Giulio Curà,

Thanks for your compliment
Wish you have a nice day.
Arlex Wong
·
Thursday, 06 March 2014 01:19
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi, I have the same problem here.
No migrations done, just a fresh installation of Easy discuss.
I was trying to do some test registering new users as I've encountered the same warning message during new registrations.
So I have deleted all "test users" from database and seems that the problem is solved.
But I noticed that all the time I do a new registration, a user with ID "0" is created in the database on the table " i0z92_discuss_users"
Also noticed that if I delete users form joomla backend, them are still visible in Easy discuss "users" backend.
Hope you can help me
Allot77
·
Monday, 07 April 2014 14:18
·
0 Likes
·
0 Votes
·
0 Comments
·
Done the edit, nothing exploded... it seems to works.
Thank you for your prompt reply... looking forward for eventual disfunctions!
Allot77
·
Monday, 07 April 2014 17:35
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Allot77,

You're welcome, glad to heard your issues resolved.
Arlex Wong
·
Monday, 07 April 2014 17:52
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post