Opened 9 years ago

Closed 9 years ago

Last modified 9 years ago

#2431 closed defect (fixed)

WorkLog tab is not working

Reported by: Peter Owned by: Colin Guthrie
Priority: normal Component: WorkLogPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.11


In 'Work Log' tab Postgres throws the following error:

Jan 17 05:48:47 db postgres[78656]: [2-1] ERROR:  syntax error at or near "lastc
hange" at character 133
Jan 17 05:48:47 db postgres[78656]: [2-2] STATEMENT:  SELECT wl.worker, s.value,
 wl.starttime, wl.endtime, wl.ticket, t.summary, t.status, wl.comment FROM (SELE
Jan 17 05:48:47 db postgres[78656]: [2-3]  worker,MAX(lastchange) lastchange FRO
M work_log GROUP BY worker) wlt INNER JOIN work_log wl ON wlt.worker=wl.worker A
Jan 17 05:48:47 db postgres[78656]: [2-4]  wlt.lastchange=wl.lastchange INNER JO
IN ticket t ON LEFT JOIN session_attribute s ON wl.worker=s.sid A
Jan 17 05:48:47 db postgres[78656]: [2-5]'name' ORDER BY wl.lastchange
DESC, wl.worker

Reason: 'max(lastchange) lastchange' does not conform to PG syntax. Should have been 'max(lastchange) as lastchange'

Attachments (0)

Change History (2)

comment:1 Changed 9 years ago by Colin Guthrie

Resolution: fixed
Status: newclosed

(In [3075]) Fixes #2431. Thanks for the report. If there are any more postgres issues please let me know.

comment:2 Changed 9 years ago by Peter

Yup, works as a charm now! :)


Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain Colin Guthrie.
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.