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 owner will remain Blackhex.
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.