trasher
commented
8 months ago Maybe you can first try to check database integrity with php bin/console database:check_schema_integrity
Open serviceticst opened 8 months ago
trasher
commented
8 months ago Maybe you can first try to check database integrity with php bin/console database:check_schema_integrity
serviceticst
commented
8 months ago The database integrity check for version "10.0.11@6795e1eea6621428b5ef42350d555715bda8a96f" is not supported.
cedric-anne
commented
8 months ago The database integrity check for version "10.0.11@6795e1eea6621428b5ef42350d555715bda8a96f" is not supported.
Did you remove the whole install directory ?
serviceticst
commented
8 months ago The "install" folder was renamed; I reverted it to the original name, ran the command, and it was successful. I ran it manually and received this log.
[root@servicetic-oracle-linux ~]# glpi-console database:check_schema_integrity Esquema do banco de dados está OK. [root@servicetic-oracle-linux ~]# tail -f /var/log/glpi/php-errors.log [2024-02-01 07:14:19] glpiphplog.WARNING: Test logger [2024-02-01 07:17:57] glpiphplog.WARNING: *** PHP Warning (2): Undefined array key "is_recursive" in /usr/share/glpi/src/CommonDBTM.php at line 3202 Backtrace : src/NotificationTarget.php:1757 CommonDBTM->isRecursive() src/NotificationTarget.php:1371 NotificationTarget->isTargetItemRecursive() src/NotificationTarget.php:854 NotificationTarget->getProfileJoinCriteria() src/NotificationTarget.php:1290 NotificationTarget->addForGroup() src/NotificationEventAbstract.php:98 NotificationTarget->addForTarget() src/NotificationEvent.php:187 NotificationEventAbstract::raise() src/SoftwareLicense.php:807 NotificationEvent::raiseEvent() src/CronTask.php:1027 SoftwareLicense::cronSoftware() front/crontask.form.php:52 CronTask::launch() public/index.php:82 require()
[2024-02-01 07:17:57] glpiphplog.CRITICAL: *** Uncaught Exception TypeError: NotificationTarget::isTargetItemRecursive(): Return value must be of type bool, null returned in /usr/share/glpi/src/NotificationTarget.php at line 1757 Backtrace : src/NotificationTarget.php:1371 NotificationTarget->isTargetItemRecursive() src/NotificationTarget.php:854 NotificationTarget->getProfileJoinCriteria() src/NotificationTarget.php:1290 NotificationTarget->addForGroup() src/NotificationEventAbstract.php:98 NotificationTarget->addForTarget() src/NotificationEvent.php:187 NotificationEventAbstract::raise() src/SoftwareLicense.php:807 NotificationEvent::raiseEvent() src/CronTask.php:1027 SoftwareLicense::cronSoftware() front/crontask.form.php:52 CronTask::launch() public/index.php:82
cedric-anne
commented
8 months ago You should updgrade to GLPI 10.0.12. It has been fixed in #16303.
serviceticst
commented
8 months ago I updated to version 10.0.12, and the log in php-error.log no longer appears.
In the log of the automatic action, a completed action is displayed.
Within the recipient group, the following error log appeared.
I checked in other groups from different databases, and the notification method is always N/A.
serviceticst
commented
8 months ago @cedric-anne, Can you please reopen it?
cedric-anne
commented
8 months ago @serviceticst
Please provide the full error trace.
serviceticst
commented
8 months ago @cedric-anne
[2024-02-05 08:53:36] glpisqllog.WARNING: DBmysql::doQuery() in /usr/share/glpi/src/DBmysql.php line 443
* MySQL query warnings:
SQL: SELECT glpi_notificationtemplates., '' AS transname, '' AS transcomment FROM glpi_notificationtemplates WHERE glpi_notificationtemplates.id = 'N/A'
Warnings:
1292: Truncated incorrect DOUBLE value: 'N/A'
Backtrace :
src/DBmysqlIterator.php:112 DBmysql->doQuery()
src/DBmysql.php:1109 DBmysqlIterator->execute()
src/Dropdown.php:544 DBmysql->request()
src/NotificationTarget.php:1639 Dropdown::getDropdownName()
src/NotificationTarget.php:1657 NotificationTarget::showForGroup()
src/CommonGLPI.php:694 NotificationTarget::displayTabContentForItem()
ajax/common.tabs.php:120 CommonGLPI::displayStandardTab()
public/index.php:82 require()
{"user":"44@servicetic-oracle-linux"}
[2024-02-05 09:02:27] glpisqllog.WARNING: DBmysql::doQuery() in /usr/share/glpi/src/DBmysql.php line 443
MySQL query warnings:
SQL: SELECT glpi_notificationtemplates.*, '' AS transname, '' AS transcomment FROM glpi_notificationtemplates WHERE glpi_notificationtemplates.id = 'N/A'
Warnings:
1292: Truncated incorrect DOUBLE value: 'N/A'
Backtrace :
src/DBmysqlIterator.php:112 DBmysql->doQuery()
src/DBmysql.php:1109 DBmysqlIterator->execute()
src/Dropdown.php:544 DBmysql->request()
src/NotificationTarget.php:1639 Dropdown::getDropdownName()
src/NotificationTarget.php:1657 NotificationTarget::showForGroup()
src/CommonGLPI.php:694 NotificationTarget::displayTabContentForItem()
ajax/common.tabs.php:120 CommonGLPI::displayStandardTab()
public/index.php:82 require()
{"user":"44@servicetic-oracle-linux"}
Code of Conduct
Is there an existing issue for this?
Version
10.0.11
Bug description
Hello,
We have configured in Administration > Entities > Root Entity > Notifications:
Enabled email notification for licenses and set an alert period.
Email notification is configured and successfully receiving test emails and email notifications for open tickets.
The license notification has been created with a specified recipient. The license has been created, and an expiration date has been set accordingly for the alert.
We executed the manual automatic action, but did not receive the notification email and received the following message in the log.
Relevant log output
Page URL
glpi/front/crontask.form.php?id=4
Steps To reproduce
We have configured in Administration > Entities > Root Entity > Notifications:
Enabled email notification for licenses and set an alert period.
Email notification is configured and successfully receiving test emails and email notifications for open tickets.
The license notification has been created with a specified recipient. The license has been created, and an expiration date has been set accordingly for the alert.
We executed the manual automatic action, but did not receive the notification email and received the following message in the log.
Your GLPI setup information
Instruções de instalação e configuração
Server
Operating system: Linux servicetic-oracle-linux 5.4.17-2136.327.2.el8uek.x86_64 #2 SMP Fri Jan 5 14:55:52 PST 2024 x86_64 PHP 8.2.15 fpm-fcgi (Core, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apcu, bcmath, bz2, calendar, cgi-fcgi, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imap, intl, json, ldap, libxml, mbstring, mysqli, mysqlnd, openssl, pcre, pdo_mysql, pdo_sqlite, posix, random, selinux, session, shmop, snmp, soap, sockets, sodium, sqlite3, standard, sysvmsg, sysvsem, sysvshm, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib) Setup: max_execution_time="300" memory_limit="1G" post_max_size="8M" safe_mode="" session.save_handler="files" upload_max_filesize="25M" disable_functions="" Software: Apache/2.4.37 (Oracle Linux) OpenSSL/1.1.1k () Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/121.0.0.0 Safari/537.36 Server Software: Percona Server (GPL), Release 27, Revision 2f8eeab2 Server Version: 8.0.35-27 Server SQL Mode: STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION Parameters: teste@localhost/teste Host info: Localhost via UNIX socket PHP version (8.2.15) is supported. Sessions configuration is OK. Allocated memory is sufficient. mysqli extension is installed. Following extensions are installed: dom, fileinfo, filter, libxml, json, simplexml, xmlreader, xmlwriter. curl extension is installed. gd extension is installed. intl extension is installed. zlib extension is installed. The constant SODIUM_CRYPTO_AEAD_XCHACHA20POLY1305_IETF_NPUBBYTES is present. Database engine version (8.0.35) is supported. No files from previous GLPI version detected. The log file has been created successfully. Write access to /var/lib/CLIENTES/teste/glpi/files/_cache has been validated. Write access to /var/lib/CLIENTES/teste/glpi/files/_cron has been validated. Write access to /var/lib/CLIENTES/teste/glpi/files/_documents has been validated. Write access to /var/lib/CLIENTES/teste/glpi/files/_dumps has been validated. Write access to /var/lib/CLIENTES/teste/glpi/files/_graphs has been validated. Write access to /var/lib/CLIENTES/teste/glpi/files/_lock has been validated. Write access to /var/lib/CLIENTES/teste/glpi/files/_pictures has been validated. Write access to /var/lib/CLIENTES/teste/glpi/files/_plugins has been validated. Write access to /var/lib/CLIENTES/teste/glpi/files/_rss has been validated. Write access to /var/lib/CLIENTES/teste/glpi/files/_sessions has been validated. Write access to /var/lib/CLIENTES/teste/glpi/files/_tmp has been validated. Write access to /var/lib/CLIENTES/teste/glpi/files/_uploads has been validated. For security reasons, SELinux mode should be Enforcing. Web server root directory configuration seems safe. Sessions configuration is secured. OS and PHP are relying on 64 bits integers. exif extension is installed. ldap extension is installed. openssl extension is installed. Following extensions are installed: bz2, Phar, zip. Zend OPcache extension is installed. Following extensions are installed: ctype, iconv, mbstring, sodium. Write access to /usr/share/CLIENTES/teste/glpi/web/glpi/marketplace has been validated. Timezones seems loaded in database.GLPI constants
Libraries
SQL replicas
Notifications
Plugins list
actualtime Name: ActualTime Version: 2.1.0 State: Not installed Install Method: Manual news Name: Alertas Version: 1.12.0 State: Not installed Install Method: Manual fields Name: Campos adicionais Version: 1.20.6 State: Enabled Install Method: Manual behaviors Name: Comportamentos Version: 2.7.2 State: Not installed Install Method: Manual costs Name: Costs Version: 3.0.1 State: Not installed Install Method: Manual customlogin Name: Custom Login Version: 1.0.6 State: Installed / not activated Install Method: Manual formcreator Name: Form Creator Version: 2.13.6 State: Not installed Install Method: Manual tag Name: Gerenciamento de Etiquetas Version: 2.11.2 State: Not installed Install Method: Manual genericobject Name: Gerenciamento de objetos Version: 2.14.3 State: Enabled Install Method: Manual datainjection Name: Importação de dados Version: 2.13.1 State: Not installed Install Method: Manual pdf Name: Imprimir em PDF Version: 3.0.0 State: Not installed Install Method: Manual mailanalyzer Name: Mail Analyzer Version: 3.0.0 State: Not installed Install Method: Manual moreticket Name: Mais Chamados Version: 1.7.1 State: Not installed Install Method: Manual satisfaction Name: Mais satisfação Version: 1.6.1 State: Not installed Install Method: Manual metabase Name: Metabase Version: 1.3.3 State: Not installed Install Method: Manual oauthimap Name: Oauth IMAP Version: 1.4.3 State: Not installed Install Method: Manual singlesignon Name: Single Sign-on Version: 1.3.4 State: Installed / not activated Install Method: Manual syncapi Name: Sync Api Version: 1.0.0 State: Enabled Install Method: Manual tasklists Name: Tasks list Version: 2.0.3 State: Not installed Install Method: ManualAnything else?
No response