本帖最后由 厦新情缘 于 2014-2-12 18:00 编辑
- 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 'qqqqqq.uc_pms' doesn't exist
- Errno:1146
复制代码 提示这样的错误。 新安装的 UC HOME2.0 。点击 消息 就提示这样。怎么解决?求助【可以查看,但是发送的内容全是????符号】
- 如有论坛,后台站长,数据库升级
- DROP TABLE IF EXISTS pre_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;
- 没有安装论坛就要到phpmyadmin里执行SQL语句 【谢谢 15楼 xiaoyuwxz 的帮助 】
复制代码
|