۱۳۹۳/۶/۴، ۱۴:۱۹:۵۷ عصر
کد:
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1364 - Field 'thx' doesn't have a default value
Query:
INSERT INTO mybb_users (`username`,`password`,`salt`,`loginkey`,`email`,`postnum`,`avatar`,`avatartype`,`usergroup`,`additionalgroups`,`displaygroup`,`usertitle`,`regdate`,`lastactive`,`lastvisit`,`website`,`icq`,`aim`,`yahoo`,`msn`,`birthday`,`signature`,`allownotices`,`hideemail`,`subscriptionmethod`,`receivepms`,`receivefrombuddy`,`pmnotice`,`pmnotify`,`showsigs`,`showavatars`,`showquickreply`,`showredirect`,`tpp`,`ppp`,`invisible`,`style`,`timezone`,`dstcorrection`,`threadmode`,`daysprune`,`dateformat`,`timeformat`,`regip`,`longregip`,`language`,`showcodebuttons`,`away`,`awaydate`,`returndate`,`awayreason`,`notepad`,`referrer`,`referrals`,`buddylist`,`ignorelist`,`pmfolders`,`warningpoints`,`moderateposts`,`moderationtime`,`suspendposting`,`suspensiontime`,`coppauser`,`classicpostbit`,`usernotes`) VALUES ('reza','98b4146503c588d6f5a5cf28dd4bb4dd','rFpo88s8','uE9JYJMyNaRNVDK4jKqxxTaUWkvaWY3XQdTpRXLwSZZ2yFbxmo','reza63@yahoo.com','0','','','5','','0','','1409046525','1409046525','1409046525','','0','','','','','','1','0','0','1','0','1','0','1','1','1','1','0','0','0','0','4.5','2','linear','0','','','176.56.147.10','-1338469622','','1','0','0','0','','','0','0','','','','0','0','0','0','0','0','0','')درست شد
چند تا فيلد بودن كه مقدار پيش فرضشون null بود در حالي كه null پذير نبودن
مقدار پيش فرض رو 0 قرار دادم