Top Menu

Jump to content
Home
    Modules
      • Projects
      • Activity
      • Work packages
      • Gantt charts
      • 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
    • Upgrade to Enterprise edition
    • 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?

      or sign in with your existing account

      OpenProject ID Google

Side Menu

  • Overview
  • Activity
    Activity
  • Roadmap
  • Work packages
    Work packages
  • Gantt charts
    Gantt charts
  • Calendars
    Calendars
  • Team planners
    Team planners
  • Boards
    Boards
  • News
  • Forums

Content

General discussion
  1. OpenProject
  2. Forums
  3. General discussion
  4. Burndown chart not working

Burndown chart not working

Added by Lesha Kravchenko almost 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.

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