我先安装了UCenter1.6
然后安装Discuz X2
最后安装了 UCenter Home
全程安装成功,通信也成功,暂时测试总体上没问题。
瑕疵出现在访问 UCenter Home 的导航上的“消息”时出现以下错误:
UCenter info: MySQL Query Error
SQL:SELECT count(*) FROM [Table]pms WHERE msgtoid='1' AND related='0' AND msgfromid>'0' AND folder='inbox'
Error:Table 'ucenter.uc_pms' doesn't exist
Errno:1146
现求助这个错误的解决方法,或者指教一下如何创建这个表!谢谢了!
我不确定下面解决方法是否正确,因为我是个菜鸟,不会创建这个表。
网上找到的一个差不多的解决方法 如下:
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;
|