86564
开源版8.2.4统计报表,全选,生成报表出错
回帖数 5
阅读数 2335
发表时间 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 禅道软件 回帖
联系我们
联系人
刘璐/高级客户经理
电话(微信)
18562550650
QQ号码
2845263372
联系邮箱
liulu@chandao.com

相关帖子
坏坏的钥匙扣 | 最后回帖 2019-08-12 17:36 张玉洁
lt | 最后回帖 2019-05-13 09:20 马超
李大善人李大恶人 | 最后回帖 2019-02-11 18:06 qq_5c60f1a2ecb96
zhuxw | 最后回帖 2023-05-15 13:05 王林
范杰 | 最后回帖 2020-03-17 08:20 禅道-李锡碧
烙印 | 最后回帖 2017-09-25 09:14 石洋洋
禅道软件

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


