id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release 2431,WorkLog tab is not working,Peter,Colin Guthrie,"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' ",defect,closed,normal,WorkLogPlugin,normal,fixed,,,0.11