{"action":"opened","issue":{"url":"https://api.github.com/repos/librenms/librenms/issues/8265","repository_url":"https://api.github.com/repos/librenms/librenms","labels_url":"https://api.github.com/repos/librenms/librenms/issues/8265/labels{/name}","comments_url":"https://api.github.com/repos/librenms/librenms/issues/8265/comments","events_url":"https://api.github.com/repos/librenms/librenms/issues/8265/events","html_url":"https://github.com/librenms/librenms/issues/8265","id":298201014,"number":8265,"title":"new alert rules save on mysql double quotes","user":{"login":"rgngpp","id":36610534,"avatar_url":"https://avatars2.githubusercontent.com/u/36610534?v=4","gravatar_id":"","url":"https://api.github.com/users/rgngpp","html_url":"https://github.com/rgngpp","followers_url":"https://api.github.com/users/rgngpp/followers","following_url":"https://api.github.com/users/rgngpp/following{/other_user}","gists_url":"https://api.github.com/users/rgngpp/gists{/gist_id}","starred_url":"https://api.github.com/users/rgngpp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rgngpp/subscriptions","organizations_url":"https://api.github.com/users/rgngpp/orgs","repos_url":"https://api.github.com/users/rgngpp/repos","events_url":"https://api.github.com/users/rgngpp/events{/privacy}","received_events_url":"https://api.github.com/users/rgngpp/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-02-19T09:01:48Z","updated_at":"2018-02-19T09:01:48Z","closed_at":null,"author_association":"NONE","body":"DO NOT DELETE THIS INFORMATION.\r\n\r\n> Please read this information carefully.\r\n\r\nGitHub issues is for known/validated bugs, please do not post issues asking for help or how to do X, Y or Z. \r\n\r\nYou can use our [Discord server](https://t.libren.ms/discord) to ask questions or our [community site](https://community.librenms.org).\r\n\r\nIf you have a feature request please post this on our [community site](https://community.librenms.org/c/feature-requests).\r\n\r\nPlease confirm each of the sections below by putting an `x` in the box like `[x]`.\r\n\r\n- [x] Is your install up to date? [Updating your install](http://docs.librenms.org/General/Updating/)\r\n      Please do not submit an issue if your install is not up to date within the last 24 hours or on a stable monthly release.\r\n- [x] Please include all of the information between the `====================================` section of `./validate.php` which you can run from the cli.\r\n- [x] Please provide ALL info asked for [here](http://docs.librenms.org/Support/FAQ/#faq20).\r\n- [x] Please provide as much detail as possible.\r\n- [ ] Please do NOT post more than 10 lines of debug information here, use a pastebin service or GitHub Gists.\r\n\r\nLove librenms? Please consider supporting our collective:\r\n👉  https://t.libren.ms/donations\r\nHi\r\nwhen I insert a new alert the value is saved in mysql with 4 double quotes.\r\nes. i insert value \"90\" and the result in gui is %processors.processor_usage >= \"\"90\"\" &&\r\nthis is record mysql:\r\n| 16 | -1 | %processors.processor_usage >= \"\"90\"\" | critical | {\"mute\":false,\"count\":\"1\",\"delay\":300,\"invert\":false,\"interval\":300} | 0 | test double | SELECT * FROM processors WHERE (processors.device_id = ?) && (processors.processor_usage >= \"\"90\"\" )\r\n====================================\r\nLibreNMS | 1.36-74-g6887d77\r\nDB Schema | 235\r\nPHP | 7.0.25-0ubuntu0.16.04.1\r\nMySQL | 10.0.33-MariaDB-0ubuntu0.16.04.1\r\nRRDTool | 1.5.5\r\nSNMP | NET-SNMP 5.7.3\r\n===================================="}}
{"actor":{"display_login":"rgngpp"}}