我用Disucz!插件安装工具安装任务精灵时按照要求下载了备份包,然后第三步把SQL升级:
ALTER TABLE `cdb_posts` ADD `missionid` VARCHAR( 25 ) NOT NULL;
DROP TABLE IF EXISTS cdb_mission;
CREATE TABLE cdb_mission (
id int(10) unsigned NOT NULL auto_increment,
uid mediumint(8) unsigned NOT NULL default '0',
username varchar(15) NOT NULL default '',
moneynum int(10) NOT NULL default '0',
begintime int(10) unsigned NOT NULL default '0',
endtime int(10) unsigned NOT NULL default '0',
pid int(10) NOT NULL default '0',
hash varchar(15) NOT NULL default '',
remark text,
islog tinyint(1) NOT NULL default '0',
czip varchar(15) NOT NULL default '0',
PRIMARY KEY (id)
);
接着第四步出现:
>> Discuz! Board Plugin Installation Wizard
Erroruplicate column name 'missionid'
Errno:1060
SQL:ALTER TABLE `cdb_posts` ADD `missionid` VARCHAR( 25 ) NOT NULL
[请返回]
然后我认为是安装不成功,就决定卸载插件
返回到第三步的卸载SQL:
DELETE FROM `cdb_crons` WHERE filename='addcard_daily.inc.php';
DROP TABLE IF EXISTS `cdb_card`;
DROP TABLE IF EXISTS `cdb_cardlog`;
DROP TABLE IF EXISTS `cdb_cardmarket`;
ALTER TABLE `cdb_posts` DROP `card`;
ALTER TABLE `cdb_posts` DROP `postscript`;
ALTER TABLE `cdb_members` DROP `cards`;
ALTER TABLE `cdb_members` DROP `postscript`;
ALTER TABLE `cdb_members` DROP `pigavatar`;
将编码复制到后台,结果整个论坛就挂了……哭……即使把备份包覆盖上FTP文件夹里还是没用
登陆论坛时出现的页面显示:
Discuz! info: MySQL Query Error
User: Cathy
Time: 2007-1-8 5:04pm
Script: /index.php
SQL: SELECT * FROM cdb_card ORDER BY id DESC
Error: Table 'dm.cdb_card' doesn't exist
数据表缺失,请恢复备份数据
Similar error report has beed dispatched to administrator before.
请问我哪里弄错了,该怎么解决?请哪位高手来帮帮忙解决下,谢谢~!
我 QQ:37908922 (隐身但在线) |