ProgrammingError: operator does not exist: text = integerLINE 1: SELECT * FROM attachment WHERE id=148 ^HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

[ocaml]

How to Reproduce

While doing a POST operation on /ticket/move, Trac issued an internal error.

(please provide additional details here)

Request parameters:

{'__FORM_TOKEN': u'c27a6808b1eaf478bdb3e028',
 'delete': u'delete',
 'project': u'AFA',
 'ticket': u'148'}

User agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:17.0) Gecko/20100101 Firefox/17.0

System Information

Trac	0.12.2
Babel	0.9.6
Docutils	0.7
Genshi	0.6
mod_python	3.3.1
psycopg2	2.4.2
Pygments	1.4
Python	2.7.2+ (default, Jul 20 2012, 22:32:25) [GCC 4.6.1]
pytz	2010b
RPC	1.1.2-r12168
setuptools	0.6
Subversion	1.6.12 (r955767)
jQuery	1.4.2

Enabled Plugins

AutocompleteUsers	0.4.2dev-r11757
cc-selector	0.0.2
TicketExtPlugin	0.3.2-r10092
TicketMoverPlugin	0.1.1
TicketSidebarProvider	0.0-r11698
TracBuildbot	0.1.2
TracCustomFieldAdmin	0.2.8-r12166
TracDateField	1.1.0-r12118
TracPyDotOrgTheme	2.0
TracReportManager	0.1
TracSQL	0.3
TracThemeEngine	2.0.1
TracTocMacro	11.0.0.3
TracWikiPrintPlugin	1.9.2
TracWysiwyg	0.12.0.4-r11158
TracXMLRPC	1.1.2-r12168

Python Traceback

Traceback (most recent call last):
  File "/usr/local/lib/python2.7/dist-packages/Trac-0.12.2-py2.7.egg/trac/web/main.py", line 511, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/local/lib/python2.7/dist-packages/Trac-0.12.2-py2.7.egg/trac/web/main.py", line 237, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/local/lib/python2.7/dist-packages/TicketMoverPlugin-0.1.1-py2.7.egg/ticketmoverplugin/web_ui.py", line 100, in process_request
    new_location = tm.move(req.args['ticket'], req.authname, req.args['project'], 'delete' in req.args)
  File "/usr/local/lib/python2.7/dist-packages/TicketMoverPlugin-0.1.1-py2.7.egg/ticketmoverplugin/ticketmover.py", line 191, in move
    for row in get_all_dict(self.env, "SELECT * FROM %s WHERE %s=%s" % (table, _id, ticket_id)):
  File "/usr/local/lib/python2.7/dist-packages/TracSQLHelper-0.2.1-py2.7.egg/tracsqlhelper/__init__.py", line 51, in get_all_dict
    desc, rows = get_all(env, sql, *params);
  File "/usr/local/lib/python2.7/dist-packages/TracSQLHelper-0.2.1-py2.7.egg/tracsqlhelper/__init__.py", line 23, in __call__
    cur.execute(sql, params)
  File "/usr/local/lib/python2.7/dist-packages/Trac-0.12.2-py2.7.egg/trac/db/util.py", line 66, in execute
    return self.cursor.execute(sql)
ProgrammingError: operator does not exist: text = integer
LINE 1: SELECT * FROM attachment WHERE id=148
                                         ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

[Nathan Bird]

This error appears to be in SQL generated by the plugin... what database system (and version) are you using?

[Ryan J Ollos]

Duplicate of #7496, which reports using PostgreSQL.