https://www.redmine.org/https://www.redmine.org/favicon.ico?16793021292013-05-08T09:06:13ZRedmineRedmine - Defect #14009: Issue Editing/Viewing - ASCII-8BIT/UTF-8 Problemshttps://www.redmine.org/issues/14009?journal_id=492262013-05-08T09:06:13ZJean-Baptiste Barth
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Needs feedback</i></li></ul><p>Can you show us a more complete stack trace ? The mentionned line is just a reference to an other view, maybe the full trace will include more informations about where the problem is so we can investigate better.</p> Redmine - Defect #14009: Issue Editing/Viewing - ASCII-8BIT/UTF-8 Problemshttps://www.redmine.org/issues/14009?journal_id=492272013-05-08T09:06:57ZRoger Griffiths
<ul></ul><p>Potentially related to <a class="issue tracker-1 status-5 priority-4 priority-default closed" title="Defect: ActionView::Template::Error (incompatible character encodings: UTF-8 and ASCII-8BIT): (Closed)" href="https://www.redmine.org/issues/13852">#13852</a>, <a class="issue tracker-1 status-5 priority-5 priority-high2 closed" title="Defect: Internal Error (incompatible character encodings: ASCII-8BIT and UTF-8) when accessing Admin/Sett... (Closed)" href="https://www.redmine.org/issues/13520">#13520</a>, <a class="issue tracker-1 status-5 priority-4 priority-default closed" title="Defect: incompatible character encodings on My account setting (Closed)" href="https://www.redmine.org/issues/13240">#13240</a>, and various other tickets.</p> Redmine - Defect #14009: Issue Editing/Viewing - ASCII-8BIT/UTF-8 Problemshttps://www.redmine.org/issues/14009?journal_id=492282013-05-08T09:08:08ZRoger Griffiths
<ul></ul><p>Problem is that I have to type the stack trace, so it gets awkward.</p> Redmine - Defect #14009: Issue Editing/Viewing - ASCII-8BIT/UTF-8 Problemshttps://www.redmine.org/issues/14009?journal_id=492292013-05-08T09:09:39ZJean-Baptiste Barth
<ul></ul><p>OK. Can you see <a class="wiki-page" href="https://www.redmine.org/projects/redmine/wiki/SubmittingBugs">SubmittingBugs</a> and give us the requested informations about your redmine instance (I'm especially interested in your "mysql" gem version, and your database encoding if you have it).</p> Redmine - Defect #14009: Issue Editing/Viewing - ASCII-8BIT/UTF-8 Problemshttps://www.redmine.org/issues/14009?journal_id=492302013-05-08T09:11:28ZRoger Griffiths
<ul></ul>Only two more levels to the stack trace:-
<ul>
<li>app/controllers/issues_controller.rb:119</li>
<li>app/controllers/issues_controller.rb:116</li>
</ul> Redmine - Defect #14009: Issue Editing/Viewing - ASCII-8BIT/UTF-8 Problemshttps://www.redmine.org/issues/14009?journal_id=492312013-05-08T09:24:51ZRoger Griffiths
<ul></ul><p>Database was created using UTF-8 as per your Wiki.</p>
<p>Gems will be as per normal for openSUSE 12.3 (updated about 1-2wks ago) or that installed by redmine-2.3.0.</p>
According to: gem list MySQL
<ul>
<li>mysql (2.9.0, 2.8.1)</li>
<li>mysql2 (0.3.11)</li>
</ul> Redmine - Defect #14009: Issue Editing/Viewing - ASCII-8BIT/UTF-8 Problemshttps://www.redmine.org/issues/14009?journal_id=492322013-05-08T09:30:16ZRoger Griffiths
<ul></ul><p>See <strong>original report above</strong> for <strong>all</strong> information explicitly mentioned in SubmittingBugs (except the complete stack trace which has been supplemented as requested).</p> Redmine - Defect #14009: Issue Editing/Viewing - ASCII-8BIT/UTF-8 Problemshttps://www.redmine.org/issues/14009?journal_id=492332013-05-08T09:55:17ZRoger Griffiths
<ul></ul>According to an SQL dump (field notes in table redmine.journals) the database encodings for the characters in question are:-
<ul>
<li>Superscript Two - \302\262</li>
<li>Greek Small Letter Lambda - \316\273</li>
<li>Greek Small Letter Pi - \317\200</li>
<li>Greek Small Letter Sigma - \317\203</li>
</ul> Redmine - Defect #14009: Issue Editing/Viewing - ASCII-8BIT/UTF-8 Problemshttps://www.redmine.org/issues/14009?journal_id=492342013-05-08T10:12:40ZRoger Griffiths
<ul></ul><p>Worked around issue by replacing UTF-8 characters with pure ASCII alternatives.</p>
<p>This should NOT be an issue with a system that accepts and even promotes usage of UTF-8 characters.</p> Redmine - Defect #14009: Issue Editing/Viewing - ASCII-8BIT/UTF-8 Problemshttps://www.redmine.org/issues/14009?journal_id=492392013-05-08T10:35:52ZToshi MARUYAMA
<ul></ul><p>Check your database encoding is UTF-8.<br />See:<br /><a class="external" href="http://www.redmine.org/boards/1/topics/36573?r=36629#message-36629">http://www.redmine.org/boards/1/topics/36573?r=36629#message-36629</a></p> Redmine - Defect #14009: Issue Editing/Viewing - ASCII-8BIT/UTF-8 Problemshttps://www.redmine.org/issues/14009?journal_id=492462013-05-08T12:29:40ZSantosh Rathod
<ul><li><strong>File</strong> <i>10250113.jpg</i> added</li></ul><p>Hello,</p>
<p>Test</p> Redmine - Defect #14009: Issue Editing/Viewing - ASCII-8BIT/UTF-8 Problemshttps://www.redmine.org/issues/14009?journal_id=492492013-05-08T12:50:32ZDaniel Felix
<ul><li><strong>File</strong> deleted (<del><i>10250113.jpg</i></del>)</li></ul> Redmine - Defect #14009: Issue Editing/Viewing - ASCII-8BIT/UTF-8 Problemshttps://www.redmine.org/issues/14009?journal_id=492912013-05-09T15:13:01ZRoger Griffiths
<ul></ul><p>Database encoding is confirmed as UTF-8.</p>
<p>The encoding previously mentioned was in an ASCII encoded SQL dump file.</p>
<p>When I manually updated the database I used the raw Unicode characters in my SQL statements.</p> Redmine - Defect #14009: Issue Editing/Viewing - ASCII-8BIT/UTF-8 Problemshttps://www.redmine.org/issues/14009?journal_id=493652013-05-12T01:03:10ZToshi MARUYAMA
<ul></ul><p>Roger Griffiths wrote:</p>
<blockquote>
<p>Database encoding is confirmed as UTF-8.</p>
<p>The encoding previously mentioned was in an ASCII encoded SQL dump file.</p>
<p>When I manually updated the database I used the raw Unicode characters in my SQL statements.</p>
</blockquote>
<p>Have you resolved the problem?</p> Redmine - Defect #14009: Issue Editing/Viewing - ASCII-8BIT/UTF-8 Problemshttps://www.redmine.org/issues/14009?journal_id=494032013-05-13T10:19:25ZRoger Griffiths
<ul></ul><p>No - I have worked around it with a kludge.</p>
<p>The reported issue still needs to be resolved.</p> Redmine - Defect #14009: Issue Editing/Viewing - ASCII-8BIT/UTF-8 Problemshttps://www.redmine.org/issues/14009?journal_id=494052013-05-13T10:45:00ZToshi MARUYAMA
<ul></ul><p>Did you check "show session variables like 'char%'" and "show global variables like 'char%';"?<br /><a class="external" href="http://www.redmine.org/boards/1/topics/36573?r=36624#message-36624">http://www.redmine.org/boards/1/topics/36573?r=36624#message-36624</a></p>
<p>Why do you use MariaDB?<br />Is MariaDB compatible with MySQL client (Ruby mysql2 adapter)?</p> Redmine - Defect #14009: Issue Editing/Viewing - ASCII-8BIT/UTF-8 Problemshttps://www.redmine.org/issues/14009?journal_id=495262013-05-18T09:11:57ZRoger Griffiths
<ul></ul><p><a href="https://mariadb.org" class="external">MariaDB</a> is the default database installation for openSUSE 12.3 and is a <a href="https://kb.askmonty.org/en/mariadb-versus-mysql-compatibility/" class="external">compatible</a> <a href="https://kb.askmonty.org/en/mariadb-versus-mysql-features/" class="external">enhancement</a> of <a href="http://www.mysql.com" class="external">MySQL</a> (i.e. a drop in replacement).</p>
<p>I am a programmer myself and have double checked my installation before reporting the issue here. I hate it when users report problems without doing such checks themselves first.</p>
<p>The database is running fine and processing UTF-8 correctly, the Ruby code would appear to be at fault based on my limited investigation (<em>I do not have the time to look into it and fix it myself</em>).</p> Redmine - Defect #14009: Issue Editing/Viewing - ASCII-8BIT/UTF-8 Problemshttps://www.redmine.org/issues/14009?journal_id=497442013-05-30T07:42:21ZRoger Griffiths
<ul></ul><p>Test Case 1 : π.σ.λ.x²</p> Redmine - Defect #14009: Issue Editing/Viewing - ASCII-8BIT/UTF-8 Problemshttps://www.redmine.org/issues/14009?journal_id=497452013-05-30T07:42:55ZRoger Griffiths
<ul></ul><p>Test Case 2 : π².σ².λ²</p> Redmine - Defect #14009: Issue Editing/Viewing - ASCII-8BIT/UTF-8 Problemshttps://www.redmine.org/issues/14009?journal_id=497462013-05-30T07:44:23ZRoger Griffiths
<ul></ul><p>As the issue does not appear to occur with the main Redmine server what component/software versions are being used for THIS site.</p> Redmine - Defect #14009: Issue Editing/Viewing - ASCII-8BIT/UTF-8 Problemshttps://www.redmine.org/issues/14009?journal_id=497472013-05-30T07:45:40ZRoger Griffiths
<ul></ul><p>Test Case 3 : πσ².σλ².πλ²</p> Redmine - Defect #14009: Issue Editing/Viewing - ASCII-8BIT/UTF-8 Problemshttps://www.redmine.org/issues/14009?journal_id=514972013-09-01T21:29:04ZJan Niggemann (redmine.org team member)jan.niggemann@redmine.org
<ul></ul><p>Toshi MARUYAMA wrote:</p>
<blockquote>
<p>Is MariaDB compatible with MySQL client (Ruby mysql2 adapter)?</p>
</blockquote>
<p>MariaDB is a drop-in replacement for MySQL, it's a fork of MySQL created by its own inventor (Monty widenius) after he left Oracle. There shouldn't be any issues using MariaDB instead of MySQL, except that the gem needs to be compatible with the db-client-lib version.</p> Redmine - Defect #14009: Issue Editing/Viewing - ASCII-8BIT/UTF-8 Problemshttps://www.redmine.org/issues/14009?journal_id=541102014-01-03T23:50:09ZDomingo Galdos
<ul></ul><p>We had the same issue using the current latest stable redmine version.<br />We have a patch to fix it (below)</p>
<p>I had the same issue with Redmine, after upgrading from ruby 1.8.x to ruby 2.0.x. It turned out that indeed, an unrecognized character had been pasted in by a user (in our case it was ""), and the GUI allows this even though it causes this issue. Correcting the field in the database fixes it.</p>
<p>A more permanent fix is to follow the advice from <a class="external" href="http://stackoverflow.com/a/5233939/368503">http://stackoverflow.com/a/5233939/368503</a> and add an initializer that monkeypatches the mysql lib to automatically re-encode problematic strings so the issue never hits Rails or Redmine. I tested this in our configuration successfully. Our configuration is:</p>
<ul>
<li>ruby 2.0.0-p353 (2013-11-22) [x86_64-linux]</li>
<li>redmine 2.4.1.stable </li>
<li>passenger 4.0.30</li>
<li>bundler 1.2.4</li>
<li>rails 3.2.15</li>
<li>Database: mysqld Ver 5.0.77 for redhat-linux-gnu on x86_64 (Source distribution)</li>
</ul>
<p>Let me know if any more information is needed to vet this before moving forward or anything else I should be aware of as this is my first time contributing bugfixes back upstream to Redmine.</p> Redmine - Defect #14009: Issue Editing/Viewing - ASCII-8BIT/UTF-8 Problemshttps://www.redmine.org/issues/14009?journal_id=541112014-01-04T02:32:08ZDomingo Galdos
<ul></ul><p>Turns out switching to the mysql2 adapter (instead of the mysql adapter) by changing one line of database.yml is a much simpler and more complete fix. So disregard the solution mentioned above.</p>
<p>Nevertheless, given that the newer version combinations of Redmine/dependencies work so badly with the mysql adapter, perhaps a deprecation warning could be added? Would have saved me a bunch of time, and I'm neither the first nor last to run into this issue. Does that sound reasonable, or some other such solution to avoid anyone wasting more than a couple minutes on this issue again? Thanks!</p> Redmine - Defect #14009: Issue Editing/Viewing - ASCII-8BIT/UTF-8 Problemshttps://www.redmine.org/issues/14009?journal_id=1123792024-01-21T11:54:46ZGo MAEDA
<ul><li><strong>Status</strong> changed from <i>Needs feedback</i> to <i>Closed</i></li><li><strong>Resolution</strong> set to <i>Invalid</i></li></ul><p>According to <a href="#note-24">#note-24</a>, the error was resolved by changing the database adapter from <code>mysql</code> to <code>mysql2</code>. Closing this issue.</p>