Trac falls over when I click on a ticket to view/edit

[charles.levere@…]

We have installed Trac. We can create new tickets. Tickets are listed in order. When we click on a ticvket to view or edit; Trac falls over with error below: Python Traceback

Traceback (most recent call last):

File "/usr/local/lib/python2.4/site-packages/trac/web/main.py", line 406, in dispatch_request

dispatcher.dispatch(req)

File "/usr/local/lib/python2.4/site-packages/trac/web/main.py", line 237, in dispatch

resp = chosen_handler.process_request(req)

File "/usr/local/lib/python2.4/site-packages/trac/ticket/web_ui.py", line 313, in process_request

get_reporter_id(req, 'author'))

File "/usr/local/lib/python2.4/site-packages/trac/ticket/web_ui.py", line 630, in _insert_ticket_data

for change in self.grouped_changelog_entries(ticket, db):

File "/usr/local/lib/python2.4/site-packages/trac/ticket/web_ui.py", line 677, in grouped_changelog_entries

changelog = ticket.get_changelog(when=when, db=db)

File "/usr/local/lib/python2.4/site-packages/trac/ticket/model.py", line 296, in get_changelog

"ORDER BY time", (self.id, str(self.id), self.id))

File "/usr/local/lib/python2.4/site-packages/trac/db/util.py", line 50, in execute

return self.cursor.execute(sql_escape_percent(sql), args)

File "/usr/local/lib/python2.4/site-packages/trac/db/util.py", line 50, in execute

return self.cursor.execute(sql_escape_percent(sql), args)

File "/usr/local/lib/python2.4/site-packages/MySQLdb/cursors.py", line 163, in execute

self.errorhandler(self, exc, value)

File "/usr/local/lib/python2.4/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler

raise errorclass, errorvalue

OperationalError: (1267, "Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation 'UNION'")

Trac Powered

Powered by Trac 0.10.4 By Edgewall Software.

Visit the Trac open source