MyBB Community Forums

MyBB Community Forums > 1.8 Support > General Support > User registration crashed
Full Version: User registration crashed
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

RigPa

2020-01-09, 03:44 PM
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.

User 129272

2020-01-09, 03:56 PM
(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?

RigPa

2020-01-09, 05:37 PM
Ahhhh thanks. That plugin was damaged somehow. Reinstalled it and voila!
MyBB Community Forums > 1.8 Support > General Support > User registration crashed