MyBB Community Forums

MyBB Community Forums > 1.8 Support > General Support > Error code when a new user registers an account.
Full Version: Error code when a new user registers an account.
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

MorganB

2021-09-23, 04:33 PM
Hi,

When someone new try's to register an account on my forums, it gives them this error message:


MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

If you're a visitor of this website, please wait a few minutes and try again. If this problem persists, please contact the site owner.

If you are the site owner, please check the MyBB Documentation for help resolving common issues, or get technical help on the MyBB Community Forums.



What does this mean and how do I fix this?

Thanks

Crazycat

2021-09-23, 04:58 PM
Read this

(2021-09-04, 02:26 PM)Crazycat Wrote: [ -> ]When you get the following message
MyBB Wrote:MyBB SQL Error MyBB has experienced an internal SQL error and cannot continue.

The first thing to do is to get verbose error.
Go to ACP, Configuration » Board Settings » Server and Optimization Options and change the errors log options:
  • Error Logging Medium : Log errors
  • Error Type Medium : Warnings and Errors

This will give you a complete error detals, so we can really help you.

MorganB

2021-09-23, 05:12 PM
(2021-09-23, 04:58 PM)Crazycat Wrote: [ -> ]Read this

(2021-09-04, 02:26 PM)Crazycat Wrote: [ -> ]When you get the following message
MyBB Wrote:MyBB SQL Error MyBB has experienced an internal SQL error and cannot continue.

The first thing to do is to get verbose error.
Go to ACP, Configuration » Board Settings » Server and Optimization Options and change the errors log options:
  • Error Logging Medium : Log errors
  • Error Type Medium : Warnings and Errors

This will give you a complete error detals, so we can really help you.

How find the error log?

HLFadmin

2021-09-24, 12:30 AM
Look in the root folder of your forum for an error log.
If your server sees the error, it might be written somewhere else.

[attachment=44414]
Edit to add:
For the error in your original post, the details will likely be provided in the popup window after you've enabled the logging.

Crazycat

2021-09-24, 06:08 AM
If you didn't change the location and name of the error file, you can got the log at {$bburl}/admin/error.log

MorganB

2021-09-26, 08:48 AM
Here is the error log file from forums, not admin
<error>
	<dateline>1632417100</dateline>
	<script></script>
	<line>0</line>
	<type>20</type>
	<friendly_type>MyBB SQL Error</friendly_type>
	<message>SQL Error: 1364 - Field 'socialsites' 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`)
			VALUES ('DemoUser','a8abf5c2902b2a46224b2c52594dd983','IilajrbT','FcURnzqk4qE1Dtj51vnDcepJ9KzLeOxWyGi4WOjTCfJ55XvovO','[email protected]',0,0,'','',5,'',0,'',1632417100,1632417100,1632417100,'',0,'','','','',1,0,0,1,0,1,0,1,1,1,1,1,1,0,0,0,0,'0',2,'',0,'','',X'52015d88',X'','',1,0,1,0,0,0,0,'',1,0,'','','0**$%%$1**$%%$2**$%%$3**$%%$4**','',0,0,0,0,0,0,1,'')
		</message>
	<back_trace>#0  errorHandler->error() called at [/inc/db_mysqli.php:601]
#1  DB_MySQLi->error() called at [/inc/db_mysqli.php:337]
#2  DB_MySQLi->query() called at [/inc/db_mysqli.php:370]
#3  DB_MySQLi->write_query() called at [/inc/db_mysqli.php:834]
#4  DB_MySQLi->insert_query() called at [/inc/datahandlers/user.php:1232]
#5  UserDataHandler->insert_user() called at [/member.php:386]
</back_trace>
</error>

<error>
	<dateline>1632417173</dateline>
	<script></script>
	<line>0</line>
	<type>20</type>
	<friendly_type>MyBB SQL Error</friendly_type>
	<message>SQL Error: 1364 - Field 'socialsites' 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`)
			VALUES ('DemoUser','9c702e663cd221f0c77549137972eff7','6GV9oDQA','8cWrmnbJU12qqf6pb3c1vqN4OYCRAuXMc4y1HTuB6MmZlLMnrx','[email protected]',0,0,'','',5,'',0,'',1632417173,1632417173,1632417173,'',0,'','','','',1,0,0,1,0,1,0,1,1,1,1,1,1,0,0,0,0,'0',2,'',0,'','',X'52015d88',X'','',1,0,1,0,0,0,0,'',1,0,'','','0**$%%$1**$%%$2**$%%$3**$%%$4**','',0,0,0,0,0,0,1,'')
		</message>
	<back_trace>#0  errorHandler->error() called at [/inc/db_mysqli.php:601]
