fusioninventory / fusioninventory-for-glpi

FusionInventory plugin for GLPI
http://www.FusionInventory.org/
GNU Affero General Public License v3.0
360 stars 148 forks source link

Error on upgrade 9.4+2.4 - 10.0.6+1.1 #3434

Open mab18 opened 1 year ago

mab18 commented 1 year ago

OS : UBUNTU Ubuntu 22.04.2 LTS PHP: 8.1.2 MariaDB: 10.3.38

OLD Version: 9.4+2.4, GLPI 9.4.6 Try upgrade new Version: 10.0.6 +1.1, GLPI 10.0.6

I got error when try enable FunsionInventory : `Update of plugin FusionInventory (0 seconde)

Changement de la structure de la base de données - glpi_plugin_fusioninventory_agents (0 seconde) Changement de la structure de la base de données - glpi_plugin_fusioninventory_agentmodules (1 seconde) Changement de la structure de la base de données - glpi_plugin_fusioninventory_configs (1 seconde) Changement de la structure de la base de données - glpi_plugin_fusioninventory_configs (1 seconde) Ajout des index d'unicité - glpi_plugin_fusioninventory_configs (1 seconde) Changement de la structure de la base de données - glpi_plugin_fusioninventory_entities (1 seconde) Changement de la structure de la base de données - glpi_plugin_fusioninventory_locks (1 seconde) Changement de la structure de la base de données - glpi_plugin_fusioninventory_locks (1 seconde) Changement de la structure de la base de données - glpi_plugin_fusioninventory_ignoredimportdevices (1 seconde) Changement de la structure de la base de données - glpi_plugin_fusioninventory_rulematchedlogs (1 seconde) Changement de la structure de la base de données - glpi_plugin_fusioninventory_unmanageds (1 seconde) Changement de la structure de la base de données - glpi_plugin_fusioninventory_inventorycomputercriterias (1 seconde) Changement de la structure de la base de données - glpi_plugin_fusioninventory_inventorycomputerblacklists (1 seconde) Changement de la structure de la base de données - glpi_plugin_fusioninventory_inventorycomputercomputers (1 seconde) Changement de la structure de la base de données - glpi_plugin_fusioninventory_inventorycomputerstats (1 seconde) Changement de la structure de la base de données - glpi_plugin_fusioninventory_computerlicenseinfos (1 seconde) Changement de la structure de la base de données - glpi_plugin_fusioninventory_computerremotemanagements (1 seconde) Changement de la structure de la base de données - glpi_plugin_fusioninventory_dblockinventorynames (1 seconde) Changement de la structure de la base de données - glpi_plugin_fusioninventory_dblockinventories (1 seconde) Changement de la structure de la base de données - glpi_plugin_fusioninventory_dblocksoftwares (1 seconde) Changement de la structure de la base de données - glpi_plugin_fusioninventory_dblocksoftwareversions (1 seconde) Changement de la structure de la base de données - glpi_plugin_fusioninventory_taskjobs (1 seconde) Changement de la structure de la base de données - glpi_plugin_fusioninventory_crontasks (1 seconde) Changement de la structure de la base de données - glpi_plugin_fusioninventory_ipranges (2 secondes) Changement de la structure de la base de données - glpi_plugin_fusioninventory_ipranges_configsecurities (2 secondes) Changement de la structure de la base de données - glpi_plugin_fusioninventory_configlogfields (2 secondes) Changement de la structure de la base de données - glpi_plugin_fusioninventory_networkportconnectionlogs (2 secondes) Changement de la structure de la base de données - glpi_plugin_fusioninventory_networkporttypes (2 secondes) Changement de la structure de la base de données - glpi_plugin_fusioninventory_networkports (2 secondes) Changement de la structure de la base de données - glpi_plugin_fusioninventory_networkportlogs (2 secondes) Changement de la structure de la base de données - glpi_plugin_fusioninventory_printers (2 secondes) Changement de la structure de la base de données - glpi_plugin_fusioninventory_printerlogs (3 secondes) Changement de la structure de la base de données - glpi_plugin_fusioninventory_printercartridges (3 secondes) Clean printers (3 secondes) Changement de la structure de la base de données - glpi_plugin_fusioninventory_networkequipments (3 secondes) Changement de la structure de la base de données - glpi_plugin_fusioninventory_configsecurities (3 secondes) Changement de la structure de la base de données - glpi_plugin_fusioninventory_statediscoveries (3 secondes) Changement de la structure de la base de données - glpi_plugin_fusioninventory_mappings (3 secondes) Changement de la structure de la base de données - glpi_plugin_fusioninventory_deployfiles (3 secondes) Changement de la structure de la base de données - glpi_plugin_fusioninventory_deploypackages (3 secondes) Changement de la structure de la base de données - glpi_plugin_fusioninventory_deploypackages_entities (3 secondes) Changement de la structure de la base de données - glpi_plugin_fusioninventory_deploypackages_groups (3 secondes) Changement de la structure de la base de données - glpi_plugin_fusioninventory_deploypackages_profiles (3 secondes) Changement de la structure de la base de données - glpi_plugin_fusioninventory_deploypackages_users (3 secondes) Changement de la structure de la base de données - glpi_plugin_fusioninventory_deploymirrors (3 secondes) Changement de la structure de la base de données - glpi_plugin_fusioninventory_deploygroups (3 secondes) Changement de la structure de la base de données - glpi_plugin_fusioninventory_deploygroups_staticdatas (3 secondes) Changement de la structure de la base de données - glpi_plugin_fusioninventory_deploygroups_dynamicdatas (3 secondes)` The plugin is not UP, and the upgrade don't go to the end.

