discuz低版本整合ucenter

我用的是discuz7.2按照步驟整和好ucenter後，通路discuz出錯。如下

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'

解決方法:

方法一：建立表

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;
           

方法二：

如果你裝的有discuzx或者是ucenterHome,并且和ucenter通信成功

複制discuzx或者uncenterHome中的uc_client到discuz中即可