https://progress.opensuse.org/https://progress.opensuse.org/themes/openSUSE/favicon/favicon.ico?15829177842019-09-30T11:38:06ZopenSUSE Project Management ToolopenSUSE admin - tickets #57530: Redmine cannot handle UTF8 characters in the lastnamehttps://progress.opensuse.org/issues/57530?journal_id=2470282019-09-30T11:38:06Zokurzokurz@suse.com
<ul><li><strong>Private</strong> changed from <i>Yes</i> to <i>No</i></li></ul> openSUSE admin - tickets #57530: Redmine cannot handle UTF8 characters in the lastnamehttps://progress.opensuse.org/issues/57530?journal_id=2470312019-09-30T11:38:28Zokurzokurz@suse.com
<ul></ul><p>Looks like a codeset or encoding problem.</p>
<p>The general mysql encoding settings should be fine:</p>
<pre><code>mysql> show variables like 'char%';
+--------------------------+------------------------------+
| Variable_name | Value |
+--------------------------+------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8mb4 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mariadb/charsets/ |
+--------------------------+------------------------------+
8 rows in set (0.01 sec)
</code></pre>
<p>however the one from the progress database might be the problem:</p>
<pre><code>mysql> show variables like 'char%';
+--------------------------+------------------------------+
| Variable_name | Value |
+--------------------------+------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8mb4 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mariadb/charsets/ |
+--------------------------+------------------------------+
8 rows in set (0.01 sec)
</code></pre>
<p>so <code>character_set_database</code> is <em>not</em> set to utf8mb4. <a href="https://stackoverflow.com/a/34854453">https://stackoverflow.com/a/34854453</a> might be the answer or <a href="https://www.redmine.org/issues/10772#note-7">https://www.redmine.org/issues/10772#note-7</a> . Potentially also the database is too old itself? See <a href="https://www.redmine.org/issues/21398#note-12">https://www.redmine.org/issues/21398#note-12</a></p>
<p>so what are the opinions of the other heroes?</p>
openSUSE admin - tickets #57530: Redmine cannot handle UTF8 characters in the lastnamehttps://progress.opensuse.org/issues/57530?journal_id=2590032019-11-21T10:44:07Zdancermakdcermak@suse.com
<ul></ul><p>Any updates on this?</p>
openSUSE admin - tickets #57530: Redmine cannot handle UTF8 characters in the lastnamehttps://progress.opensuse.org/issues/57530?journal_id=2618662019-12-04T18:13:12Zlrupp
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Workable</i></li><li><strong>Assignee</strong> set to <i>tuanpembual</i></li></ul><p>I think we should check, if the new system has this problem as well...</p>
<p>Assigning to our current Redmine hero!</p>
openSUSE admin - tickets #57530: Redmine cannot handle UTF8 characters in the lastnamehttps://progress.opensuse.org/issues/57530?journal_id=2618902019-12-05T04:05:51Ztuanpembualandro.medh4@gmail.com
<ul></ul><p>Thank you. I will try reproduce this scenario.</p>
openSUSE admin - tickets #57530: Redmine cannot handle UTF8 characters in the lastnamehttps://progress.opensuse.org/issues/57530?journal_id=2618932019-12-05T04:41:40Ztuanpembualandro.medh4@gmail.com
<ul></ul><p>Hi,</p>
<p>I have checked on new progress (redmine 3.4.12.stable).<br>
This issue still happen. I try to change my last name in my account to use "Čermák" and Redmine show 500 error code.</p>
<p>I do some alter sql query.</p>
<pre><code>ALTER DATABASE redmine_default CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE users CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
</code></pre>
<p>add set encode on database.yml.<br>
production:<br>
encoding: utf8mb4</p>
<p>Restart redmine.<br>
And it is working now.</p>
<p>Estu~</p>
openSUSE admin - tickets #57530: Redmine cannot handle UTF8 characters in the lastnamehttps://progress.opensuse.org/issues/57530?journal_id=2620612019-12-05T08:54:38Zdancermakdcermak@suse.com
<ul></ul><p>Unfortunately it is still broken for me. I just changed my last name to<br>
'Čermák' and now I cannot login to progress anymore. Changing the name<br>
back to 'Cermak' doesn't solve the issue.</p>
openSUSE admin - tickets #57530: Redmine cannot handle UTF8 characters in the lastnamehttps://progress.opensuse.org/issues/57530?journal_id=2621602019-12-05T09:45:54Ztuanpembualandro.medh4@gmail.com
<ul></ul><p>Hi Dancermak,</p>
<p>Sorry, we have missing understanding.<br>
New progress redmine not yet on production use, still using dummy url. and I only fixed on new progress. So you still get error 500.</p>
<p>About new progress redmine, I hope it can release as soon as possible.</p>
openSUSE admin - tickets #57530: Redmine cannot handle UTF8 characters in the lastnamehttps://progress.opensuse.org/issues/57530?journal_id=2621872019-12-05T10:03:58Zdancermakdcermak@suse.com
<ul></ul><p><a href="mailto:admin@opensuse.org">admin@opensuse.org</a> writes:</p>
<blockquote>
<p>[openSUSE Tracker]<br>
Issue <a class="issue tracker-10 status-3 priority-4 priority-default closed" title="tickets: Redmine cannot handle UTF8 characters in the lastname (Resolved)" href="https://progress.opensuse.org/issues/57530">#57530</a> has been updated by tuanpembual.</p>
<p>Hi Dancermak,</p>
<p>Sorry, we have missing understanding.<br>
New progress redmine not yet on production use, still using dummy url. and I only fixed on new progress. So you still get error 500.</p>
</blockquote>
<p>No need to apologize, I should have read your message properly ;-).</p>
<blockquote>
<p>About new progress redmine, I hope it can release as soon as possible.</p>
</blockquote>
<p>Looking forward to that! But no need to hurry, this is really just a<br>
minor inconvenience for me.</p>
openSUSE admin - tickets #57530: Redmine cannot handle UTF8 characters in the lastnamehttps://progress.opensuse.org/issues/57530?journal_id=2703892020-01-12T19:02:58Zlrupp
<ul><li><strong>% Done</strong> changed from <i>0</i> to <i>10</i></li></ul><p>JFYI: I upgraded/converted the database already. As utf8 is a subset of utf8mb4, this should not harm. But the changes in Redmine's productive config need a newer Ruby mysql client - otherwise the server fails with: "Character set 'utf8mb4' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file".</p>
<p>So: the sooner we migrate to the new Redmine instance, the better :-)</p>
openSUSE admin - tickets #57530: Redmine cannot handle UTF8 characters in the lastnamehttps://progress.opensuse.org/issues/57530?journal_id=2934322020-04-16T19:02:11Ztuanpembualandro.medh4@gmail.com
<ul></ul><p>Hi,</p>
<p>We done migrate to new redmine. Can you re-check this issue again?<br>
Thank you</p>
openSUSE admin - tickets #57530: Redmine cannot handle UTF8 characters in the lastnamehttps://progress.opensuse.org/issues/57530?journal_id=2935882020-04-17T08:06:08Zdancermakdcermak@suse.com
<ul></ul><p>tuanpembual wrote:</p>
<blockquote>
<p>Hi,</p>
<p>We done migrate to new redmine. Can you re-check this issue again?<br>
Thank you</p>
</blockquote>
<p>It appears to be working correctly, thank you!</p>
openSUSE admin - tickets #57530: Redmine cannot handle UTF8 characters in the lastnamehttps://progress.opensuse.org/issues/57530?journal_id=2940982020-04-20T06:19:57Ztuanpembualandro.medh4@gmail.com
<ul><li><strong>Status</strong> changed from <i>Workable</i> to <i>Resolved</i></li></ul>