Errors in _log/sql-errors.log 👍

[2023-05-31 17:17:48] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi/src/DBmysql.php line 370 *** MySQL query error: SQL: INSERT INTOglpi_rules(name,match,sub_type,is_active,ranking,date_creation,date_mod) VALUES ('Peripheral serial', 'AND', 'PluginFusioninventoryInventoryRuleImport', '1', '0', '2023-05-31 17:17:47', '2023-05-31 17:17:47') Error: Field 'description' doesn't have a default value Backtrace : src/DBmysql.php:1320 src/CommonDBTM.php:721 DBmysql->insert() src/CommonDBTM.php:1326 CommonDBTM->addToDB() plugins/fusioninventory/install/update.php:6671 CommonDBTM->add() plugins/fusioninventory/install/update.php:386 do_rule_migration() plugins/fusioninventory/hook.php:847 pluginFusioninventoryUpdate() src/Plugin.php:840 plugin_fusioninventory_install() front/plugin.form.php:51 Plugin->install() {"user":"50@myserver"} [2023-05-31 17:17:48] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi/src/DBmysql.php line 370 *** MySQL query error: SQL: INSERT INTOglpi_rules(name,match,sub_type,is_active,ranking,date_creation,date_mod) VALUES ('Peripheral import', 'AND', 'PluginFusioninventoryInventoryRuleImport', '1', '1', '2023-05-31 17:17:47', '2023-05-31 17:17:47') Error: Field 'description' doesn't have a default value Backtrace : src/DBmysql.php:1320 src/CommonDBTM.php:721 DBmysql->insert() src/CommonDBTM.php:1326 CommonDBTM->addToDB() plugins/fusioninventory/install/update.php:6718 CommonDBTM->add() plugins/fusioninventory/install/update.php:386 do_rule_migration() plugins/fusioninventory/hook.php:847 pluginFusioninventoryUpdate() src/Plugin.php:840 plugin_fusioninventory_install() front/plugin.form.php:51 Plugin->install() {"user":"50@myserver","mem_usage":"0.003\", 3.07Mio)"} [2023-05-31 17:17:48] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi/src/DBmysql.php line 370 *** MySQL query error: SQL: INSERT INTOglpi_rules(name,match,sub_type,is_active,ranking,date_creation,date_mod) VALUES ('Peripheral ignore import', 'AND', 'PluginFusioninventoryInventoryRuleImport', '1', '2', '2023-05-31 17:17:47', '2023-05-31 17:17:47') Error: Field 'description' doesn't have a default value Backtrace : src/DBmysql.php:1320 src/CommonDBTM.php:721 DBmysql->insert() src/CommonDBTM.php:1326 CommonDBTM->addToDB() plugins/fusioninventory/install/update.php:6758 CommonDBTM->add() plugins/fusioninventory/install/update.php:386 do_rule_migration() plugins/fusioninventory/hook.php:847 pluginFusioninventoryUpdate() src/Plugin.php:840 plugin_fusioninventory_install() front/plugin.form.php:51 Plugin->install() {"user":"50@myserver","mem_usage":"0.002\", 3.07Mio)"} [2023-05-31 17:17:48] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi/src/DBmysql.php line 370 *** MySQL query error: SQL: INSERT INTOglpi_rules(name,match,sub_type,is_active,ranking,date_creation,date_mod) VALUES ('Monitor serial', 'AND', 'PluginFusioninventoryInventoryRuleImport', '1', '2', '2023-05-31 17:17:47', '2023-05-31 17:17:47') Error: Field 'description' doesn't have a default value Backtrace : src/DBmysql.php:1320 src/CommonDBTM.php:721 DBmysql->insert() src/CommonDBTM.php:1326 CommonDBTM->addToDB() plugins/fusioninventory/install/update.php:6856 CommonDBTM->add() plugins/fusioninventory/install/update.php:386 do_rule_migration() plugins/fusioninventory/hook.php:847 pluginFusioninventoryUpdate() src/Plugin.php:840 plugin_fusioninventory_install() front/plugin.form.php:51 Plugin->install() {"user":"50@myserver","mem_usage":"0.014\", 3.07Mio)"} [2023-05-31 17:17:48] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi/src/DBmysql.php line 370 *** MySQL query error: SQL: INSERT INTOglpi_rules(name,match,sub_type,is_active,ranking,date_creation,date_mod) VALUES ('Monitor import', 'AND', 'PluginFusioninventoryInventoryRuleImport', '1', '3', '2023-05-31 17:17:47', '2023-05-31 17:17:47') Error: Field 'description' doesn't have a default value Backtrace : src/DBmysql.php:1320 src/CommonDBTM.php:721 DBmysql->insert() src/CommonDBTM.php:1326 CommonDBTM->addToDB() plugins/fusioninventory/install/update.php:6904 CommonDBTM->add() plugins/fusioninventory/install/update.php:386 do_rule_migration() plugins/fusioninventory/hook.php:847 pluginFusioninventoryUpdate() src/Plugin.php:840 plugin_fusioninventory_install() front/plugin.form.php:51 Plugin->install() {"user":"50@myserver","mem_usage":"0.002\", 3.07Mio)"} [2023-05-31 17:17:48] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi/src/DBmysql.php line 370 *** MySQL query error: SQL: INSERT INTOglpi_rules(name,match,sub_type,is_active,ranking,date_creation,date_mod) VALUES ('Monitor ignore import', 'AND', 'PluginFusioninventoryInventoryRuleImport', '1', '4', '2023-05-31 17:17:47', '2023-05-31 17:17:47') Error: Field 'description' doesn't have a default value Backtrace : src/DBmysql.php:1320 src/CommonDBTM.php:721 DBmysql->insert() src/CommonDBTM.php:1326 CommonDBTM->addToDB() plugins/fusioninventory/install/update.php:6945 CommonDBTM->add() plugins/fusioninventory/install/update.php:386 do_rule_migration() plugins/fusioninventory/hook.php:847 pluginFusioninventoryUpdate() src/Plugin.php:840 plugin_fusioninventory_install() front/plugin.form.php:51 Plugin->install() {"user":"50@myserver","mem_usage":"0.002\", 3.07Mio)"}

