You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2018-03-08 16:29:40

webbo
Member
Registered: 2013-11-15
Posts: 8

GLPI Receiver SQL Error

I am getting an error when trying to import mail using a receiver.

018-03-08 14:25:49 [11@xxx]
  *** MySQL query error:
  SQL: INSERT
                   INTO `glpi_tickets` (`date`,`content`,`name`,`urgency`,`requesttypes_id`,`entities_id`,`status`,`impact`,`priority`,`users_id_lastupdater`,`users_id_recipient`,`itilcategories_id`,`global_validation`,`type`,`date_creation`,`date_mod`) VALUES ('2018-03-08 14:25:18','won'tfix\','test','3','2','3','1','3','3','11','11','0','1','1','2018-03-08 14:25:48','2018-03-08 14:25:48')
  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 'tfix\n\n-- \n\' at line 2
  Backtrace :
  inc/commondbtm.class.php:504                       
  inc/commondbtm.class.php:928                       CommonDBTM->addToDB()
  inc/mailcollector.class.php:596                    CommonDBTM->add()
  front/mailcollector.form.php:81                    MailCollector->collect()

It seems to be caused by the use of ' in the email text. I have reproduced it with three separate emails. GLPI version 9.2.1 and 9.2.2 are affected.

Many thanks.

Offline

#2 2018-03-09 10:40:38

webbo
Member
Registered: 2013-11-15
Posts: 8

Re: GLPI Receiver SQL Error

It seems enabling 'Use rich text for helpdesk' fixes this issue.

Offline

Board footer

Powered by FluxBB