id summary reporter owner description type status priority milestone component version severity resolution keywords cc branch changelog apichanges internalchanges 3949 trac fails to show ticket anonymous Jonas Borgström "1) add ticket 2) submit this happens: {{{ Traceback (most recent call last): File ""/usr/lib/python2.4/site-packages/trac/web/main.py"", line 356, in dispatch_request dispatcher.dispatch(req) File ""/usr/lib/python2.4/site-packages/trac/web/main.py"", line 224, in dispatch resp = chosen_handler.process_request(req) File ""/usr/lib/python2.4/site-packages/trac/ticket/web_ui.py"", line 302, in process_request get_reporter_id(req, 'author')) File ""/usr/lib/python2.4/site-packages/trac/ticket/web_ui.py"", line 615, in _insert_ticket_data for change in self.grouped_changelog_entries(ticket, db): File ""/usr/lib/python2.4/site-packages/trac/ticket/web_ui.py"", line 662, in grouped_changelog_entries changelog = ticket.get_changelog(when=when, db=db) File ""/usr/lib/python2.4/site-packages/trac/ticket/model.py"", line 297, in get_changelog ""ORDER BY time"", (self.id, str(self.id), self.id)) File ""/usr/lib/python2.4/site-packages/trac/db/util.py"", line 47, in execute return self.cursor.execute(sql_escape_percent(sql), args) File ""/usr/lib/python2.4/site-packages/trac/db/util.py"", line 47, in execute return self.cursor.execute(sql_escape_percent(sql), args) File ""/usr/lib/python2.4/site-packages/MySQLdb/cursors.py"", line 137, in execute self.errorhandler(self, exc, value) File ""/usr/lib/python2.4/site-packages/MySQLdb/connections.py"", line 33, in defaulterrorhandler raise errorclass, errorvalue OperationalError: (1267, ""Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'UNION'"") }}} The ticket is added but this stacktrace is shown when trying to display the ticket." defect closed normal general 0.10 critical duplicate mysql