Edgewall Software

Changes between Initial Version and Version 1 of Ticket #6799


Ignore:
Timestamp:
Feb 11, 2008, 11:47:43 AM (16 years ago)
Author:
Christian Boos
Comment:

Another hint: use Wiki blocks: {{{ ... }}} for such backtraces.

Plus: 

SELECT id, forum, time, subject, body, author FROM topic

This is coming from a plugin, so you should identify that plugin and report the problem to its author, not here (as we don't maintain that plugin here).

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #6799

    • Property Keywords postgresql83 added
    • Property Status new → closed
    • Property Resolution → wontfix
    • Property Milestone 0.11

  • Ticket #6799 – Description

    initial v1  
    1 Trac![sample-project:main] DEBUG: Dispatching <Request "GET u'/search'">[[BR]]Trac![sample-project:svn_fs] DEBUG: Subversion bindings imported[[BR]]Trac![sample-project:search] DEBUG: SELECT id, forum, time, subject, body, author FROM topic WHERE (author ILIKE %s ESCAPE '/' OR subject ILIKE %s ESCAPE '/' OR body ILIKE %s ESCAPE '/')[[BR]]Trac![sample-project:search] DEBUG: SELECT m.id, m.forum, m.topic, m.time, m.author, m.body, t.subject FROM message m LEFT JOIN (SELECT subject, id FROM topic) t ON t.id = m.topic WHERE (m.author ILIKE %s ESCAPE '/' OR m.body ILIKE %s ESCAPE '/' OR t.subject ILIKE %s ESCAPE '/')[[BR]]Trac![sample-project:chrome] DEBUG: Prepare chrome data for request[[BR]]Trac![sample-project:main] ERROR: operator does not exist: integer !~~* text at character 440[[BR]]HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.[[BR]]Traceback (most recent call last):[[BR]]  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r0-py2.4.egg/trac/web/main.py", line 406, in _dispatch_request[[BR]]    dispatcher.dispatch(req)[[BR]]  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r0-py2.4.egg/trac/web/main.py", line 195, in dispatch[[BR]]    resp = chosen_handler.process_request(req)[[BR]]  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r0-py2.4.egg/trac/search/web_ui.py", line 106, in process_request[[BR]]    results += list(source.get_search_results(req, terms, filters))[[BR]]  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r0-py2.4.egg/trac/ticket/web_ui.py", line 196, in get_search_results[[BR]]    args + args2)[[BR]]  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r0-py2.4.egg/trac/db/util.py", line 50, in execute[[BR]]    return self.cursor.execute(sql_escape_percent(sql), args)[[BR]]  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r0-py2.4.egg/trac/db/util.py", line 50, in execute[[BR]]    return self.cursor.execute(sql_escape_percent(sql), args)[[BR]]!ProgrammingError: operator does not exist: integer !~~* text at character 440[[BR]]HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
     1{{{
     2Trac[sample-project:main] DEBUG: Dispatching <Request "GET u'/search'">
     3Trac[sample-project:svn_fs] DEBUG: Subversion bindings imported
     4Trac[sample-project:search] DEBUG: SELECT id, forum, time, subject, body, author FROM topic WHERE (author ILIKE %s ESCAPE '/' OR subject ILIKE %s ESCAPE '/' OR body ILIKE %s ESCAPE '/')
     5Trac[sample-project:search] DEBUG: SELECT m.id, m.forum, m.topic, m.time, m.author, m.body, t.subject FROM message m LEFT JOIN (SELECT subject, id FROM topic) t ON t.id = m.topic WHERE (m.author ILIKE %s ESCAPE '/' OR m.body ILIKE %s ESCAPE '/' OR t.subject ILIKE %s ESCAPE '/')
     6Trac[sample-project:chrome] DEBUG: Prepare chrome data for request
     7Trac[sample-project:main] ERROR: operator does not exist: integer ~~* text at character 440
     8HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
     9Traceback (most recent call last):
     10  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r0-py2.4.egg/trac/web/main.py", line 406, in _dispatch_request
     11    dispatcher.dispatch(req)
     12  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r0-py2.4.egg/trac/web/main.py", line 195, in dispatch
     13    resp = chosen_handler.process_request(req)
     14  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r0-py2.4.egg/trac/search/web_ui.py", line 106, in process_request
     15    results += list(source.get_search_results(req, terms, filters))
     16  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r0-py2.4.egg/trac/ticket/web_ui.py", line 196, in get_search_results
     17    args + args2)
     18  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r0-py2.4.egg/trac/db/util.py", line 50, in execute
     19    return self.cursor.execute(sql_escape_percent(sql), args)
     20  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r0-py2.4.egg/trac/db/util.py", line 50, in execute
     21    return self.cursor.execute(sql_escape_percent(sql), args)
     22ProgrammingError: operator does not exist: integer ~~* text at character 440
     23HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
     24}}}