UnicodeDecodeError: 'utf8' codec can't decode byte 0xa9 in position 20: unexpected code byte

[suresh@…]

How to Reproduce

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

Please see - ​https://wellzio.projecthut.com/trac/cascade/ticket/33

Clicking on bug #33, errors out. Please resolve this, so we don't get an internal error.

Request parameters:

{'id': u'33'}

User Agent was: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET CLR 3.0.30618; InfoPath.2; SLCC1; MS-RTC EA 2; .NET4.0C; Tablet PC 2.0)

System Information

Trac	0.11.2.1
Python	2.4.3 (#1, May 24 2008, 13:57:05) [GCC 4.1.2 20070626 (Red Hat 4.1.2-14)]
setuptools	0.6c7
SQLite	3.3.6
pysqlite	1.1.7
Genshi	0.5.1
mod_python	3.2.8
Pygments	1.0
Subversion	1.4.2 (r22196)
jQuery:	1.2.6

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/Trac-0.11.2.1-py2.4.egg/trac/web/main.py", line 432, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.4/site-packages/Trac-0.11.2.1-py2.4.egg/trac/web/main.py", line 204, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.4/site-packages/Trac-0.11.2.1-py2.4.egg/trac/ticket/web_ui.py", line 181, in process_request
    return self._process_ticket_request(req)
  File "/usr/lib/python2.4/site-packages/Trac-0.11.2.1-py2.4.egg/trac/ticket/web_ui.py", line 530, in _process_ticket_request
    get_reporter_id(req, 'author'), field_changes)
  File "/usr/lib/python2.4/site-packages/Trac-0.11.2.1-py2.4.egg/trac/ticket/web_ui.py", line 1187, in _insert_ticket_data
    for change in self.rendered_changelog_entries(req, ticket):
  File "/usr/lib/python2.4/site-packages/Trac-0.11.2.1-py2.4.egg/trac/ticket/web_ui.py", line 1285, in rendered_changelog_entries
    for group in self.grouped_changelog_entries(ticket, None, when):
  File "/usr/lib/python2.4/site-packages/Trac-0.11.2.1-py2.4.egg/trac/ticket/web_ui.py", line 1365, in grouped_changelog_entries
    changelog = ticket.get_changelog(when=when, db=db)
  File "/usr/lib/python2.4/site-packages/Trac-0.11.2.1-py2.4.egg/trac/ticket/model.py", line 333, in get_changelog
    for t, author, field, oldvalue, newvalue, permanent in cursor:
  File "/usr/lib/python2.4/site-packages/Trac-0.11.2.1-py2.4.egg/trac/db/util.py", line 40, in __iter__
    row = self.cursor.fetchone()
  File "/usr/lib/python2.4/site-packages/Trac-0.11.2.1-py2.4.egg/trac/db/sqlite_backend.py", line 76, in fetchone
    return row and self._convert_row(row) or None
  File "/usr/lib/python2.4/site-packages/Trac-0.11.2.1-py2.4.egg/trac/db/sqlite_backend.py", line 72, in _convert_row
    return tuple([(isinstance(v, str) and [v.decode('utf-8')] or [v])[0]
  File "/usr/lib64/python2.4/encodings/utf_8.py", line 16, in decode
    return codecs.utf_8_decode(input, errors, True)
UnicodeDecodeError: 'utf8' codec can't decode byte 0xa9 in position 20: unexpected code byte

[Remy Blank]

pysqlite 1.1.7, while still (more or less) working, is completely unsupported at this time, and exhibits the kind of errors you posted. Please update to pysqlite 2.*, ideally 2.6.3.

Also, you should update to at least Trac 0.11.7, or even better 0.12.2.