MyBB Community Forums

Full Version: Error 1364
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
When ever a user tries to sign up on my site
they get this error message;

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1364 - Field 'myalerts_disabled_alert_types' doesn't have a default value
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`) VALUES ('kkk','2a006cc87a21298947875d325303651c','0gg6XV9N','hDPnQxN7JHxj9qA6m1VnnaHyDdT28RKoUulTQf6vUaWNEkWmhx','[email protected]',0,0,'','',2,'',0,'',1482032668,1482032668,1482032668,'',0,'','','','','','',1,0,0,1,0,1,0,1,1,1,1,1,1,0,0,0,0,'0',2,'linear',0,'','',X'ac44360e','',1,0,1,0,0,0,0,'','',0,0,'','','',0,0,0,0,0,0,0,'')
Please contact the MyBB Group for technical support.
I have no clue what to do with this. Iv'e never had issues like this.
Website URL: Site (frozoforums.net)
Please help.
Kind Regards.
first try to disable myalert plugin then test it again