Forum GLPI-Project

k-nike

Member

Registered: 2012-05-23

Posts: 10

Reciever can't get mail with title "..."

Freebsd 9.0, GLPI 0.83.1, MySQL-Server-5.5.20, PHP5-5.3.9

If email subject is null and body begins with:
Доброе утро!
Не могу открыть 1С: Предприятие

С уважением,
Заместитель главного бухгалтера
ОАО «ГСК «

GLPI Reciver can't get mail.

At the same time in sql-errors.log:
23-05-2012 14:14
*** MySQL query error :
***
SQL: INSERT
                   INTO `glpi_tickets` (`content`,`name`,`urgency`,`itemtype`,`requesttypes_id`,`entities_id`,`impact`,`priority`,`users_id_lastupdater`,`users_id_recipient`,`status`,`date`,`suppliers_id_assign`,`itilcategories_id`,`global_validation`,`items_id`,`slas_id`,`slalevels_id`,`due_date`,`sla_waiting_duration`,`type`,`date_mod`) VALUES (\'Доброе утро! \\nНе могу открыть 1С: Предприятие \\n \\n \\n С уважением, \\n Заместитель главного бухгалтера \\n ОАО «ГСК «\',\'Доброе утро! \\nНе могу открыть 1С: Предприятие \\n \\n \\n С уважением, \\\',\'3\',\'\',\'2\',\'76\',\'3\',\'3\',\'3941\',\'3941\',\'assign\',\'2012-05-23 14:14:10\',0,\'35\',\'none\',0,\'6\',\'7\',\'2012-05-25 14:14:10\',0,\'1\',\'2012-05-23 14:14:10\')
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '3','','2','76','3','3','3941','3941','assign','2012-05-23 14:14:10',0,'35','none' at line 2

And now, i have send email with subject:
Доброе утро! Не могу открыть 1С: Предприятие \

GLPI Reciver get mail, but message queue repeated in the tickets:

k-nike

Member

Registered: 2012-05-23

Posts: 10

Re: Reciever can't get mail with title "..."

May be error in triple "\" in the end email subject?

MoYo

GLPI - Lead

From: Poitiers

Registered: 2004-09-13

Posts: 14,513

Website

Re: Reciever can't get mail with title "..."

Yes a ticket is open on that problem : https://forge.indepnet.net/issues/3593

---

MoYo - Julien Dombre - Association INDEPNET
Contribute to GLPI :    Support     Contribute     References     Freshmeat