Modify

Opened 10 years ago

Closed 10 years ago

#1210 closed defect (fixed)

Discussion doesn't work with Timeline - SQL Error

Reported by: fungbat@… Owned by: Radek Bartoň
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 10 years ago by Radek Bartoň

Status: newassigned

Will be fixed in next changeset...

comment:2 Changed 10 years ago by Radek Bartoň

Resolution: fixed
Status: assignedclosed

Fixed in changeset 1987.

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Radek Bartoň.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment


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

 
Note: See TracTickets for help on using tickets.