MyBB Community Forums

Full Version: MyTabs error 1364 - Field 'default_tab' doesn't have a default value
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hello
I have installed this plugin:  https://community.mybb.com/mods.php?action=view&pid=456
When I try to register I get this error: 
1364 - Field 'default_tab' doesn't have a default value

How can i solve?

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1364 - Field 'default_tab' 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`,`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`,`lastip`,`language`,`showcodebuttons`,`sourceeditor`,`buddyrequestspm`,`buddyrequestsauto`,`away`,`awaydate`,`returndate`,`awayreason`,`referrer`,`referrals`,`buddylist`,`ignorelist`,`pmfolders`,`notepad`,`warningpoints`,`moderateposts`,`moderationtime`,`suspendposting`,`suspensiontime`,`coppauser`,`classicpostbit`,`usernotes`,`dst`,`myalerts_disabled_alert_types`,`ougc_awards`) VALUES ('sdgsdgdgs','8b1956a2f4f250268552f17633631b8b','e5R04p74','Tz5Qgwv5FaIkALtzAAx7uSiAB5WHi5jOk4ABtSiAKBF1gPDEdq','[email protected]',0,0,'','',2,'',0,'',1673899845,1673899845,1673899845,'',0,'','','','',0,0,0,0,0,0,0,1,1,1,1,1,1,0,0,0,0,'0',0,'',0,'','',X'ac4766c7',X'','',1,0,1,0,0,0,0,'',0,0,'','','0**$%%$1**$%%$2**$%%$3**$%%$4**','',0,0,0,0,0,0,0,'',0,'[]','')


https://i.imgur.com/JwusWMN.png

[Image: JwusWMN.png]
This is pretty common I think with older plugins - which that is.  Have a look at the last updated date - 2015-04-01, 12:20 PM.

You're probably running up against a strict mode database issue.  Similar thread and troubleshooting suggestions here:

https://community.mybb.com/thread-223174.html