665200 - Collation error

Status: RESOLVED FIXED

(addons.mozilla.org Graveyard :: Code Quality, defect)

Description

[Andy McKay]

Traceback (most recent call last):

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

 File "/data/amo_python/www/prod/zamboni/vendor/lib/python/session_csrf/__init__.py", line 107, in wrapper
   response = f(request, *args, **kw)

 File "/data/amo_python/www/prod/zamboni/apps/users/views.py", line 379, in register
   if form.is_valid():

 File "/data/amo_python/www/prod/zamboni/vendor/src/django/django/forms/forms.py", line 121, in is_valid
   return self.is_bound and not bool(self.errors)

 File "/data/amo_python/www/prod/zamboni/vendor/src/django/django/forms/forms.py", line 112, in _get_errors
   self.full_clean()

 File "/data/amo_python/www/prod/zamboni/vendor/src/django/django/forms/forms.py", line 267, in full_clean
   self._clean_fields()

 File "/data/amo_python/www/prod/zamboni/vendor/src/happyforms/happyforms/__init__.py", line 32, in _clean_fields
   value = getattr(self, 'clean_%s' % name)()

 File "/data/amo_python/www/prod/zamboni/apps/users/forms.py", line 48, in clean_password
   if BlacklistedPassword.blocked(data):

 File "/data/amo_python/www/prod/zamboni/vendor/src/django/django/db/models/query.py", line 113, in __nonzero__
   iter(self).next()

 File "/data/amo_python/www/prod/zamboni/vendor/src/django/django/db/models/query.py", line 107, in _result_iter
   self._fill_cache()

 File "/data/amo_python/www/prod/zamboni/vendor/src/django/django/db/models/query.py", line 784, in _fill_cache
   self._result_cache.append(self._iter.next())

 File "/data/amo_python/www/prod/zamboni/vendor/src/django-cache-machine/caching/base.py", line 103, in __iter__
   obj = iterator.next()

 File "/data/amo_python/www/prod/zamboni/vendor/src/django-cache-machine/caching/base.py", line 159, in fetch_by_id
   pks = [val[0] for val in vals]

 File "/data/amo_python/www/prod/zamboni/vendor/src/django/django/db/models/query.py", line 107, in _result_iter
   self._fill_cache()

 File "/data/amo_python/www/prod/zamboni/vendor/src/django/django/db/models/query.py", line 784, in _fill_cache
   self._result_cache.append(self._iter.next())

 File "/data/amo_python/www/prod/zamboni/vendor/src/django/django/db/models/query.py", line 971, in iterator
   for row in self.query.get_compiler(self.db).results_iter():

 File "/data/amo_python/www/prod/zamboni/vendor/src/django/django/db/models/sql/compiler.py", line 695, in results_iter
   for rows in self.execute_sql(MULTI):

 File "/data/amo_python/www/prod/zamboni/vendor/src/django/django/db/models/sql/compiler.py", line 750, in execute_sql
   cursor.execute(sql, params)

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

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

 File "/usr/lib/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 '='")

Comment 1

[Andy McKay]

https://github.com/jbalogh/zamboni/commit/9ceecdbac2798a9e625222e21f222c4f58f02e76