#3182: Error when adding or viewing a ticket using MySQL
----------------------------+-----------------------------------------------
Reporter: [EMAIL PROTECTED] | Owner: jonas
Type: defect | Status: new
Priority: normal | Milestone:
Component: ticket system | Version: devel
Severity: normal | Keywords:
----------------------------+-----------------------------------------------
When adding or viewing a ticket, I'm receiving the same error as found in
#2973 and #986. The traceback is as follows:
{{{
Traceback (most recent call last):
File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 300, in
dispatch_request
dispatcher.dispatch(req)
File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 190, in
dispatch
resp = chosen_handler.process_request(req)
File "/usr/lib/python2.3/site-packages/trac/ticket/web_ui.py", line 280,
in process_request
self._insert_ticket_data(req, db, ticket, reporter_id)
File "/usr/lib/python2.3/site-packages/trac/ticket/web_ui.py", line 561,
in _insert_ticket_data
changelog = ticket.get_changelog(db=db)
File "/usr/lib/python2.3/site-packages/trac/ticket/model.py", line 287,
in get_changelog
"ORDER BY time", (self.id, str(self.id), self.id))
File "/usr/lib/python2.3/site-packages/trac/db/util.py", line 47, in
execute
return self.cursor.execute(sql_escape_percent(sql), args)
File "/usr/lib/python2.3/site-packages/trac/db/util.py", line 47, in
execute
return self.cursor.execute(sql_escape_percent(sql), args)
File "/usr/lib64/python2.3/site-packages/MySQLdb/cursors.py", line 163,
in execute
self.errorhandler(self, exc, value)
File "/usr/lib64/python2.3/site-packages/MySQLdb/connections.py", line
35, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1267, "Illegal mix of collations
(latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation
'UNION'")
}}}
Running trac from subversion, revision 3344.
MySQL version 4.1.12 from RHEL4
Python MySQLdb version 1.2.1_p2
--
Ticket URL: <http://projects.edgewall.com/trac/ticket/3182>
The Trac Project <http://trac.edgewall.com/>
_______________________________________________
Trac-Tickets mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac-tickets
