WorkLog tab is not working

[Peter]

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'

[Colin Guthrie]

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

[Peter]

Yup, works as a charm now! :)

Thanks!