Edgewall Software
Modify

Opened 15 years ago

Closed 15 years ago

Last modified 9 years ago

#8704 closed defect (invalid)

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

Reported by: software@… Owned by:
Priority: normal Milestone:
Component: ticket system Version: 0.11.1
Severity: major Keywords: plugins, MasterTicketsPlugin, SQL, error, PostgreSQL, postgresql
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:

Description

It seems the MasterTicketsPlugin does not like being on PostgreSQL. The following type error is proof:

How to Reproduce

While doing a GET operation on /ticket/1732, Trac issued an internal error.

(please provide additional details here)

Request parameters:

{'id': u'1732'}

User Agent was: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.4pre) Gecko/20090929 Ubuntu/8.04 (hardy) Shiretoko/3.5.4pre

System Information

Trac 0.11.1
Python 2.5.2 (r252:60911, Jan 4 2009, 21:59:32)
[GCC 4.3.2]
setuptools 0.6c8
psycopg2 2.0.7
Genshi 0.5.1
Pygments 0.10
Subversion 1.5.1 (r32289)
jQuery: 1.2.6

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.5/site-packages/trac/web/main.py", line 423, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.5/site-packages/trac/web/main.py", line 209, in dispatch
    self._post_process_request(req, *resp)
  File "/usr/lib/python2.5/site-packages/trac/web/main.py", line 299, in _post_process_request
    resp = f.post_process_request(req, *resp)
  File "build/bdist.linux-x86_64/egg/mastertickets/web_ui.py", line 45, in post_process_request
    links = TicketLinks(self.env, tkt)
  File "build/bdist.linux-x86_64/egg/mastertickets/model.py", line 22, in __init__
    cursor.execute('SELECT dest FROM mastertickets WHERE source=%s ORDER BY dest', (self.tkt.id,))
  File "/usr/lib/python2.5/site-packages/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.5/site-packages/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
ProgrammingError: operator does not exist: text = integer
LINE 1: SELECT dest FROM mastertickets WHERE source=1732 ORDER BY de...
                                                   ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.


Attachments (0)

Change History (2)

comment:1 by Felix Schwarz <felix.schwarz@…>, 15 years ago

Resolution: invalid
Status: newclosed

comment:2 by Ryan J Ollos, 9 years ago

Keywords: postgresql added

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The ticket will remain with no owner.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from (none) to the specified user.

Add Comment


E-mail address and name can be saved in the Preferences .
 
Note: See TracTickets for help on using tickets.