微赞、微擎模块更新提示 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 Reply to “微赞、微擎模块更新提示 Table ‘xxx’ doesn’t exist 的解决方法”

Leave a Reply

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