Hi, I don't know why that's happening, but just to help with narrowing it down a bit, I can say that encoding issues for diff content isn't a problem. We base64-encode all diff content and store it in the database that way in order to prevent any encoding issues. So what was in the original database should be what's in the new database.
What version control system are you using? Perhaps there's some environmental difference causing the fetched files to not be in the proper encoding? Christian -- Christian Hammond - chip...@chipx86.com Review Board - http://www.reviewboard.org VMware, Inc. - http://www.vmware.com On Tue, May 29, 2012 at 10:52 AM, Gonz <gonzalo...@gmail.com> wrote: > Hi, > > Im having a hard time trying to figure out a solution out of this > issue. I had an RB site set up with a SQLITE backend database, but due > to some performance issues, I attempted to migrate the db to MySql > using the provided dump and loaddb scripts. > > To do that, I: > > * set up a testing environment with the exact same setup as in the > production environment, and dumped the db to json using rb-site manage > dump db, > * set up the new MySql database, > * changed the settings in the settings_local.py file to tell RB to use > the new MySql db. > * did a syncdb to create the table structure on the new mysql db > * restored the json dump into the new mysql db using rb-site manage > loaddb. > > The process seemed pretty effortless until that point. > > I would like to add that I set up the new db with utf-8 as the default > charset, trying to prevent any encoding troubles. > > At first glance, the db seemed to work fine. Acute letters and other > spanish characters actually show up correctly on posts and such, but > when trying to view a Diff that contains an "á", RB will return "Diff > Currently Unavailable" error. Here is an example: > > > > ********************************************************************************************************************************************************************* > /src/main/resources/configuration/deployment.general.properties > Revision 38077 New Change > Diff currently unavailable. > Error: The patch to '/src/main/resources/configuration/ > deployment.general.properties' didn't apply cleanly. The temporary > files have been left in '/tmp/reviewboard.tCd6AH' for debugging > purposes. `patch` returned: patching file /tmp/reviewboard.tCd6AH/ > tmpso_wST Hunk #1 FAILED at 73. 1 out of 1 hunk FAILED -- saving > rejects to file /tmp/reviewboard.tCd6AH/tmpso_wST-new.rej > Details > Traceback (most recent call last): > File "/usr/local/lib/python2.6/dist-packages/ReviewBoard-1.6.6- > py2.6.egg/reviewboard/diffviewer/views.py", line 217, in > view_diff_fragment > file = get_requested_diff_file() > File "/usr/local/lib/python2.6/dist-packages/ReviewBoard-1.6.6- > py2.6.egg/reviewboard/diffviewer/views.py", line 193, in > get_requested_diff_file > get_chunks) > File "/usr/local/lib/python2.6/dist-packages/ReviewBoard-1.6.6- > py2.6.egg/reviewboard/diffviewer/diffutils.py", line 1072, in > get_diff_files > large_data=True) > File "/usr/local/lib/python2.6/dist-packages/Djblets-0.6.16- > py2.6.egg/djblets/util/misc.py", line 157, in cache_memoize > data = lookup_callable() > File "/usr/local/lib/python2.6/dist-packages/ReviewBoard-1.6.6- > py2.6.egg/reviewboard/diffviewer/diffutils.py", line 1071, in <lambda> > enable_syntax_highlighting)), > File "/usr/local/lib/python2.6/dist-packages/ReviewBoard-1.6.6- > py2.6.egg/reviewboard/diffviewer/diffutils.py", line 553, in > get_chunks > new = get_patched_file(old, filediff) > File "/usr/local/lib/python2.6/dist-packages/ReviewBoard-1.6.6- > py2.6.egg/reviewboard/diffviewer/diffutils.py", line 375, in > get_patched_file > return patch(filediff.diff, buffer, filediff.dest_file) > File "/usr/local/lib/python2.6/dist-packages/ReviewBoard-1.6.6- > py2.6.egg/reviewboard/diffviewer/diffutils.py", line 243, in patch > (filename, tempdir, patch_output)) > Exception: The patch to '/src/main/resources/configuration/ > deployment.general.properties' didn't apply cleanly. The temporary > files have been left in '/tmp/reviewboard.tCd6AH' for debugging > purposes. > `patch` returned: patching file /tmp/reviewboard.tCd6AH/tmpso_wST > Hunk #1 FAILED at 73. > 1 out of 1 hunk FAILED -- saving rejects to file /tmp/ > reviewboard.tCd6AH/tmpso_wST-new.rej > > > ********************************************************************************************************************************************************************* > I could see that the problem was the "á" since I looked it up in > the .rej file that it generated, and the "á" shows all messed up like > this= #...hasta ac� > > At this point I have already tried to re-do the whole process a few > times, first time I didnt set up the Mysql db with utf8 as the default > charset, and I thought that was my mistake, but then I did it and it > kept happening the same. > > Any help on this would be greatly appreciated, please ask any details > you may need.. > > Many Thanks In Advance, > > Gonzalo. > > -- > 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
