Forum GLPI-Project

nbriche

Member

From: Picardie

Registered: 2011-05-23

Posts: 55

Behavior: SQL Error bloque le cron ticketrecurrent

Bonjour,

Je tombe sur un problème similaire à ici: SQL syntaxe error sur GLPI v9.4.2

J'ai appliqué la r290 mais le problème persiste; sauf que ce n'est plus depuis PluginBehaviorsTicket::getLastLinkedUserByType() mais depuis PluginBehaviorsTicket::addForGroup() (ou plus probablement getLastLinkedGroupByType()?), et comme ça concerne le cron des tickets récurrents, je n'ai plus de tickets récurrents générés.

DBmysql::query() in /var/www/html/glpi/inc/dbmysql.class.php line 188
  *** MySQL query error:
  SQL: SELECT DISTINCT `glpi_users`.`id` AS `users_id`, `glpi_users`.`language` AS `language` FROM `glpi_groups_users` INNER JOIN `glpi_users` ON (`glpi_groups_users`.`users_id` = `glpi_users`.`id`) INNER JOIN `glpi_profiles_users` ON (`glpi_profiles_users`.`users_id` = `glpi_users`.`id` glpi_profiles_users.entities_id 1) INNER JOIN `glpi_groups` ON (`glpi_groups_users`.`groups_id` = `glpi_groups`.`id`) WHERE `glpi_groups_users`.`groups_id` = '143' AND `glpi_groups`.`is_notify` = '1'
  Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'glpi_profiles_users.entities_id 1) INNER JOIN `glpi_groups` ON (`glpi_groups_use' at line 1
  Backtrace :
  inc/dbmysqliterator.class.php:95                   
  inc/dbmysql.class.php:580                          DBmysqlIterator->execute()
  plugins/behaviors/inc/ticket.class.php:731         DBmysql->request()
  plugins/behaviors/inc/ticket.class.php:226         PluginBehaviorsTicket::addForGroup()
  plugins/behaviors/inc/ticket.class.php:102         PluginBehaviorsTicket::getLastLinkedGroupByType()
  inc/plugin.class.php:1112                          PluginBehaviorsTicket::addActionTargets()
  inc/notificationtarget.class.php:1148              Plugin::doHook()
  inc/notificationeventabstract.class.php:91         NotificationTarget->addForTarget()
  inc/notificationevent.class.php:163                NotificationEventAbstract::raise()
  inc/commonitilactor.class.php:409                  NotificationEvent::raiseEvent()
  inc/group_ticket.class.php:66                      CommonITILActor->post_addItem()
  inc/commondbtm.class.php:1142                      Group_Ticket->post_addItem()
  inc/commonitilobject.class.php:1651                CommonDBTM->add()
  inc/ticket.class.php:2149                          CommonITILObject->post_addItem()
  inc/commondbtm.class.php:1142                      Ticket->post_addItem()
  inc/ticketrecurrent.class.php:509                  CommonDBTM->add()
  inc/ticketrecurrent.class.php:446                  TicketRecurrent::createTicket()
  inc/crontask.class.php:829                         TicketRecurrent::cronTicketRecurrent()
  front/cron.php:83                                  CronTask::launch()

Cordialement,

N.

nbriche

Member

From: Picardie

Registered: 2011-05-23

Posts: 55

Re: Behavior: SQL Error bloque le cron ticketrecurrent

Bonjour,

Petit up?

nbriche

Member

From: Picardie

Registered: 2011-05-23

Posts: 55

Re: Behavior: SQL Error bloque le cron ticketrecurrent

Le petit up du jeudi

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: Behavior: SQL Error bloque le cron ticketrecurrent

Je n'arrive pas à reproduire votre bug.
Vous pouvez détailler le paramétrage de votre ticket récurrent (enfin surtout le gabarit utilisé) et le notification définie ?

---

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)

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: Behavior: SQL Error bloque le cron ticketrecurrent

OK j'ai compris le problème.
Corrigé : https://forge.glpi-project.org/issues/5587

---

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)

nbriche

Member

From: Picardie

Registered: 2011-05-23

Posts: 55

Re: Behavior: SQL Error bloque le cron ticketrecurrent

Ca fonctionne sans erreur maintenant.

Merci beaucoup!

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: Behavior: SQL Error bloque le cron ticketrecurrent

Parfait. Je clos ce post

---

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)

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: Behavior: SQL Error bloque le cron ticketrecurrent

Nouvelle version publiée ce jour : https://forge.glpi-project.org/news/399

---

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)