You are not logged in.
Since yesterday I have been having a problem with sending glpi emails when I close a case or when they open one, I try to send it manually and it doesn't work either, it stays in the "In process of execution" state, I already reviewed the cron and it's fine, no I know what else to check
Offline
open "queudnotifications" automatic action and click on the x near "In process of execution" this should reset status to scheduled
Trouver la panne avant de réparer...
GLPI10.0.16 (ubuntu 22.04 PHP8.1 Mariadb10.6 ) plugins : comportements 2.7.3 reports 1.16.0 formcreator 2.13.9, datainjection 2.13.5 fields 1.21.9
Offline
Thanks for responding, I already did it and waited for the crontab to do its thing and send the emails, but when the automatic action was executed again, it remained in the execution process again, could they be the logs?
Although I have 11488, I already debugged the others, it's strange, some problem with PHP maybe?
Offline
11488 queued notifications ??? quite a lot, it might take time and next scheduled task might be triggered before the previous is completed.
I would first :
use mass action to send 200 notifications ( administration>queued notifications) (6 times should be enough)
or delete some old notifications that are anymoer usefull
then check again
Trouver la panne avant de réparer...
GLPI10.0.16 (ubuntu 22.04 PHP8.1 Mariadb10.6 ) plugins : comportements 2.7.3 reports 1.16.0 formcreator 2.13.9, datainjection 2.13.5 fields 1.21.9
Offline
The 11488 are logs, however I already did what you told me, and it remains the same, something new is that when I press x to remove the message and it gives me the option to execute the task manually, when I click on run now, it should reload the page without any problem, I get a problem in which it says that the page does not work, the strange thing is that the rest of the automatic actions when I do the same if it works normally it only happens with this
Offline
I think it has to do with the file glpi/front/crontask.form.php, since when I click on run now and I get the error the page is to the path it tells me, but I check the file and everything is normal.
Offline
If you run
cat /var/log/glpi/php-errors.log
(my log files are stored outside of the GLPI directory so you may need to change the path to match your system) do you see any errors?
Offline
Hello brother, thank you for responding, in fact I get several errors at the time that glpi notified me of the email sending error, this is an example:
[2024-02-06 17:02:04] glpiphplog.WARNING: *** PHP User Warning (512): Relation between "glpi_networkports" and "glpi_plugin_ocsinventoryng_networkports" table based on "networkports_id" field cannot be handled automatically as "networkports_id" also corresponds to index field of the target table. in /var/www/html/glpi/src/DbUtils.php at line 2131
Backtrace :
src/DbUtils.php:2131 trigger_error()
inc/db.function.php:585 DbUtils->getDbRelations()
src/CommonDBTM.php:866 getDbRelations()
src/CommonDBTM.php:788 CommonDBTM->cleanRelationD$
src/CommonDBTM.php:2068 CommonDBTM->deleteFromDB()
src/QueuedNotification.php:194 CommonDBTM->delete()
src/CommonDBTM.php:1278 QueuedNotification->prepar$
src/NotificationMailing.php:181 CommonDBTM->add()
src/Notification.php:624 NotificationMailing->sendN$
src/NotificationEventAbstract.php:146 Notification::send()
src/NotificationEvent.php:187 NotificationEventAbstract:$
src/CronTask.php:2039 NotificationEvent::raiseEv$
src/CronTask.php:1018 CronTask::cronWatcher()
front/cron.php:83 CronTask::launch()
I think they are all different texts but they lead to the same thing, it is the first time I see this type of mistake.
Last edited by BVALENCIA (2024-02-12 14:33:53)
Offline
One of the recent GLPI 10 versions made defining relationships between database tables more strict than they were before and at least one defined by the OCS plugin isn't compliant anymore. It is something they need to fix and I am pretty sure this was reported a while ago on their GitHub.
GLPI Collaborator and Plugin Developer.
My non-English comments are automated translations. Sorry for any confusion that causes.
Mes commentaires non anglais sont des traductions automatiques. Désolé pour toute confusion qui cause.
Mis comentarios que no están en inglés son traducciones automáticas. Perdón por cualquier confusión que cause.
Offline
I understand, thank you very much for your collaboration guys, I will start reviewing the entire issue to solve it, thank you very much
Offline