UnicodeDecodeError: 'utf8' codec can't decode byte 0xae in position 18: invalid start byte

[trac@…]

the id 32 in the database is

| 3         |     32 | Install Jennifer - application performance management | environmental setup | NULL    | sample-svc 1.0 | task |       | new    | 1314067297170599 | 1315039835262843 | JENNIFER
JENNIFER? is the application performance management (APM) solution developed by JenniferSoft Inc. JENNIFER is designed to provide integrated performance management services for enterprise company?s IT infrastructure that is based on the J2EE web application server(WAS) technology. Occupying 70% of the APM solution market in Korea and globally distributed, JENNIFER is the premier APM solution available today.
JENNIFER utilizes the powerful and intuitive monitoring dashboard to deliver in-depth performance data and its analysis in an intuitive and elegant view. Most of traditional and current system management solutions available today only show basic information such as CPU, memory and disk space usage, thus if problem occurs internally within the application, they would not be able to identify the ?root-cause? of the issue. However, JENNIFER not only monitors basic system resources, it also directly monitors individual service transactions, allowing users to easily detect, analyze and resolve system performance problems.

http://www.jennifersoft.com/docs/hidden5.html

http://www.youtube.com/watch?v=idwgxkX6M3s&feature=player_embedded |

I suspect that the registered trademark ® wasn't handle properly.

How to Reproduce

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

(please provide additional details here)

Request parameters:

{'id': u'32'}

User agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_4) AppleWebKit/534.57.2 (KHTML, like Gecko) Version/5.1.7 Safari/534.57.2

System Information

Trac	1.0dev-r11100
Babel	0.9.6
Docutils	0.7
Genshi	0.6 (with speedups)
GIT	1.7.2.5
mod_wsgi	3.3 (WSGIProcessGroup WSGIApplicationGroup trac.empi.vn|)
MySQL	server: "5.1.58-1", client: "5.1.58", thread-safe: 1
MySQLdb	1.2.2
Pygments	1.4
Python	2.6.7 (r267:88850, Aug 3 2011, 15:36:58) [GCC 4.6.1]
pytz	2010b
RPC	1.1.2-r10514
setuptools	0.6
Subversion	1.6.17 (r1128011)
jQuery	1.7.2

Enabled Plugins

ChangeLogMacro	0.2
TracXMLRPC	1.1.2-r10514

Python Traceback

Traceback (most recent call last):
  File "/usr/local/lib/python2.6/dist-packages/Trac-1.0dev_r11100-py2.6.egg/trac/web/main.py", line 490, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/local/lib/python2.6/dist-packages/Trac-1.0dev_r11100-py2.6.egg/trac/web/main.py", line 205, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/local/lib/python2.6/dist-packages/Trac-1.0dev_r11100-py2.6.egg/trac/ticket/web_ui.py", line 179, in process_request
    return self._process_ticket_request(req)
  File "/usr/local/lib/python2.6/dist-packages/Trac-1.0dev_r11100-py2.6.egg/trac/ticket/web_ui.py", line 525, in _process_ticket_request
    ticket = Ticket(self.env, id, version=version)
  File "/usr/local/lib/python2.6/dist-packages/Trac-1.0dev_r11100-py2.6.egg/trac/ticket/model.py", line 80, in __init__
    self._fetch_ticket(tkt_id)
  File "/usr/local/lib/python2.6/dist-packages/Trac-1.0dev_r11100-py2.6.egg/trac/ticket/model.py", line 115, in _fetch_ticket
    ','.join(self.std_fields), (tkt_id,)):
  File "/usr/local/lib/python2.6/dist-packages/Trac-1.0dev_r11100-py2.6.egg/trac/db/api.py", line 116, in execute
    return db.execute(query, params)
  File "/usr/local/lib/python2.6/dist-packages/Trac-1.0dev_r11100-py2.6.egg/trac/db/util.py", line 121, in execute
    cursor.execute(query, params)
  File "/usr/local/lib/python2.6/dist-packages/Trac-1.0dev_r11100-py2.6.egg/trac/db/util.py", line 65, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 166, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35, in defaulterrorhandler
    raise errorclass, errorvalue
UnicodeDecodeError: 'utf8' codec can't decode byte 0xae in position 18: invalid start byte

[Jun Omae]

It seems your database isn't configured with utf8 charset and utf8_bin collation. Please read MySqlDb.

And, the issue is an InstallationIssue. Please ask on MailingList and/or IrcChannel.

[trac@…]

I just changed my charset and it works now.

Theses errors started appearing when I upgraded to 1.0 from 0.12

Everything works perfectly before the update. I don't know if the upgrade script has anything to do with this