{"action":"created","issue":{"url":"https://api.github.com/repos/ChurchCRM/CRM/issues/231","labels_url":"https://api.github.com/repos/ChurchCRM/CRM/issues/231/labels{/name}","comments_url":"https://api.github.com/repos/ChurchCRM/CRM/issues/231/comments","events_url":"https://api.github.com/repos/ChurchCRM/CRM/issues/231/events","html_url":"https://github.com/ChurchCRM/CRM/pull/231","id":125851678,"number":231,"title":"Closes #228","user":{"login":"crossan007","id":11679900,"avatar_url":"https://avatars.githubusercontent.com/u/11679900?v=3","gravatar_id":"","url":"https://api.github.com/users/crossan007","html_url":"https://github.com/crossan007","followers_url":"https://api.github.com/users/crossan007/followers","following_url":"https://api.github.com/users/crossan007/following{/other_user}","gists_url":"https://api.github.com/users/crossan007/gists{/gist_id}","starred_url":"https://api.github.com/users/crossan007/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/crossan007/subscriptions","organizations_url":"https://api.github.com/users/crossan007/orgs","repos_url":"https://api.github.com/users/crossan007/repos","events_url":"https://api.github.com/users/crossan007/events{/privacy}","received_events_url":"https://api.github.com/users/crossan007/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/ChurchCRM/CRM/labels/in%20progress","name":"in progress","color":"ededed"}],"state":"open","locked":false,"assignee":{"login":"crossan007","id":11679900,"avatar_url":"https://avatars.githubusercontent.com/u/11679900?v=3","gravatar_id":"","url":"https://api.github.com/users/crossan007","html_url":"https://github.com/crossan007","followers_url":"https://api.github.com/users/crossan007/followers","following_url":"https://api.github.com/users/crossan007/following{/other_user}","gists_url":"https://api.github.com/users/crossan007/gists{/gist_id}","starred_url":"https://api.github.com/users/crossan007/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/crossan007/subscriptions","organizations_url":"https://api.github.com/users/crossan007/orgs","repos_url":"https://api.github.com/users/crossan007/repos","events_url":"https://api.github.com/users/crossan007/events{/privacy}","received_events_url":"https://api.github.com/users/crossan007/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/ChurchCRM/CRM/milestones/1","html_url":"https://github.com/ChurchCRM/CRM/milestones/2.0.0","labels_url":"https://api.github.com/repos/ChurchCRM/CRM/milestones/1/labels","id":1481208,"number":1,"title":"2.0.0","description":"1st Release of ChurchCRM","creator":{"login":"DawoudIO","id":554959,"avatar_url":"https://avatars.githubusercontent.com/u/554959?v=3","gravatar_id":"","url":"https://api.github.com/users/DawoudIO","html_url":"https://github.com/DawoudIO","followers_url":"https://api.github.com/users/DawoudIO/followers","following_url":"https://api.github.com/users/DawoudIO/following{/other_user}","gists_url":"https://api.github.com/users/DawoudIO/gists{/gist_id}","starred_url":"https://api.github.com/users/DawoudIO/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DawoudIO/subscriptions","organizations_url":"https://api.github.com/users/DawoudIO/orgs","repos_url":"https://api.github.com/users/DawoudIO/repos","events_url":"https://api.github.com/users/DawoudIO/events{/privacy}","received_events_url":"https://api.github.com/users/DawoudIO/received_events","type":"User","site_admin":false},"open_issues":23,"closed_issues":162,"state":"open","created_at":"2016-01-03T19:46:03Z","updated_at":"2016-01-13T03:53:06Z","due_on":"2016-01-31T08:00:00Z","closed_at":null},"comments":10,"created_at":"2016-01-10T22:58:39Z","updated_at":"2016-01-13T04:23:19Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/ChurchCRM/CRM/pulls/231","html_url":"https://github.com/ChurchCRM/CRM/pull/231","diff_url":"https://github.com/ChurchCRM/CRM/pull/231.diff","patch_url":"https://github.com/ChurchCRM/CRM/pull/231.patch"},"body":"Move the multi select boxes to Select2"},"comment":{"url":"https://api.github.com/repos/ChurchCRM/CRM/issues/comments/171162299","html_url":"https://github.com/ChurchCRM/CRM/pull/231#issuecomment-171162299","issue_url":"https://api.github.com/repos/ChurchCRM/CRM/issues/231","id":171162299,"user":{"login":"dschwen","id":202302,"avatar_url":"https://avatars.githubusercontent.com/u/202302?v=3","gravatar_id":"","url":"https://api.github.com/users/dschwen","html_url":"https://github.com/dschwen","followers_url":"https://api.github.com/users/dschwen/followers","following_url":"https://api.github.com/users/dschwen/following{/other_user}","gists_url":"https://api.github.com/users/dschwen/gists{/gist_id}","starred_url":"https://api.github.com/users/dschwen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dschwen/subscriptions","organizations_url":"https://api.github.com/users/dschwen/orgs","repos_url":"https://api.github.com/users/dschwen/repos","events_url":"https://api.github.com/users/dschwen/events{/privacy}","received_events_url":"https://api.github.com/users/dschwen/received_events","type":"User","site_admin":false},"created_at":"2016-01-13T04:23:19Z","updated_at":"2016-01-13T04:23:19Z","body":"Is it the empty set? I'll test it in a few minutes.\n\nOn Tue, Jan 12, 2016, 9:20 PM Charles <notifications@github.com> wrote:\n\n> Something still looks broken in here, but I'm not sure what.\n>\n> @dschwen <https://github.com/dschwen> can you test this with some real\n> data? something looks funky with the SQL\n>\n> Cannot execute query.\n> SELECT fam_ID, fam_Name, fam_Address1, fam_Address2, fam_City, fam_State,\n> fam_Zip, fam_Country, fam_envelope, plg_date, plg_amount, plg_method,\n> plg_comment, plg_CheckNo, fun_Name, plg_PledgeOrPayment, plg_NonDeductible\n> FROM family_fam INNER JOIN pledge_plg ON fam_ID=plg_FamID LEFT JOIN\n> donationfund_fun ON plg_fundID=fun_ID LEFT JOIN person_per ON\n> fam_ID=per_fam_ID WHERE plg_PledgeOrPayment='Payment' AND plg_date BETWEEN\n> '2016-01-12' AND '2016-01-12' AND (plg_FamID='19' OR plg_FamID='20' OR\n> plg_FamID='10' OR plg_FamID='3' OR plg_FamID='13' OR plg_FamID='8' OR\n> plg_FamID='7' OR plg_FamID='6' OR plg_FamID='2' OR plg_FamID='9' OR\n> plg_FamID='1' OR plg_FamID='11' OR plg_FamID='12' OR plg_FamID='16' OR\n> plg_FamID='14' OR plg_FamID='18' OR plg_FamID='17' OR plg_FamID='15' OR\n> plg_FamID='4' OR plg_FamID='5') AND per_cls_ID IN (1,2,3,5,4) AND\n> per_fam_ID NOT IN (SELECT DISTINCT per_fam_ID FROM person_per WHERE\n> per_cls_ID IN ()) ORDER BY plg_FamID, plg_date\n>\n> You have an error in your SQL syntax; check the manual that corresponds to\n> your MySQL server version for the right syntax to use near ')) ORDER BY\n> plg_FamID, plg_date' at line 3\n>\n> —\n> Reply to this email directly or view it on GitHub\n> <https://github.com/ChurchCRM/CRM/pull/231#issuecomment-171161968>.\n>\n"}}