Ticket #1210 (closed defect: fixed)

Opened 2 years ago

Last modified 2 years ago

Discussion doesn't work with Timeline - SQL Error

Reported by: fungbat@hotmail.com Assigned to: Blackhex
Priority: normal Component: DiscussionPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.10

Description

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

Attachments

Change History

02/16/07 12:45:20 changed by Blackhex

  • status changed from new to assigned.

Will be fixed in next changeset...

02/16/07 14:39:17 changed by Blackhex

  • status changed from assigned to closed.
  • resolution set to fixed.

Fixed in changeset 1987.


Add/Change #1210 (Discussion doesn't work with Timeline - SQL Error)




Change Properties
Action