756101 - [traceback] Error: OperationalError: (1267, "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'")

Status: VERIFIED WORKSFORME

(Participation Infrastructure :: Phonebook, defect)

Description

[Matt Brandt [:mbrandt]]

Steps to reproduce:
1. goto https://mozillians.allizom.org/en-US/skills/search?term=%C4%9Ft

======================

Traceback (most recent call last):

 File "/data/www/mozillians.org/mozillians/vendor/src/django/django/core/handlers/base.py", line 111, in get_response
   response = callback(request, *callback_args, **callback_kwargs)

 File "/data/www/mozillians.org/mozillians/vendor/src/django/django/contrib/auth/decorators.py", line 19, in _wrapped_view
   return view_func(request, *args, **kwargs)

 File "/data/www/mozillians.org/mozillians/vendor/src/django/django/views/decorators/cache.py", line 74, in _cache_controlled
   response = viewfunc(request, *args, **kw)

 File "/data/www/mozillians.org/mozillians/apps/groups/views.py", line 44, in search
   data['groups'] = searched_object.search(request.GET.get('term'))

 File "/data/www/mozillians.org/mozillians/apps/groups/models.py", line 33, in search
   ).values_list('name', flat=True)

 File "/data/www/mozillians.org/mozillians/vendor/src/django/django/db/models/query.py", line 84, in __len__
   self._result_cache.extend(self._iter)

 File "/data/www/mozillians.org/mozillians/vendor/src/django/django/db/models/query.py", line 968, in iterator
   for row in self.query.get_compiler(self.db).results_iter():

 File "/data/www/mozillians.org/mozillians/vendor/src/django/django/db/models/sql/compiler.py", line 699, in results_iter
   for rows in self.execute_sql(MULTI):

 File "/data/www/mozillians.org/mozillians/vendor/src/django/django/db/models/sql/compiler.py", line 754, in execute_sql
   cursor.execute(sql, params)

 File "/data/www/mozillians.org/mozillians/vendor/src/django/django/db/backends/mysql/base.py", line 86, in execute
   return self.cursor.execute(query, args)

 File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 173, in execute
   self.errorhandler(self, exc, value)

 File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
   raise errorclass, errorvalue

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

Comment 1

[Giorgos Logiotatidis [:giorgos]]

This bug points to a non-existing URL now, since this functionality was dropped at some point.

Searching for 'ğt' in the search box doesn't result in a similar error.

Thanks for reporting Matt!

Comment 2

[Matt Brandt [:mbrandt]]

Hawt .. bumping to verified wfm.

https://mozillians.allizom.org/en-US/skills/search?term=%C4%9Ft