Forum GLPI-Project

LukeZ

Member

Registered: 2011-11-17

Posts: 58

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)"}

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

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.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

thomasravail0101

Member

Registered: 2016-10-18

Posts: 101

Re: SQL error: : INSERT INTO `glpi_plugin_fusioninventory_dblocksoftwareve

Bonjour,

Je rencontre actuellement le même problème.

Une idée de solution ?

GLPI 9.2.4
FusionPlugin : 9.2 +2.1
FusionAgent : 2.3.21

Merci pour votre aide.

Insshin

Member

Registered: 2019-04-10

Posts: 14

Re: SQL error: : INSERT INTO `glpi_plugin_fusioninventory_dblocksoftwareve

Bonjour,

Je rencontre actuellement le même problème.

Une idée de solution ?

GLPI 9.2.4
FusionPlugin : 9.2 +2.1
FusionAgent : 2.3.21

Merci pour votre aide.

change de version du plugin FI, passe en 9.4+1.1 cela pourrai régler ton problème

thomasravail0101

Member

Registered: 2016-10-18

Posts: 101

Re: SQL error: : INSERT INTO `glpi_plugin_fusioninventory_dblocksoftwareve

Bonjour,

La version 9.4+1.1 n'est pas compatible avec GLPI 9.2.4.
Je ne peux pas monter en version sur GLPI..

Merci en tout cas