Forums FusionInventory
SQL error on software update - Printable Version

+- Forums FusionInventory (https://forum.fusioninventory.org)
+-- Forum: English (https://forum.fusioninventory.org/forumdisplay.php?fid=3)
+--- Forum: FusionInventory for GLPI - BETA Test (https://forum.fusioninventory.org/forumdisplay.php?fid=12)
+--- Thread: SQL error on software update (/showthread.php?tid=1106)



SQL error on software update - entr04y - 2012-06-29

Clean install of .83 RC1 (latest beta) on glpi 0.83.2

I'm seeing this in the log:

Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Anti-Malware";s:7:"VERSION";s:3:"N/A";s:9:"PUBLISHER";s:24:"Malwarebytes Corpora' at line 2
Backtrace :
/var/www/glpi/plugins/fusinvinventory/inc/lib.class.php :778 DBmysql->query()
/var/www/glpi/plugins/fusinvinventory/inc/lib.class.php :934 PluginFusinvinventoryLib->_serializeIntoDB()
/var/www/glpi/plugins/fusinvinventory/inc/inventory.class.php :803 PluginFusinvinventoryLib->addLibMachineFromGLPI()
/var/www/glpi/plugins/fusinvinventory/inc/lib.class.php :128 PluginFusinvinventoryInventory->createMachineInLib()
/var/www/glpi/plugins/fusinvinventory/inc/inventory.class.php :408 PluginFusinvinventoryLib->startAction()
/var/www/glpi/plugins/fusioninventory/inc/ruleimportequipment.class.php :616 PluginFusinvinventoryInventory->rulepassed()
/var/www/glpi/inc/rule.class.php :781 PluginFusioninventoryRuleImportEquipment->executeActions()
/var/www/glpi/inc/rulecollection.class.php :667 Rule->process()
/var/www/glpi/plugins/fusinvinventory/inc/inventory.class.php :257 RuleCollection->processAllRules()
/var/www/glpi/plugins/fusinvinventory/inc/inventory.class.php :66 PluginFusinvinventoryInventory->sendCriteria()
/var/www/glpi/plugins/fusioninventory/inc/communication.class.php :195 PluginFusinvinventoryInventory->import()
/var/www/glpi/plugins/fusioninventory/inc/communication.class.php :620 PluginFusioninventoryCommunication->import()
/var/www/glpi/plugins/fusioninventory/front/communication.php :84 PluginFusioninventoryCommunication->handleOCSCommunication()
/var/www/glpi/plugins/fusioninventory/front/plugin_fusioninventory.communication.php :47 include_once()
/var/www/glpi/plugins/fusioninventory/front/plugin_fusioninventory.communication.php

The update that is happening is incredibly long, but here are the 5 lines preceding the error:

SOFTWARES/142851<<=>>a:3:{s:4:\"NAME\";s:35:\"UltiDev Cassini Web Server Explorer\";s:7:\"VERSION\";s:5:\"1.0.4\";s:9:\"PUBLISHER\";s:11:\"UltiDev LLC\";}SOFTWARES
SOFTWARES/143031<<=>>a:3:{s:4:\"NAME\";s:42:\"UltiDev Cassini Web Server for ASP.NET 2.0\";s:7:\"VERSION\";s:5:\"1.0.6\";s:9:\"PUBLISHER\";s:11:\"UltiDev LLC\";}SOFTWARES
SOFTWARES/140441<<=>>a:2:{s:4:\"NAME\";s:34:\"Websense Web Security / Web Filter\";s:7:\"VERSION\";s:3:\"N/A\";}SOFTWARES
SOFTWARES/140451<<=>>a:3:{s:4:\"NAME\";s:9:\"Adobe AIR\";s:7:\"VERSION\";s:8:\"1.0.4990\";s:9:\"PUBLISHER\";s:18:\"Adobe Systems Inc.\";}SOFTWARES
SOFTWARES/140481<<=>>a:3:{s:4:\"NAME\";s:11:\"Acrobat.com\";s:7:\"VERSION\";s:7:\"1.1.377\";s:9:\"PUBLISHER\";s:26:\"Adobe Systems Incorporated\";}SOFTWARES
SOFTWARES/142731<<=>>a:3:{s:4:\"NAME\";s:26:\"Malwarebytes\' Anti-Malware\";s:7:\"VERSION\";s:3:\"N/A\";s:9:\"PUBLISHER\";s:24:\"Malwarebytes Corporation\";}SOFTWARES


SQL error on software update - ddurieux - 2012-06-29

Can you send me the XML please ? if possible the XML (saved by agent localy with --local) ?


SQL error on software update - entr04y - 2012-07-02

I'm not sure why, but I think this had to do with corruption in the database. I blew away the server and did a clean install and the problem seems to have gone away.


SQL error on software update - Charliedavid - 2015-10-08

Yes you are right it was due to corruption in database. cheers


SQL error on software update - burcestoof - 2016-03-29

Some Time Error i Can't handle in SQL I am Sure That My Code Is correct I Try again again but not access......

website design and development


SQL error on software update - momentumm - 2017-06-21

Very useful information mentioned shared in this article. Thanks for sharing.

Real Estate Property management


SQL error on software update - ShemtovSystems - 2017-12-19

Awesome post shared here. Thanks for sharing such a useful article.

Furnace installation