{"action":"closed","issue":{"url":"https://api.github.com/repos/Charcoal-SE/metasmoke/issues/43","repository_url":"https://api.github.com/repos/Charcoal-SE/metasmoke","labels_url":"https://api.github.com/repos/Charcoal-SE/metasmoke/issues/43/labels{/name}","comments_url":"https://api.github.com/repos/Charcoal-SE/metasmoke/issues/43/comments","events_url":"https://api.github.com/repos/Charcoal-SE/metasmoke/issues/43/events","html_url":"https://github.com/Charcoal-SE/metasmoke/issues/43","id":187479702,"number":43,"title":"Error message on search","user":{"login":"AWegnerGitHub","id":6462439,"avatar_url":"https://avatars.githubusercontent.com/u/6462439?v=3","gravatar_id":"","url":"https://api.github.com/users/AWegnerGitHub","html_url":"https://github.com/AWegnerGitHub","followers_url":"https://api.github.com/users/AWegnerGitHub/followers","following_url":"https://api.github.com/users/AWegnerGitHub/following{/other_user}","gists_url":"https://api.github.com/users/AWegnerGitHub/gists{/gist_id}","starred_url":"https://api.github.com/users/AWegnerGitHub/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AWegnerGitHub/subscriptions","organizations_url":"https://api.github.com/users/AWegnerGitHub/orgs","repos_url":"https://api.github.com/users/AWegnerGitHub/repos","events_url":"https://api.github.com/users/AWegnerGitHub/events{/privacy}","received_events_url":"https://api.github.com/users/AWegnerGitHub/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-11-05T06:10:34Z","updated_at":"2016-12-05T13:14:12Z","closed_at":"2016-12-05T13:14:12Z","body":"First, I admit that regular expressions and I don't get along. \r\n\r\nMy goal is to find a post that has the following in the body:\r\n\r\n    http://Xtreme*Testrone/\r\n\r\nI used the following string and checked the \"regex\" box for body:\r\n\r\n    *http://Xtreme*Testrone/*\r\n\r\nMy search URL ends up being this: \r\n\r\n    https://metasmoke.erwaysoftware.com/search?utf8=%E2%9C%93&title=&body_is_regex=1&body=*http%3A%2F%2FXtreme*Testrone%2F*&username=&why=&site=&feedback=&reason=&user_rep_direction=%3E%3D&user_reputation=0&commit=Search\r\n\r\nAs an aside, I realize this is an invalid domain (no TLD)\r\n \r\n\n---\r\n\r\nThe error message this generates:\r\n\r\n```\r\nMysql2::Error: Got error 'repetition-operator operand invalid' from regexp: SELECT `posts`.* FROM `posts` WHERE (IFNULL(posts.username, '') LIKE '%%' AND IFNULL(title, '') LIKE '%%' AND IFNULL(body, '') REGEXP '*http://Xtreme*Testrone/*' AND IFNULL(why, '') LIKE '%%') AND (ifnull(user_reputation, 0) >= 0) ORDER BY `posts`.`created_at` DESC LIMIT 100 OFFSET 0\r\n```"}}
{"actor":{"display_login":"ArtOfCode-"}}