0.6升级出现如下错误

该问题已被锁定！

3: 关注

2904: 浏览

bug

Fatal error: Uncaught exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli prepare error: Unknown column 'sort' in 'order clause'' in /home/readmeme/public_html/web20share/cy/gzphp/Zend/Db/Statement/Mysqli.php:77 Stack trace: #0 /home/readmeme/public_html/web20share/cy/gzphp/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('SELECT `aws_cat...') #1 /home/readmeme/public_html/web20share/cy/gzphp/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'SELECT `aws_cat...') #2 /home/readmeme/public_html/web20share/cy/gzphp/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('SELECT `aws_cat...') #3 /home/readmeme/public_html/web20share/cy/gzphp/Zend/Db/Adapter/Abstract.php(736): Zend_Db_Adapter_Abstract->query(Object(Zend_Db_Select), Array) #4 /home/readmeme/public_html/web20share/cy/gzphp/gz_model.inc.php(244): Zend_Db_Adapter_Abstract->fetchAll(Object(Zend_Db_Select)) #5 /home/readmeme/public_html/web20share/cy/app/account/model/system_class in /home/readmeme/public_html/web20share/cy/gzphp/Zend/Db/Statement/Mysqli.php on line 77

好问题 0 评论收藏举报

AI智能回复搜索中，请稍后...

3 回答

Sank 初级会员用户来自于: IANA
2012-06-23 18:19

部分升级SQL没执行成功，请执行以下SQL，报错的行跳过。 ALTER TABLE `aws_notification` CHANGE `read_flag` `read_flag` INT( 11 ) NULL DEFAULT '0' COMMENT '阅读状态'; ALTER TABLE `aws_category` ADD `sort` SMALLINT( 6 ) NULL DEFAULT '0' COMMENT '排序' AFTER `parent_id`; INSERT INTO `aws_system_setting` (`id`, `varname`, `value`) VALUES (NULL, 'register_seccode', 's:1:"Y";'); INSERT INTO `aws_system_setting` (`id`, `varname`, `value`) VALUES (NULL, 'admin_login_seccode', 's:1:"Y";'); CREATE TABLE `aws_question_keyword` ( `auto_id` INT(10) NOT NULL AUTO_INCREMENT, `question_id` INT(10) DEFAULT NULL, `keyword` VARCHAR(20) DEFAULT NULL, `add_time` INT(10) DEFAULT NULL, UNIQUE KEY `auto_id` (`auto_id`), UNIQUE KEY `keyword` (`question_id`,`keyword`) ) ENGINE=INNODB DEFAULT CHARSET=utf8; ALTER TABLE `aws_topic` CHANGE `topic_count` `topic_count` INT( 11 ) NULL DEFAULT '0' COMMENT '讨论计数'; UPDATE `aws_topic` SET `topic_count` = 0 WHERE `topic_count` IS NULL;

赞同 2 0评论

persia 初级会员用户来自于: IANA
2012-06-23 19:40

Fatal error: Uncaught exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli prepare error: Unknown column 'sort' in 'order clause'' in /www/users/yanyishe.com/wenda/gzphp/Zend/Db/Statement/Mysqli.php:77 Stack trace: #0 /www/users/yanyishe.com/wenda/gzphp/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('SELECT `aws_cat...') #1 /www/users/yanyishe.com/wenda/gzphp/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'SELECT `aws_cat...') #2 /www/users/yanyishe.com/wenda/gzphp/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('SELECT `aws_cat...') #3 /www/users/yanyishe.com/wenda/gzphp/Zend/Db/Adapter/Abstract.php(736): Zend_Db_Adapter_Abstract->query(Object(Zend_Db_Select), Array) #4 /www/users/yanyishe.com/wenda/gzphp/gz_model.inc.php(244): Zend_Db_Adapter_Abstract->fetchAll(Object(Zend_Db_Select)) #5 /www/users/yanyishe.com/wenda/app/account/model/system_class.inc.php(25): GZ_MODEL->fetch_all('category', '`type` = 'quest...', 'sort ASC in /www/users/yanyishe.com/wenda/gzphp/Zend/Db/Statement/Mysqli.php on line 77 升级后,点击首页出现的. 紧急,现在网站无法访问了! http://www.gewuhui.cn/wenda/

赞同 0 2评论

Sank 初级会员用户来自于: IANA
2012-06-23 17:49

这个错误是访问哪个页面出现的，有没有先通过访问网站根目录/upgrade 执行升级？

赞同 0 1评论

关于作者

: watsonxu 初级会员
这家伙很懒，还没有设置简介

8: 回答

0: 文章

10: 问题

问题动态

发布时间: 2012-06-23 13:40

更新时间: 2012-06-23 19:41

关注人数: 3 人关注