86564
开源版8.2.4统计报表,全选,生成报表出错
回帖数 5
阅读数 2388
发表时间 2016-07-16 08:46:47
15:37:04 ERROR: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT distinct t1., t2.,t3.branch as productBranch,t4.type as productType,t2.' at line 1
The sql is: SELECT product as name, count(product) as value FROM zt_story wHeRe SELECT distinct t1., t2.,t3.branch as productBranch,t4.type as productType,t2.version as version FROM zt_projectstory AS t1 LEFT JOIN zt_story AS t2 ON t1.story = t2.id LEFT JOIN zt_projectproduct AS t3 ON t1.project = t3.project LEFT JOIN zt_product AS t4 ON t2.product = t4.id WHERE t1.project = '32' AND t2.deleted = '0' gRoUp bY product oRdEr bY value DESC
in /var/www/p.xxx.com/lib/base/dao/dao.class.php on line 1301, last called by /var/www/p.xxx.com/lib/base/dao/dao.class.php on line 707 through function sqlError.
in /var/www/p.xxx.com/framework/base/router.class.php on line 1919 when visiting story-report-10-unclosed-0
The sql is: SELECT product as name, count(product) as value FROM zt_story wHeRe SELECT distinct t1., t2.,t3.branch as productBranch,t4.type as productType,t2.version as version FROM zt_projectstory AS t1 LEFT JOIN zt_story AS t2 ON t1.story = t2.id LEFT JOIN zt_projectproduct AS t3 ON t1.project = t3.project LEFT JOIN zt_product AS t4 ON t2.product = t4.id WHERE t1.project = '32' AND t2.deleted = '0' gRoUp bY product oRdEr bY value DESC
in /var/www/p.xxx.com/lib/base/dao/dao.class.php on line 1301, last called by /var/www/p.xxx.com/lib/base/dao/dao.class.php on line 707 through function sqlError.
in /var/www/p.xxx.com/framework/base/router.class.php on line 1919 when visiting story-report-10-unclosed-0
5个回复
这个sql是项目->需求页面的,感觉你是从项目->需求页面进入报表的。代码你自己有做过改动,或者有安装插件吗?
2016-07-21 14:23:31 禅道软件 回帖
5个回复
安装补丁8.2.4.3试试
http://www.zentao.net/extension-browseRelease-6-front.html
2016-07-29 11:13:55 禅道软件 回帖
联系我们
联系人
刘斌/高级客户经理
电话(微信)
17685869372
QQ号码
526288068
联系邮箱
liubin@chandao.com

相关帖子
lt | 最后回帖 2019-05-13 09:20 马超
周昌和 | 最后回帖 2021-03-18 08:53 王林
会芳 | 最后回帖 2019-12-23 17:21 王林
蒋莹凯 | 最后回帖 2019-03-22 18:16 禅道-李锡碧
dongs | 最后回帖 2018-06-22 09:45 扮猪吃老虎
Roby.Ruan | 最后回帖 2017-06-20 17:08 石洋洋


禅道软件

精品资料包
1V1产品演示
免费试用增强功能
专属顾问答疑支持


