Ticket #2431 (closed defect: fixed)

Opened 11 months ago

Last modified 11 months ago

WorkLog tab is not working

Reported by: goldman Assigned to: coling
Priority: normal Component: WorkLogPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.11

Description

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
CT
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
ND
Jan 17 05:48:47 db postgres[78656]: [2-4]  wlt.lastchange=wl.lastchange INNER JO
IN ticket t ON wl.ticket=t.id LEFT JOIN session_attribute s ON wl.worker=s.sid A
ND
Jan 17 05:48:47 db postgres[78656]: [2-5]  s.name='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

Change History

01/17/08 06:04:43 changed by coling

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

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

01/17/08 06:11:13 changed by goldman

Yup, works as a charm now! :)

Thanks!

Add/Change #2431 (WorkLog tab is not working)




Change Properties
Action