Opened 18 years ago
Last modified 17 years ago
#2973 closed task
Error when adding a ticket (using Trac-Mysql DB ) - Illegal mix of collations — at Version 3
Reported by: | Owned by: | anonymous | |
---|---|---|---|
Priority: | highest | Milestone: | |
Component: | ticket system | Version: | devel |
Severity: | critical | Keywords: | ticket mysql Operational Error |
Cc: | Branch: | ||
Release Notes: | |||
API Changes: | |||
Internal Changes: |
Description (last modified by )
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
Change History (3)
comment:1 by , 18 years ago
Type: | defect → task |
---|
comment:2 by , 18 years ago
Owner: | changed from | to
---|---|
Status: | new → assigned |
comment:3 by , 18 years ago
Description: | modified (diff) |
---|
Note:
See TracTickets
for help on using tickets.