Edgewall Software

Opened 9 years ago

Closed 9 years ago

#10857 closed defect (cantfix)

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

Reported by: stefan Owned by:
Priority: normal Milestone:
Component: database backend Version: 1.0
Severity: normal Keywords: mysql unicode needinfo
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:


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)
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
  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

Attachments (0)

Change History (2)

comment:1 by Christian Boos, 9 years ago

Component: generaldatabase backend
Keywords: mysql unicode needinfo added; UnicodeDecodeError: 'utf8' removed
Milestone: 1.0.1

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).

comment:2 by Christian Boos, 9 years ago

Resolution: cantfix
Status: newclosed

No feedback, closing.

Modify Ticket

Change Properties
Set your email in Preferences
as closed The ticket will remain with no owner.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from (none) to the specified user.

Add Comment

E-mail address and name can be saved in the Preferences .
Note: See TracTickets for help on using tickets.