{"action":"created","issue":{"url":"https://api.github.com/repos/pluginsGLPI/fields/issues/137","repository_url":"https://api.github.com/repos/pluginsGLPI/fields","labels_url":"https://api.github.com/repos/pluginsGLPI/fields/issues/137/labels{/name}","comments_url":"https://api.github.com/repos/pluginsGLPI/fields/issues/137/comments","events_url":"https://api.github.com/repos/pluginsGLPI/fields/issues/137/events","html_url":"https://github.com/pluginsGLPI/fields/issues/137","id":199223448,"number":137,"title":"probleme import FusionInventory","user":{"login":"alex8276","id":24961561,"avatar_url":"https://avatars.githubusercontent.com/u/24961561?v=3","gravatar_id":"","url":"https://api.github.com/users/alex8276","html_url":"https://github.com/alex8276","followers_url":"https://api.github.com/users/alex8276/followers","following_url":"https://api.github.com/users/alex8276/following{/other_user}","gists_url":"https://api.github.com/users/alex8276/gists{/gist_id}","starred_url":"https://api.github.com/users/alex8276/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/alex8276/subscriptions","organizations_url":"https://api.github.com/users/alex8276/orgs","repos_url":"https://api.github.com/users/alex8276/repos","events_url":"https://api.github.com/users/alex8276/events{/privacy}","received_events_url":"https://api.github.com/users/alex8276/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":6,"created_at":"2017-01-06T15:47:05Z","updated_at":"2017-01-10T11:16:32Z","closed_at":null,"body":"Hello,\r\nWhen the plugin is enabled, importing of xml files fusioninventory crash.\r\nThere is no problem when the inventory is made by the agent.\r\n\r\nI use GLPI 9.1.1 - Fields 1.4.3 - debian 8 - PHP 5.6\r\n\r\nlog mysql \r\n`  *** MySQL query error:\r\n  SQL: SELECT *\r\n                FROM `glpi_plugin_fields_fields` WHERE plugin_fields_containers_id =\r\n  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 '' at line 2\r\n  Backtrace :\r\n  inc/commondbtm.class.php:263\r\n  plugins/fields/inc/container.class.php:904         CommonDBTM->find()\r\n  plugins/fields/inc/container.class.php:746         PluginFieldsContainer::validateValues()\r\n  plugins/fields/inc/container.class.php:1043        PluginFieldsContainer->updateFieldsValues()\r\n  :                                                  PluginFieldsContainer::postItemAdd()\r\n  inc/plugin.class.php:1125                          call_user_func()\r\n  inc/commondbtm.class.php:885                       Plugin::doHook()\r\n  ...ry/inc/inventorycomputerinventory.class.php:520 CommonDBTM->add()\r\n  ...inventory/inc/inventoryruleimport.class.php:801 PluginFusioninventoryInventoryComputerInventory->rulepassed()\r\n  inc/rule.class.php:1427                            PluginFusioninventoryInventoryRuleImport->executeActions()\r\n  inc/rulecollection.class.php:1459                  Rule->process()\r\n  ...ry/inc/inventorycomputerinventory.class.php:375 RuleCollection->processAllRules()\r\n  ...ry/inc/inventorycomputerinventory.class.php:127 PluginFusioninventoryInventoryComputerInventory->sendCriteria()\r\n  ...fusioninventory/inc/communication.class.php:235 PluginFusioninventoryInventoryComputerInventory->import()\r\n  ...fusioninventory/inc/communication.class.php:463 PluginFusioninventoryCommunication->import()\r\n  ...ventory/front/inventorycomputerimportxml.php:97 PluginFusioninventoryCommunication->handleOCSCommunication()`\r\n\r\nlog PHP\r\n`2017-01-06 15:37:29 [2@srv-glpi]\r\n  *** PHP Notice(8): Undefined index: plugin_fields_containers_id\r\n  Backtrace :\r\n  plugins/fields/inc/container.class.php:900\r\n  plugins/fields/inc/container.class.php:746         PluginFieldsContainer::validateValues()\r\n  plugins/fields/inc/container.class.php:1043        PluginFieldsContainer->updateFieldsValues()\r\n  :                                                  PluginFieldsContainer::postItemAdd()\r\n  inc/plugin.class.php:1125                          call_user_func()\r\n  inc/commondbtm.class.php:885                       Plugin::doHook()\r\n  ...ry/inc/inventorycomputerinventory.class.php:520 CommonDBTM->add()\r\n  ...inventory/inc/inventoryruleimport.class.php:801 PluginFusioninventoryInventoryComputerInventory->rulepassed()\r\n  inc/rule.class.php:1427                            PluginFusioninventoryInventoryRuleImport->executeActions()\r\n  inc/rulecollection.class.php:1459                  Rule->process()\r\n  ...ry/inc/inventorycomputerinventory.class.php:375 RuleCollection->processAllRules()\r\n  ...ry/inc/inventorycomputerinventory.class.php:127 PluginFusioninventoryInventoryComputerInventory->sendCriteria()\r\n  ...fusioninventory/inc/communication.class.php:235 PluginFusioninventoryInventoryComputerInventory->import()\r\n  ...fusioninventory/inc/communication.class.php:463 PluginFusioninventoryCommunication->import()\r\n  ...ventory/front/inventorycomputerimportxml.php:97 PluginFusioninventoryCommunication->handleOCSCommunication()\r\n2017-01-06 15:37:29 [2@srv-glpi]\r\n  *** PHP Notice(8): Undefined index: plugin_fields_containers_id\r\n  Backtrace :\r\n  plugins/fields/inc/container.class.php:904\r\n  plugins/fields/inc/container.class.php:746         PluginFieldsContainer::validateValues()\r\n  plugins/fields/inc/container.class.php:1043        PluginFieldsContainer->updateFieldsValues()\r\n  :                                                  PluginFieldsContainer::postItemAdd()\r\n  inc/plugin.class.php:1125                          call_user_func()\r\n  inc/commondbtm.class.php:885                       Plugin::doHook()\r\n  ...ry/inc/inventorycomputerinventory.class.php:520 CommonDBTM->add()\r\n  ...inventory/inc/inventoryruleimport.class.php:801 PluginFusioninventoryInventoryComputerInventory->rulepassed()\r\n  inc/rule.class.php:1427                            PluginFusioninventoryInventoryRuleImport->executeActions()\r\ninc/rulecollection.class.php:1459                  Rule->process()\r\n  ...ry/inc/inventorycomputerinventory.class.php:375 RuleCollection->processAllRules()\r\n  ...ry/inc/inventorycomputerinventory.class.php:127 PluginFusioninventoryInventoryComputerInventory->sendCriteria()\r\n  ...fusioninventory/inc/communication.class.php:235 PluginFusioninventoryInventoryComputerInventory->import()\r\n  ...fusioninventory/inc/communication.class.php:463 PluginFusioninventoryCommunication->import()\r\n  ...ventory/front/inventorycomputerimportxml.php:97 PluginFusioninventoryCommunication->handleOCSCommunication()\r\n2017-01-06 15:37:29 [2@srv-glpi]\r\n  *** PHP Notice(8): Undefined index: name\r\n  Backtrace :\r\n  plugins/fields/inc/container.class.php:756\r\n  plugins/fields/inc/container.class.php:1043        PluginFieldsContainer->updateFieldsValues()\r\n  :                                                  PluginFieldsContainer::postItemAdd()\r\n  inc/plugin.class.php:1125                          call_user_func()\r\n  inc/commondbtm.class.php:885                       Plugin::doHook()\r\n  ...ry/inc/inventorycomputerinventory.class.php:520 CommonDBTM->add()\r\n  ...inventory/inc/inventoryruleimport.class.php:801 PluginFusioninventoryInventoryComputerInventory->rulepassed()\r\n  inc/rule.class.php:1427                            PluginFusioninventoryInventoryRuleImport->executeActions()\r\n  inc/rulecollection.class.php:1459                  Rule->process()\r\n  ...ry/inc/inventorycomputerinventory.class.php:375 RuleCollection->processAllRules()\r\n  ...ry/inc/inventorycomputerinventory.class.php:127 PluginFusioninventoryInventoryComputerInventory->sendCriteria()\r\n  ...fusioninventory/inc/communication.class.php:235 PluginFusioninventoryInventoryComputerInventory->import()\r\n  ...fusioninventory/inc/communication.class.php:463 PluginFusioninventoryCommunication->import()\r\n  ...ventory/front/inventorycomputerimportxml.php:97 PluginFusioninventoryCommunication->handleOCSCommunication()\r\n`\r\n\r\nThanks"},"comment":{"url":"https://api.github.com/repos/pluginsGLPI/fields/issues/comments/271550035","html_url":"https://github.com/pluginsGLPI/fields/issues/137#issuecomment-271550035","issue_url":"https://api.github.com/repos/pluginsGLPI/fields/issues/137","id":271550035,"user":{"login":"alex8276","id":24961561,"avatar_url":"https://avatars.githubusercontent.com/u/24961561?v=3","gravatar_id":"","url":"https://api.github.com/users/alex8276","html_url":"https://github.com/alex8276","followers_url":"https://api.github.com/users/alex8276/followers","following_url":"https://api.github.com/users/alex8276/following{/other_user}","gists_url":"https://api.github.com/users/alex8276/gists{/gist_id}","starred_url":"https://api.github.com/users/alex8276/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/alex8276/subscriptions","organizations_url":"https://api.github.com/users/alex8276/orgs","repos_url":"https://api.github.com/users/alex8276/repos","events_url":"https://api.github.com/users/alex8276/events{/privacy}","received_events_url":"https://api.github.com/users/alex8276/received_events","type":"User","site_admin":false},"created_at":"2017-01-10T11:16:32Z","updated_at":"2017-01-10T11:16:32Z","body":"yes i have one fields but not required"}}
{"actor":{"display_login":"alex8276"}}