php外包、微信开发、app开发尽在蓝普!PHP技术服务商

解决安装UCHOME报错Error:Table ‘ucenter.uc_pms’ doesn’t exist

第一次安装uchome,安装成功后打开消息页面,报如下错误:
Error:Table ‘ucenter.uc_pms’ doesn’t exist
Errno:1146
SQL::SELECT count(*) FROM `ucenter`.uc_pms WHERE (=’0′ AND msgfromid>’0′ OR msgfromid=’0′) AND msgtoid=’0′ AND folder=’inbox’ AND new=’1′
后来看了下 ,原来数据库ucenter里没有uc_pms表。
解决方法,在数据库中执行下面代码创建该表即可。
DROP TABLE IF EXISTS 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’,
PRIMARY KEY(pmid),
KEY msgtoid(msgtoid,folder,dateline),
KEY msgfromid(msgfromid,folder,dateline),
KEY related (related),
KEY getnum (msgtoid,folder,delstatus)
) TYPE=MyISAM;

标签:,

转载请注明来源蓝普网络并以链接形式标明本文地址
本文链接: http://www.wbphp.cn/html/y08/7507.html

作者:lee | 日期:2014-08-12 | 分类:新闻中心 | 评论:0 条 | 浏览:27


上一篇:
下一篇:

发表评论

*

* 以便邮件回复


给我汇款 | 合作流程 | 看看我们 | 加入我们 Copyright 2008-2016 php外包与洛阳php培训服务商. Some Rights Reserved. 豫ICP备12025288号-1