OperationalError: (1267, "Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_general_ci,EXPLICIT) for operation 'like'")

[dongjiang]

How to Reproduce

While doing a GET operation on /search, Trac issued an internal error.

(please provide additional details here)

Request parameters:

{'changeset': u'on',
 'milestone': u'on',
 'noquickjump': u'1',
 'q': u'aa',
 'ticket': u'on',
 'wiki': u'on'}

User agent: Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/34.0.1847.116 Safari/537.36

System Information

Trac	1.0.1
Trac	1.0.1
Babel	0.9.6
Docutils	0.10
Genshi	0.7 (with speedups)
MySQL	server: "5.5.38", client: "5.5.10", thread-safe: 1
MySQLdb	1.2.5
Pygments	1.6
Python	2.7.6 (default, Jun 24 2014, 10:39:06) [GCC 4.4.6 20110731 (Red Hat 4.4.6-3)]
Python	2.7.6 (default, Jun 24 2014, 10:39:06) [GCC 4.4.6 20110731 (Red Hat 4.4.6-3)]
setuptools	2.2
setuptools	2.2
jQuery	1.7.2

Enabled Plugins

AutocompleteUsers	0.4.2dev-r13962
cc-selector	0.0.3dev
LogViewerPlugin	0.2-r13412
PrivateWikis	1.0.0
TicketCreationStatus	0.1
trac-UserPicturesPlugin	0.1.1
TracAccountManager	0.4.3
TracAddCommentMacro	0.3
TracBookmark	0.1dev
Tracchildtickettreemacro	1.0.1
TracHtmlNotificationPlugin	0.12.0.1
TracMacroPost	0.2
TracSectionEditPlugin	0.2.6-r11208
TracWorkflowAdmin	0.12.0.2
TracWysiwyg	0.12.0.5-r13457
VisitCounter	0.2
whiteboard	0.1.0-trac0.12dev
WikiTableMacro	0.2dev

Python Traceback

Traceback (most recent call last):
  File "build/bdist.linux-x86_64/egg/trac/web/main.py", line 497, in _dispatch_request
    dispatcher.dispatch(req)
  File "build/bdist.linux-x86_64/egg/trac/web/main.py", line 214, in dispatch
    resp = chosen_handler.process_request(req)
  File "build/bdist.linux-x86_64/egg/trac/search/web_ui.py", line 106, in process_request
    results = self._do_search(req, terms, filters)
  File "build/bdist.linux-x86_64/egg/trac/search/web_ui.py", line 214, in _do_search
    or [])
  File "build/bdist.linux-x86_64/egg/trac/wiki/web_ui.py", line 768, in get_search_results
    AND """ + sql_query, args):
  File "build/bdist.linux-x86_64/egg/trac/db/util.py", line 121, in execute
    cursor.execute(query, params)
  File "build/bdist.linux-x86_64/egg/trac/db/util.py", line 65, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "build/bdist.linux-x86_64/egg/MySQLdb/cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "build/bdist.linux-x86_64/egg/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
OperationalError: (1267, "Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_general_ci,EXPLICIT) for operation 'like'")

[Jun Omae]

That's an InstallationIssue.

It seems that your database is configured with latin1 charset and latin1_general_ci collation. MySQL database for Trac must be configured with utf8 charset and utf8_bin collation. See MySqlDb#Requirements.

[Jun Omae]

Also, a duplicate of #10431.