[Trac-tickets] Re: [The Trac Project] #2973: Error when adding a ticket (using Trac-Mysql DB ) - Illegal mix of collations

[The Trac Project]

#2973: Error when adding a ticket (using Trac-Mysql DB ) - Illegal mix of
collations
--------------------------------------------+-------------------------------
 Reporter:  amgad.mosleh at rezayat.net        |        Owner:  anonymous
     Type:  task                            |       Status:  assigned 
 Priority:  highest                         |    Milestone:  2.0      
Component:  ticket system                   |      Version:  0.9.4    
 Severity:  critical                        |   Resolution:           
 Keywords:  ticket mysql Operational Error  |  
--------------------------------------------+-------------------------------
Old description:

> 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

New description:

 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

-- 
Ticket URL: <http://projects.edgewall.com/trac/ticket/2973>
The Trac Project <http://trac.edgewall.com/>