Forum GLPI-Project

jros

Member

Registered: 2023-01-19

Posts: 8

SQL Error importing a xml file

I have seen this error in sql-errors.log running in debug mode:

[2023-03-30 11:51:07] glpisqllog.WARNING: DBmysql::query() in /var/www/glpi/src/DBmysql.php line 404
  *** MySQL query warnings:
  SQL: UPDATE `glpi_plugin_fusioninventory_inventorycomputercomputers` SET `last_fusioninventory_update` = '2023-03-30 11:51:07', `remote_addr` = '10.51.79.21', `serialized_inventory` = 'x▒▒V▒n▒6▒B}i▒▒A]m+/▒:▒m▒$▒▒\\\\▒>▒D▒D$R%){▒A>▒_▒▒P\\\"▒▒▒▒ l▒3gngH▒ N▒U:M▒▒▒▒FS▒]▒ԏ▒0J=N*▒]▒_▒▒T
▒Z▒»`p▒;n\\Z▒[▒a▒zQ4▒
▒`1▒▒b▒▒▒▒▒x4].▒y4▒▒p>3▒>N▒BT▒▒b▒`▒\\\"▒Y▒\\\\7▒▒kf\\\'▒▒[▒▒(h▒N▒!\\\\l▒▒▒|
▒o▒D▒Q▒▒▒@t▒▒▒M▒▒ģ▒ \\Z▒▒S▒▒h▒▒,▒▒Gj▒▒D ▒▒|▒j▒z▒▒gJK▒cjU ▒,77}▒Z▒ckU▒▒▒▒▒▒▒N▒▒▒VPξ▒{▒o▒(ņQ▒▒▒/▒K~▒      ▒▒▒▒Ы▒
▒▒▒>F▒_▒▒I▒n▒▒▒Z▒C▒넉i▒▒J▒ߨ▒ҴZA▒4)K     ^▒Q▒▒▒▒▒▒vɞq▒▒pȅ▒       ▒▒▒▒▒\\0Z▒W\\\'PVM▒▒\\0?▒A8▒▒(B▒▒O\\\\ؒVB▒)\\n▒D>▒▒x2\\r▒u▒      ▒O▒▒x
▒R▒▒0▒T▒▒▒!8{▒▒▒LA▒:\\\'2߂ᶂG]▒0y▒▒▒▒A▒▒^▒▒E▒▒#▒;▒Ӛ▒ONN4▒▒▒ߧ▒(▒▒c▒t▒l▒▒h7׮▒▒Q▒▒M▒\\r▒{&*Z0=▒▒▒▒ڮ▒ȩR▒▒▒▒▒▒緧ߟ%▒▒Ul▒▒▒k
                                                                                                                        ▒+▒i▒▒_▒Tp▒▒▒▒(H▒v▒c▒?▒▒▒v▒Zҿ\\Z▒▒▒\\0c▒u▒ͳ\\\\@▒▒h▒▒▒▒魤▒▒tc▒▒3NO▒::^tM▒RtLvL▒▒▒▒`R▒▒$▒▒▒▒▒Fx▒▒▒▒aؕ▒f▒▒▒I̟\\Z~▒i▒▒Et&▒▒▒2▒A▒\\Z▒▒▒▒▒+▒▒Y▒▒▒?▒{▒\\Zw▒ø▒▒        T▒v▒T▒▒/▒▒▒?޲<▒A/&▒^-[▒▒7p▒▒U▒▒?▒Qx▒1▒▒꽐O▒A▒▒p▒hx1▒\\Z~5{I▒▒▒▒▒▒▒▒Iݐ▒\\\"▒H▒C▒}▒L=\\r▒▒▒k!▒▒▒▒▒▒Yuhi▒\\r▒▒]▒>▒▒q\\Z▒_▒N▒4▒▒l▒^
O^▒+▒6▒F▒▒H▒▒q<v▒▒J▒▒#b▒׆l6▒;▒▒▒Ժ▒▒L▒m▒▒MLrg▒
j8▒5▒.:▒Y[▒▒iF▒▒n▒▒|▒▒8▒ΓM6▒▒▒SӠMfU,B3j@▒▒i▒▒=▒)=▒r˿▒▒sR▒{Y\\0 V▒▒▒▒kD▒9▒E▒КNq▒N▒       ▒▒b▒▒f▒i▒gQaz▒▒-0▒Шa7▒▒▒▒bЊ▒▒=▒▒▒!▒,r-▒@VK▒▒5!PX▒▒▒▒▒▒*▒L6\\\'▒f▒|▒▒▒\\0B.▒{L=▒ ▒/▒n▒n?|▒▒P▒▒▒▒o▒6▒▒▒▒▒▒▒▒▒▒r▒rzi▒gL▒▒c▒▒▒w n▒%x▒▒#?p/dz▒▒wmi׭u▒▒▒▒▒?(▒7 ▒▒<5▒ֆQ\\\\B^▒▒▒▒' WHERE `id` = '9'
  Warnings:
1300: Invalid utf8mb4 character string: '9C9D56'
  Backtrace :
  src/DBmysql.php:1439
  src/CommonDBTM.php:685                             DBmysql->update()
  src/CommonDBTM.php:1681                            CommonDBTM->updateInDB()
  ...nventory/inc/inventorycomputerlib.class.php:292 CommonDBTM->update()
  ...ry/inc/inventorycomputerinventory.class.php:564 PluginFusioninventoryInventoryComputerLib->updateComputer()
  ...inventory/inc/inventoryruleimport.class.php:968 PluginFusioninventoryInventoryComputerInventory->rulepassed()
  src/Rule.php:1522                                  PluginFusioninventoryInventoryRuleImport->executeActions()
  src/RuleCollection.php:1626                        Rule->process()
  ...ry/inc/inventorycomputerinventory.class.php:346 RuleCollection->processAllRules()
  ...ry/inc/inventorycomputerinventory.class.php:102 PluginFusioninventoryInventoryComputerInventory->sendCriteria()
  ...fusioninventory/inc/communication.class.php:227 PluginFusioninventoryInventoryComputerInventory->import()
  ...fusioninventory/inc/communication.class.php:461 PluginFusioninventoryCommunication->import()
  ...ventory/front/inventorycomputerimportxml.php:93 PluginFusioninventoryCommunication->handleOCSCommunication()
  {"user":"473@SUInventario"}

How to solve it?

---

Using GLPI 10.0.6
Fusion Inventory 10.0.6+1.1

Serega.CIT

Member

Registered: 2023-07-12

Posts: 2

Re: SQL Error importing a xml file

Same problem.
FILE /glpi/files/_log/sql-errors.log -- Dramatically growing!!
(c) _https://github.com/fusioninventory/fusioninventory-for-glpi/issues/3439

Last edited by Serega.CIT (2023-07-13 08:25:10)