cconard96
commented
2 years ago A new feature was added with 10.0.1 to try and catch issues with the database schema as we noticed some users (mostly from very old versions) had not had all the expected migrations done.
In this case, I don't understand how that table would have those columns. The table was added in 9.4.0 and has kept the same columns. It never should have had a changes_id column.
Can you verify from the database itself which columns the table has to rule out an issue with the schema checker?
jackburton79
Code of Conduct
Is there an existing issue for this?
Version
10.0.1
Bug description
After migrating to glpi 10.0.1, the system showed a message saying the database is inconsistent. I ran
php bin/console glpi:database:check_schema_integrityand:How do I fix this ?
Relevant log output
No response
Page URL
No response
Steps To reproduce
No response
Your GLPI setup information
Informazioni sul sistema, l'installazione e la configurazione
Server
Operating system: Linux group 5.3.18-150300.59.68-default #1 SMP Wed May 4 11:29:09 UTC 2022 (ea30951) x86_64 PHP 7.4.6 apache2handler (Core, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apache2handler, apcu, bcmath, bz2, ctype, curl, date, dom, exif, fileinfo, filter, gd, gettext, hash, iconv, intl, json, ldap, libxml, mbstring, memcached, mysqli, mysqlnd, openssl, pcre, pdo_mysql, pdo_sqlite, posix, session, snmp, soap, sockets, sodium, sqlite3, standard, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib) Setup: max_execution_time="30" memory_limit="128M" post_max_size="101M" safe_mode="" session.save_handler="files" upload_max_filesize="8M" Software: Apache () Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.5005.63 Safari/537.36 Edg/102.0.1245.33 Server Software: MariaDB package Server Version: 10.5.15-MariaDB Server SQL Mode: STRICT_TRANS_TABLES Parameters: glpi-test@localhost/glpi-test Host info: Localhost via UNIX socket PHP version (7.4.6) is supported. Sessions configuration is OK. Allocated memory is sufficient. mysqli extension is installed. Following extensions are installed: dom, fileinfo, json, simplexml. curl extension is installed. gd extension is installed. intl extension is installed. libxml extension is installed. zlib extension is installed. The constant SODIUM_CRYPTO_AEAD_XCHACHA20POLY1305_IETF_NPUBBYTES is present. Database engine version (10.5.15) is supported. The log file has been created successfully. Write access to /usr/local/share/glpitest/files/_cache has been validated. Write access to /usr/local/share/glpitest/config has been validated. Write access to /usr/local/share/glpitest/files/_cron has been validated. Write access to /usr/local/share/glpitest/files has been validated. Write access to /usr/local/share/glpitest/files/_dumps has been validated. Write access to /usr/local/share/glpitest/files/_graphs has been validated. Write access to /usr/local/share/glpitest/files/_lock has been validated. Write access to /usr/local/share/glpitest/files/_pictures has been validated. Write access to /usr/local/share/glpitest/files/_plugins has been validated. Write access to /usr/local/share/glpitest/files/_rss has been validated. Write access to /usr/local/share/glpitest/files/_sessions has been validated. Write access to /usr/local/share/glpitest/files/_tmp has been validated. Write access to /usr/local/share/glpitest/files/_uploads has been validated. Web access to files directory is protected exif extension is installed. ldap extension is installed. openssl extension is installed. zip extension is installed. bz2 extension is installed. Zend OPcache extension is installed. Following extensions are installed: ctype, iconv, mbstring, sodium. Write access to /usr/local/share/glpitest/marketplace has been validated. Timezones seems loaded in database.GLPI constants
Libraries
LDAP directories
Server: 'ldap://uddc1.iacpud.local', Port: '389', BaseDN: 'OU=AterUsers,DC=IACPUD,DC=LOCAL', Connection filter: '(&(objectClass=user)(objectCategory=person)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))', RootDN: 'LDAPSearchUser', Use TLS: noneSQL replicas
Notifications
Plugins list
accounts Name: Accounts Version: 3.0.2 State: Enabled additionalalerts Name: Altre notifiche Version: 2.4.0 State: Enabled barcode Name: Barcode Version: 2.7.0 State: Enabled printercounters Name: Contatori della stampante Version: 2.0.0 State: Enabled dashboard Name: Dashboard Version: 0.9.6 State: Not installed datainjection Name: Data injection Version: 2.11.1 State: Enabled databases Name: Databases Version: 2.3.0 State: Installed / not activated addressing Name: Indirizzamento IP Version: 3.0.0 State: Installed / not activated room Name: Locali Version: 3.1.3 State: Enabled mailanalyzer Name: Mail Analyzer Version: 1.6.0 State: Not installed mreporting Name: More Reporting Version: 1.8.0 State: Installed / not activated ocsinventoryng Name: OCS Inventory NG Version: 2.0.0 State: Enabled reports Name: Report Version: 1.12.0 State: Installed / not activated reservation Name: Reservation Version: 2.3.3 State: Not installed screenshot Name: Screenshot Version: 2.0.0 State: Not installed shellcommands Name: Shell Commands Version: 4.0.1 State: Enabled pdf Name: Stampa in PDF Version: 1.7.0 State: Installed / not activated ticketcleaner Name: Ticket Cleaner Version: 2.1.0 State: Installed / not activated useditemsexport Name: Used items export Version: 2.5.0 State: Installed / not activated treeview Name: Visualizzazione struttura Version: 1.10.0 State: Enabled webapplications Name: Web applications Version: 4.0.1 State: EnabledAnything else?
No response