UnicodeDecodeError: 'ascii' codec can't decode byte 0xe2 in position 1153: ordinal not in range(128)

[anonymous]

Just searched for "rme" on ffado.org:

​http://subversion.ffado.org/index.fcgi/search?q=rme&noquickjump=1&ticket=on&changeset=on&wiki=on

Python Traceback

Traceback (most recent call last):
  File "/home/ffado/packages/lib/python2.3/site-packages/trac/web/main.py", line 387, in dispatch_request
    dispatcher.dispatch(req)
  File "/home/ffado/packages/lib/python2.3/site-packages/trac/web/main.py", line 237, in dispatch
    resp = chosen_handler.process_request(req)
  File "/home/ffado/packages/lib/python2.3/site-packages/trac/Search.py", line 181, in process_request
    results += list(source.get_search_results(req, terms, filters))
  File "/home/ffado/packages/lib/python2.3/site-packages/trac/wiki/web_ui.py", line 488, in get_search_results
    yield (req.href.wiki(name), '%s: %s' % (name, shorten_line(text)),
  File "/home/ffado/packages/lib/python2.3/site-packages/trac/Search.py", line 92, in shorten_result
    i = text_low.find(k.lower())
UnicodeDecodeError: 'ascii' codec can't decode byte 0xe2 in position 1153: ordinal not in range(128)

Per Eriksson per at erinet d0t se

[Emmanuel Blot]

(fixing description)

[Emmanuel Blot]

It looks like a dup of #4684, although the site is using a recent release of Trac.

Maybe their database contains invalid data produced by an invalid commit script, or an old release of Trac.

I would propose a wontfix status here, as there's nothing that can be done in Trac, but the admin of ffado.org needs to clean up the DB.

[anonymous]

pieter . palmers at ffado . org (ffado.org admin)

If someone would be so kind as to point me to a description on how I should clean up the DB?

The main issue seems to be that I use the MySQL backend to TRAC (at least that's what I conclude from googling). Several people report similar issues, but I can't find a conclusive solution.

Meanwhile I've worked around the issue by putting the following on top of Search.py:

import sys
reload(sys)
sys.setdefaultencoding("latin1")

[Christian Boos]

See #6017.