Defect #1165

filtering issue problem

Added by Sergio Freire over 14 years ago. Updated over 14 years ago.

Status:ClosedStart date:2008-05-02
Priority:NormalDue date:
Assignee:-% Done:


Target version:0.7.1
Resolution:Fixed Affected version:


Im using redmine 0.7, which was migrated from a previous 0.5.0 version.
When I go to Issues and filter by "Status => All", it gives an internal error.
Looking at mongrel logs, I can see the generated SQL:

SELECT count(DISTINCT AS count_all FROM issues  LEFT OUTER JOIN issue_statuses ON = issues.status_id  LEFT OUTER JOIN projects ON = issues.project_id   WHERE (issues.project_id = 17 AND (issues.status_id IS NOT NULL AND issues.status_id <> ''))

Since status_id is an integer, I think the expression is not ok at the end.
In that case, it should maybe even not be there.

Maybe it has to do with this line in the Redmine code?

@issue_count = Issue.count(:include => [:status, :project], :conditions => @query.statement)

Im using a posgresql 8.2.4 backend on a Centos 5 (RHAS5)


#1 Updated by Sergio Freire over 14 years ago

The machine is using the postgres updated gem.

-bash-3.1$ gem list | grep pos
postgres (, 0.7.1)

#2 Updated by Jean-Philippe Lang over 14 years ago

  • Category set to Issues
  • Status changed from New to Resolved
  • Target version set to 0.7.1
  • Resolution set to Fixed

This problem was fixed in r1379 and will be fixed in 0.7.1 that should be released tomorrow.

#3 Updated by Jean-Philippe Lang over 14 years ago

  • Status changed from Resolved to Closed

Fixed in 0.7.1 release.

Also available in: Atom PDF