Edgewall Software

Opened 13 years ago

Last modified 13 years ago

#2973 closed task

Error when adding a ticket (using Trac-Mysql DB ) - Illegal mix of collations — at Version 3

Reported by: amgad.mosleh@… Owned by: anonymous
Priority: highest Milestone:
Component: ticket system Version: devel
Severity: critical Keywords: ticket mysql Operational Error
Cc: Branch:
Release Notes:
API Changes:

Description (last modified by Alec Thomas)

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 anonymous, 13 years ago

Type: defecttask

comment:2 by anonymous, 13 years ago

Owner: changed from Jonas Borgström to anonymous
Status: newassigned

comment:3 by Alec Thomas, 13 years ago

Description: modified (diff)
Note: See TracTickets for help on using tickets.