Modify

Opened 7 years ago

Closed 4 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

Description

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/model.py", 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 7 years ago.

Download all attachments as: .zip

Change History (2)

Changed 7 years ago by Mitar

Attachment: schema_types.patch added

comment:1 Changed 4 years ago by Ryan J Ollos

Resolution: fixed
Status: newclosed

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Noah Kantrowitz.
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.