家族門派Full House版1.5 for Discuz4.1[最新修正7月15]

Discuz! info: MySQL Query Error

User: Benjamin
Time: 2006-4-9 4:28am
Script: /plugin.php

SQL: select * from cdb_fam where fmname=''
Error: Table 'sq_mysql.cdb_fam' doesn't exist
数据表缺失,请恢复备份数据

An error report has been dispatched to our administrator.

安装后出现这个~~怎么解决

Discuz! info: MySQL Query Error

User: Benjamin
Time: 2006-4-9 4:32am
Script: /viewthread.php

SQL: SELECT p.*, m.uid, m.fam, m.username, m.groupid, 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.avatarshowid, 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
FROM cdb_posts p
LEFT JOIN cdb_members m ON m.uid=p.authorid
LEFT JOIN cdb_memberfields mf ON mf.uid=m.uid
WHERE p.tid='824' AND p.invisible='0' ORDER BY dateline LIMIT 0, 10
Error: Unknown column 'm.fam' in 'field list'
程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖

Similar error report has beed dispatched to administrator before.

上面问题已解决~~呵呵~原来是忘了执行安装~~

家族安装完成
http://www.wecc.cn/plugin.php?identifier=family&module=family

Time: 2006-4-9 10:56am
Script: /family_install.php

SQL:
CREATE TABLE `cdb_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',
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.

原帖由 blacklily 于 2006-4-8 16:38 发表
https://discuz.dismall.com/thread-248563-1-1.html
由于我的论坛是utf版本所以后台乱码
拜托好心人给个后台截图感激不尽呀

原帖由 blacklily 于 2006-4-8 16:38 发表
https://discuz.dismall.com/thread-248563-1-1.html
由于我的论坛是utf版本所以后台乱码
拜托好心人给个后台截图感激不尽呀

原帖由 blacklily 于 2006-4-8 16:38 发表
https://discuz.dismall.com/thread-248563-1-1.html
由于我的论坛是utf版本所以后台乱码
拜托好心人给个后台截图感激不尽呀

拜托了
好心人请给个后台插件管理一项中此插件的详情页面的截图吧
这样我就能一一对照把字改成正常了
拜托了谢谢

拜托了
好心人请给个后台插件管理一项中此插件的详情页面的截图吧
这样我就能一一对照把字改成正常了
拜托了谢谢