Hi Kevin,

Do you know if your database is properly set up to use utf-8 encoding?

Christian

-- 
Christian Hammond - christ...@beanbaginc.com
Review Board - http://www.reviewboard.org
Beanbag, Inc. - http://www.beanbaginc.com

On July 31, 2014 at 8:49:16 AM, Kevin Jones (kjlo...@gmail.com) 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&timestamp=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&timestamp=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 reviewboard+unsubscr...@googlegroups.com.
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 reviewboard+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to