Discussion doesn't work with Timeline - SQL Error

[fungbat@…]

If the "Discussion Changes" is turned on on the Timeline, the following error will occur:

Discussion changes event provider (DiscussionTimeline) failed:

ProgrammingError: column "forum.name" must appear in the GROUP BY clause or be used in an aggregate function

The log file from Postgres looks like this:

ERROR:  column "forum.name" must appear in the GROUP BY clause or be used in an aggregate function
STATEMENT:  SELECT t.id, t.subject, t.author, t.time, t.forum, f.name FROM topic t LEFT JOIN (SELECT name, id FROM forum GROUP BY id) f ON t.forum = f.id WHERE time BETWEEN 1168959599.0 AND 1171637999.0

I am using Trac 0.10.3, Postgres 8.2.1

[Radek Bartoň]

Will be fixed in next changeset...

[Radek Bartoň]

Fixed in changeset 1987.