MyBB Community Forums

MyBB Community Forums > 1.8 Support > General Support > users can't register new accounts
Full Version: users can't register new accounts
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

beast

2021-02-14, 12:19 PM
Hi after importing the FB and installing the forum, everthing is working file boards/posts/likes etc..
till i noticed today that new members can't register account

after adding usernname/pass etc..

it show the error below 


[Image: HMP6o3S.png]

Mastersly

2021-02-14, 12:48 PM
AdmimCP>>Configuration>>Server and Optimization>>Error Type Medium>>warning and errors

Enable it and try to register and post the error here

beast

2021-02-14, 12:57 PM
<error>
	<dateline>1613307186</dateline>
	<script></script>
	<line>0</line>
	<type>20</type>
	<friendly_type>MyBB SQL Error</friendly_type>
	<message>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`,`language`,`showcodebuttons`,`sourceeditor`,`buddyrequestspm`,`buddyrequestsauto`,`away`,`awaydate`,`returndate`,`awayreason`,`notepad`,`referrer`,`referrals`,`buddylist`,`ignorelist`,`pmfolders`,`warningpoints`,`moderateposts`,`moderationtime`,`suspendposting`,`suspensiontime`,`coppauser`,`classicpostbit`,`usernotes`,`myalerts_disabled_alert_types`,`ougc_awards`)
			VALUES ('zererz','d4ace069807350521df25859aeb30df0','guUQnK7s','JxCJx2hXSASkTQm18e1q1Gxh37nWVcloz8mbIWIKzfQGh10Bop','[email protected]',0,0,'','',5,'',0,'',1613307186,1613307186,1613307186,'',0,'','','','',1,0,0,1,0,1,0,1,1,1,1,1,1,0,0,0,0,'0',2,'linear',0,'','',X'66aa7e73','',1,0,1,0,0,0,0,'','',0,0,'','','',0,0,0,0,0,0,0,'','[]','')
		</message>
	<back_trace>#0  errorHandler->log_error(20, 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`,`language`,`showcodebuttons`,`sourceeditor`,`buddyrequestspm`,`buddyrequestsauto`,`away`,`awaydate`,`returndate`,`awayreason`,`notepad`,`referrer`,`referrals`,`buddylist`,`ignorelist`,`pmfolders`,`warningpoints`,`moderateposts`,`moderationtime`,`suspendposting`,`suspensiontime`,`coppauser`,`classicpostbit`,`usernotes`,`myalerts_disabled_alert_types`,`ougc_awards`)
			VALUES ('zererz','d4ace069807350521df25859aeb30df0','guUQnK7s','JxCJx2hXSASkTQm18e1q1Gxh37nWVcloz8mbIWIKzfQGh10Bop','[email protected]',0,0,'','',5,'',0,'',1613307186,1613307186,1613307186,'',0,'','','','',1,0,0,1,0,1,0,1,1,1,1,1,1,0,0,0,0,'0',2,'linear',0,'','',X'66aa7e73','',1,0,1,0,0,0,0,'','',0,0,'','','',0,0,0,0,0,0,0,'','[]','')
		, , 0) called at [/home/qaeczzioas/public_html/inc/class_error.php:189]
#1  errorHandler->error(20, Array ([error_no] => 1364,[error] => 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`,`language`,`showcodebuttons`,`sourceeditor`,`buddyrequestspm`,`buddyrequestsauto`,`away`,`awaydate`,`returndate`,`awayreason`,`notepad`,`referrer`,`referrals`,`buddylist`,`ignorelist`,`pmfolders`,`warningpoints`,`moderateposts`,`moderationtime`,`suspendposting`,`suspensiontime`,`coppauser`,`classicpostbit`,`usernotes`,`myalerts_disabled_alert_types`,`ougc_awards`)
			VALUES ('zererz','d4ace069807350521df25859aeb30df0','guUQnK7s','JxCJx2hXSASkTQm18e1q1Gxh37nWVcloz8mbIWIKzfQGh10Bop','[email protected]',0,0,'','',5,'',0,'',1613307186,1613307186,1613307186,'',0,'','','','',1,0,0,1,0,1,0,1,1,1,1,1,1,0,0,0,0,'0',2,'linear',0,'','',X'66aa7e73','',1,0,1,0,0,0,0,'','',0,0,'','','',0,0,0,0,0,0,0,'','[]','')
		)) called at [/home/qaeczzioas/public_html/inc/db_mysqli.php:597]
