如果你点击消息链接却报如下错误的话:
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 'l数据库名字.uc_pms' doesn't exist
Errno:1146
打开你的数据库
将下面的代码复制进phpmyadmin中,点击执行按钮的输入框内:
--
-- 表的结构 `uc_pms`
--
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`),
KEY `related` (`related`),
KEY `getnum` (`msgtoid`,`folder`,`delstatus`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;
--
-- 转存表中的数据 `uc_pms`
--
就OK 了~
自己亲自测试,
欢迎访问
http://www.cqei.cn/home
|