Forum GLPI-Project

houstek

Member

Registered: 2017-02-11

Posts: 5

Migration GLPI 9.1.2

Bonjour a la commu GLPI
suite a un changement d'hyperviseur, je dois réinstaller mon glpi sur une autre machine. Le backup et la restau fonctionne tres bien, je retrouve bien mes petits
Par contre en consultant les logs SQL, je me rends compte que j'ai plein d'erreur du genre :

  *** MySQL query error:
  SQL: INSERT INTO `glpi_notificationtemplatetranslations` VALUES (\'2\',\'2\',\'\',\'##reservation.action##\',\'======================================================================
##lang.reservation.user##: ##reservation.user##
##lang.reservation.item.name##: ##reservation.itemtype## - ##reservation.item.name##
##IFreservation.tech## ##lang.reservation.tech## ##reservation.tech## ##ENDIFreservation.tech##
##lang.reservation.begin##: ##reservation.begin##
##lang.reservation.end##: ##reservation.end##
##lang.reservation.comment##: ##reservation.comment##
======================================================================
\',\'<!-- description{ color: inherit; background: #ebebeb;border-style: solid;border-color: #8d8d8d; border-width: 0px 1px 1px 0px; } -->

  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 ''<!-- description{ color: inherit; background: #ebebeb;border-style: solid;bo' at line 1
  Backtrace :
  front/backup.php:280                               
  front/backup.php:559                               restoreMySqlDump()
2018-12-16 12:40:36 [2@glpi]
  *** MySQL query error:
  SQL: INSERT INTO `glpi_notificationtemplatetranslations` VALUES (\'3\',\'3\',\'\',\'##reservation.action##  ##reservation.entity##\',\'##lang.reservation.entity## : ##reservation.entity##


##FOREACHreservations##
##lang.reservation.itemtype## : ##reservation.itemtype##

 ##lang.reservation.item## : ##reservation.item##

 ##reservation.url##

 ##ENDFOREACHreservations##\',\'<p>##lang.reservation.entity## : ##reservation.entity## <br /> <br />

  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 ''<p>##lang.reservation.entity## : ##reservation.entity## <br /> <' at line 1
  Backtrace :
  front/backup.php:280                               
  front/backup.php:559                               restoreMySqlDump()
2018-12-16 12:40:36 [2@glpi]
  *** MySQL query error:
  SQL: INSERT INTO `glpi_notificationtemplatetranslations` VALUES (\'3\',\'3\',\'\',\'##reservation.action##  ##reservation.entity##\',\'##lang.reservation.entity## : ##reservation.entity##

Dois je m'inquieter ?

eric.le-corre

Member

Registered: 2013-01-07

Posts: 1,005

Re: Migration GLPI 9.1.2

on dirait des erreurs lié aux notifications

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,273

Re: Migration GLPI 9.1.2

Oui c'est un modèle de notification donc le corps n'est ni en balises GLPI, ni en HTML

---

CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)