Top Menu

Jump to content
Home
    • Projects
    • Activity
    • Work packages
    • Calendars
    • Team planners
    • Boards
    • News
    • Getting started
    • Introduction video
      Welcome to OpenProject Community
      Get a quick overview of project management and team collaboration with OpenProject. You can restart this video from the help menu.
    • Help and support
    • User guides
    • Videos
    • Shortcuts
    • Community forum
    • Enterprise support
    • Additional resources
    • Data privacy and security policy
    • Digital accessibility (DE)
    • OpenProject website
    • Security alerts / Newsletter
    • OpenProject blog
    • Release notes
    • Report a bug
    • Development roadmap
    • Add and edit translations
    • API documentation
  • Sign in
      Forgot your password?
      Create a new account

      or sign in with your existing account

      Google

Side Menu

  • Overview
  • Activity
    Activity
  • Roadmap
  • Work packages
    Work packages
  • Calendars
    Calendars
  • Team planners
    Team planners
  • Boards
    Boards
  • Forums
  • Feature tour
    Feature tour
You are here:
  • Forums
  • General discussion

Content

Burndown chart not working

Added by Lesha Kravchenko about 9 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 8 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.

  • (1 - 1/1)
Loading...