and here the _log/phperror.log :

[2023-05-31 17:29:00] glpiphplog.WARNING: *** PHP User Warning (512): getFromDBByCrit expects to get one result, 4 found in query "SELECTidFROMglpi_rulesWHEREname= 'Peripheral serial' ANDmatch= 'AND' ANDsub_type` = 'PluginFusioninventoryInventoryRuleImport'". in /var/www/html/glpi/src/CommonDBTM.php at line 396 Backtrace : src/CommonDBTM.php:396 trigger_error() plugins/fusioninventory/install/update.php:6668 CommonDBTM->getFromDBByCrit() plugins/fusioninventory/install/update.php:386 do_rule_migration() plugins/fusioninventory/hook.php:847 pluginFusioninventoryUpdate() src/Plugin.php:840 plugin_fusioninventory_install() front/plugin.form.php:51 Plugin->install()

[2023-05-31 17:29:00] glpiphplog.WARNING: *** PHP User Warning (512): getFromDBByCrit expects to get one result, 4 found in query "SELECT id FROM glpi_rules WHERE name = 'Peripheral import' AND match = 'AND' AND sub_type = 'PluginFusioninventoryInventoryRuleImport'". in /var/www/html/glpi/src/CommonDBTM.php at line 396 Backtrace : src/CommonDBTM.php:396 trigger_error() plugins/fusioninventory/install/update.php:6715 CommonDBTM->getFromDBByCrit() plugins/fusioninventory/install/update.php:386 do_rule_migration() plugins/fusioninventory/hook.php:847 pluginFusioninventoryUpdate() src/Plugin.php:840 plugin_fusioninventory_install() front/plugin.form.php:51 Plugin->install()

