86564

开源版8.2.4统计报表,全选,生成报表出错

回帖
回帖数 5
阅读数 2335
发表时间 2016-07-16 08:46:47
🌿
xiagw楼主
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
5个回复
禅道软件沙发
你是从哪个页面进入报表页面的?能具体说一下重现步骤吗?报表依赖的查询条件与列表页面是相关的。
2016-07-18 09:50:34 禅道软件 回帖
🌿
xiagw板凳
嗯,你看sql 就知道是从产品需求进去的。
2016-07-21 10:30:28 xiagw 回帖
禅道软件#3
这个sql是项目->需求页面的,感觉你是从项目->需求页面进入报表的。代码你自己有做过改动,或者有安装插件吗?
2016-07-21 14:23:31 禅道软件 回帖
未改动,未安装插件
2016-07-28 18:54:27 xiagw 回帖
禅道软件#5

安装补丁8.2.4.3试试

http://www.zentao.net/extension-browseRelease-6-front.html

2016-07-29 11:13:55 禅道软件 回帖
联系我们
联系人
刘璐/高级客户经理
电话(微信)
18562550650
QQ号码
2845263372
联系邮箱
liulu@chandao.com
相关帖子
返回顶部
客服头像
刘璐
高级客户经理
客服微信
18562550650
2845263372
统一服务热线 4006-8899-23
我要提问提问有任何问题,您都可以在这里提问。问题反馈反馈点击这里,让我们聆听您的建议与反馈。