id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
11950	MySQL - Handling illegal mix of collations	Erik Karulf	nobody	"Hi All,

{{{
Traceback (most recent call last):

 File ""/www/www.penny-arcade.com/parts/django/django/core/handlers/base.py"", line 92, in get_response
   response = callback(request, *callback_args, **callback_kwargs)

 File ""/www/www.penny-arcade.com/parts/django/django/views/decorators/cache.py"", line 30, in _cache_controlled
   response = viewfunc(request, *args, **kw)

 File ""/www/www.penny-arcade.com/src/penny_arcade/views.py"", line 190, in archive
   if len(tags) == 0:

 File ""/www/www.penny-arcade.com/parts/django/django/db/models/query.py"", line 81, in __len__
   self._result_cache = list(self.iterator())

 File ""/www/www.penny-arcade.com/parts/django/django/db/models/query.py"", line 238, in iterator
   for row in self.query.results_iter():

 File ""/www/www.penny-arcade.com/parts/django/django/db/models/sql/query.py"", line 287, in results_iter
   for rows in self.execute_sql(MULTI):

 File ""/www/www.penny-arcade.com/parts/django/django/db/models/sql/query.py"", line 2369, in execute_sql
   cursor.execute(sql, params)

 File ""/www/www.penny-arcade.com/parts/django/django/db/backends/mysql/base.py"", line 84, in execute
   return self.cursor.execute(query, args)

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

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

OperationalError: (1270, ""Illegal mix of collations (latin1_swedish_ci,IMPLICIT), (utf8_general_ci,COERCIBLE), (utf8_general_ci,COERCIBLE) for operation ' IN '"")


<WSGIRequest
GET:<QueryDict: {u'q': [u'news  /path\ufffdto\ufffdqnews/q-news.php?id=http://www.diakonia-jkt.sch.id/upload/id1???']}>,
POST:<QueryDict: {}>,
COOKIES:{},
META:{'DOCUMENT_ROOT': '/www/www.penny-arcade.com/public/',
 'GATEWAY_INTERFACE': 'CGI/1.1',
 'HTTP_HOST': 'www.penny-arcade.com',
 'HTTP_USER_AGENT': 'Mozilla/5.0',
 'HTTP_X_FORWARDED_FOR': '206.225.23.4',
 'HTTP_X_VARNISH': '499193426',
 'PATH': '/sbin:/bin:/usr/sbin:/usr/bin',
 'PATH_INFO': u'/archive/',
 'PATH_TRANSLATED': '/www/www.penny-arcade.com/bin/django.wsgi/archive/',
 'QUERY_STRING': 'q=news%20%20/path%A7to%A7qnews/q-news.php?id=http://www.diakonia-jkt.sch.id/upload/id1???',
 'REMOTE_ADDR': '172.17.16.98',
 'REMOTE_PORT': '52485',
 'REQUEST_METHOD': 'GET',
 'REQUEST_URI': '/archive/?q=news%20%20/path%A7to%A7qnews/q-news.php?id=http://www.diakonia-jkt.sch.id/upload/id1???',
 'SCRIPT_FILENAME': '/www/www.penny-arcade.com/bin/django.wsgi',
 'SCRIPT_NAME': u'',
 'SERVER_ADDR': '172.17.17.9',
 'SERVER_ADMIN': 'webmaster@penny-arcade.com',
 'SERVER_NAME': 'www.penny-arcade.com',
 'SERVER_PORT': '80',
 'SERVER_PROTOCOL': 'HTTP/1.1',
 'SERVER_SIGNATURE': '',
 'SERVER_SOFTWARE': 'Apache',
 'mod_wsgi.application_group': 'www.penny-arcade.com|',
 'mod_wsgi.callable_object': 'application',
 'mod_wsgi.listener_host': '',
 'mod_wsgi.listener_port': '80',
 'mod_wsgi.process_group': '',
 'mod_wsgi.reload_mechanism': '0',
 'mod_wsgi.script_reloading': '1',
 'mod_wsgi.version': (2, 5),
 'wsgi.errors': <mod_wsgi.Log object at 0x8035c6480>,
 'wsgi.file_wrapper': <built-in method file_wrapper of mod_wsgi.Adapter object at 0x80315a3f0>,
 'wsgi.input': <mod_wsgi.Input object at 0x8031e2730>,
 'wsgi.multiprocess': True,
 'wsgi.multithread': False,
 'wsgi.run_once': False,
 'wsgi.url_scheme': 'http',
 'wsgi.version': (1, 0)}>
}}}"		closed	Uncategorized	1.1		invalid			Unreviewed	0	0	0	0	0	0