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 2019-01-21 09:28:21

LukeZ
Guest
Registered: 2011-11-17
Posts: 54

SQL error: : INSERT INTO `glpi_plugin_fusioninventory_dblocksoftwareve

Any ideas about this SQL error?

GLPI 9.3.2 with plugins:
behaviors (2.1.1)
fusioninventory (9.3+1.3)
genericobject (Version: 2.6.2)

SQL-ERROR:
[2019-01-21 08:22:30] glpisqllog.ERROR: DBmysql::query() in C:\xampp\htdocs\helpdesk\inc\dbmysql.class.php line 177
  *** MySQL query error:
  SQL: INSERT INTO `glpi_plugin_fusioninventory_dblocksoftwareversions` (`value`) VALUES ('1')
  Error: Duplicate entry '1' for key 'PRIMARY'
  Backtrace :
  plugins\fusioninventory\inc\dblock.class.php:90   
  ...ventory\inc\inventorycomputerlib.class.php:2867 PluginFusioninventoryDBLock->setLock()
  ...nventory\inc\inventorycomputerlib.class.php:916 PluginFusioninventoryInventoryComputerLib->importSoftware()
  ...ry\inc\inventorycomputerinventory.class.php:538 PluginFusioninventoryInventoryComputerLib->updateComputer()
  ...inventory\inc\inventoryruleimport.class.php:769 PluginFusioninventoryInventoryComputerInventory->rulepassed()
  inc\rule.class.php:1432                            PluginFusioninventoryInventoryRuleImport->executeActions()
  inc\rulecollection.class.php:1464                  Rule->process()
  ...ry\inc\inventorycomputerinventory.class.php:337 RuleCollection->processAllRules()
  ...ry\inc\inventorycomputerinventory.class.php:102 PluginFusioninventoryInventoryComputerInventory->sendCriteria()
  ...fusioninventory\inc\communication.class.php:229 PluginFusioninventoryInventoryComputerInventory->import()
  ...fusioninventory\inc\communication.class.php:461 PluginFusioninventoryCommunication->import()
  plugins\fusioninventory\front\communication.php:93 PluginFusioninventoryCommunication->handleOCSCommunication()
  ...ont\plugin_fusioninventory.communication.php:50 include_once()
  {"user":"27@ASSET2","mem_usage":"0.109\", 4.56Mio)"}

Offline

#2 2019-01-21 16:42:05

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 14,842

Re: SQL error: : INSERT INTO `glpi_plugin_fusioninventory_dblocksoftwareve

This message come from FusionInventory.
I move your post in correct part.


CentOS 6.5 - CentOS 7
PHP 5.6 - PHP 7 - MySQL 5.6  + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

Offline

Board footer

Powered by FluxBB