notification not Works

[Azgar1998]

Hello, Since today around 2 p.m., I no longer receive a notification.

when I run the command: php glpi-path/docs/front/cron.php --force queuednotification

i have this message: PHP Warning: Trying to access array offset on value of type bool in glpi-path/src/NotificationEventMailing.php on line 278 PHP Warning: Trying to access array offset on value of type bool in glpi-path/src/NotificationEventMailing.php on line 279

sq log:

[2023-03-15 14:35:37] glpisqllog.ERROR: DBmysql::query() in glpi-path/src/DBmysql.php line 370 *** MySQL query error: SQL: INSERT INTO glpi_pendingreasons_items (pendingreasons_id, followup_frequency, followups_before_resolution, itemtype, items_id, last_bump_date) VALUES (NULL, '0', '0', 'Ticket', '93473', '2023-03-15 14:35:37') Error: Column 'pendingreasons_id' cannot be null Backtrace : src/DBmysql.php:1320
src/CommonDBTM.php:721 DBmysql->insert() src/CommonDBTM.php:1326 CommonDBTM->addToDB() src/PendingReason_Item.php:100 CommonDBTM->add() src/PendingReason_Item.php:382 PendingReason_Item::createForItem() src/ITILFollowup.php:486 PendingReason_Item::handleTimelineEdits() src/CommonDBTM.php:1727 ITILFollowup->post_updateItem() front/itilfollowup.form.php:85 CommonDBTM->update() {"user":"51322@serveurname"} [2023-03-15 14:35:37] glpisqllog.ERROR: DBmysql::query() in glpi-path/src/DBmysql.php line 370 *** MySQL query error: SQL: INSERT INTO glpi_pendingreasons_items (pendingreasons_id, followup_frequency, followups_before_resolution, itemtype, items_id, last_bump_date) VALUES (NULL, '0', '0', 'ITILFollowup', '83126', '2023-03-15 14:35:37') Error: Column 'pendingreasons_id' cannot be null Backtrace : src/DBmysql.php:1320
src/CommonDBTM.php:721 DBmysql->insert() src/CommonDBTM.php:1326 CommonDBTM->addToDB() src/PendingReason_Item.php:100 CommonDBTM->add() src/PendingReason_Item.php:387 PendingReason_Item::createForItem() src/ITILFollowup.php:486 PendingReason_Item::handleTimelineEdits() src/CommonDBTM.php:1727 ITILFollowup->post_updateItem() front/itilfollowup.form.php:85 CommonDBTM->update() {"user":"51322@servername","mem_usage":"0.001", 2.56Mio)"}

php log:

[2023-03-15 17:33:31] glpiphplog.CRITICAL: *** Uncaught Exception DivisionByZeroError: Division by zero in glpi-path/src/NotificationEventMailing.php at line 283 Backtrace : src/QueuedNotification.php:602 NotificationEventMailing::send() src/CronTask.php:1018 QueuedNotification::cronQueuedNotification() front/cron.php:79 CronTask::launch()

[2023-03-15 17:34:32] glpiphplog.WARNING: *** PHP Warning (2): Trying to access array offset on value of type bool in glpi-path/src/NotificationEventMailing.php at line 278 Backtrace : src/QueuedNotification.php:602 NotificationEventMailing::send() src/CronTask.php:1018 QueuedNotification::cronQueuedNotification() front/cron.php:79 CronTask::launch()

[2023-03-15 17:34:32] glpiphplog.WARNING: *** PHP Warning (2): Trying to access array offset on value of type bool in glpi-path/src/NotificationEventMailing.php at line 279 Backtrace : src/QueuedNotification.php:602 NotificationEventMailing::send() src/CronTask.php:1018 QueuedNotification::cronQueuedNotification() front/cron.php:79 CronTask::launch()

[2023-03-15 17:34:32] glpiphplog.CRITICAL: *** Uncaught Exception DivisionByZeroError: Division by zero in glpi-path/src/NotificationEventMailing.php at line 283 Backtrace : src/QueuedNotification.php:602 NotificationEventMailing::send() src/CronTask.php:1018 QueuedNotification::cronQueuedNotification() front/cron.php:79

since the beginning of the afternoon I have these php messages which are looping

Thank you for your help

[btry]

Hi

Did you upgrade glpi a few hours before the error appeared ? A column seems to be missing in a table of GLPI. It seems that Formcreator is not related to this issue.

[Azgar1998]

Hello,

GLPI has been up to date for more than a week (10.0.3 to 10.0.6).

the problem was related to a ticket. a user to embed an html code in a ticket. the notification thread was blocked. We have edited the ticket and removed the link. this solved the problem. There is no security for this kind of incident?

[btry]

Hi

So far, I cannot know if the issue comes from glou or Formcreator. Coult you try to reproduce by creating a ticket from glpi, without the help of Formcreator?

I think the test would be more reliable if you disable the plugin first.