Oops in the following two SQL in PostgreSQL
SELECT path FROM node_change WHERE rev=4
- HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
ORDER BY 1*rev DESC ...
- HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Oops…
Trac detected an internal error: ProgrammingError: operator does not exist: text = integer LINE 1: SELECT path
FROM node_change WHERE rev=4 ^ HINT: No operator matches the given name and argument type(s). You might need
to add explicit type casts.
There was an internal error in Trac. It is recommended that you inform your local Trac administrator and give
him all the information he needs to reproduce the issue.
To that end, you could
==== How to Reproduce ====
While doing a GET operation on `/modifiedfiles/3`, Trac issued an internal error.
''(please provide additional details here)''
Request parameters:
{{{
{'id': u'3'}
}}}
User Agent was: `Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727;
InfoPath.1; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022)`
==== System Information ====
|| '''Trac''' || `0.11.1` ||
|| '''Python''' || `2.5.2 (r252:60911, Feb 21 2008, 13:11:45) [MSC v.1310 32 bit (Intel)]` ||
|| '''setuptools''' || `0.6c8` ||
|| '''psycopg2''' || `2.0.7` ||
|| '''Genshi''' || `0.5.1` ||
|| '''mod_python''' || `3.3.1` ||
|| '''Pygments''' || `0.11.1` ||
|| '''Subversion''' || `1.5.2 (r32768)` ||
|| '''jQuery:''' || `1.2.6` ||
==== Python Traceback ====
{{{
Traceback (most recent call last):
File "c:\python25\lib\site-packages\Trac-0.11.1-py2.5.egg\trac\web\main.py", line 423, in
_dispatch_request
dispatcher.dispatch(req)
File "c:\python25\lib\site-packages\Trac-0.11.1-py2.5.egg\trac\web\main.py", line 197, in dispatch
resp = chosen_handler.process_request(req)
File "build\bdist.win32\egg\ticketmodifiedfiles\ticketmodifiedfiles.py", line 30, in process_request
(id, files, deletedfiles, ticketsperfile, filestatus, conflictingtickets, ticketisclosed, revisions) =
self.__process_ticket_request(req)
File "build\bdist.win32\egg\ticketmodifiedfiles\ticketmodifiedfiles.py", line 133, in
__process_ticket_request
cursor2.execute("SELECT path FROM node_change WHERE rev=" + str(rev))
File "c:\python25\lib\site-packages\Trac-0.11.1-py2.5.egg\trac\db\util.py", line 51, in execute
return self.cursor.execute(sql)
File "c:\python25\lib\site-packages\Trac-0.11.1-py2.5.egg\trac\db\util.py", line 51, in execute
return self.cursor.execute(sql)
ProgrammingError: operator does not exist: text = integer
LINE 1: SELECT path FROM node_change WHERE rev=4
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
}}}
a ticket at this site.
The action that triggered the error was:
GET: /modifiedfiles/3
TracGuide — The Trac User and Administration Guide
Oops…
Trac detected an internal error: ProgrammingError: operator does not exist: integer * text LINE 1: ...ERE
path='trunk/hello/hello/Program.cs' ORDER BY 1*rev DESC ... ^ HINT: No operator matches the given name and
argument type(s). You might need to add explicit type casts.
There was an internal error in Trac. It is recommended that you inform your local Trac administrator and give
him all the information he needs to reproduce the issue.
To that end, you could
==== How to Reproduce ====
While doing a GET operation on `/modifiedfiles/3`, Trac issued an internal error.
''(please provide additional details here)''
Request parameters:
{{{
{'id': u'3'}
}}}
User Agent was: `Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727;
InfoPath.1; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022)`
==== System Information ====
|| '''Trac''' || `0.11.1` ||
|| '''Python''' || `2.5.2 (r252:60911, Feb 21 2008, 13:11:45) [MSC v.1310 32 bit (Intel)]` ||
|| '''setuptools''' || `0.6c8` ||
|| '''psycopg2''' || `2.0.7` ||
|| '''Genshi''' || `0.5.1` ||
|| '''mod_python''' || `3.3.1` ||
|| '''Pygments''' || `0.11.1` ||
|| '''Subversion''' || `1.5.2 (r32768)` ||
|| '''jQuery:''' || `1.2.6` ||
==== Python Traceback ====
{{{
Traceback (most recent call last):
File "c:\python25\lib\site-packages\Trac-0.11.1-py2.5.egg\trac\web\main.py", line 423, in
_dispatch_request
dispatcher.dispatch(req)
File "c:\python25\lib\site-packages\Trac-0.11.1-py2.5.egg\trac\web\main.py", line 197, in dispatch
resp = chosen_handler.process_request(req)
File "build\bdist.win32\egg\ticketmodifiedfiles\ticketmodifiedfiles.py", line 30, in process_request
(id, files, deletedfiles, ticketsperfile, filestatus, conflictingtickets, ticketisclosed, revisions) =
self.__process_ticket_request(req)
File "build\bdist.win32\egg\ticketmodifiedfiles\ticketmodifiedfiles.py", line 144, in
__process_ticket_request
cursor.execute("SELECT change_type FROM node_change WHERE path='" + file + "' ORDER BY 1*rev DESC LIMIT
1")
File "c:\python25\lib\site-packages\Trac-0.11.1-py2.5.egg\trac\db\util.py", line 51, in execute
return self.cursor.execute(sql)
File "c:\python25\lib\site-packages\Trac-0.11.1-py2.5.egg\trac\db\util.py", line 51, in execute
return self.cursor.execute(sql)
ProgrammingError: operator does not exist: integer * text
LINE 1: ...ERE path='trunk/hello/hello/Program.cs' ORDER BY 1*rev DESC ...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
}}}
a ticket at this site.
The action that triggered the error was:
GET: /modifiedfiles/3
TracGuide — The Trac User and Administration Guide
