ddurieux
commented
9 years ago Original Redmine Comment Author Name: Konstantin KABASSANOV (Konstantin KABASSANOV) Original Date: 2015-01-16T16:49:41Z
Konstantin KABASSANOV wrote:
2015-01-05 18:01:13 [9498@toto.lip6.fr] *\ MySQL query error: SQL: UPDATE
glpi_plugin_fusioninventory_printersSETserialized_inventory= \'xeR]Ú0ü+ÈÏ Å!Ä¼Ë ª#ÞkäK ãСA5í¦ULõ{×&¡É5O»;³³»SOMbv 0Ô_YPÃ¥Ðù ÃZR=[ó â%Zj2\'± h \"GÀ@µT×\\ó?¬Ã¢ onî+Ô²dÕ 9ôl$hͺðµä. .ͧÓZeëCý8öûÒ|À.pz.×yyQ^ %\'ØVáza9³M;pÓdtÃjsmÜÜ¡a°$ »ª=sñÜjð îê[O§¯ºdºp} Ȭwô¸N÷Yz¼7³4{ÛÆ/©~6R{<\0 § Ê(^ähÞýô¹u/Æ÷l¹,ì2첤˺16ôÌ ÙZ×´{Î7»Etn¤¹ÿGxIº·ô È߬·vÖG9îËFæ#{0]P!Xù?ÝÍÍÝ }áî(MÿFcÑB6× 5GH4aáXñß¡Ûí/ä4Å\' WHEREid=\'143\' Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '?{?&??5O?;???S?OMb?v? ?СA5???UL? ?ZR?=[? ?%Zj2'??0?_YPÃ¥?? h "G?@`?T?\' at line 2 Backtrace : inc/commondbtm.class.php:353 inc/commondbtm.class.php:1103 CommonDBTM->updateInDB() ...inc/communicationnetworkdiscovery.class.php:688 CommonDBTM->update() ...inc/communicationnetworkdiscovery.class.php:568 PluginFusioninventoryCommunicationNetworkDiscovery->_updateSNMPInfo() ...inc/communicationnetworkdiscovery.class.php:362 PluginFusioninventoryCommunicationNetworkDiscovery->importDevice() ...inventory/inc/inventoryruleimport.class.php:700 PluginFusioninventoryCommunicationNetworkDiscovery->rulepassed() inc/rule.class.php:1402 PluginFusioninventoryInventoryRuleImport->executeActions() inc/rulecollection.class.php:1452 Rule->process() ...inc/communicationnetworkdiscovery.class.php:236 RuleCollection->processAllRules() ...ventory/inc/snmpmodelimportexport.class.php:555 PluginFusioninventoryCommunicationNetworkDiscovery->sendCriteria() ...inc/communicationnetworkdiscovery.class.php:102 PluginFusioninventorySnmpmodelImportExport->import_netdiscovery() ...fusioninventory/inc/communication.class.php:222 PluginFusioninventoryCommunicationNetworkDiscovery->import() ...fusioninventory/inc/communication.class.php:452 PluginFusioninventoryCommunication->import() plugins/fusioninventory/front/communication.php:85 PluginFusioninventoryCommunication->handleOCSCommunication() plugins/fusioninventory/index.php:50 include_once()
I suggest (English speaking this time ;)) to replace:
--- downloads/fusioninventory/inc/communicationnetworkdiscovery.class.php 2014-12-04 14:31:07.000000000 +0100 +++ inc/communicationnetworkdiscovery.class.php 2015-01-15 20:15:02.905638143 +0100
@@ -662,7 +665,9 @@ class PluginFusioninventoryCommunication
$instances = $class->find("$key_field='$id'");
$input = array();
if (count($instances) > 0) {
- $input = current($instances); +// $input = current($instances);
- $input = Toolbox::addslashes_deep(current($instances)); } else { $input[$key_field] = $id; $id = $class->add($input);
Author Name: Konstantin KABASSANOV (Konstantin KABASSANOV) Original Redmine Issue: 2853, http://forge.fusioninventory.org/issues/2853 Original Date: 2015-01-05 Original Assignee: David Durieux
2015-01-05 18:01:13 [9498@toto.lip6.fr] *\ MySQL query error: SQL: UPDATE
glpi_plugin_fusioninventory_printersSETserialized_inventory= \'xeR]Ú0ü+ÈÏ Å!Ä¼Ë ª#ÞkäK ãСA5í¦ULõ{×&¡É5O»;³³»SOMbv 0Ô_YPÃ¥Ðù ÃZR=[ó â%Zj2\'± h \"GÀ@µT×\\ó?¬Ã¢ onî+Ô²dÕ 9ôl$hͺðµä. .ͧÓZeëCý8öûÒ|À.pz.×yyQ^ %\'ØVáza9³M;pÓdtÃjsmÜÜ¡a°$ »ª=sñÜjð îê[O§¯ºdºp} Ȭwô¸N÷Yz¼7³4{ÛÆ/©~6R{<\0 § Ê(^ähÞýô¹u/Æ÷l¹,ì2첤˺16ôÌ ÙZ×´{Î7»Etn¤¹ÿGxIº·ô È߬·vÖG9îËFæ#{0]P!Xù?ÝÍÍÝ }áî(MÿFcÑB6× 5GH4aáXñß¡Ûí/ä4Å\' WHEREid=\'143\' Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '?{?&??5O?;???S?OMb?v? ?СA5???UL? ?ZR?=[? ?%Zj2'??0?_YPÃ¥?? h "G?@`?T?\' at line 2 Backtrace : inc/commondbtm.class.php:353 inc/commondbtm.class.php:1103 CommonDBTM->updateInDB() ...inc/communicationnetworkdiscovery.class.php:688 CommonDBTM->update() ...inc/communicationnetworkdiscovery.class.php:568 PluginFusioninventoryCommunicationNetworkDiscovery->_updateSNMPInfo() ...inc/communicationnetworkdiscovery.class.php:362 PluginFusioninventoryCommunicationNetworkDiscovery->importDevice() ...inventory/inc/inventoryruleimport.class.php:700 PluginFusioninventoryCommunicationNetworkDiscovery->rulepassed() inc/rule.class.php:1402 PluginFusioninventoryInventoryRuleImport->executeActions() inc/rulecollection.class.php:1452 Rule->process() ...inc/communicationnetworkdiscovery.class.php:236 RuleCollection->processAllRules() ...ventory/inc/snmpmodelimportexport.class.php:555 PluginFusioninventoryCommunicationNetworkDiscovery->sendCriteria() ...inc/communicationnetworkdiscovery.class.php:102 PluginFusioninventorySnmpmodelImportExport->import_netdiscovery() ...fusioninventory/inc/communication.class.php:222 PluginFusioninventoryCommunicationNetworkDiscovery->import() ...fusioninventory/inc/communication.class.php:452 PluginFusioninventoryCommunication->import() plugins/fusioninventory/front/communication.php:85 PluginFusioninventoryCommunication->handleOCSCommunication() plugins/fusioninventory/index.php:50 include_once()