{"action":"opened","issue":{"url":"https://api.github.com/repos/fusioninventory/fusioninventory-for-glpi/issues/690","labels_url":"https://api.github.com/repos/fusioninventory/fusioninventory-for-glpi/issues/690/labels{/name}","comments_url":"https://api.github.com/repos/fusioninventory/fusioninventory-for-glpi/issues/690/comments","events_url":"https://api.github.com/repos/fusioninventory/fusioninventory-for-glpi/issues/690/events","html_url":"https://github.com/fusioninventory/fusioninventory-for-glpi/issues/690","id":109029176,"number":690,"title":"Error sql in rule import equipment","user":{"login":"ddurieux","id":239744,"avatar_url":"https://avatars.githubusercontent.com/u/239744?v=3","gravatar_id":"","url":"https://api.github.com/users/ddurieux","html_url":"https://github.com/ddurieux","followers_url":"https://api.github.com/users/ddurieux/followers","following_url":"https://api.github.com/users/ddurieux/following{/other_user}","gists_url":"https://api.github.com/users/ddurieux/gists{/gist_id}","starred_url":"https://api.github.com/users/ddurieux/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ddurieux/subscriptions","organizations_url":"https://api.github.com/users/ddurieux/orgs","repos_url":"https://api.github.com/users/ddurieux/repos","events_url":"https://api.github.com/users/ddurieux/events{/privacy}","received_events_url":"https://api.github.com/users/ddurieux/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/fusioninventory/fusioninventory-for-glpi/milestones/27","html_url":"https://github.com/fusioninventory/fusioninventory-for-glpi/milestones/0.80+1.2","labels_url":"https://api.github.com/repos/fusioninventory/fusioninventory-for-glpi/milestones/27/labels","id":1330290,"number":27,"title":"0.80+1.2","description":null,"creator":{"login":"ddurieux","id":239744,"avatar_url":"https://avatars.githubusercontent.com/u/239744?v=3","gravatar_id":"","url":"https://api.github.com/users/ddurieux","html_url":"https://github.com/ddurieux","followers_url":"https://api.github.com/users/ddurieux/followers","following_url":"https://api.github.com/users/ddurieux/following{/other_user}","gists_url":"https://api.github.com/users/ddurieux/gists{/gist_id}","starred_url":"https://api.github.com/users/ddurieux/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ddurieux/subscriptions","organizations_url":"https://api.github.com/users/ddurieux/orgs","repos_url":"https://api.github.com/users/ddurieux/repos","events_url":"https://api.github.com/users/ddurieux/events{/privacy}","received_events_url":"https://api.github.com/users/ddurieux/received_events","type":"User","site_admin":false},"open_issues":1,"closed_issues":8,"state":"open","created_at":"2015-09-30T00:53:36Z","updated_at":"2015-09-30T07:02:55Z","due_on":null,"closed_at":null},"comments":0,"created_at":"2015-09-30T07:02:55Z","updated_at":"2015-09-30T07:02:55Z","closed_at":null,"body":"---\n\n\nAuthor Name: **DuyLong LE** (DuyLong LE)\nOriginal Redmine Issue: 1320, http://forge.fusioninventory.org/issues/1320\nOriginal Date: 2011-11-02\n\n\n---\n\n```\r\n*** MySQL query error :\r\n***\r\nSQL: SELECT `glpi_computers`.`id`\r\n                      FROM `glpi_computers` LEFT JOIN `glpi_networkports`\r\n                  ON (`glpi_computers`.`id` = `glpi_networkports`.`items_id`\r\n                      AND `glpi_networkports`.`itemtype` = \\'Computer\\')\r\n                      WHERE  `glpi_computers`.`is_template` = \\'0\\'  AND `glpi_networkports`.`ip` IN 192.168.0.197)\r\n                      GROUP BY `glpi_computers`.`id`\r\n                      ORDER BY `glpi_computers`.`is_deleted` ASC\r\n\r\nError: 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 '192.168.0.197)\r\n                      GROUP BY `glpi_computers`.`id`\r\n             ' at line 5\r\nBacktrace :\r\n/usr/share/glpi/plugins/fusioninventory/inc/ruleimportequipment.class.php&nbsp;:505   DBmysql->query()\r\n/usr/share/glpi/inc/rule.class.php&nbsp;:826    PluginFusioninventoryRuleImportEquipment->findWithGlobalCriteria()\r\n/usr/share/glpi/inc/rule.class.php&nbsp;:769    Rule->checkCriterias()\r\n/usr/share/glpi/inc/rulecollection.class.php&nbsp;:668    Rule->process()\r\n/usr/share/glpi/plugins/fusinvsnmp/inc/communicationnetdiscovery.class.php&nbsp;:178    RuleCollection->processAllRules()\r\n/usr/share/glpi/plugins/fusinvsnmp/inc/importexport.class.php&nbsp;:425   PluginFusinvsnmpCommunicationNetDiscovery->sendCriteria()\r\n/usr/share/glpi/plugins/fusinvsnmp/inc/communicationnetdiscovery.class.php&nbsp;:93   PluginFusinvsnmpImportExport->import_netdiscovery()\r\n/usr/share/glpi/plugins/fusioninventory/inc/communication.class.php&nbsp;:175   PluginFusinvsnmpCommunicationNetDiscovery->import()\r\n/usr/share/glpi/plugins/fusioninventory/front/communication.php&nbsp;:172   PluginFusioninventoryCommunication->import()\r\n/usr/share/glpi/plugins/fusioninventory/index.php&nbsp;:44    include_once()\r\n/usr/share/glpi/plugins/fusioninventory/index.php\r\n\n```\r\n\n\n\n"}}