1364 - Field 'aim' 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`,`yahoo`,`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`) VALUES ('rio','6db04d3a4e1c1f25eef276376e6fe59a','fOEYofMQ','0plMO4vfUU7WeKjUvMGJarO942RyR4zBPLm99WiH0HW6eNtdTj','[email protected]',0,0,'','',2,'',0,'',1572470900,1572470900,1572470900,'',0,'','','','','',1,0,0,1,0,1,0,1,1,1,1,1,1,0,0,0,0,'0',2,'linear',0,'','',X'ac45371d','',1,0,1,0,0,0,0,'','',0,0,'','','',0,0,0,0,0,0,0,'')
我收到这个错误,有人能帮忙吗
问候里约
答案1
非常不言自明:您有一个名为“aim”的字段,但您没有在查询中为其分配任何值。数据库引擎尝试分配其默认值,但没有指定默认值(并且它可能也不可为空)