禅道升级
5131
升级新版出现文档错误已解决 悬赏5积分
提问者曹科
答案数1
阅读数1357
发表时间2017-09-07 09:47:49
升级最新版本9.5stable版本。打开文档栏目,报错:
09:47:08 ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't1.order' in 'order clause'<p>The sql is: SELECT t1.* FROM `zt_doclib` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id wHeRe t1.deleted = '0' AND t1.product != '0' oRdEr bY t2.`order` desc,t1.`order` asc,`id` desc </p> in D:\xampp\zentao\lib\base\dao\dao.class.php on line 1319, last called by D:\xampp\zentao\lib\base\dao\dao.class.php on line 718 through function sqlError.
in D:\xampp\zentao\framework\base\router.class.php on line 2195 when visiting doc
09:47:08 ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't1.order' in 'order clause'<p>The sql is: SELECT t1.* FROM `zt_doclib` AS t1 LEFT JOIN `zt_product` AS t2 ON t1.product=t2.id wHeRe t1.deleted = '0' AND t1.product != '0' oRdEr bY t2.`order` desc,t1.`order` asc,`id` desc </p> in D:\xampp\zentao\lib\base\dao\dao.class.php on line 1319, last called by D:\xampp\zentao\lib\base\dao\dao.class.php on line 718 through function sqlError.
in D:\xampp\zentao\framework\base\router.class.php on line 2195 when visiting doc
禅道版本:9.4
安装包类型:源码包
操作系统:Windows 7
客户端浏览器:其他
答案列表
石洋洋
2017-09-07 14:18:00
到数据库中执行一下sql :ALTER TABLE `zt_doclib` ADD `order` tinyint(5) unsigned NOT NULL AFTER `main`;
回复
|
联系我们
联系人
刘斌/高级客户经理
电话(微信)
17685869372
QQ号码
526288068
联系邮箱
liubin@chandao.com