2021-10-25, 05:53 PM
When I try to add new user from Admin Cp, It shows MyBB SQL error.
How to solve this?
Disabling Newpoints solves the issue, But Newpoints is something I want as well.
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1364 - Field 'newpoints_items' doesn't have a default value
Query:
INSERT INTO mybbz2_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`) VALUES ('test','62bf86c0d3bba9d6928819cec8cfc2dd','8JPP6RV0','XfYdHjwGL6aweedt1Q1bhga8FlOYdyBdnZrdhyVBKAAMKoVZRw','[email protected]',0,0,'','',2,'',0,'',1635184271,0,0,'',0,'','','','',1,0,0,1,0,1,1,1,1,1,1,1,1,0,0,0,0,'0',0,'',0,'','',X'',X'','',1,0,1,0,0,0,0,'',0,0,'','','0**$%%$1**$%%$2**$%%$3**$%%$4**','',0,0,0,0,0,0,0,'',0)
How to solve this?
Disabling Newpoints solves the issue, But Newpoints is something I want as well.