MyBB Community Forums
[Error Message] User registration crashed - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: General Support (https://community.mybb.com/forum-176.html)
+--- Thread: [Error Message] User registration crashed (/thread-226004.html)



User registration crashed - RigPa - 2020-01-09

Just got this one trying to add a user from admin panel. 

MyBB has experienced an internal SQL error and cannot continue.
SQL Error:1054 - Unknown column 'msn' in 'field list'Query:INSERT INTO bb_users (username,password,salt,loginkey,email,postnum,avatar,avatartype,usergroup,additionalgroups,displaygroup,usertitle,regdate,lastactive,lastvisit,website,icq,aim,yahoo,msn,birthday,signature,allownotices,hideemail,subscriptionmethod,receivepms,receivefrombuddy,pmnotice,pmnotify,showsigs,showavatars,showquickreply,showredirect,tpp,ppp,invisible,style,timezone,dstcorrection,threadmode,daysprune,dateformat,timeformat,regip,longregip,language,showcodebuttons,away,awaydate,returndate,awayreason,notepad,referrer,referrals,buddylist,ignorelist,pmfolders,warningpoints,moderateposts,moderationtime,suspendposting,suspensiontime,coppauser,classicpostbit,usernotes,dst) VALUES ('Debra Quincy','2ded2de092aca6b47f84c27461c5ba09','tygSbIqe','wceLxoyGQgass9TDz99tCefuNgOeXdf6wK2cnD2R7Lu8c1FSHJ','[email protected]','0','','','4','','4','','1578584443','1578584443','1578584443','','0','','','','','','1','0','0','1','0','1','0','1','1','1','1','0','0','0','0','','0','linear','0','','','','0','','1','0','0','0','','','0','0','','','','0','0','0','0','0','0','1','','0')
Please contact the MyBB Group for support.


RE: User registration crashed - User 129272 - 2020-01-09

(2020-01-09, 03:44 PM)RigPa Wrote: Just got this one trying to add a user from admin panel. 

MyBB has experienced an internal SQL error and cannot continue.
SQL Error:1054 - Unknown column 'msn' in 'field list'Query:INSERT INTO bb_users (username,password,salt,loginkey,email,postnum,avatar,avatartype,usergroup,additionalgroups,displaygroup,usertitle,regdate,lastactive,lastvisit,website,icq,aim,yahoo,msn,birthday,signature,allownotices,hideemail,subscriptionmethod,receivepms,receivefrombuddy,pmnotice,pmnotify,showsigs,showavatars,showquickreply,showredirect,tpp,ppp,invisible,style,timezone,dstcorrection,threadmode,daysprune,dateformat,timeformat,regip,longregip,language,showcodebuttons,away,awaydate,returndate,awayreason,notepad,referrer,referrals,buddylist,ignorelist,pmfolders,warningpoints,moderateposts,moderationtime,suspendposting,suspensiontime,coppauser,classicpostbit,usernotes,dst) VALUES ('Debra Quincy','2ded2de092aca6b47f84c27461c5ba09','tygSbIqe','wceLxoyGQgass9TDz99tCefuNgOeXdf6wK2cnD2R7Lu8c1FSHJ','[email protected]','0','','','4','','4','','1578584443','1578584443','1578584443','','0','','','','','','1','0','0','1','0','1','0','1','1','1','1','0','0','0','0','','0','linear','0','','','','0','','1','0','0','0','','','0','0','','','','0','0','0','0','0','0','1','','0')
Please contact the MyBB Group for support.
It seems like either a plugin or outdated code is adding a "msn" field for users - which, as far as I know, is not a part of MyBB by default. Could you try with a stock admin CP?


RE: User registration crashed - RigPa - 2020-01-09

Ahhhh thanks. That plugin was damaged somehow. Reinstalled it and voila!