Hi Sam,

This sounds like another instance of the database not being utf-8. We
operate almost entirely in utf-8, and the database needs to be able to store
that. The reviews_review table is the cause for this error, but you'll
likely hit it again and again with more tables unless the entire database is
converted.

Christian

-- 
Christian Hammond - chip...@chipx86.com
Review Board - http://www.reviewboard.org
VMware, Inc. - http://www.vmware.com


On Fri, Oct 14, 2011 at 9:15 AM, Sam <sam...@gmail.com> wrote:

> Installing RB for the first time today. I ran into problems when
> trying to comment on code lines using Chines; it would show up as
> question marks after I published it. I made a quick fix by changing
> the text column of a reviews_comment table to be utf8_general_ci
> collation in the database. I noticed that the whole database is mostly
> latin1_swedish_ci collation.
>
> Another issue was when trying to submit a review. I turned on DEBUG
> and received an error after pressing submit:
>
> Warning at /rb/api/json/reviewrequests/2/reviews/draft/publish/
> Incorrect string value: '\xE6\xB5\x8B\xE8\xAF\x95' for column
> 'body_top' at row 1
> Request Method:         POST
> Request URL:
> http://rb.sam.org/rb/api/json/reviewrequests/2/reviews/draft/publish/
> Exception Type:         Warning
> Exception Value:
> Incorrect string value: '\xE6\xB5\x8B\xE8\xAF\x95' for column
> 'body_top' at row 1
> Exception Location:     /usr/lib64/python2.4/warnings.py in
> warn_explicit, line 96
> Python Executable:      /usr/bin/python
> Python Version:         2.4.3
> Python Path:    ['/var/www/html/rb/conf', '/usr/lib/python2.4/site-
> packages/setuptools-0.6c12dev_r88846-py2.4.egg', '/usr/lib/python2.4/
> site-packages/python_memcached-1.47-py2.4.egg', '/usr/lib/python2.4/
> site-packages/MySQL_python-1.2.3-py2.4-linux-x86_64.egg', '/usr/lib/
> python2.4/site-packages/RBTools-0.3.4-py2.4.egg', '/usr/lib64/
> python24.zip', '/usr/lib64/python2.4', '/usr/lib64/python2.4/plat-
> linux2', '/usr/lib64/python2.4/lib-tk', '/usr/lib64/python2.4/lib-
> dynload', '/usr/lib64/python2.4/site-packages', '/usr/lib64/python2.4/
> site-packages/PIL', '/usr/lib64/python2.4/site-packages/gtk-2.0', '/
> usr/lib/python2.4/site-packages']
> Server time:    Fri, 14 Oct 2011 08:55:38 -0700
>
>
> Are these known issues? Is there some type of setting or config I need
> to set to make RB more internationalized?
>
> --
> Want to help the Review Board project? Donate today at
> http://www.reviewboard.org/donate/
> Happy user? Let us know at http://www.reviewboard.org/users/
> -~----------~----~----~----~------~----~------~--~---
> To unsubscribe from this group, send email to
> reviewboard+unsubscr...@googlegroups.com
> For more options, visit this group at
> http://groups.google.com/group/reviewboard?hl=en

-- 
Want to help the Review Board project? Donate today at 
http://www.reviewboard.org/donate/
Happy user? Let us know at http://www.reviewboard.org/users/
-~----------~----~----~----~------~----~------~--~---
To unsubscribe from this group, send email to 
reviewboard+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/reviewboard?hl=en

Reply via email to