search

jbostoen / iTop-custom-extensions

Extensions for iTop . New classes (SIM cards, Monitors, IP Devices), more powerful Mail to Ticket automation, basic info on pro extensions such as geometry and ticket merge, some concepts (Check Out system), several small tweaks.
GNU General Public License v3.0
36 stars 13 forks source link

Ticket from eMail: bug in mail handling #19

Closed jbostoen closed 6 years ago

jbostoen commented 7 years ago

Current master contains a bug when handling very specific emails. Investigating.

Probably also present in the original Combodo Ticket from eMail extension.

jbostoen commented 7 years ago

Turns out to be an unicode issue. MySQL database and tables were not utf8mb4_unicode_ci (they were utf8_unicode_ci).

Also config-itop.php needs these lines:

$MySettings = array(
...
    'db_character_set' => 'utf8mb4',
    'db_collation' => 'utf8mb4_unicode_ci',
...
);

It looks as if this is a more general iTop problem after some investigation. utf8_unicode_ci is hardcoded and ignores above settings in a few files.

Ticket logged: https://sourceforge.net/p/itop/tickets/1489/

jbostoen commented 6 years ago

Combodo has now released 3.0.7 of their ticket-from-email extension, which is a significant update. Will implement it.