Hi, I just started playing around with CE. Unfortunately there seems to be some problems with Postgresql.
First, the values "0" and "1" (within the fixtures) are not correctly translated to their boolean Postgresql values. Whatever went wrong there, changing those values to "false" and "true" took care of that. Second and more severe is the error thrown by Postgresql for the following statement: SELECT *, count(*) as count FROM "activities" LEFT JOIN users ON users.id = activities.user_id WHERE (activities.created_at > '2009-01-10 11:21:33.504753') GROUP BY activities.user_id ORDER BY count DESC LIMIT 5 Postgresql states that: ERROR: column "activities.id" must appear in the GROUP BY clause or be used in an aggregate function. And of course this makes sense, since Postgresql could only guess the other values need for the "Select *" part of the query. Any ideas on how this could be fixed? Best regards Johannes --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CommunityEngine" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/communityengine?hl=en -~----------~----~----~----~------~----~------~--~---
