安装全新的uc home 一点消息就报错

安装uc home时出现 Error:Table ‘ucenter.uc_pms’ doesn’t exist,安装成功后跳到首页,其他栏目都正常,点击消息的时候报错。报错如下

Error:Table ‘ucenter.uc_pms’ doesn’t exist
Errno:1146
SQL::SELECT count(*) FROM `ucenter`.uc_pms WHERE (related=’0′ AND msgfromid>’0′ OR msgfromid=’0′) AND msgtoid=’0′ AND folder=’inbox’ AND new=’1′

 

解决方法如下 :

原因是因为数据库ucenter里没有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;

 

将以上语句,在phpmyadmin中执行即可。然后消息就可以使用了

原文链接:,转发请注明来源!

发表评论

  • 1 Responses to “安装全新的uc home 一点消息就报错”