第一、出現的錯誤現象是:
數據庫連接出錯,是短消息整合出錯,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;
|
新聞熱點
疑難解答