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 2019-08-13 15:50:42

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.

Offline

#2 2019-08-23 18:10:08

nbriche
Member
From: Picardie
Registered: 2011-05-23
Posts: 55

Re: Behavior: SQL Error bloque le cron ticketrecurrent

Bonjour,

Petit up?

Offline

#3 2019-08-29 09:26:30

nbriche
Member
From: Picardie
Registered: 2011-05-23
Posts: 55

Re: Behavior: SQL Error bloque le cron ticketrecurrent

Le petit up du jeudi

Offline

#4 2019-09-04 17:59:56

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 15,273

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)

Offline

#5 2019-09-04 18:52:29

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 15,273

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)

Offline

#6 2019-09-05 15:37:53

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!

Offline

#7 2019-09-06 16:02:06

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 15,273

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)

Offline

#8 2019-09-23 18:43:19

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 15,273

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)

Offline

Board footer

Powered by FluxBB