MyBB Community Forums

Hello,
A few days ago, I tried to install a plugin that would make members able to sign in through steam. As I said before, I did not manage to put the plugin working (due to unknown reasons) and so I deleted it.
Now everytime I join my website, I see that the last user that register was "Nobody", and whenever I try to create a new user on the Admin Control Panel or register a new user in the registration page, I get this MySQL error:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:1062 - Duplicate entry '' for key 'loginname'Query:
INSERT INTO (database name removed for security reasons)  (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,dst) 

VALUES (values appear here)
________________________________________________________________________________________________________________________

I am aware this error appears when we try to create a user with the same login name, but this is not happening. The users I am creating have different names in relation to the already existing ones. 

If you please could help me on this issue, I would be appreciate it a LOT.
Thank you,
Pmx.pt

which plugin exactly you have used for the steam login & have you uninstalled it or deleted its files ?

FIXED: I checked the database and there was a line, on a table in which the loginame field was empty. That way it wouldnt allow any users to register.
Thank you for your reply!

Hello,
I have a mysql problem. Everytime a user registers, the "loginname" value for that user isn't defined in the Mybb mysql database table and therefore the next user that tries to register, fails to do so, as the error (presented below) shows up due to the fact that the loginname field wasn't setup in the previous user.
This is happening after I installed a steam login plugin which came with another plugin that was able to change the display nicknames of my website users.
(I unistalled both plugins and removed them from the Mybb installation. That is why I am not understanding why "loginname" value isn't being defined for new registered users).

( website: https://forum.cyberfleet.net/index.php )

How can I fix this error?


Error: https://gyazo.com/0d1dd9e4a56b3648a275bb979b756443
Steam plugin: https://github.com/noxwyll/Steam-Login-MyBB-1.8
Display Names plugin: https://github.com/noxwyll/Steam-Login-M...nc/plugins

This is urgent!
If somebody could help me I would be thankful.
Thank you,
pmx.pt


"FIXED": I installed the plugin I removed and it started to work again. I think the plugin messed up with the loginname field.