uchome 消息 Error:Table 'ucenter.uc_pms' doesn't exist

来源：互联网发布：手机淘宝退货怎么退啊编辑：程序博客网时间：2024/05/14 10:15

uchome2.0+ucenter1.6 完全整合后，在uchome上登录，查看消息项

提示错误信息：Error:Table 'ucenter.uc_pms' doesn't exist；

查看数据库，不存在表uc_pms，后在ucenter库中新建个uc_pms表即可

创建uc_pms命令行如下：

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;

创建完成后，刷新界面即可。

-------我自己实际操作过，可以解决该问题。