Greetings again,
I appear to be getting the following errors sent by email:
Title: [Review Board] ERROR (EXTERNAL IP): Internal Server Error:
/reviewboard/api/users
Traceback (most recent call last):
File
"/usr/local/lib/python2.6/dist-packages/Django-1.6.5-py2.6.egg/django/core/handlers/base.py",
line 112, in get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File
"/usr/local/lib/python2.6/dist-packages/Django-1.6.5-py2.6.egg/django/views/decorators/cache.py",
line 52, in _wrapped_view_func
response = view_func(request, *args, **kwargs)
File
"/usr/local/lib/python2.6/dist-packages/Django-1.6.5-py2.6.egg/django/views/decorators/vary.py",
line 19, in inner_func
response = func(*args, **kwargs)
File
"/usr/local/lib/python2.6/dist-packages/Djblets-0.8.8-py2.6.egg/djblets/webapi/resources.py",
line 494, in __call__
request, method, view, api_format=api_format, *args, **kwargs)
File
"/usr/local/lib/python2.6/dist-packages/Djblets-0.8.8-py2.6.egg/djblets/webapi/resources.py",
line 565, in call_method_view
return view(request, *args, **kwargs)
File
"/usr/local/lib/python2.6/dist-packages/Djblets-0.8.8-py2.6.egg/djblets/webapi/decorators.py",
line 117, in _call
return view_func(*args, **kwargs)
File
"/usr/local/lib/python2.6/dist-packages/ReviewBoard-2.0.5-py2.6.egg/reviewboard/webapi/decorators.py",
line 110, in _check
return view_func(*args, **kwargs)
File
"/usr/local/lib/python2.6/dist-packages/Djblets-0.8.8-py2.6.egg/djblets/webapi/decorators.py",
line 117, in _call
return view_func(*args, **kwargs)
File
"/usr/local/lib/python2.6/dist-packages/Djblets-0.8.8-py2.6.egg/djblets/webapi/decorators.py",
line 117, in _call
return view_func(*args, **kwargs)
File
"/usr/local/lib/python2.6/dist-packages/Djblets-0.8.8-py2.6.egg/djblets/webapi/decorators.py",
line 287, in _validate
return view_func(*args, **new_kwargs)
File
"/usr/local/lib/python2.6/dist-packages/ReviewBoard-2.0.5-py2.6.egg/reviewboard/webapi/resources/user.py",
line 156, in get_list
return super(UserResource, self).get_list(*args, **kwargs)
File
"/usr/local/lib/python2.6/dist-packages/Djblets-0.8.8-py2.6.egg/djblets/webapi/decorators.py",
line 117, in _call
return view_func(*args, **kwargs)
File
"/usr/local/lib/python2.6/dist-packages/ReviewBoard-2.0.5-py2.6.egg/reviewboard/webapi/decorators.py",
line 33, in _check
return view_func(*args, **kwargs)
File
"/usr/local/lib/python2.6/dist-packages/Djblets-0.8.8-py2.6.egg/djblets/webapi/decorators.py",
line 117, in _call
return view_func(*args, **kwargs)
File
"/usr/local/lib/python2.6/dist-packages/ReviewBoard-2.0.5-py2.6.egg/reviewboard/webapi/decorators.py",
line 110, in _check
return view_func(*args, **kwargs)
File
"/usr/local/lib/python2.6/dist-packages/Djblets-0.8.8-py2.6.egg/djblets/webapi/decorators.py",
line 117, in _call
return view_func(*args, **kwargs)
File
"/usr/local/lib/python2.6/dist-packages/Djblets-0.8.8-py2.6.egg/djblets/webapi/decorators.py",
line 287, in _validate
return view_func(*args, **new_kwargs)
File
"/usr/local/lib/python2.6/dist-packages/ReviewBoard-2.0.5-py2.6.egg/reviewboard/webapi/base.py",
line 75, in get_list
return self._get_list_impl(request, *args, **kwargs)
File
"/usr/local/lib/python2.6/dist-packages/ReviewBoard-2.0.5-py2.6.egg/reviewboard/webapi/base.py",
line 90, in _get_list_impl
return super(WebAPIResource, self).get_list(request, *args, **kwargs)
File
"/usr/local/lib/python2.6/dist-packages/Djblets-0.8.8-py2.6.egg/djblets/util/decorators.py",
line 78, in _call
f = augmented_func(*args, **kwargs)
File
"/usr/local/lib/python2.6/dist-packages/Djblets-0.8.8-py2.6.egg/djblets/webapi/decorators.py",
line 117, in _call
return view_func(*args, **kwargs)
File
"/usr/local/lib/python2.6/dist-packages/Djblets-0.8.8-py2.6.egg/djblets/webapi/decorators.py",
line 117, in _call
return view_func(*args, **kwargs)
File
"/usr/local/lib/python2.6/dist-packages/Djblets-0.8.8-py2.6.egg/djblets/webapi/decorators.py",
line 287, in _validate
return view_func(*args, **new_kwargs)
File
"/usr/local/lib/python2.6/dist-packages/Djblets-0.8.8-py2.6.egg/djblets/webapi/resources.py",
line 865, in get_list
**self.build_response_args(request))
File
"/usr/local/lib/python2.6/dist-packages/Djblets-0.8.8-py2.6.egg/djblets/webapi/responses.py",
line 164, in __init__
self.total_results = self.get_total_results()
File
"/usr/local/lib/python2.6/dist-packages/Djblets-0.8.8-py2.6.egg/djblets/webapi/responses.py",
line 227, in get_total_results
return self.queryset.count()
File
"/usr/local/lib/python2.6/dist-packages/Django-1.6.5-py2.6.egg/django/db/models/query.py",
line 294, in count
return self.query.get_count(using=self.db)
File
"/usr/local/lib/python2.6/dist-packages/Django-1.6.5-py2.6.egg/django/db/models/sql/query.py",
line 390, in get_count
number = obj.get_aggregation(using=using)[None]
File
"/usr/local/lib/python2.6/dist-packages/Django-1.6.5-py2.6.egg/django/db/models/sql/query.py",
line 356, in get_aggregation
result = query.get_compiler(using).execute_sql(SINGLE)
File
"/usr/local/lib/python2.6/dist-packages/Django-1.6.5-py2.6.egg/django/db/models/sql/compiler.py",
line 786, in execute_sql
cursor.execute(sql, params)
File
"/usr/local/lib/python2.6/dist-packages/Django-1.6.5-py2.6.egg/django/db/backends/util.py",
line 53, in execute
return self.cursor.execute(sql, params)
File
"/usr/local/lib/python2.6/dist-packages/Django-1.6.5-py2.6.egg/django/db/utils.py",
line 99, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File
"/usr/local/lib/python2.6/dist-packages/Django-1.6.5-py2.6.egg/django/db/backends/util.py",
line 53, in execute
return self.cursor.execute(sql, params)
File
"/usr/local/lib/python2.6/dist-packages/Django-1.6.5-py2.6.egg/django/db/backends/mysql/base.py",
line 124, in execute
return self.cursor.execute(query, args)
File "/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 166, in
execute
self.errorhandler(self, exc, value)
File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35, in
defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1267, "Illegal mix of collations
(latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation
'like'")
<WSGIRequest
path:/reviewboard/api/users/,
GET:<QueryDict: {u'q': [u'\u310d\u311f'], u'timestamp': [u'1406790482470'],
u'fullname': [u'1'], u'limit': [u'150']}>,
POST:<QueryDict: {}>,
COOKIES:{'collapsediffs': 'True',
'csrftoken': 'h52J5ERI1Wli9hYLKNVdRFMKBVqjPybS',
'rbsessionid': 'nb1owxohc5ocrjvucaq82rthkwrkn4rj'},
META:{'DOCUMENT_ROOT': '/var/www/reviewboard.xxxxxxxxx.com/htdocs',
'GATEWAY_INTERFACE': 'CGI/1.1',
'HTTP_ACCEPT': '*/*',
'HTTP_ACCEPT_ENCODING': 'gzip,deflate,sdch',
'HTTP_ACCEPT_LANGUAGE': 'zh-TW,zh;q=0.8,en-US;q=0.6,en;q=0.4,zh-CN;q=0.2',
'HTTP_CONNECTION': 'keep-alive',
'HTTP_COOKIE': 'rbsessionid=nb1owxohc5ocrjvucaq82rthkwrkn4rj;
csrftoken=h52J5ERI1Wli9hYLKNVdRFMKBVqjPybS; collapsediffs=True',
'HTTP_HOST': 'bedlam',
'HTTP_REFERER': 'http://xxxxxxxx/reviewboard/r/31/',
'HTTP_USER_AGENT': 'Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36
(KHTML, like Gecko) Chrome/36.0.1985.125 Safari/537.36',
'HTTP_X_REQUESTED_WITH': 'XMLHttpRequest',
'PATH': '/usr/local/bin:/usr/bin:/bin',
'PATH_INFO': u'/reviewboard/api/users/',
'PATH_TRANSLATED':
'/var/www/reviewboard.xxxxxxx.com/htdocs/reviewboard.wsgi/reviewboard/api/users/',
'QUERY_STRING':
'q=%E3%84%8D%E3%84%9F&limit=150×tamp=1406790482470&fullname=1',
'REMOTE_ADDR': '10.11.0.65',
'REMOTE_PORT': '57736',
'REQUEST_METHOD': 'GET',
'REQUEST_URI':
'/reviewboard/api/users/?q=%E3%84%8D%E3%84%9F&limit=150×tamp=1406790482470&fullname=1',
'SCRIPT_FILENAME':
'/var/www/reviewboard.xxxxxxxxxx.com/htdocs/reviewboard.wsgi',
'SCRIPT_NAME': u'',
'SERVER_ADDR': '10.0.50.11',
'SERVER_ADMIN': '[no address given]',
'SERVER_NAME': 'xxxxxxxxx',
'SERVER_PORT': '80',
'SERVER_PROTOCOL': 'HTTP/1.1',
'SERVER_SIGNATURE': '<address>Apache/2.2.14 (Ubuntu) Server at
xxxxxxxxxxPort 80</address>\n',
'SERVER_SOFTWARE': 'Apache/2.2.14 (Ubuntu)',
'mod_wsgi.application_group': 'xxxxxxxx|',
'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, 8),
'wsgi.errors': <mod_wsgi.Log object at 0x2391ebe0>,
'wsgi.file_wrapper': <built-in method file_wrapper of mod_wsgi.Adapter
object at 0x23a4e698>,
'wsgi.input': <mod_wsgi.Input object at 0x23733980>,
'wsgi.multiprocess': True,
'wsgi.multithread': True,
'wsgi.run_once': False,
'wsgi.url_scheme': 'http',
'wsgi.version': (1, 0)}>
I've obfuscated the company-specific bits of the above. I'm using Mysql,
and apparently there's conflict between Latin1 and utf8 somewhere in the
query. If anyone has suggestions on how to resolve this such that I don't
get strange errors, I'd appreciate it.
-Kevin
--
Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
---
Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
---
Happy user? Let us know at http://www.reviewboard.org/users/
---
You received this message because you are subscribed to the Google Groups
"reviewboard" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
