Redmine

Problem with redmine-charts plugin (with trunk)

When i want to look at the charts/burndown graph i see the following error in the log:

ActiveRecord::StatementInvalid (Mysql::Error: Every derived table must have its own alias: select sum(journal_details.value*issues.estimated_hours)/sum(issues.estimated_hours) as ratio_done from (select max(journal_details.id) as journal_details_id, journals.journalized_id as issue_id from issues left join journals on journals.journalized_id = issues.id and journals.journalized_type ='Issue' left join journal_details on journals.id = journal_details.journal_id and journal_details.prop_key = 'done_ratio' where issues.project_id in (7) and (journals.id is null or journals.created_on <= '2009-03-07 23:59:59') group by issues.id) left join issues on issues.id = issue_id left join journal_details on journal_details.id = journal_details_id):

I add an alias phrase "as issues2" after "journals.created_on <= ?) group by issues.id)" in line 59 of app/controller/charts_burndown_controller.rbThe problem went away though I don't know whether I was correct

Burndown chart is working fine now, But I am getting the following error with "Logged hours deviations" chart.

[...]

Log details :

[...]

I am not able to reproduce that problem currently, but that might be due to my test-environment. I'd suggest to open a new issue to the tracker over at GitHub including the entire stack-trace and all other logs, details etc.

I installed the plugins and configurated in the project, and I could view the chart from the project menu, this is the default burndown chart. But I have no project_id in the url when I click any link in the chart pages, and got a 404 error. I do some hack in the "app/helpers/charts_helper.rb"

I installed the plugins and configurated in the project, and I could view the chart from the project menu, this is the default burndown chart. But I have no project_id in the url when I click any link in the chart pages, and got a 404 error. I do some hack in the "app/helpers/charts_helper.rb"