请选择 进入手机版 | 继续访问电脑版

UESOHO

discuz安装出现Error:Table 'ucenter.uc_pms' doesn't exist Errno:1146

admin 发表于 3-24 14:42:51 | 1 条回复 | 1892 次浏览

Error:Table 'ucenter.uc_pms' doesn't exist
第一次安装discuz,安装成功后跳到首页,报如下错误:
Error:Table 'ucenter.uc_pms' doesn't exist
Errno:1146
SQL::SELECT count(*) FROM `ucenter`.uc_pms WHERE (related='0' AND msgfromid>'0' OR msgfromid='0') AND msgtoid='0' AND folder='inbox' AND new='1'
查了下 ,数据库ucenter里没有uc_pms表。
经过搜索,在一篇帖子里提到的方法新建这个表:
  1. DROP TABLE IF EXISTS uc_pms;
  2. CREATE TABLE uc_pms (
  3. pmid int(10) unsigned NOT NULL auto_increment,
  4. msgfrom varchar(15) NOT NULL default '',
  5. msgfromid mediumint(8) unsigned NOT NULL default '0',
  6. msgtoid mediumint(8) unsigned NOT NULL default '0',
  7. folder enum('inbox','outbox') NOT NULL default 'inbox',
  8. new tinyint(1) NOT NULL default '0',
  9. subject varchar(75) NOT NULL default '',
  10. dateline int(10) unsigned NOT NULL default '0',
  11. message text NOT NULL,
  12. delstatus tinyint(1) unsigned NOT NULL default '0',
  13. related int(10) unsigned NOT NULL default '0',
  14. PRIMARY KEY(pmid),
  15. KEY msgtoid(msgtoid,folder,dateline),
  16. KEY msgfromid(msgfromid,folder,dateline),
  17. KEY related (related),
  18. KEY getnum (msgtoid,folder,delstatus)
  19. ) TYPE=MyISAM;
复制代码

刷新原报错页面就ok了。
至于原因没有过多追究!有兴趣的朋友可以去查查。

回复 道具 举报

沸沸队长 发表于 3-24 15:37:36
支持下      

回复 道具 举报

您需要登录后才可以回帖 登录 | 注册

UESOHO/津ICP备11001501号-4 Powered by Discuz!

top