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 - [email protected] Review Board - http://www.reviewboard.org VMware, Inc. - http://www.vmware.com On Fri, Oct 14, 2011 at 9:15 AM, Sam <[email protected]> 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 > [email protected] > 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 [email protected] For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en
