Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Solved: 3 Years, 4 Months, 2 Weeks ago SQL Error when trying to register!
#1
Solved: 3 Years, 4 Months, 2 Weeks ago
Hey guys, when a player registers they get this error:

SQL Error:1062 - Duplicate entry '' for key 'loginname'Query: INSERT INTO mybb_users (username,password,salt,loginkey,email,postnum,threadnum,avatar,avatartype,usergroup,additionalgroups,displaygroup,usertitle,regdate,lastactive,lastvisit,website,icq,aim,yahoo,skype,google,birthday,signature,allownotices,hideemail,subscriptionmethod,receivepms,receivefrombuddy,pmnotice,pmnotify,showimages,showvideos,showsigs,showavatars,showquickreply,showredirect,tpp,ppp,invisible,style,timezone,dstcorrection,threadmode,daysprune,dateformat,timeformat,regip,language,showcodebuttons,sourceeditor,buddyrequestspm,buddyrequestsauto,away,awaydate,returndate,awayreason,notepad,referrer,referrals,buddylist,ignorelist,pmfolders,warningpoints,moderateposts,moderationtime,suspendposting,suspensiontime,coppauser,classicpostbit,usernotes,myalerts_disabled_alert_types) VALUES ('test','925eb0b4e0233dcc139e95d34ee9e0c9','GfZ4YrSD','PgK4Agw2A8JxhvOeh1oPrfu0o1SCaGCcoO2IfvblmG2kxLV5wn','[email protected]',0,0,'','',5,'',0,'',1479172036,1479172036,1479172036,'',0,'','','','','2-3-1

My board url is here: anathemanetwork.com

I haven't installed any new plugins and registrations were working fine till yesterday.
Reply
#2
Solved: 3 Years, 4 Months, 2 Weeks ago
Appears that the user is using the same name as "test". I would highly suggest making sure you are using the most current version of MyBB.
Hey Everyone I am back! I will slowly be in progression of helping you all with your questions!


Reply
#3
Solved: 3 Years, 4 Months, 2 Weeks ago
(2016-11-15, 01:27 AM)VoIP Wrote: Appears that the user is using the same name as "test". I would highly suggest making sure you are using the most current version of MyBB.

I am, these issues have arised after trying to install the steam login plugin. Also yes that user had the username of test as I was testing it, but it does it for any kind of username.
Reply
#4
Solved: 3 Years, 4 Months, 2 Weeks ago
Is the MyBB plugin for 1.8?
Hey Everyone I am back! I will slowly be in progression of helping you all with your questions!


Reply
#5
Solved: 3 Years, 4 Months, 2 Weeks ago
(2016-11-15, 03:23 AM)VoIP Wrote: Is the MyBB plugin for 1.8?

Yep but it didn't work so I removed it.
Reply
#6
Solved: 3 Years, 4 Months, 2 Weeks ago
(2016-11-15, 05:04 AM)orc Wrote:
(2016-11-15, 03:23 AM)VoIP Wrote: Is the MyBB plugin for 1.8?

Yep but it didn't work so I removed it.

Same issue?
Hey Everyone I am back! I will slowly be in progression of helping you all with your questions!


Reply
#7
Solved: 3 Years, 4 Months, 2 Weeks ago
(2016-11-15, 05:09 AM)VoIP Wrote:
(2016-11-15, 05:04 AM)orc Wrote:
(2016-11-15, 03:23 AM)VoIP Wrote: Is the MyBB plugin for 1.8?

Yep but it didn't work so I removed it.

Same issue?

Yes.
Reply
#8
Solved: 3 Years, 4 Months, 2 Weeks ago
^ have you disabled & uninstalled the steam plugin or just removed its files ?
which steam plugin you have tried - can you give its link ..
Reply
#9
Solved: 3 Years, 4 Months, 2 Weeks ago
(2016-11-15, 06:28 AM).m. Wrote: ^ have you disabled & uninstalled the steam plugin or just removed its files ?
which steam plugin you have tried - can you give its link ..

Turns out that the Steam plugin by stewartiee adds an extra column in the mybb_users table called loginname. After disabling, and uninstalling the steam plugin and removing its files the loginname column was still there. Removing the loginname column fixed this problem. Thanks for the help.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)