##升级1.900以后无法添加分类和修改分类的问题 >出现这个问题是因为升级过程中数据库升级部分失败所致，解决办法：在mysql的中运行以下命令代码即可 ~~~ ALTER TABLE `yiqi_navigate` ADD COLUMN `catid` int NULL DEFAULT 0 AFTER `url`; #<--break--> ALTER TABLE `yiqi_category` ADD COLUMN `thumb` text COLLATE utf8_unicode_ci AFTER `status`; #<--break--> ALTER TABLE `yiqi_article` ADD COLUMN `thumb` text COLLATE utf8_unicode_ci AFTER `status`; #<--break--> INSERT INTO `yiqi_regular` (`rid`, `name`, `description`, `type`, `pid`, `value`, `displayorder`, `status`) VALUES (45, '轮播图设置', '轮播图设置', 'member', '23', 'lunbo.php', '0', 'ok'), (46, '附件', '附件', 'attach', '20', 'attach.php', '0', 'ok'); #<--break--> INSERT INTO `yiqi_templets` (`tid`, `name`, `directory`, `thumb`, `author`, `copyright`, `adddate`, `status`) VALUES (3, '搜外专供', 'seowhy', '../templets/seowhy/preview.gif', 'SEOWHY-XIAOLIANG', 'FOR IE8+<br>Copyright 2015 seowhy.com all rights reserved.', '2015-08-06 00:00:00', 'ok'); #<--break--> UPDATE `yiqi_settings` SET `value` = '3' WHERE `varname` = 'sitetemplets'; #<--break--> UPDATE `yiqi_users` SET `regular`=CONCAT(`regular`,'','|45|46'); #<--break--> DROP TABLE IF EXISTS `yiqi_attach`; #<--break--> CREATE TABLE `yiqi_attach` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `file_name` varchar(255) DEFAULT NULL COMMENT '附件名称', `access_key` varchar(32) DEFAULT NULL COMMENT '批次 Key', `add_time` int(10) DEFAULT '0' COMMENT '上传时间', `file_location` varchar(255) DEFAULT NULL COMMENT '文件位置', `is_image` int(1) DEFAULT '0', `item_type` varchar(32) DEFAULT '0' COMMENT '关联类型', `item_id` bigint(20) DEFAULT '0' COMMENT '关联 ID', PRIMARY KEY (`id`), KEY `access_key` (`access_key`), KEY `is_image` (`is_image`), KEY `fetch` (`item_id`,`item_type`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; ~~~