Not Solved SQL Error: 1364 - Field 'newpoints_items' doesn't have a default value
#1
Not Solved
Hello currently getting an issue when adding a new registration on my website getting this error. 

<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 Smile

PHP Version 7.3.23
5.7.33 - MySQL Community Server (GPL)
Reply


Messages In This Thread
SQL Error: 1364 - Field 'newpoints_items' doesn't have a default value - by Kojixus - 2021-02-10, 09:51 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)