Hmm, seems like the GROUP BY does not work.
Could you try
@down_count = Todo.count(
:all,
:conditions => ['todos.user_id = ? and todos.state = ? and
contexts.hide = ? AND (projects.state = ? OR todos.project_id IS NULL)',
current_user.id, 'active', false, 'active'],
:include => [ :project, :context ])
Reinier
Van: Reinier Balt [mailto:[EMAIL PROTECTED]
Verzonden: zondag 6 april 2008 17:24
Aan: 'Walter Cruz'
CC: '[email protected]'
Onderwerp: RE: [Tracks-discuss] problem with postgres and version
Great, I’ll add it to trunk and 1.5.1.
Reinier
Van: Walter Cruz [mailto:[EMAIL PROTECTED]
Verzonden: zondag 6 april 2008 17:22
Aan: Reinier Balt
CC: [email protected]
Onderwerp: Re: [Tracks-discuss] problem with postgres and version
Yes Reinier, this query works well :)
I will patch my tracks instance :D
[]'s
- Walter
_______________________________________________
Tracks-discuss mailing list
[email protected]
http://lists.rousette.org.uk/mailman/listinfo/tracks-discuss
