https://www.redmine.org/https://www.redmine.org/favicon.ico?16793021292017-05-17T11:19:19ZRedmineRedmine - Defect #25959: "Smile of the death" problemhttps://www.redmine.org/issues/25959?journal_id=785902017-05-17T11:19:19ZMaxim Krušina
<ul><li><strong>Affected version</strong> changed from <i>3.2.5</i> to <i>3.3.1</i></li></ul><p>Hmm, THIS instance will not crash, but there is no smile. Our instance will crash.</p>
<p>Whole string including smile is here:<br /><a class="external" href="https://docs.google.com/document/d/1lxVicYv_DMSgJmqGOeClgY1pbdfXqh_Nf6jiIZoOpug/edit">https://docs.google.com/document/d/1lxVicYv_DMSgJmqGOeClgY1pbdfXqh_Nf6jiIZoOpug/edit</a></p> Redmine - Defect #25959: "Smile of the death" problemhttps://www.redmine.org/issues/25959?journal_id=786402017-05-17T12:33:36ZToshi MARUYAMA
<ul><li><strong>File</strong> <a href="/attachments/18334">1.png</a> <a class="icon-only icon-download" title="Download" href="/attachments/download/18334/1.png">1.png</a> added</li><li><strong>Status</strong> changed from <i>New</i> to <i>Closed</i></li><li><strong>Resolution</strong> set to <i>Cant reproduce</i></li></ul><p><img src="https://www.redmine.org/attachments/download/18334/1.png" alt="" /></p> Redmine - Defect #25959: "Smile of the death" problemhttps://www.redmine.org/issues/25959?journal_id=786562017-05-17T15:54:01ZVasili Korol
<ul></ul><p>I can reproduce the problem. "Internal server error" appears after attempting to create a ticket with the following string in the title and description (copied together with the smiley from the google document in <a href="http://www.redmine.org/issues/25959#note-1" class="external">comment 1</a>:</p>
<blockquote>
<p>A druhá věc, možná bych ten pruh dole, světle modrou, vyměnil za naší tmavě modrou</p>
</blockquote>
<p>My version of Redmine:<br /><pre>
Environment:
Redmine version 3.2.4.stable
Ruby version 2.0.0-p384 (2014-01-12) [x86_64-linux-gnu]
Rails version 4.2.7.1
Environment production
Database adapter Mysql2
SCM:
Subversion 1.8.8
Git 1.9.1
Filesystem
Redmine plugins:
advanced_roadmap_v2 2.4.2
</pre></p> Redmine - Defect #25959: "Smile of the death" problemhttps://www.redmine.org/issues/25959?journal_id=786572017-05-17T16:01:09ZMarius BĂLTEANU
<ul></ul><p>The are multiple issue reported on the same subject, please see <a class="issue tracker-1 status-5 priority-4 priority-default closed" title="Defect: Mysql: 500 server error when submitting 4 bytes utf8 (to be saved in the 'notes' field) (Closed)" href="https://www.redmine.org/issues/21398">#21398</a>, <a class="issue tracker-1 status-5 priority-4 priority-default closed" title="Defect: MySQL: disappear after 4-Byte UTF-8 (Closed)" href="https://www.redmine.org/issues/18866">#18866</a> and <a class="issue tracker-3 status-5 priority-4 priority-default closed" title="Patch: RedmineInstall: MySQL: collation_database (Closed)" href="https://www.redmine.org/issues/19742">#19742</a>.</p>
<p>We had the same issue and we fixed it by migrating our Mysql database to utf8mb4. I think that the installation doc from <a class="wiki-page" href="https://www.redmine.org/projects/redmine/wiki/RedmineInstall#Installation-procedure">RedmineInstall</a> could be improved and include this change.</p> Redmine - Defect #25959: "Smile of the death" problemhttps://www.redmine.org/issues/25959?journal_id=786582017-05-17T16:01:59ZVasili Korol
<ul></ul><p>Update: the smiley in my previous comment was first visible, but now it disappeared.</p> Redmine - Defect #25959: "Smile of the death" problemhttps://www.redmine.org/issues/25959?journal_id=786592017-05-17T16:09:08ZToshi MARUYAMA
<ul><li><strong>File</strong> <a href="/attachments/18341">python.png</a> <a class="icon-only icon-download" title="Download" href="/attachments/download/18341/python.png">python.png</a> added</li><li><strong>Resolution</strong> changed from <i>Cant reproduce</i> to <i>Invalid</i></li></ul><p>This is FAQ.</p>
<p><img src="https://www.redmine.org/attachments/download/18341/python.png" alt="" /></p> Redmine - Defect #25959: "Smile of the death" problemhttps://www.redmine.org/issues/25959?journal_id=786602017-05-17T16:11:28ZToshi MARUYAMA
<ul><li><strong>Category</strong> deleted (<del><i>Issues</i></del>)</li></ul> Redmine - Defect #25959: "Smile of the death" problemhttps://www.redmine.org/issues/25959?journal_id=931682019-08-17T16:13:10ZMarius BĂLTEANU
<ul><li><strong>Related to</strong> <i><a class="issue tracker-2 status-5 priority-4 priority-default closed" href="/issues/31921">Feature #31921</a>: Changes to properly support 4 byte characters (emoji) when database is MySQL</i> added</li></ul>