{"action":"created","issue":{"url":"https://api.github.com/repos/fusioninventory/fusioninventory-for-glpi/issues/1536","labels_url":"https://api.github.com/repos/fusioninventory/fusioninventory-for-glpi/issues/1536/labels{/name}","comments_url":"https://api.github.com/repos/fusioninventory/fusioninventory-for-glpi/issues/1536/comments","events_url":"https://api.github.com/repos/fusioninventory/fusioninventory-for-glpi/issues/1536/events","html_url":"https://github.com/fusioninventory/fusioninventory-for-glpi/issues/1536","id":109197172,"number":1536,"title":"SQL error during field unlock ","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":[{"url":"https://api.github.com/repos/fusioninventory/fusioninventory-for-glpi/labels/Category:%20Locks","name":"Category: Locks","color":"ededed"},{"url":"https://api.github.com/repos/fusioninventory/fusioninventory-for-glpi/labels/Component:%20For%20junior%20contributor","name":"Component: For junior contributor","color":"ededed"},{"url":"https://api.github.com/repos/fusioninventory/fusioninventory-for-glpi/labels/Component:%20Found%20in%20version","name":"Component: Found in version","color":"ededed"},{"url":"https://api.github.com/repos/fusioninventory/fusioninventory-for-glpi/labels/Priority:%20Normal","name":"Priority: Normal","color":"ededed"},{"url":"https://api.github.com/repos/fusioninventory/fusioninventory-for-glpi/labels/Status:%20Closed","name":"Status: Closed","color":"ededed"},{"url":"https://api.github.com/repos/fusioninventory/fusioninventory-for-glpi/labels/Tracker:%20Bug","name":"Tracker: Bug","color":"ededed"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/fusioninventory/fusioninventory-for-glpi/milestones/48","html_url":"https://github.com/fusioninventory/fusioninventory-for-glpi/milestones/0.84+3.5","labels_url":"https://api.github.com/repos/fusioninventory/fusioninventory-for-glpi/milestones/48/labels","id":1332128,"number":48,"title":"0.84+3.5","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":19,"state":"open","created_at":"2015-09-30T21:27:49Z","updated_at":"2015-09-30T22:55:01Z","due_on":null,"closed_at":null},"comments":2,"created_at":"2015-09-30T22:55:01Z","updated_at":"2015-09-30T22:55:06Z","closed_at":null,"body":"---\n\n\nAuthor Name: **Walid Nouh** (@wawax)\nOriginal Redmine Issue: 2755, http://forge.fusioninventory.org/issues/2755\nOriginal Date: 2014-10-20\nOriginal Assignee: David Durieux\n\n---\n\nPlugin FI 0.84+3.3\r\n\r\nWhen I unlock OS from a massive action, I got the following SQL error:\r\n\r\n```\r\n==> sql-errors.log <==\r\n2014-10-20 10:24:03\r\n*** MySQL query error: \r\n***\r\nSQL: UPDATE `glpi_computers`\r\n                       SET `comment` = \\'Ordinateur cédé à l\\'association xxxx le xx/yy/zz\\' WHERE `id` =\\'2979\\'\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 'association xxxx le xx/yy/zz' WHERE `id` ='2979'' at line 2\r\nBacktrace :\r\n/var/www/glpi/inc/commondbtm.class.php&nbsp;:335                DBmysql->query()\r\n/var/www/glpi/inc/commondbtm.class.php&nbsp;:1046               CommonDBTM->updateInDB()\r\n/var/www/glpi/plugins/fusioninventory/inc/lock.class.php&nbsp;:569              CommonDBTM->update()\r\n&nbsp;:         PluginFusioninventoryLock::deleteLock()\r\n/var/www/glpi/inc/plugin.class.php&nbsp;:1049           call_user_func()\r\n/var/www/glpi/inc/commondbtm.class.php&nbsp;:1048               Plugin::doHook()\r\n/var/www/glpi/plugins/fusioninventory/inc/lock.class.php&nbsp;:386              CommonDBTM->update()\r\n/var/www/glpi/plugins/fusioninventory/hook.php&nbsp;:1208               PluginFusioninventoryLock::setLockArray()\r\n&nbsp;:         plugin_fusioninventory_MassiveActionsProcess()\r\n/var/www/glpi/inc/plugin.class.php&nbsp;:1120           call_user_func()\r\n/var/www/glpi/inc/commondbtm.class.php&nbsp;:3364               Plugin::doOneHook()\r\n/var/www/glpi/front/massiveaction.php&nbsp;:116         CommonDBTM->doMassiveActions()\r\n/var/www/glpi/front/massiveaction.php\r\n\r\n\n```\n\n\n"},"comment":{"url":"https://api.github.com/repos/fusioninventory/fusioninventory-for-glpi/issues/comments/144568731","html_url":"https://github.com/fusioninventory/fusioninventory-for-glpi/issues/1536#issuecomment-144568731","issue_url":"https://api.github.com/repos/fusioninventory/fusioninventory-for-glpi/issues/1536","id":144568731,"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},"created_at":"2015-09-30T22:55:06Z","updated_at":"2015-09-30T22:55:06Z","body":"---\n\nOriginal Redmine Comment\nAuthor Name: **David Durieux** (@ddurieux)\nOriginal Date: 2014-10-25T15:45:13Z\n\n---\n\nApplied in changeset commit:c8931062f0c3c89be16bd5e8c75125290310edf8."}}