Edgewall Software

Opened 10 years ago

Closed 10 years ago

#10977 closed defect (cantfix)

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

Reported by: kevin Owned by:
Priority: normal Milestone:
Component: general Version: 1.0
Severity: normal Keywords:
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:


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

Attachments (0)

Change History (2)

comment:1 by Jun Omae, 10 years ago

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.

comment:2 by Jun Omae, 10 years ago

Resolution: cantfix
Status: newclosed

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

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.