Sorry, at this time CE isn't supported on postgres (I don't use it so I've never tested the application on it). Unfortunately I can't give you any advice, beyond switching to mysql or sqlite. Good luck, Bruno
On Mon, Sep 1, 2008 at 10:24 AM, Jarod Reid <[EMAIL PROTECTED]> wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
