Hi list,
I have GLPI 9.1 installed and a strange SQL error.
Extract from sql-errors.log:
2016-11-08 14:51:02 [@glpi]
*** MySQL query error:
SQL: INSERT
INTO `glpi_ticketfollowups`
(`content`,`tickets_id`,`users_id`,`requesttypes_id`,`is_private`,`date`,`date_creation`,`date_mod`)
VALUES (\'Bonsoir,\\nJe vous réponds pour vous donner la réponse à ma question secrète :
xxxxx,\\nSi je me suis trompé, pourriez vous quand même envoyer l\'identifiant sur la boite
laposte.net ? \\nVous remerciant d\'avance,\\nCordialement,\\nA. François\\n\\nLe 4 novembre 2016 Ã
22:22, <helpd...@univ-poitiers.fr> a écrit :\\n\\n
\\n\\n\',\'2602\',\'0\',\'0\',0,\'2016-11-08 14:51:02\',\'2016-11-08 14:51:02\',\'2016-11-08 14:51:02\')
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 'identifiant sur la boite laposte.net ? \nVous
remerciant d'avance,\nCordialement' at line 2
Backtrace :
inc/commondbtm.class.php:427
inc/commondbtm.class.php:838 CommonDBTM->addToDB()
inc/mailcollector.class.php:554 CommonDBTM->add()
inc/mailcollector.class.php:1614 MailCollector->collect()
: MailCollector::cronMailgate()
inc/crontask.class.php:803 call_user_func()
front/cron.php:88 CronTask::launch()
The error is the value of the is_private field is not quoted.
GLPI has been updated on Octobre #31, this error dates from November #4. I have restarted Apache and
finally the server itself : the error comes back again and again. I don't find a location where this
query could be stored.
What should be done in order to clear this error ?
Sincerely,
Valéry
_______________________________________________
Glpi-user mailing list
Glpi-user@gna.org
https://mail.gna.org/listinfo/glpi-user
