Forum GLPI-Project

Baud21

Member

Registered: 2015-05-12

Posts: 12

Erreur SQL lors de l'exécution de cron

Version: 9.4.1.1 (fresh install)
Context: debian 8, php7-fpm

Erreur lors de l'exécution manuelle de /front/cron.php

Message d'erreur:
Externe #3 : Démarrage SyncIssues
DBmysql::query() in /var/www/html/glpi/inc/dbmysql.class.php line 177
  *** MySQL query error:
  SQL: SELECT COUNT(*) AS `cpt` FROM (SELECT DISTINCT
                  NULL                           AS `id`,
                  CONCAT('f_',`fanswer`.`id`)    AS `display_id`,
                  `fanswer`.`id`                 AS `original_id`,
                  'PluginFormcreatorFormAnswer'  AS `sub_itemtype`,
                  `f`.`name`                     AS `name`,
                  `fanswer`.`status`             AS `status`,
                  `fanswer`.`request_date`       AS `date_creation`,
                  `fanswer`.`request_date`       AS `date_mod`,
                  `fanswer`.`entities_id`        AS `entities_id`,
                  `fanswer`.`is_recursive`       AS `is_recursive`,
                  `fanswer`.`requester_id`       AS `requester_id`,
                  `fanswer`.`users_id_validator` AS `validator_id`,
                  `fanswer`.`comment`            AS `comment`
               FROM `glpi_plugin_formcreator_formanswers` AS `fanswer`
               LEFT JOIN `glpi_plugin_formcreator_forms` AS `f`
                  ON`f`.`id` = `fanswer`.`plugin_formcreator_forms_id`
               LEFT JOIN `glpi_items_tickets` AS `itic`
                  ON `itic`.`items_id` = `fanswer`.`id`
                  AND `itic`.`itemtype` = 'PluginFormcreatorFormAnswer'
               WHERE `fanswer`.`is_deleted` = '0'
               GROUP BY `original_id`
               HAVING COUNT(`itic`.`tickets_id`) != 1

               UNION

               SELECT DISTINCT
                  NULL                          AS `id`,
                  CONCAT('t_',`tic`.`id`)       AS `display_id`,
                  `tic`.`id`                    AS `original_id`,
                  'Ticket'                      AS `sub_itemtype`,
                  `tic`.`name`                  AS `name`,
                  `tic`.`status`                AS `status`,
                  `tic`.`date`                  AS `date_creation`,
                  `tic`.`date_mod`              AS `date_mod`,
                  `tic`.`entities_id`           AS `entities_id`,
                  0                             AS `is_recursive`,
                  `tic`.`users_id_recipient`    AS `requester_id`,
                  0                             AS `validator_id`,
                  `tic`.`content`               AS `comment`
               FROM `glpi_tickets` AS `tic`
               LEFT JOIN `glpi_items_tickets` AS `itic`
                  ON `itic`.`tickets_id` = `tic`.`id`
                  AND `itic`.`itemtype` = 'PluginFormcreatorFormAnswer'
               WHERE `tic`.`is_deleted` = 0
               GROUP BY `original_id`
               HAVING COUNT(`itic`.`items_id`) <= 1) AS `issues`
  Error: Unknown column 'fanswer.is_deleted' in 'where clause'
  Backtrace :
  plugins/formcreator/inc/issue.class.php:125
  inc/crontask.class.php:829                         PluginFormcreatorIssue::cronSyncIssues()
  front/cron.php:88                                  CronTask::launch()

Cependant, je n'ai pas trouvé de conséquence à cette erreur.

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: Erreur SQL lors de l'exécution de cron

Exécution manuelle, c'est-à-dire ? lancement manuelle dans l'interface ? lancement en ligne de commande ?
Pouvez-vous fournir le log complet dans files/_logs/php-error.log ?

---

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)

Baud21

Member

Registered: 2015-05-12

Posts: 12

Re: Erreur SQL lors de l'exécution de cron

Exécution manuelle depuis l'invite shell.

php /var/www/html/glpi/front/cron.php --force SyncIssues

Par contre l'erreur SQL semble provenir d'un plugin et pas de GLPI même.

Mon fichier php-errors.log est un peu gros (136 ko) pour être posté dans un forum. Le voici : https://pastebin.com/qLdz8hvV