fusioninventory-for-glpi
fusioninventory-for-glpi copied to clipboard
Error on upgrade 9.4+2.4 - 10.0.6+1.1
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 INTO
glpi_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 INTO
glpi_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 INTO
glpi_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 INTO
glpi_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 INTO
glpi_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 INTO
glpi_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 "SELECT
idFROM
glpi_rulesWHERE
name= 'Peripheral 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: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() `