Defect #22646
Updated by Toshi MARUYAMA almost 9 years ago
The following exception is raised, when viewing /projects/projektmanagement/issues/report on PostgreSQL: <pre> ActiveRecord::StatementInvalid (PG::AmbiguousColumn: ERROR: column reference "status_id" is ambiguous LINE 1: SELECT COUNT(*) AS count_all, status_id AS status_id, is_clo... ^ : SELECT COUNT(*) AS count_all, status_id AS status_id, is_closed AS is_closed, tracker_id AS tracker_id FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" INNER JOIN "issue_statuses" ON "issue_statuses"."id" = "issues"."status_id" INNER JOIN "trackers" ON "trackers"."id" = "issues"."tracker_id" WHERE ((projects.id = 204) AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking'))) GROUP BY "issues"."status_id", "is_closed", "issues"."tracker_id"): app/models/issue.rb:1348:in `count_and_group_by' app/models/issue.rb:1305:in `by_tracker' app/controllers/reports_controller.rb:31:in `issue_report' lib/redmine/sudo_mode.rb:63:in `sudo_mode' </pre> The attached patch fixes this.