第一、出现的错误现象是:
数据库连接出错,是短消息整合出错,pw8的短信原来保存在msg数据表,现在换了,错误代码如下:
- SELECT COUNT(*) AS pmNUM FROM pw_msg WHERE `touid`='1' AND type='rebox' AND ifnew=1
- Table 's462861db0.pw_msg' doesn't exist
- 1146
第二、在php168后台的数据库管理中执行如下语句:
- CREATE TABLE pw_msg (
- mid int(10) unsigned NOT NULL AUTO_INCREMENT,
- touid mediumint(8) unsigned NOT NULL DEFAULT '0',
- togroups varchar(80) NOT NULL DEFAULT '',
- fromuid mediumint(8) unsigned NOT NULL DEFAULT '0',
- username varchar(15) NOT NULL DEFAULT '',
- `type` enum('rebox','sebox','public') NOT NULL DEFAULT 'rebox',
- ifnew tinyint(1) NOT NULL DEFAULT '0',
- mdate int(10) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (mid),
- KEY touid (touid),
- KEY fromuid (fromuid,mdate),
- KEY `type` (`type`),
- KEY touids (touid,mdate)
- ) ENGINE=MyISAM DEFAULT CHARSET=gbk;
新闻热点
疑难解答