Modify

Opened 8 years ago

Closed 8 years ago

#1210 closed defect (fixed)

Discussion doesn't work with Timeline - SQL Error

Reported by: fungbat@… Owned by: 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 (0)

Change History (2)

comment:1 Changed 8 years ago by Blackhex

  • Status changed from new to assigned

Will be fixed in next changeset...

comment:2 Changed 8 years ago by Blackhex

  • Resolution set to fixed
  • Status changed from assigned to closed

Fixed in changeset 1987.

Add Comment

Modify Ticket

Action
as closed .
The resolution will be deleted. Next status will be 'reopened'.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.