微赞、微擎模块更新提示 Table ‘xxx’ doesn’t exist 的解决方法

执行前注意备份!


打开对应模块目录下的 manifest.xml 或 install.php,找到对应的语句,例如

CREATE TABLE IF NOT EXISTS `缺失的表名` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rid` int(11) NOT NULL,
  `reid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

进入 phpMyAdmin,找到对应的微赞数据库,执行以下 SQL

DROP TABLE IF EXISTS `缺失的表名`;

然后执行以下 SQL

CREATE TABLE `缺失的表名` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rid` int(11) NOT NULL,
  `reid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

One comment on “微赞、微擎模块更新提示 Table ‘xxx’ doesn’t exist 的解决方法”

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>