后台升级后，v9_keyword和v9_keyword_data报错的解决办法
V9后台点击升级后，添加文章完毕后出来一段数据库错误，提示情况如下：MySQL Query : SELECT * FROM `test`.`v9_keyword` WHERE `keyword` = '青年' AND `siteid` = '1' LIMIT 1
MySQL Error : Table 'test.v9_keyword' doesn't exist
MySQL Errno : 1146
Message : Table 'test.v9_keyword' doesn't exist
Need Help?
找半天，自己琢磨好的，方法如下：
用phpmyadmin 从其他数据库，导出v9_keyword和v9_keyword_data，完后再导入到因升级丢失这俩数据表的数据库里，完后你去后台添加会发现已经好了....
复制以下代码，另存为 v9_keyword.sql文件
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `v9_keyword`
-- ----------------------------
DROP TABLE IF EXISTS `v9_keyword`;
CREATE TABLE `v9_keyword` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`siteid` smallint(5) unsigned NOT NULL DEFAULT '0',
`keyword` char(100) NOT NULL,
`pinyin` char(100) NOT NULL,
`videonum` int(11) NOT NULL DEFAULT '0',
`searchnums` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `keyword` (`keyword`,`siteid`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
复制以下代码，另存为v9_keyword_data.sql文件
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `v9_keyword_data`
-- ----------------------------
DROP TABLE IF EXISTS `v9_keyword_data`;
CREATE TABLE `v9_keyword_data` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`tagid` int(10) unsigned NOT NULL DEFAULT '0',
`siteid` smallint(5) unsigned NOT NULL DEFAULT '0',
`contentid` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `tagid` (`tagid`,`siteid`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
页:
[1]