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 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.