john001

我的6.0装了家族插件啦，设置想注册家族门派的时候，提示说要发帖100才有这个权限，我的是新论坛，哪里有这么多啊，我想多点人注册家族门派，请问怎样设置修改家族注册条件的发帖数量为10，甚至是1呢？

amoshuang

顶～～～～～～～～～～～～～～～～～～～～

honeytu

为什么不能注册中文的家族名啊，一用中文就出现
Discuz! info: MySQL Query Error

User: admin
Time: 2007-9-16 10:10am
Script: /plugin.php

SQL: UPDATE [Table]fam SET updateok='0' WHERE fmname='我的家族'
Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (gbk_chinese_ci,COERCIBLE) for operation '='
Errno.: 1267

Similar error report has beed dispatched to administrator before.


这个怎么解决啊？？不明白~

wang9780

Warning: include(plugins/family_menu.php) [function.include]: failed to open stream: No such file or directory in E:\Vhost\WebRoot\bbswestqy\www\plugins\family.inc.php on line 1531

Warning: include() [function.include]: Failed opening 'plugins/family_menu.php' for inclusion (include_path='C:/php/includes') in E:\Vhost\WebRoot\bbswestqy\www\plugins\family.inc.php on line 1531

木和尚

Time: 2007-9-18 3:14am
Script: /bbs/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

兰陵笑笑生

完咯...
Discuz! info: MySQL Query Error

User: 兰陵笑笑生
Time: 2007-9-20 7:31pm
Script: /discuz/viewthread.php

SQL: SELECT p.*, m.uid, m.famname, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.digestposts, m.oltime,
m.pageviews, m.credits, m.extcredits1, m.extcredits2, m.extcredits3, m.extcredits4, m.extcredits5, m.extcredits6,
m.extcredits7, m.extcredits8, m.email, m.gender, m.showemail, m.invisible, m.xspacestatus, mf.nickname, mf.site,
mf.icq, mf.qq, mf.yahoo, mf.msn, mf.taobao, mf.alipay, mf.location, mf.medals, mf.avatar, mf.avatarwidth,
mf.avatarheight, mf.sightml AS signature, mf.customstatus, mf.spacename
FROM [Table]posts p
LEFT JOIN [Table]members m ON m.uid=p.authorid
LEFT JOIN [Table]memberfields mf ON mf.uid=m.uid
WHERE p.tid='2' AND p.invisible='0' ORDER BY dateline LIMIT 0, 10
Error: Unknown column 'm.famname' in 'field list'
程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖

Fantasy1993

谢谢分享~~~

wawa8

Discuz! info: MySQL Query Error

User: reading
Time: 2007-9-24 4:34am
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







family_install.php执行时出现这个

wawa8

1064的解决了1067的问题呢？

信德

我文件里没有DEFAULT CHARSET=gbk
还是显示1067问题！！！请帮忙各位