You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2017-03-13 15:32:24

cremos
Guest
Registered: 2012-08-15
Posts: 46

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

Offline

#2 2017-03-23 08:46:57

ddurieux
Plugins Dev
From: Monsols, France
Registered: 2005-06-17
Posts: 7,520

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


Support / dev / installation / configuration GLPI : [email protected]
DCS : expert GLPI & FusionInventory / Développeur du plugin FusionInventory
IRC #glpi sur freenode.net

Offline

#3 2017-03-24 09:02:24

cremos
Guest
Registered: 2012-08-15
Posts: 46

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

Merci !

Offline

Board footer

Powered by FluxBB