Hi Kevin, Do you know if your database is properly set up to use utf-8 encoding?
Christian -- Christian Hammond - [email protected] Review Board - http://www.reviewboard.org Beanbag, Inc. - http://www.beanbaginc.com On July 31, 2014 at 8:49:16 AM, Kevin Jones ([email protected]) wrote: 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. -- 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.
