I'm getting some errors using CE with postgres as follows: PGError: ERROR: column "activities.id" must appear in the GROUP BY clause or be used in an aggregate function : SELECT *, count(*) as count FROM "activities" LEFT JOIN users ON users.id = activities.user_id WHERE (activities.created_at > '2008-08-25 15:22:34.571331' ) GROUP BY activities.user_id ORDER BY count DESC LIMIT 5
I've tried different things, and I can't seem to get it to work at all. Ideas? --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