#2  DB_MySQLi->error(
			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`,`language`,`showcodebuttons`,`sourceeditor`,`buddyrequestspm`,`buddyrequestsauto`,`away`,`awaydate`,`returndate`,`awayreason`,`notepad`,`referrer`,`referrals`,`buddylist`,`ignorelist`,`pmfolders`,`warningpoints`,`moderateposts`,`moderationtime`,`suspendposting`,`suspensiontime`,`coppauser`,`classicpostbit`,`usernotes`,`myalerts_disabled_alert_types`,`ougc_awards`)
			VALUES ('zererz','d4ace069807350521df25859aeb30df0','guUQnK7s','JxCJx2hXSASkTQm18e1q1Gxh37nWVcloz8mbIWIKzfQGh10Bop','[email protected]',0,0,'','',5,'',0,'',1613307186,1613307186,1613307186,'',0,'','','','',1,0,0,1,0,1,0,1,1,1,1,1,1,0,0,0,0,'0',2,'linear',0,'','',X'66aa7e73','',1,0,1,0,0,0,0,'','',0,0,'','','',0,0,0,0,0,0,0,'','[]','')
		) called at [/home/qaeczzioas/public_html/inc/db_mysqli.php:337]
#3  DB_MySQLi->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`,`language`,`showcodebuttons`,`sourceeditor`,`buddyrequestspm`,`buddyrequestsauto`,`away`,`awaydate`,`returndate`,`awayreason`,`notepad`,`referrer`,`referrals`,`buddylist`,`ignorelist`,`pmfolders`,`warningpoints`,`moderateposts`,`moderationtime`,`suspendposting`,`suspensiontime`,`coppauser`,`classicpostbit`,`usernotes`,`myalerts_disabled_alert_types`,`ougc_awards`)
			VALUES ('zererz','d4ace069807350521df25859aeb30df0','guUQnK7s','JxCJx2hXSASkTQm18e1q1Gxh37nWVcloz8mbIWIKzfQGh10Bop','[email protected]',0,0,'','',5,'',0,'',1613307186,1613307186,1613307186,'',0,'','','','',1,0,0,1,0,1,0,1,1,1,1,1,1,0,0,0,0,'0',2,'linear',0,'','',X'66aa7e73','',1,0,1,0,0,0,0,'','',0,0,'','','',0,0,0,0,0,0,0,'','[]','')
		, 0, 1) called at [/home/qaeczzioas/public_html/inc/db_mysqli.php:370]
#4  DB_MySQLi->write_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`,`language`,`showcodebuttons`,`sourceeditor`,`buddyrequestspm`,`buddyrequestsauto`,`away`,`awaydate`,`returndate`,`awayreason`,`notepad`,`referrer`,`referrals`,`buddylist`,`ignorelist`,`pmfolders`,`warningpoints`,`moderateposts`,`moderationtime`,`suspendposting`,`suspensiontime`,`coppauser`,`classicpostbit`,`usernotes`,`myalerts_disabled_alert_types`,`ougc_awards`)
			VALUES ('zererz','d4ace069807350521df25859aeb30df0','guUQnK7s','JxCJx2hXSASkTQm18e1q1Gxh37nWVcloz8mbIWIKzfQGh10Bop','[email protected]',0,0,'','',5,'',0,'',1613307186,1613307186,1613307186,'',0,'','','','',1,0,0,1,0,1,0,1,1,1,1,1,1,0,0,0,0,'0',2,'linear',0,'','',X'66aa7e73','',1,0,1,0,0,0,0,'','',0,0,'','','',0,0,0,0,0,0,0,'','[]','')
		) called at [/home/qaeczzioas/public_html/inc/db_mysqli.php:830]
#5  DB_MySQLi->insert_query(users, Array ([username] => 'zererz',[password] => 'd4ace069807350521df25859aeb30df0',[salt] => 'guUQnK7s',[loginkey] => 'JxCJx2hXSASkTQm18e1q1Gxh37nWVcloz8mbIWIKzfQGh10Bop',[email] => '[email protected]',[postnum] => 0,[threadnum] => 0,[avatar] => '',[avatartype] => '',[usergroup] => 5,[additionalgroups] => '',[displaygroup] => 0,[usertitle] => '',[regdate] => 1613307186,[lastactive] => 1613307186,[lastvisit] => 1613307186,[website] => '',[icq] => 0,[skype] => '',[google] => '',[birthday] => '',[signature] => '',[allownotices] => 1,[hideemail] => 0,[subscriptionmethod] => 0,[receivepms] => 1,[receivefrombuddy] => 0,[pmnotice] => 1,[pmnotify] => 0,[showimages] => 1,[showvideos] => 1,[showsigs] => 1,[showavatars] => 1,[showquickreply] => 1,[showredirect] => 1,[tpp] => 0,[ppp] => 0,[invisible] => 0,[style] => 0,[timezone] => '0',[dstcorrection] => 2,[threadmode] => 'linear',[daysprune] => 0,[dateformat] => '',[timeformat] => '',[regip] => X'66aa7e73',[language] => '',[showcodebuttons] => 1,[sourceeditor] => 0,[buddyrequestspm] => 1,[buddyrequestsauto] => 0,[away] => 0,[awaydate] => 0,[returndate] => 0,[awayreason] => '',[notepad] => '',[referrer] => 0,[referrals] => 0,[buddylist] => '',[ignorelist] => '',[pmfolders] => '',[warningpoints] => 0,[moderateposts] => 0,[moderationtime] => 0,[suspendposting] => 0,[suspensiontime] => 0,[coppauser] => 0,[classicpostbit] => 0,[usernotes] => '',[myalerts_disabled_alert_types] => '[]',[ougc_awards] => '')) called at [/home/qaeczzioas/public_html/inc/datahandlers/user.php:1197]
#6  UserDataHandler->insert_user() called at [/home/qaeczzioas/public_html/member.php:383]
</back_trace>
</error>
here is the error.log
i tried this https://community.mybb.com/thread-154553-page-2.html
but it didn't work

Erikbe

2021-02-14, 07:54 PM
Hello,

Your issue is being caused by a third party plugin please try admin => configuration => general configuration => disable all plugins  (set that to yes) to confirm the issue is being caused by a plugin

https://community.mybb.com/thread-173482.html
MyBB Community Forums > 1.8 Support > General Support > users can't register new accounts