The query used to generate a subscriptions feed isn't valid for PostgreSQL right now, because it's being sorted by n.created, which isn't included in the "GROUP BY" part of the query.

A simple cross-database fix is attached -- enclosing "n.created" in an aggregate function makes PostgreSQL happy and gives the same results.

CommentFileSizeAuthor
subscriptions.module_1.patch602 bytesSteve Simms

Comments

dziemecki’s picture

dziemecki commented
Assigned: Unassigned » dziemecki
Status: Needs review » Fixed

I've applied this fix, and committed it.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)