id summary reporter owner description type status priority milestone component version severity resolution keywords cc branch changelog apichanges internalchanges 2973 Error when adding a ticket (using Trac-Mysql DB ) - Illegal mix of collations amgad.mosleh@… anonymous "Hi every one I am using Trac with MySQL data base and I am getting an exception when I try to add a ticket. The Trace of the Exception is as followos: {{{ Traceback (most recent call last): File ""C:\engines\Python24\lib\site-packages\trac\web\main.py"", line 283, in dispatch_request dispatcher.dispatch(req) File ""C:\engines\Python24\lib\site-packages\trac\web\main.py"", line 170, in dispatch resp = chosen_handler.process_request(req) File ""C:\engines\Python24\lib\site-packages\trac\ticket\web_ui.py"", line 219, in process_request self._insert_ticket_data(req, db, ticket, reporter_id) File ""C:\engines\Python24\lib\site-packages\trac\ticket\web_ui.py"", line 424, in _insert_ticket_data changelog = ticket.get_changelog(db=db) File ""C:\engines\Python24\lib\site-packages\trac\ticket\model.py"", line 271, in get_changelog ""ORDER BY time"", (self.id, str(self.id), self.id)) File ""C:\engines\Python24\lib\site-packages\trac\db\util.py"", line 47, in execute return self.cursor.execute(sql_escape_percent(sql), args) File ""C:\engines\Python24\lib\site-packages\trac\db\util.py"", line 47, in execute return self.cursor.execute(sql_escape_percent(sql), args) File ""C:\engines\Python24\lib\site-packages\MySQLdb\cursors.py"", line 137, in execute self.errorhandler(self, exc, value) File ""C:\engines\Python24\lib\site-packages\MySQLdb\connections.py"", line 33, in defaulterrorhandler raise errorclass, errorvalue OperationalError: (1267, ""Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation 'UNION'"") }}} Thanks in advance " task closed highest ticket system devel critical duplicate ticket mysql Operational Error