添加表 pre_forum_rsscache 出错,请手工执行以下SQL语句后,再重新运行本升级程序:
CREATE TABLE pre_forum_rsscache ( lastupdate int(10) unsigned NOT NULL DEFAULT '0', fid mediumint(8) unsigned NOT NULL DEFAULT '0', tid mediumint(8) unsigned NOT NULL DEFAULT '0', dateline int(10) unsigned NOT NULL DEFAULT '0', forum char(50) NOT NULL DEFAULT '', author char(15) NOT NULL DEFAULT '', `subject` char(80) NOT NULL DEFAULT '', description char(255) NOT NULL DEFAULT '', guidetype char(10) NOT NULL DEFAULT '', UNIQUE KEY tid (tid), KEY fid (fid,dateline) ) ENGINE=MYISAM DEFAULT CHARSET=gbk
我进入PHPMYADMIN中执行了, 但提示:
错误SQL 查询:
CREATE TABLE pre_forum_rsscache( lastupdate int( 10 ) unsigned NOT NULL DEFAULT '0',
fid mediumint( 8 ) unsigned NOT NULL DEFAULT '0',
tid mediumint( 8 ) unsigned NOT NULL DEFAULT '0',
dateline int( 10 ) unsigned NOT NULL DEFAULT '0',
forumchar( 50 ) NOT NULL DEFAULT '',
authorchar( 15 ) NOT NULL DEFAULT '',
`subject` char( 80 ) NOT NULL DEFAULT '',
descriptionchar( 255 ) NOT NULL DEFAULT '',
guidetypechar( 10 ) NOT NULL DEFAULT '',
UNIQUE KEY tid( tid ) ,
KEY fid( fid, dateline )
) ENGINE = MYISAM DEFAULT CHARSET = gbk
MySQL 返回:
#1050 - Table 'pre_forum_rsscache' already exists
提示表存在,没法执行。 所以现在升级不成功呀, 请大家帮助我呀! |