2021-02-10, 09:51 PM
Hello currently getting an issue when adding a new registration on my website getting this error.
If you know why this is happening, please let me know, or a fix-it will be great. I tried to remove a plugin I added last month, which didn't cause the issue.
Thanks
PHP Version 7.3.23
5.7.33 - MySQL Community Server (GPL)
<error>
<dateline>1612993210</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 mybbje_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`,`ougc_awards`)
</message>
<back_trace>#0 errorHandler->error() called at [/inc/db_mysqli.php:597]
#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:830]
#4 DB_MySQLi->insert_query() called at [/inc/datahandlers/user.php:1192]
#5 UserDataHandler->insert_user() called at [/member.php:383]
</back_trace>
</error>
I've taken out the info of the user for privacy reasons.If you know why this is happening, please let me know, or a fix-it will be great. I tried to remove a plugin I added last month, which didn't cause the issue.
Thanks
PHP Version 7.3.23
5.7.33 - MySQL Community Server (GPL)