MyBB Community Forums

Full Version: SQL Error 1364
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hello!

First is to say, good work with the Forum.

One problem I want to register new users when I get this error.

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1364 - Field 'thx' doesn't have a default value
Query:
INSERT INTO mybb_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) VALUES ('speedcoremo','a612256ca69080dd512f3ba9f9682360','bvqeFBgk','WryEr9YZFgb99Q7nyC4DwKoqbBYXbG6JpkfJwXHChIqRq9hth8','[email protected]','0','','','5','','0','','1337329443','1337329443','1337329443','','0','','','','','','1','0','0','1','0','1','0','1','1','1','1','0','0','0','0','10','2','linear','0','','','84.114.248.21','1416820757','','1','0','0','0','','','0','0','','','','0','0','0','0','0','0','0','')

You can test this at: http://www.flourity-wow.eu/forum/
Hi welcome to MyBB, Smile

Field 'thx' is not a default column, so it must be from a plugin.
Uninstall the related plugin (or "dig in" and fix it), and then your reg will work.*
*If you uninstall the plugin and still get the error, then you need to manually delete the 'thx' column.
thx - must be a thank you plugin that causing this issues.
OK Thanks.