https://www.redmine.org/https://www.redmine.org/favicon.ico?16793021292021-01-08T07:38:25ZRedmineRedmine - Defect #34574: Email Fetcher catch no Mails with smileyhttps://www.redmine.org/issues/34574?journal_id=1004802021-01-08T07:38:25ZC S
<ul></ul><p>Also does not work if an email (with ticket header) sent by the system is replied to</p> Redmine - Defect #34574: Email Fetcher catch no Mails with smileyhttps://www.redmine.org/issues/34574?journal_id=1007432021-01-30T10:35:31ZMichael K.
<ul></ul><p>We have similar problem with our Redmine, but I cannot confirm that it's the emoticon issue.<br />Sometimes once in a multiple emails, the message is marked as READ in inbox (Gmail IMAP) but is not updated in the Redmine.</p>
<p>What I've managed to find:</p>
<p>1. The problem is not present when creating new issue (ie. emails not connected to existing tickets are always read correctly into the system)</p>
<p>2. When someone "bumps" their email <strong>in existing issue</strong> bumped email is not read into the system (ie. sends an email to help@ inbox, issue is created, I answer in redmine, he/she gets notification and then answers this email notification once to update an issue, and then forwards own answer again to help@, then first mail is read correctly and second stays in the inbox - marked as READ but not put into redmine)</p>
<p>3. Yesterday we got an issue no <a class="issue tracker-2 status-1 priority-4 priority-default" title="Feature: Allow Slashes in wiki URLs (New)" href="https://www.redmine.org/issues/1213">#1213</a>, my collegaue answered notfication about new issue creation, his message hasn't been put into Redmine, just marked as READ in gmail inbox - production.log stays silent about that, just some lines regarding "missing scope, creating scope :system" etc)</p>
<p>I conducted various test - I told him to answer again removing all other content of email, email signature, etc.<br />I moved issue to another project, I've even elevated his rights to Project Manager (who has all the privelages) - didn't help<br />I changed rake command in crontab (allow ovveride, no persmission check etc) didn't help<br />I tried to answer to issue myslef, forawrding his email - didn't help</p>
<p>It worked after I added myself as issue observer, answered issue in Redmine directly, and then went to my inbox and answered notification about that issue change</p>
<p>It's very weird because the problem happens to maybe 5% of mails (maybe even less) but sometimes it's a pain in the ***, especially when I cannot tell some people (from sales department) to "log in to redmine and answer there"...</p>
<pre>
Environment:
Redmine version 4.0.6.stable
Ruby version 2.7.0-p0 (2019-12-25) [x86_64-linux-gnu]
Rails version 5.2.3
Environment production
Database adapter Mysql2
Mailer queue ActiveJob::QueueAdapters::AsyncAdapter
Mailer delivery smtp
SCM:
Git 2.25.1
Filesystem
Redmine plugins:
reopen_issues_by_mail 0.1.0
</pre> Redmine - Defect #34574: Email Fetcher catch no Mails with smileyhttps://www.redmine.org/issues/34574?journal_id=1010682021-02-24T13:28:53ZC S
<ul></ul><p>I made another Test:</p>
3 Mails send from Outlook 365 to redmine:
<ol>
<li>First Mail - Standard with no smiley</li>
<li>Second Mail - Standard With a smiley between text</li>
<li>Third Mail - Standard with no smiley</li>
</ol>
Redmine Email rake task
<ol>
<li>Fist Mail - catch, Notfication Mail send, but not deleted!, marked in Mailbox as unread</li>
<li>Second Mail, no catch, no notification, no visible error msg, marked in Mailbox as read</li>
<li>Third Mail, no catch, no notification, no visible error msg, marked in Mailbox as unread.</li>
</ol>
<p>After i delete the second mail, the catcher works again...</p>
<pre>
Environment:
Redmine version 4.1.1.stable
Ruby version 2.4.10-p364 (2020-03-31) [x86_64-linux-gnu]
Rails version 5.2.4.2
Environment production
Database adapter Mysql2
Mailer queue ActiveJob::QueueAdapters::AsyncAdapter
Mailer delivery smtp
SCM:
Subversion 1.9.3
Mercurial 3.7.3
Cvs 1.12.13
Bazaar 2.7.0
Git 2.28.0
Filesystem
Redmine plugins:
additionals 3.0.2-master
mobile_issue_table 0.0.1
redmine_checklists 3.1.18
redmine_ckeditor 1.2.3
redmine_contacts 4.3.2
redmine_dmsf 2.4.5
redmine_issue_dynamic_edit 0.7.2
redmine_issue_todo_lists 1.3
redmine_issue_view_columns 1.0.1
redmine_lightbox2 0.5.1
redmine_logs 0.2.0
redmine_questions 1.0.2
redmine_wktime 4.1.1
redmine_xapian 2.0.3
</pre> Redmine - Defect #34574: Email Fetcher catch no Mails with smileyhttps://www.redmine.org/issues/34574?journal_id=1011392021-02-28T16:53:04ZMarius BĂLTEANU
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Closed</i></li><li><strong>Resolution</strong> set to <i>Duplicate</i></li></ul><p>The smiley issue is generated by your database configuration, most probably you are using MySQL with a column encoding such as utf8 which can not store 4-Byte unicode characters (such as most emojis or special characters) If that is the case, see <a class="issue tracker-1 status-5 priority-4 priority-default closed" title="Defect: 4-byte utf-8 characters (Closed)" href="https://www.redmine.org/issues/10772">#10772</a>.</p>
<p>In Redmine 4.1 we fixed this problem for new fresh installations (<a class="issue tracker-2 status-5 priority-4 priority-default closed" title="Feature: Changes to properly support 4 byte characters (emoji) when database is MySQL (Closed)" href="https://www.redmine.org/issues/31921">#31921</a>), but for existing installations, before making that change, you need to migrate your database. In the mentioned tickets, you can find various links to articles that describe the process. Please be aware that it's a sensitive process and I highly recommend to backup your data before proceeding.</p>
<p>Please reopen if I'm wrong.</p> Redmine - Defect #34574: Email Fetcher catch no Mails with smileyhttps://www.redmine.org/issues/34574?journal_id=1011402021-02-28T16:54:24ZMarius BĂLTEANU
<ul></ul><p>Michael, for your problem, can you open a new tichet? it seems to be another issue on your case.</p> Redmine - Defect #34574: Email Fetcher catch no Mails with smileyhttps://www.redmine.org/issues/34574?journal_id=1011412021-02-28T16:55:33ZMarius BĂLTEANU
<ul><li><strong>Is duplicate of</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> Redmine - Defect #34574: Email Fetcher catch no Mails with smileyhttps://www.redmine.org/issues/34574?journal_id=1011872021-03-03T08:37:56ZC S
<ul></ul><p>Great...i found my mistake.<br />Database was set to <code>utf8mb4_unicode_ci</code> but the config not ;)<br />Thank you very much for your support!</p>