86564
开源版8.2.4统计报表,全选,生成报表出错
回帖数 5
阅读数 2445
发表时间 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

相关帖子
爽快的热水瓶 | 最后回帖 2024-12-10 13:37 郑院生
dongs | 最后回帖 2016-06-29 12:15 石洋洋
laughing wen | 最后回帖 2023-09-26 14:45 禅道 - 闫敏
黄雨 | 最后回帖 2019-06-27 08:51 禅道 - 闫敏
周杰 | 最后回帖 2017-10-18 13:57 王春生
不要命的火锅 | 最后回帖 2024-09-10 08:41 马超
禅道软件


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


