##升級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; ~~~