UTF8 encode error when receiving emails

[bestkiller92]

Hi, not sure of what this is, but i have an issue with incoming emails. the subjects seems to be the only field affected, it tried to find the root cause but i couldn't:

"Test d'intégration #5" becomes " =?UTF-8?Q?Testint=C3=A9gration=233?= #5"

Could you please help me ? This might be related to the email directly : i've seen in the header that the issue is already there, but if this is a new way of sending mails .... the app needs to be updated to right ?

[bestkiller92]

I added this function at the beginning of the "cron/checkmail2.php" file :

function utf8_decode_email_subject($str)
{
    $wordStart = '=\?UTF-8\?Q\?';
    $wordEnd = '\?='; 
    $output = "";

    $output = preg_replace('#' . $wordStart . '#', '', $str);//Remove start of UTF8 encoding
    $output = preg_replace('#' . $wordEnd . '#', '', $output);//Remove end of tUTF8 encoding
    $output = quoted_printable_decode($output);//decode special chars
    $output = preg_replace('#_#', ' ', $output);//replace spacing

    return $output;
}

Then I declared the variable $subject a bit earlier in the code and replaced occurences of "$header->subject" by "$subject": L144 >> $subject = utf8_decode_email_subject($header->subject); //early declaration L150 >> $log->write(sprintf('No matching user, using default - From: %s; Subject: %s', $from, $subject)); L152 >> $log->write(sprintf('Skipping message, no matching user - From: %s; Subject: %s', $from, $subject)); L177 >> $subject = trim(preg_replace("/^((Re|Fwd?):\s)*/i", "", $subject));//previous declaration L178 >> $issue->load(array('name=? AND deleted_date IS NULL AND closed_date IS NULL', $subject)); L192 >> 'name' => $subject,

This should do the trick... I'm currently testing on my server but the cron is only once an hour... I will let you know if it works fine

[bestkiller92]

It's working ;)

[bestkiller92]

Dude, I have to say that i'm having so much fun right now ! I've added a new function with this fix allowing groups to define a "group mailbox", incoming mails to that address will generate issue assigned to the group and not to the user... Testing... code is coming

[bestkiller92]

Ok it's working :p But code is difficult to explain without a new fork... so ....

You basicaly have to reproduce the function used to set a manager in a group. add a "mailbox" field in the related view. Then update the check-mail script to take that information into account.

{ //No matching issue, creating a new issue //if user is mailbox of the group, the issue is assigned to the group. $is_group_mailbox = new \Model\Custom("user_group_user"); $is_group_mailbox->load(array("user_id = ? AND deleted_date IS NULL", $owner)); if($is_group_mailbox->mailbox){ $owner = $is_group_mailbox->group_id; } }

Resulting functionnality is quite interesting.

[bestkiller92]

updated the following files: cron\checkmail2.php db\database.sql app\dict\en.ini app\routes.ini app\controller\admin.php app\view\admin\groups\edit.html

[bestkiller92]

see #407