{"action":"created","issue":{"url":"https://api.github.com/repos/openemr/openemr/issues/291","repository_url":"https://api.github.com/repos/openemr/openemr","labels_url":"https://api.github.com/repos/openemr/openemr/issues/291/labels{/name}","comments_url":"https://api.github.com/repos/openemr/openemr/issues/291/comments","events_url":"https://api.github.com/repos/openemr/openemr/issues/291/events","html_url":"https://github.com/openemr/openemr/issues/291","id":179892066,"number":291,"title":"Address Book error on INSERT","user":{"login":"mdsupport","id":399047,"avatar_url":"https://avatars.githubusercontent.com/u/399047?v=3","gravatar_id":"","url":"https://api.github.com/users/mdsupport","html_url":"https://github.com/mdsupport","followers_url":"https://api.github.com/users/mdsupport/followers","following_url":"https://api.github.com/users/mdsupport/following{/other_user}","gists_url":"https://api.github.com/users/mdsupport/gists{/gist_id}","starred_url":"https://api.github.com/users/mdsupport/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mdsupport/subscriptions","organizations_url":"https://api.github.com/users/mdsupport/orgs","repos_url":"https://api.github.com/users/mdsupport/repos","events_url":"https://api.github.com/users/mdsupport/events{/privacy}","received_events_url":"https://api.github.com/users/mdsupport/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/openemr/openemr/labels/Bug","name":"Bug","color":"d93f0b"},{"url":"https://api.github.com/repos/openemr/openemr/labels/Priority:%20Blocking","name":"Priority: Blocking","color":"d93f0b"}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-09-28T21:15:07Z","updated_at":"2016-09-28T23:40:17Z","closed_at":"2016-09-28T23:40:17Z","body":"SQL error when inserting a new \"lab service\" record - here is SQL from error message\r\n`\r\n INSERT INTO users ( username, password, authorized, info, source, title, fname, lname, mname, suffix, federaltaxid, federaldrugid, upin, facility, see_auth, active, npi, taxonomy, cpoe, specialty, organization, valedictory, assistant, billname, email, email_direct, url, street, streetb, city, state, zip, street2, streetb2, city2, state2, zip2, phone, phonew1, phonew2, phonecell, fax, notes, abook_type ) VALUES ( '', '', 0, '', NULL, 'Mr.', '5', '4', '6', , '29', '', '27', '', 0, 1, '28', '30', '1', '', '1', '7', '13', '', '14', '15', '16', '17', '18', '19', '20', '21', '21', '23', '24', '25', '26', '8', '10', '11', '9', '12', '31', 'ord_lab' )`\r\n\r\nIf `suffix` field is hidden, the insert value is set to `nothing` which causes the error.  You can add the records when suffix is shown.  If the user type is changed, the update fails."},"comment":{"url":"https://api.github.com/repos/openemr/openemr/issues/comments/250332831","html_url":"https://github.com/openemr/openemr/issues/291#issuecomment-250332831","issue_url":"https://api.github.com/repos/openemr/openemr/issues/291","id":250332831,"user":{"login":"Wakie87","id":975165,"avatar_url":"https://avatars.githubusercontent.com/u/975165?v=3","gravatar_id":"","url":"https://api.github.com/users/Wakie87","html_url":"https://github.com/Wakie87","followers_url":"https://api.github.com/users/Wakie87/followers","following_url":"https://api.github.com/users/Wakie87/following{/other_user}","gists_url":"https://api.github.com/users/Wakie87/gists{/gist_id}","starred_url":"https://api.github.com/users/Wakie87/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Wakie87/subscriptions","organizations_url":"https://api.github.com/users/Wakie87/orgs","repos_url":"https://api.github.com/users/Wakie87/repos","events_url":"https://api.github.com/users/Wakie87/events{/privacy}","received_events_url":"https://api.github.com/users/Wakie87/received_events","type":"User","site_admin":false},"created_at":"2016-09-28T23:40:17Z","updated_at":"2016-09-28T23:40:17Z","body":"Rays eye form added suffix to \"person centric\" updated so \"company centric\" also includes suffix for the directors name."}}
{"actor":{"display_login":"Wakie87"}}