Modify

Opened 6 years ago

Closed 6 years ago

#3875 closed defect (fixed)

sql syntax error on postgres

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

Change History (3)

comment:1 Changed 6 years ago by JoshuaH

(In [4650]) Release 0.4

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

comment:2 Changed 6 years ago 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.

comment:3 Changed 6 years ago by JoshuaH

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

I'll assume this works.

Add Comment

Modify Ticket

Action
as closed The owner will remain JoshuaH.
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.