#1  DB_MySQLi->error() called at [/inc/db_mysqli.php:337]
#2  DB_MySQLi->query() called at [/inc/db_mysqli.php:370]
#3  DB_MySQLi->write_query() called at [/inc/db_mysqli.php:834]
#4  DB_MySQLi->insert_query() called at [/inc/datahandlers/user.php:1232]
#5  UserDataHandler->insert_user() called at [/member.php:386]
</back_trace>
</error>

<error>
	<dateline>1632417222</dateline>
	<script></script>
	<line>0</line>
	<type>20</type>
	<friendly_type>MyBB SQL Error</friendly_type>
	<message>SQL Error: 1364 - Field 'socialsites' 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`)
			VALUES ('DemoUser','1cda15cf79ad82d3d6b4abe4e5623f7c','Vp4Su3Kh','b3KbxAZMLRIF6FsCOrgD7CYttrQBzBGDeTq3oHVxWEnjDgiNpL','[email protected]',0,0,'','',5,'',0,'',1632417222,1632417222,1632417222,'',0,'','','','',1,0,0,1,0,1,0,1,1,1,1,1,1,0,0,0,0,'0',2,'',0,'','',X'52015d88',X'','',1,0,1,0,0,0,0,'',1,0,'','','0**$%%$1**$%%$2**$%%$3**$%%$4**','',0,0,0,0,0,0,1,'')
		</message>
	<back_trace>#0  errorHandler->error() called at [/inc/db_mysqli.php:601]
#1  DB_MySQLi->error() called at [/inc/db_mysqli.php:337]
#2  DB_MySQLi->query() called at [/inc/db_mysqli.php:370]
#3  DB_MySQLi->write_query() called at [/inc/db_mysqli.php:834]
#4  DB_MySQLi->insert_query() called at [/inc/datahandlers/user.php:1232]
#5  UserDataHandler->insert_user() called at [/member.php:386]
</back_trace>
</error>

<error>
	<dateline>1632643121</dateline>
	<script></script>
	<line>0</line>
	<type>20</type>
	<friendly_type>MyBB SQL Error</friendly_type>
	<message>SQL Error: 1364 - Field 'newpoints_items' 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`)
			VALUES ('Demo','38e306e03eed391f342fab40f4a116f6','SChr9I6w','SneeV5dLrJgfhlwF31XjZgYcpUFJtgw9wJcoaVBNYsioIom6FN','[email protected]',0,0,'','',5,'',0,'',1632643121,1632643121,1632643121,'',0,'','','30-11-1994','',1,0,0,1,0,1,0,1,1,1,1,1,1,0,0,0,0,'0',2,'',0,'','',X'52015d88',X'','',1,0,1,0,0,0,0,'',1,0,'','','0**$%%$1**$%%$2**$%%$3**$%%$4**','',0,0,0,0,0,0,1,'')
		</message>
	<back_trace>#0  errorHandler->error() called at [/inc/db_mysqli.php:601]
#1  DB_MySQLi->error() called at [/inc/db_mysqli.php:337]
#2  DB_MySQLi->query() called at [/inc/db_mysqli.php:370]
#3  DB_MySQLi->write_query() called at [/inc/db_mysqli.php:834]
#4  DB_MySQLi->insert_query() called at [/inc/datahandlers/user.php:1232]
#5  UserDataHandler->insert_user() called at [/member.php:386]
</back_trace>
</error>

Admin error log: https://www.filemail.com/d/qghqhhsqlbjmhji - Couldn't add it as a attachment or post it.

Crazycat

2021-09-26, 12:34 PM
So, it's an error with socialsite plugin.
You may have answers in https://community.mybb.com/thread-232961.html and https://community.mybb.com/thread-227436.html
MyBB Community Forums > 1.8 Support > General Support > Error code when a new user registers an account.