Modify

Opened 7 years ago

Closed 7 years ago

Last modified 7 years ago

#2431 closed defect (fixed)

WorkLog tab is not working

Reported by: goldman Owned by: 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 (0)

Change History (2)

comment:1 Changed 7 years ago by coling

  • Resolution set to fixed
  • Status changed from new to closed

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

comment:2 Changed 7 years ago by goldman

Yup, works as a charm now! :)

Thanks!

Add Comment

Modify Ticket

Action
as closed The owner will remain coling.
The resolution will be deleted. Next status will be 'reopened'.
Author


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

 
Note: See TracTickets for help on using tickets.