UnicodeDecodeError: 'utf8' codec can't decode byte 0xfc in position 11: invalid start byte

[stefan]

How to Reproduce

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

(please provide additional details here)

Request parameters:

{'group': u'resolution', 'milestone': u'Bugfixing CoMA', 'status': u'closed'}

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

System Information

Trac	1.0
Genshi	0.6 (with speedups)
GIT	1.7.9.5
mod_wsgi	3.3 (WSGIProcessGroup WSGIApplicationGroup %{GLOBAL})
MySQL	server: "5.5.24-0ubuntu0.12.04.1", client: "5.5.24", thread-safe: 1
MySQLdb	1.2.3
Pygments	1.4
Python	2.7.3 (default, Aug 1 2012, 05:25:23) [GCC 4.6.3]
setuptools	0.6
jQuery	1.4.4

Enabled Plugins

Python Traceback

Traceback (most recent call last):
  File "/usr/local/lib/python2.7/dist-packages/Trac-1.0-py2.7.egg/trac/web/main.py", line 497, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/local/lib/python2.7/dist-packages/Trac-1.0-py2.7.egg/trac/web/main.py", line 214, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/local/lib/python2.7/dist-packages/Trac-1.0-py2.7.egg/trac/ticket/query.py", line 960, in process_request
    return self.display_html(req, query)
  File "/usr/local/lib/python2.7/dist-packages/Trac-1.0-py2.7.egg/trac/ticket/query.py", line 1058, in display_html
    tickets = query.execute(req)
  File "/usr/local/lib/python2.7/dist-packages/Trac-1.0-py2.7.egg/trac/ticket/query.py", line 317, in execute
    cursor.execute(sql, args)
  File "/usr/local/lib/python2.7/dist-packages/Trac-1.0-py2.7.egg/trac/db/util.py", line 65, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
UnicodeDecodeError: 'utf8' codec can't decode byte 0xfc in position 11: invalid start byte

[Christian Boos]

The usual questions… did you follow the prerequisites for selecting the proper encoding for your MySQL database, as explained in MySqlDb?

Check with the SHOW VARIABLES WHERE… statement detailed in that page. If this is not what was expected, see MySqlDb#Collationfromwhatevertoutf8_bin for the commands to fix it.

Also … how come you have jQuery 1.4.4 with Trac 1.0 (check step 5 in TracUpgrade#a5.Refreshstaticresources).

[Christian Boos]

No feedback, closing.