更换论坛系统,出现uc_pms’ doesn’t exist错误

作者: Cpder 分类: 杂七杂八 发布时间: 2011-12-26 16:25

今天原本DZX2.0+UC1.6的组合,我删掉了DZX2.0换成DZ7.2,删除了2.0的数据库重建了,UC没动,在重装完7.2以后提示“uc_pms’ doesn’t exist”。在网上Google了一下,按以下方式解决了。

经过搜索按照童虎在一篇帖子里提到的方法新建这个表

DROP TABLE IF EXISTS uc_pms;
CREATE TABLE uc_pms (
pmid int(10) unsigned NOT NULL auto_increment,
msgfrom varchar(15) NOT NULL default '',
msgfromid mediumint(8) unsigned NOT NULL default '0',
msgtoid mediumint(8) unsigned NOT NULL default '0',
folder enum('inbox','outbox') NOT NULL default 'inbox',
new tinyint(1) NOT NULL default '0',
subject varchar(75) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
message text NOT NULL,
delstatus tinyint(1) unsigned NOT NULL default '0',
related int(10) unsigned NOT NULL default '0',
PRIMARY KEY(pmid),
KEY msgtoid(msgtoid,folder,dateline),
KEY msgfromid(msgfromid,folder,dateline),
KEY related (related),
KEY getnum (msgtoid,folder,delstatus)
) TYPE=MyISAM;

搞定。

Leave a Reply

Your email address will not be published. Required fields are marked *

Optimized by WPJAM Basic