Edgewall Software

Opened 10 years ago

Closed 10 years ago

Last modified 10 years ago

#11665 closed defect (cantfix)

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

Reported by: dongjiang Owned by:
Priority: normal Milestone:
Component: general Version: 1.0.1
Severity: normal Keywords:
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:


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
TracMacroPost 0.2
TracSectionEditPlugin 0.2.6-r11208
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
  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'")

Attachments (0)

Change History (2)

comment:1 by Jun Omae, 10 years ago

Resolution: cantfix
Status: newclosed

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.

comment:2 by Jun Omae, 10 years ago

Also, a duplicate of #10431.

Modify Ticket

Change Properties
Set your email in Preferences
as closed The ticket will remain with no owner.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from (none) to the specified user.

Add Comment

E-mail address and name can be saved in the Preferences .
Note: See TracTickets for help on using tickets.