Discuz! info: MySQL Query Error 
 
User: shy9000 
Time: 2007-10-3 1:34pm 
Script: /family_install.php 
 
SQL:  
CREATE TABLE `[Table]fam` ( 
`fmid` int(10) NOT NULL auto_increment, 
`level` int(10) NOT NULL default '0', 
`fmname` varchar(40) NOT NULL default '0', 
`username` varchar(40) NOT NULL default '', 
`firstname` varchar(50) NOT NULL default '族长', 
`firstname2` varchar(50) NOT NULL default '副族长', 
`secondname` varchar(50) NOT NULL default '长老', 
`thirdname` varchar(50) NOT NULL default '堂主', 
`mbname` varchar(50) NOT NULL default '族员', 
`first` varchar(40) NOT NULL default '', 
`second` varchar(40) NOT NULL default '', 
`third` varchar(40) NOT NULL default '', 
`four` varchar(40) NOT NULL default '', 
`five` varchar(40) NOT NULL default '', 
`six` varchar(40) NOT NULL default '', 
`seven` varchar(40) NOT NULL default '', 
`pmoney` int(8) NOT NULL default '0', 
`cmoney` int(12) NOT NULL default '0', 
`mb` int(10) NOT NULL default '0', 
`fmimg` varchar(100) NOT NULL default '', 
`createtime` int(10) NOT NULL default '0', 
`newmember` int(10) NOT NULL default '0', 
`applyok` enum('y','n') NOT NULL default 'y', 
`memo` varchar(200) NOT NULL default 'EMPTY', 
`leaveok` int(1) NOT NULL default '2', 
`joinok` int(1) NOT NULL default '1', 
`maxmb` int(20) NOT NULL default '1', 
`chname` int(10) NOT NULL default '0', 
`win` int(10) NOT NULL default '0', 
`lose` int(10) NOT NULL default '0', 
`updateok` int(1) NOT NULL default '0', 
PRIMARY KEY (`fmid`), 
UNIQUE KEY `fmid_2` (`fmid`), 
KEY `fmid` (`fmid`) 
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ; 
Error: Invalid default value for 'firstname' 
Errno.: 1067 
 
Similar error report has beed dispatched to administrator before. 
 
 
 
怎么会出现这个东西?????????? |