discuz之——Table 'uc.uc_pms' doesn't exist,uc_pms不存在解决

转载请注明出处:https://blog.csdn.net/l1028386804/article/details/85321690

第一次安装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'

查了下 ,数据库ucenter里没有uc_pms表。
执行如下SQL创建表即可:

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 )
) ENGINE=MYISAM ;

 

上一篇:ADO.NET 帮助类 参数传递 存储过程 分页


下一篇:Android PMS之启动流程