Search is broken with SQLite < 3.0

[Tim Hatch <trac@…>]

I have a Debian box that's been running Trac nicely for a while, but recently encountered a search error, pointing at use of ESCAPE. Here's the traceback:

Traceback (most recent call last):
  File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 299, in dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 175, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.3/site-packages/trac/Search.py", line 184, in process_request
    results += list(source.get_search_results(req, terms, filters))
  File "/usr/lib/python2.3/site-packages/trac/ticket/api.py", line 193, in get_search_results
    args + args2)
  File "/usr/lib/python2.3/site-packages/trac/db/util.py", line 47, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.3/site-packages/sqlite/main.py", line 255, in execute
    self.rs = self.con.db.execute(SQL % parms)
DatabaseError: near "ESCAPE": syntax error

This is caused by using SQLite 2.0, which works for everything else... just not for search. The relevant Debian packages are python-sqlite (supports SQLite 2.0) and python-pysqlite2 (which supports SQLite 3.0). I only had the first installed on this box, and the database was 2.0 format. The ESCAPE clause was added for 3.0. After installing python-pysqlite2 and running the standard 2.0->3.0 upgrade procedure for the database, it now works great.

I believe this worked fine before r2940, as that is when ESCAPE was first added to source:trunk/trac/Search.py . The easy solution is to just upgrade any servers to pysqlite2 for SQLite 3.0.

[anonymous]

#2976, #2980 marked as duplicates.

[cboos]

#3127 marked as duplicate.

[cboos]

... and #3133, plus I added a note on bulix.org to hopefully stop the flood of duplicate tickets.

[cboos]

(OTOH, this ticket will make a good test case for the ticket similarity code ;) )

[jonas]

Fixed in r3326.