Burndown chart not working

Added by Lesha Kravchenko about 11 years ago

Hello.
When clicked projects -> backlogs -> sprint1 -> burndown chart , openproject showed empty window(scr in attachments).

OpenProject version 3.1.0pre1 (Mysql2).

Log from /var/log/openproject/web-1.log:

Processing by RbBurndownChartsController#show as HTML
Parameters: {“project_id”=>“project”, “sprint_id”=>“1”}
Completed 500 Internal Server Error in 9.5ms

ActiveRecord::StatementInvalid (Mysql2::Error: 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 ‘))
GROUP BY date_journals.date
ORDER BY date_journals.date’ at line 43: SELECT
date_journals.date,
SUM (work_package_journals.story_points) as story_points
FROM
(
SELECT
d.date,
j.journable_id,
MAX (j.version) as version

Have ideas?

Replies (1)

RE: Burndown chart not working - Added by Hans Moreels over 10 years ago

Lesha Kravchenko wrote:

Hello.
When clicked projects -> backlogs -> sprint1 -> burndown chart , openproject showed empty window(scr in attachments).

OpenProject version 3.1.0pre1 (Mysql2).

Log from /var/log/openproject/web-1.log:

Processing by RbBurndownChartsController#show as HTML
Parameters: {“project_id”=>“project”, “sprint_id”=>“1”}
Completed 500 Internal Server Error in 9.5ms

ActiveRecord::StatementInvalid (Mysql2::Error: 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 ‘))
GROUP BY date_journals.date
ORDER BY date_journals.date’ at line 43: SELECT
date_journals.date,
SUM (work_package_journals.story_points) as story_points
FROM
(
SELECT
d.date,
j.journable_id,
MAX (j.version) as version

Have ideas?

Is this bug already fixed?
I am having the same issue.
We are on version 3.0.14.
When generating the burndown i only see an http 500 in my browser console.

Side Menu

Content