{"action":"created","issue":{"url":"https://api.github.com/repos/sipcapture/homer-api/issues/33","labels_url":"https://api.github.com/repos/sipcapture/homer-api/issues/33/labels{/name}","comments_url":"https://api.github.com/repos/sipcapture/homer-api/issues/33/comments","events_url":"https://api.github.com/repos/sipcapture/homer-api/issues/33/events","html_url":"https://github.com/sipcapture/homer-api/issues/33","id":99201023,"number":33,"title":"homer-api update admin node fails with sql error","user":{"login":"00Asgaroth00","id":13218073,"avatar_url":"https://avatars.githubusercontent.com/u/13218073?v=3","gravatar_id":"","url":"https://api.github.com/users/00Asgaroth00","html_url":"https://github.com/00Asgaroth00","followers_url":"https://api.github.com/users/00Asgaroth00/followers","following_url":"https://api.github.com/users/00Asgaroth00/following{/other_user}","gists_url":"https://api.github.com/users/00Asgaroth00/gists{/gist_id}","starred_url":"https://api.github.com/users/00Asgaroth00/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/00Asgaroth00/subscriptions","organizations_url":"https://api.github.com/users/00Asgaroth00/orgs","repos_url":"https://api.github.com/users/00Asgaroth00/repos","events_url":"https://api.github.com/users/00Asgaroth00/events{/privacy}","received_events_url":"https://api.github.com/users/00Asgaroth00/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-08-05T13:06:13Z","updated_at":"2015-08-05T13:13:17Z","closed_at":null,"body":"Hi,\r\n\r\nI am trying to update the default admin node from the web-ui and am getting the following error when clicking the \"save changes\" button, it apprears that you have a \"like\" command in an update staement somewhere:\r\n\r\n```\r\n2015/08/05 14:01:13 [error] 5415#0: *74 FastCGI sent in stderr: \"PHP message: Fail to execute query: [UPDATE node SET status = '1', host = '127.0.0.1', dbname = 'homer_data', dbport = '3306', dbusername = 'homer', dbpassword like 'password', dbtables = 'sip_capture', name = 'homer01' WHERE id=1]\r\nPHP message: Array\r\n(\r\n    [0] => 42000\r\n    [1] => 1064\r\n    [2] => 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 'like 'password', dbtables = 'sip_capture', name = 'homer01' WHERE id=1' at line 1\r\n)\" while reading response header from upstream, client: 10.6.0.25, server: trace_node, request: \"POST /api/admin/node/edit HTTP/1.1\", upstream: \"fastcgi://127.0.0.1:9000\", host: \"capture_node\", referrer: \"http://capture_node/\"\r\n```"},"comment":{"url":"https://api.github.com/repos/sipcapture/homer-api/issues/comments/127993129","html_url":"https://github.com/sipcapture/homer-api/issues/33#issuecomment-127993129","issue_url":"https://api.github.com/repos/sipcapture/homer-api/issues/33","id":127993129,"user":{"login":"00Asgaroth00","id":13218073,"avatar_url":"https://avatars.githubusercontent.com/u/13218073?v=3","gravatar_id":"","url":"https://api.github.com/users/00Asgaroth00","html_url":"https://github.com/00Asgaroth00","followers_url":"https://api.github.com/users/00Asgaroth00/followers","following_url":"https://api.github.com/users/00Asgaroth00/following{/other_user}","gists_url":"https://api.github.com/users/00Asgaroth00/gists{/gist_id}","starred_url":"https://api.github.com/users/00Asgaroth00/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/00Asgaroth00/subscriptions","organizations_url":"https://api.github.com/users/00Asgaroth00/orgs","repos_url":"https://api.github.com/users/00Asgaroth00/repos","events_url":"https://api.github.com/users/00Asgaroth00/events{/privacy}","received_events_url":"https://api.github.com/users/00Asgaroth00/received_events","type":"User","site_admin":false},"created_at":"2015-08-05T13:13:17Z","updated_at":"2015-08-05T13:13:17Z","body":"interresting, ok, i'll try that, thanks for the quick reply!"}}