ucenter 报错 Error:Table \'ucenter.uc_pms\' doesn\'t exist解决方法

 

DROP TABLE IF EXISTS uc_pms;# MySQL 返回的查询结果为空(即零行)。
# MySQL 返回的查询结果为空(即零行)。
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 ;# MySQL 返回的查询结果为空(即零行)。

在phpmyadmin中加入uc_pms这个表就可以了

 

转自http://blog.163.com/along007_yes@yeah/blog/static/105357154201210194123855/