[2023-05-31 17:29:00] glpiphplog.WARNING: *** PHP User Warning (512): getFromDBByCrit expects to get one result, 4 found in query "SELECT id FROM glpi_rules WHERE name = 'Peripheral ignore import' AND match = 'AND' AND sub_type = 'PluginFusioninventoryInventoryRuleImport'". in /var/www/html/glpi/src/CommonDBTM.php at line 396 Backtrace : src/CommonDBTM.php:396 trigger_error() plugins/fusioninventory/install/update.php:6755 CommonDBTM->getFromDBByCrit() plugins/fusioninventory/install/update.php:386 do_rule_migration() plugins/fusioninventory/hook.php:847 pluginFusioninventoryUpdate() src/Plugin.php:840 plugin_fusioninventory_install() front/plugin.form.php:51 Plugin->install()

[2023-05-31 17:29:00] glpiphplog.WARNING: *** PHP User Warning (512): getFromDBByCrit expects to get one result, 4 found in query "SELECT id FROM glpi_rules WHERE name = 'Monitor serial' AND match = 'AND' AND sub_type = 'PluginFusioninventoryInventoryRuleImport'". in /var/www/html/glpi/src/CommonDBTM.php at line 396 Backtrace : src/CommonDBTM.php:396 trigger_error() plugins/fusioninventory/install/update.php:6853 CommonDBTM->getFromDBByCrit() plugins/fusioninventory/install/update.php:386 do_rule_migration() plugins/fusioninventory/hook.php:847 pluginFusioninventoryUpdate() src/Plugin.php:840 plugin_fusioninventory_install() front/plugin.form.php:51 Plugin->install()

[2023-05-31 17:29:00] glpiphplog.WARNING: *** PHP User Warning (512): getFromDBByCrit expects to get one result, 4 found in query "SELECT id FROM glpi_rules WHERE name = 'Monitor import' AND match = 'AND' AND sub_type = 'PluginFusioninventoryInventoryRuleImport'". in /var/www/html/glpi/src/CommonDBTM.php at line 396 Backtrace : src/CommonDBTM.php:396 trigger_error() plugins/fusioninventory/install/update.php:6901 CommonDBTM->getFromDBByCrit() plugins/fusioninventory/install/update.php:386 do_rule_migration() plugins/fusioninventory/hook.php:847 pluginFusioninventoryUpdate() src/Plugin.php:840 plugin_fusioninventory_install() front/plugin.form.php:51 Plugin->install()

[2023-05-31 17:29:00] glpiphplog.WARNING: *** PHP User Warning (512): getFromDBByCrit expects to get one result, 4 found in query "SELECT id FROM glpi_rules WHERE name = 'Monitor ignore import' AND match = 'AND' AND sub_type = 'PluginFusioninventoryInventoryRuleImport'". in /var/www/html/glpi/src/CommonDBTM.php at line 396 Backtrace : src/CommonDBTM.php:396 trigger_error() plugins/fusioninventory/install/update.php:6942 CommonDBTM->getFromDBByCrit() plugins/fusioninventory/install/update.php:386 do_rule_migration() plugins/fusioninventory/hook.php:847 pluginFusioninventoryUpdate() src/Plugin.php:840 plugin_fusioninventory_install() front/plugin.form.php:51 Plugin->install()

[2023-05-31 17:29:02] glpiphplog.CRITICAL: *** Uncaught Exception Error: Attempt to assign property "jobs" on null in /var/www/html/glpi/plugins/fusioninventory/install/update.php at line 10342 Backtrace : plugins/fusioninventory/install/update.php:444 migrateTablesFromFusinvDeploy() plugins/fusioninventory/hook.php:847 pluginFusioninventoryUpdate() src/Plugin.php:840 plugin_fusioninventory_install() front/plugin.form.php:51 Plugin->install() `