绝代刀杰

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

An error report has been dispatched to our administrator.



楼主在吗？我安装时出现错误，为什么？

绝代刀杰

麻烦楼主详细说明1067的问题～

xdai

Discuz! info: MySQL Query Error

User: 呆..
Time: 2008-5-10 5:35pm
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.

tengho

這個東西...其實還有bug的嗎..."

快乐天下

Similar error report has beed dispatched to administrator before.

快乐天下

Discuz! info: MySQL Query Error

User: 快乐天下
Time: 2008-5-31 2:46am
Script: /family_install.php

SQL: ALTER TABLE `[Table]fam` ADD `seven` varchar(40) NOT NULL default '';
Error: Table 'db_kltx.[Table]fam' doesn't exist
数据表缺失,请恢复备份数据

Similar error report has beed dispatched to administrator before.

lanyu2008

--安装完后，点“领域管理 ”就出现下面的问题，请帮帮忙！！！


Discuz! info: MySQL Query Error

User: admin
Time: 2008-5-31 2:42pm
Script: /plugin.php

SQL: SELECT * FROM [Table]family_domain WHERE fam='梦想成真'
Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (gbk_chinese_ci,COERCIBLE) for operation '='
Errno.: 1267

nhdx

就是家族版块是族长创建的   帖子页面显示是版主
但是没有版主的实际功能  
废人一个
呵呵  
希望解决
谢谢