Modify

Opened 9 years ago

Closed 8 years ago

#3875 closed defect (fixed)

sql syntax error on postgres

Reported by: Shane Caraveo 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 8 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 8 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 8 years ago by JoshuaH

Resolution: fixed
Status: newclosed

I'll assume this works.

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain JoshuaH.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment


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

 
Note: See TracTickets for help on using tickets.