trasher
commented
1 year ago This is an issue on accounts plugin, please report issue against plugin
Closed npo412 closed 1 year ago
trasher
commented
1 year ago This is an issue on accounts plugin, please report issue against plugin
npo412
commented
1 year ago Thanks for the answer, sorry to post on the wrong channel.
Code of Conduct
Is there an existing issue for this?
Version
10.0.9
Bug description
Hello,
After the upgrade to version 10.0.9, we encountered issues with the Accounts plugin:
PHP Warning: Invalid relations declared for "glpi_plugin_accounts_accountstates" table. Target table "glpi_plugin_accounts_mailingstates" does not correspond to a known itemtype. in /var/local/xxxxxxxxxx/glpi/src/DbUtils.php on line 2111
The accounts plugin works well and we can access the accounts and passwords without any issue but this alert on PHP appears every day since the update.
Relevant log output
Page URL
No response
Steps To reproduce
No response
Your GLPI setup information
Information about system installation and configuration
Server
Operating system: Linux glpi 5.10.0-23-amd64 #1 SMP Debian 5.10.179-1 (2023-05-12) x86_64 PHP 7.4.33 apache2handler (Core, FFI, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apache2handler, apc, apcu, bz2, calendar, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imap, intl, json, ldap, libxml, mbstring, mysqli, mysqlnd, openssl, pcre, pdo_mysql, posix, readline, session, shmop, soap, sockets, sodium, standard, sysvmsg, sysvsem, sysvshm, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib) Setup: max_execution_time="30" memory_limit="128M" post_max_size="8M" safe_mode="" session.save_handler="files" upload_max_filesize="2M" Software: Apache/2.4.56 (Debian) (Apache/2.4.56 (Debian) Server at glpi.xxxxx.net Port 443 ) Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36 Server Software: Debian 11 Server Version: 10.5.19-MariaDB-0+deb11u2 Server SQL Mode: STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION Parameters: glpi@localhost/glpi Host info: Localhost via UNIX socket PHP version (7.4.33) 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 (10.5.19) is supported. No files from previous GLPI version detected. The log file has been created successfully. Write access to /var/local/xxxxx/glpi/files/_cache has been validated. Write access to /var/local/xxxxx/glpi/config has been validated. Write access to /var/local/xxxxx/glpi/files/_cron has been validated. Write access to /var/local/xxxxx/glpi/files has been validated. Write access to /var/local/xxxxx/glpi/files/_dumps has been validated. Write access to /var/local/xxxxx/glpi/files/_graphs has been validated. Write access to /var/local/xxxxx/glpi/files/_lock has been validated. Write access to /var/local/xxxxx/glpi/files/_pictures has been validated. Write access to /var/local/xxxxx/glpi/files/_plugins has been validated. Write access to /var/local/xxxxx/glpi/files/_rss has been validated. Write access to /var/local/xxxxx/glpi/files/_sessions has been validated. Write access to /var/local/xxxxx/glpi/files/_tmp has been validated. Write access to /var/local/xxxxx/glpi/files/_uploads has been validated. PHP 7.4 official support has ended. An upgrade to a more recent PHP version is recommended. Web server root directory configuration seems safe. PHP directive "session.cookie_secure" should be set to "on" when GLPI can be accessed on HTTPS protocol. PHP directive "session.cookie_httponly" should be set to "on" to prevent client-side script to access cookie values. 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 /var/local/xxxxx/glpi/marketplace has been validated. Timezones seems loaded in database.GLPI constants
Libraries
LDAP directories
Server: 'ldaps://fr-val-dc02.xxxxx.net', Port: '389', BaseDN: 'DC=xxxxx,DC=net', Connection filter: '(&(objectClass=user)(objectCategory=person)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))', RootDN: 's_glpi', Use TLS: none Server: 'auth2.xxxxx.net', Port: '389', BaseDN: 'dc=xxxxx,dc=lz', Connection filter: '(&(|(sambaAcctFlags=[U ])(sambaAcctFlags=[U]))(!(uid=adminscan))(!(uid=faxuser))(!(uid=git))(!(uid=mroom))(!(uid=mtest))(!(uid=root))(!(uid=qc))(!(uid=qcatl2016))(!(uid=scan))(!(uid=supertest))(!(uid=dspoutnik))(!(uid=s_winsync)))', RootDN: none, Use TLS: noneSQL replicas
Notifications
Plugins list
accounts Name: Accounts Version: 3.0.3 State: Enabled Install Method: Marketplace glpiinventory Name: GLPI Inventory Version: 1.2.3 State: Enabled Install Method: MarketplaceAnything else?
No response