id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release 3844,Oops postgreSQL,JaeWook Choi,Emilien Klein,"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 }}}",defect,closed,normal,TicketModifiedFilesPlugin,normal,fixed,,,0.11