Ticket #3875 (closed defect: fixed)

Opened 3 months ago

Last modified 2 months ago

sql syntax error on postgres

Reported by: mixedpuppy Assigned to: JoshuaH
Priority: normal Component: RoadmapHoursPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.11

Description

patch to fix:

Index: /Users/shanec/svn/users/shanec/tforge/build/plugins/roadmaphoursplugin/roadmaphours/roadmaphours.py =================================================================== --- roadmaphours.py (revision 4430) +++ roadmaphours.py (working copy) @@ -63,8 +63,8 @@

if total_cnt:

cursor = self.env.get_db_cnx().cursor() str_ids = [str(x) for x in sorted(ticket_ids)]

- cursor.execute("SELECT status, est.value as 'Est', " - "act.value as 'Act' " + cursor.execute("SELECT status, est.value as Est, " + "act.value as Act "

"FROM ticket t " "LEFT OUTER JOIN ticket_custom est ON " " (t.id=est.ticket AND est.name='estimatedhours') "

Attachments

Change History

10/29/08 11:35:03 changed by JoshuaH

(In [4650]) Release 0.4

  • Remove dead code _get_ticket_groups function
  • Remove field aliases from SQL query (addresses #3875)

10/29/08 11:38:14 changed by JoshuaH

Please see if version 0.4 works for you. I just took out the AS clauses instead of unquoting them; the result fields are never referred to by name anyway.

11/10/08 09:54:29 changed by JoshuaH

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

I'll assume this works.

Add/Change #3875 (sql syntax error on postgres)




Change Properties
Action