1

Topic: MySQL query error (Duplicate entry) & PHP Notice(8): Undefined index

Bonjour,
J'ai mis à jour GLPI, passage de la version GLPI 0.90.1 vers GLPI 9.1.2 sans problème particulier, je viens de constater des erreurs dans les fichiers de logs.

/var/www/files/_log/php-errors.log

Backtrace :
  ...ventory/inc/inventorycomputerlib.class.php:1433
  ...ry/inc/inventorycomputerinventory.class.php:562 PluginFusioninventoryInventoryComputerLib->updateComputer()
  ...inventory/inc/inventoryruleimport.class.php:781 PluginFusioninventoryInventoryComputerInventory->rulepassed()
  inc/rule.class.php:1427                            PluginFusioninventoryInventoryRuleImport->executeActions()
  inc/rulecollection.class.php:1459                  Rule->process()
  ...ry/inc/inventorycomputerinventory.class.php:375 RuleCollection->processAllRules()
  ...ry/inc/inventorycomputerinventory.class.php:127 PluginFusioninventoryInventoryComputerInventory->sendCriteria()
  ...fusioninventory/inc/communication.class.php:235 PluginFusioninventoryInventoryComputerInventory->import()
  ...fusioninventory/inc/communication.class.php:463 PluginFusioninventoryCommunication->import()
  plugins/fusioninventory/front/communication.php:93 PluginFusioninventoryCommunication->handleOCSCommunication()
  plugins/fusioninventory/index.php:59               include_once()
2017-03-13 14:25:15 [[email protected]]
  *** PHP Notice(8): Undefined index: name


/var/www/files/_log/sql-errors.log

  *** MySQL query error:
  SQL: UPDATE `glpi_computers_softwareversions`
                         SET `softwareversions_id` = \'2523461\'
                         WHERE `id` = 206243674
  Error: Duplicate entry '88754-2523461' for key 'unicity'
  Backtrace :
  inc/transfer.class.php:1535
  inc/transfer.class.php:1140                        Transfer->transferComputerSoftwares()
  inc/transfer.class.php:187                         Transfer->transferItem()
  ...ry/inc/inventorycomputerinventory.class.php:489 Transfer->moveItems()
  ...inventory/inc/inventoryruleimport.class.php:781 PluginFusioninventoryInventoryComputerInventory->rulepassed()
  inc/rule.class.php:1427                            PluginFusioninventoryInventoryRuleImport->executeActions()
  inc/rulecollection.class.php:1459                  Rule->process()
  ...ry/inc/inventorycomputerinventory.class.php:375 RuleCollection->processAllRules()
  ...ry/inc/inventorycomputerinventory.class.php:127 PluginFusioninventoryInventoryComputerInventory->sendCriteria()
  ...fusioninventory/inc/communication.class.php:235 PluginFusioninventoryInventoryComputerInventory->import()
  ...fusioninventory/inc/communication.class.php:463 PluginFusioninventoryCommunication->import()
  plugins/fusioninventory/front/communication.php:93 PluginFusioninventoryCommunication->handleOCSCommunication()
  plugins/fusioninventory/index.php:59               include_once()


Qu'en pensez-vous ?
Merci d'avance pour vos réponses.

Plugins installés
Alertes            1.3.2.5
FusionInventory        9.1+1.1
Injection de fichiers    2.4.2
Plus de rapports    1.3.1
Rapports        1.10
Tableau de bord        0.8.0
Apache/2.2.22 (Debian)
Version du client MySQL: 5.5.54
Version du serveur MySQL: 5.5.54-0+deb7u2-log

2

Re: MySQL query error (Duplicate entry) & PHP Notice(8): Undefined index

Hum, apparement tu aurai deja le même logiciel attaché à l'ordinateur. Il faudrait voir si le logiciel déjà défini est en inventaire automatique ou pas, ça donnerai des pistes wink

3

Re: MySQL query error (Duplicate entry) & PHP Notice(8): Undefined index

Merci !