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

[Emmanuel Blot]

MySQL is only supported with UTF-8 character set - see MySqlDb

It seems that another charset is used in your environment (latin1_swedish_ci)

Duplicate of #3182