604795 - Traceback: OperationalError: (1267, "Illegal mix of collations..."

Status: VERIFIED DUPLICATE of bug 606244

(Input :: General, defect)

Description

[Stephen Donner [:stephend] Not actively reading bugmail]

http://input.mozilla.com/en-US/themes/?a=mobile&p=%f6%22%20onmouseover%3dprompt%28929657%29%20%2f%2f&page=2&s=sad triggers a 500 for me, but is fine on staging; here's the traceback:

Traceback (most recent call last):

  File "/data/www/django/input.mozilla.com/reporter/vendor/packages/Django/django/core/handlers/base.py", line 100, in get_response
    response = callback(request, *callback_args, **callback_kwargs)

  File "/data/www/django/input.mozilla.com/reporter/vendor/packages/Django/django/utils/decorators.py", line 76, in _wrapped_view
    response = view_func(request, *args, **kwargs)

  File "/data/www/django/input.mozilla.com/reporter/apps/input/decorators.py", line 33, in cached_view
    return f(request, *args, **kwargs)

  File "/data/www/django/input.mozilla.com/reporter/apps/themes/views.py", line 96, in index
    if qs:

  File "/data/www/django/input.mozilla.com/reporter/vendor/packages/Django/django/db/models/query.py", line 112, in __nonzero__
    iter(self).next()

  File "/data/www/django/input.mozilla.com/reporter/vendor/packages/Django/django/db/models/query.py", line 106, in _result_iter
    self._fill_cache()

  File "/data/www/django/input.mozilla.com/reporter/vendor/packages/Django/django/db/models/query.py", line 760, in _fill_cache
    self._result_cache.append(self._iter.next())

  File "/data/www/django/input.mozilla.com/reporter/vendor/src/django-cache-machine/caching/base.py", line 127, in __iter__
    obj = iterator.next()

  File "/data/www/django/input.mozilla.com/reporter/vendor/packages/Django/django/db/models/query.py", line 269, in iterator
    for row in compiler.results_iter():

  File "/data/www/django/input.mozilla.com/reporter/vendor/packages/Django/django/db/models/sql/compiler.py", line 672, in results_iter
    for rows in self.execute_sql(MULTI):

  File "/data/www/django/input.mozilla.com/reporter/vendor/packages/Django/django/db/models/sql/compiler.py", line 727, in execute_sql
    cursor.execute(sql, params)

  File "/data/www/django/input.mozilla.com/reporter/vendor/packages/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 '='")

Not sure if this is a config thing or what.

Comment 2

[Stephen Donner [:stephend] Not actively reading bugmail]

Mine was first!  /me doesn't really care :-)