Opened 8 years ago

Closed 6 years ago

#7460 closed defect (fixed)

Wrong schema definition for PostgreSQL

Reported by: Mitar Owned by: Noah Kantrowitz
Priority: normal Component: MasterTicketsPlugin
Severity: normal Keywords:
Cc: Mitar Trac Release: 0.11


Schema defintion for mastertickets table is not precise and so plugin fails on PostgreSQL with:

ProgrammingError: operator does not exist: text = integer
LINE 1: SELECT dest FROM mastertickets WHERE source=32 ORDER BY dest
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

This select query is in:

 File "/usr/lib/pymodules/python2.5/mastertickets/", line 22, in  __init__  

The problem is that columns are not defined with integer type. I am attaching a patch which fixes this.

Attachments (1)

schema_types.patch (421 bytes) - added by Mitar 8 years ago.

Download all attachments as: .zip

Change History (2)

Changed 8 years ago by Mitar

Attachment: schema_types.patch added

comment:1 Changed 6 years ago by Ryan J Ollos

Resolution: fixed
Status: newclosed

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain Noah Kantrowitz.
The resolution will be deleted.

Add Comment

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

Note: See TracTickets for help on using tickets.