UnicodeDecodeError: 'utf8' codec can't decode byte 0x93 in position 91: invalid start byte

[kevin]

How to Reproduce

While doing a GET operation on /search, Trac issued an internal error.

The same error shows up on some Wiki pages (but not others), all reports, and when trying to view the contents of a ticket. I've disabled all plugins except for the Account Manager (so I can log in and view this content).

This error showed up after doing an upgrade to Trac 1.0. My guess is that there's non-unicode content in the database which Trac now doesn't know what to do with, but I don't now how to fix it. I've done a trac-admin upgrade.

Request parameters:

{'changeset': u'on',
 'milestone': u'on',
 'noquickjump': u'1',
 'q': u'a',
 'ticket': u'on',
 'wiki': u'on'}

User agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.95 Safari/537.11

System Information

Trac	1.0
Babel	0.9.6
Docutils	0.7
Genshi	0.6 (without speedups)
mod_python	3.3.1
MySQL	server: "5.1.66-0ubuntu0.11.10.2", client: "5.1.66", thread-safe: 1
MySQLdb	1.2.3
Pygments	1.4
Python	2.7.2+ (default, Jul 20 2012, 22:32:25) [GCC 4.6.1]
pytz	2010b
setuptools	0.6c12
jQuery	1.7.2

Enabled Plugins

TracAccountManager

0.2.1dev-r4679

Python Traceback

Traceback (most recent call last):
  File "/usr/local/lib/python2.7/dist-packages/trac/web/main.py", line 497, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/local/lib/python2.7/dist-packages/trac/web/main.py", line 214, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/local/lib/python2.7/dist-packages/trac/search/web_ui.py", line 106, in process_request
    results = self._do_search(req, terms, filters)
  File "/usr/local/lib/python2.7/dist-packages/trac/search/web_ui.py", line 214, in _do_search
    or [])
  File "/usr/local/lib/python2.7/dist-packages/trac/ticket/web_ui.py", line 220, in get_search_results
    args + args2 + args3):
  File "/usr/local/lib/python2.7/dist-packages/trac/db/util.py", line 121, in execute
    cursor.execute(query, params)
  File "/usr/local/lib/python2.7/dist-packages/trac/db/util.py", line 65, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/pymodules/python2.7/MySQLdb/cursors.py", line 174, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/pymodules/python2.7/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
UnicodeDecodeError: 'utf8' codec can't decode byte 0x93 in position 91: invalid start byte

[Jun Omae]

It seems a duplicate of #10857 and #10758.

MySQL database must be configured with utf8 charset and utf8_bin collation. Please see MySqlDb and check the configuration.

[Jun Omae]

Close as "cantfix" cause of an InstallationIssue. Feel free to reopen if that's not the case. Thanks!