登录站点

用户名

密码

uchome不能发站内短信的解决办法

100已有 325 次阅读  2020-07-03 18:52
问题如下:
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 'sql10086buy.pre_ucenter_pms' doesn't exist
Errno:1146
什么原因?


当打开UChome消息页面出现如下错误 UCenter info: MySQL Query Error SQL: SELECT count(*) FROM [Table]pms WHERE msgtoid=1 AND related=0 AND msgfromid0 AND folder=inbox Error: Table abc.uc_pms doesnt exist Errno: 1

很多站长可能碰见过这样的问题,当打开UChome消息页面出现如下错误

“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 'abc.uc_pms' doesn't exist
Errno:1146”

下面我们就来彻底解决这个问题 首先进入phpmyadmin 在sql执行里面执行如下语句,彻底解决问题就这么简单!



CREATE TABLE IF NOT EXISTS `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`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;



在phpmyadmin中运行以上语句,执行即可解决消息错误!
分享 举报