Getting MySQL errors when creating users through EasySocial
By Dave Parker on Friday, 06 June 2014
Posted in Technical Issues
Likes 0
Views 670
Votes 0
Hi.
Just setting up a new site, and have noticed that when people register (well, through quick registration anyway), I am getting this error
1062 - Duplicate entry '0' for key 'PRIMARY' SQL=INSERT INTO `cxvoz_discuss_users` (`points`) VALUES ('0')
If I delete the "0" entry in the _discuss_users table, another registration is allowed.
How can I fix this.
On the latest releases of all products
Dave
Hello Dave Parker,

Sorry for late reply to this,
I have applied some fixes in your site, it work fine now, please have a check.
JoomalFolder\administrator\components\com_easydiscuss\tables\profile.php
JoomlaFolder\media\com_easysocial\apps\fields\user\discuss_signature\discuss_signature.php
Arlex Wong
·
Friday, 06 June 2014 16:43
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Dave Parker,

Sorry for late reply to this,
That might causing issues from the easydiscuss plugin, can i have your Joomla backend and FTP access so we can help you check on this? Please advise.
Arlex Wong
·
Friday, 06 June 2014 08:42
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi
I've added the site details in the section below
Dave Parker
·
Friday, 06 June 2014 13:16
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi.
Thanks. Will this persist during future upgrades to EasyDiscuss and EasySocial or is it something I need to keep an eye on?
Dave
Dave Parker
·
Friday, 06 June 2014 16:52
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Dave Parker,

You're welcome, this fixes will be including in next release version of Easydiscuss.
Arlex Wong
·
Friday, 06 June 2014 16:57
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks for all your help Arlex. Have a good evening.
Dave
Dave Parker
·
Friday, 06 June 2014 17:04
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Dave Parker,

You're welcome, have a nice weekend too
Arlex Wong
·
Friday, 06 June 2014 17:52
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post