急急！消息出错，点击消息报如下错误

网站出错：

• 消息
  

报如下错误


UCenter info: MySQL Query Error
SQL:SELECT count(*) FROM [Table]pms WHERE msgtoid='2' AND related='0' AND msgfromid>'0' AND folder='inbox'
Error:Table 'robbie_lianxincenter.uccenter_pms' doesn't exist
Errno:1146


如uccenter_pms 不存在的，可以不可以收到建立，MYSQL的命令是什么啊？

请各位大侠给予指点

同样问题，等解答

创建表没问题啊；只是不指导能否解决你的问题。SQL如下：

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',
  fromappid SMALLINT(6) 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;