{"action":"created","issue":{"url":"https://api.github.com/repos/YetiForceCompany/YetiForceCRM/issues/2063","labels_url":"https://api.github.com/repos/YetiForceCompany/YetiForceCRM/issues/2063/labels{/name}","comments_url":"https://api.github.com/repos/YetiForceCompany/YetiForceCRM/issues/2063/comments","events_url":"https://api.github.com/repos/YetiForceCompany/YetiForceCRM/issues/2063/events","html_url":"https://github.com/YetiForceCompany/YetiForceCRM/issues/2063","id":111693568,"number":2063,"title":"Error!!! SQLSTATE[42000]: Syntax error or access violation:","user":{"login":"PercyP","id":10598886,"avatar_url":"https://avatars.githubusercontent.com/u/10598886?v=3","gravatar_id":"","url":"https://api.github.com/users/PercyP","html_url":"https://github.com/PercyP","followers_url":"https://api.github.com/users/PercyP/followers","following_url":"https://api.github.com/users/PercyP/following{/other_user}","gists_url":"https://api.github.com/users/PercyP/gists{/gist_id}","starred_url":"https://api.github.com/users/PercyP/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PercyP/subscriptions","organizations_url":"https://api.github.com/users/PercyP/orgs","repos_url":"https://api.github.com/users/PercyP/repos","events_url":"https://api.github.com/users/PercyP/events{/privacy}","received_events_url":"https://api.github.com/users/PercyP/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/YetiForceCompany/YetiForceCRM/labels/Label::Core","name":"Label::Core","color":"fbca04"},{"url":"https://api.github.com/repos/YetiForceCompany/YetiForceCRM/labels/Priority::%233%20High","name":"Priority::#3 High","color":"ff5252"},{"url":"https://api.github.com/repos/YetiForceCompany/YetiForceCRM/labels/Type::VerificationRequired","name":"Type::VerificationRequired","color":"0052cc"}],"state":"closed","locked":false,"assignee":{"login":"mariuszkrzaczkowski","id":10198654,"avatar_url":"https://avatars.githubusercontent.com/u/10198654?v=3","gravatar_id":"","url":"https://api.github.com/users/mariuszkrzaczkowski","html_url":"https://github.com/mariuszkrzaczkowski","followers_url":"https://api.github.com/users/mariuszkrzaczkowski/followers","following_url":"https://api.github.com/users/mariuszkrzaczkowski/following{/other_user}","gists_url":"https://api.github.com/users/mariuszkrzaczkowski/gists{/gist_id}","starred_url":"https://api.github.com/users/mariuszkrzaczkowski/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mariuszkrzaczkowski/subscriptions","organizations_url":"https://api.github.com/users/mariuszkrzaczkowski/orgs","repos_url":"https://api.github.com/users/mariuszkrzaczkowski/repos","events_url":"https://api.github.com/users/mariuszkrzaczkowski/events{/privacy}","received_events_url":"https://api.github.com/users/mariuszkrzaczkowski/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/YetiForceCompany/YetiForceCRM/milestones/13","html_url":"https://github.com/YetiForceCompany/YetiForceCRM/milestones/YetiForce%202.4%20GA","labels_url":"https://api.github.com/repos/YetiForceCompany/YetiForceCRM/milestones/13/labels","id":1244414,"number":13,"title":"YetiForce 2.4 GA","description":"","creator":{"login":"bpabiszczak","id":10197525,"avatar_url":"https://avatars.githubusercontent.com/u/10197525?v=3","gravatar_id":"","url":"https://api.github.com/users/bpabiszczak","html_url":"https://github.com/bpabiszczak","followers_url":"https://api.github.com/users/bpabiszczak/followers","following_url":"https://api.github.com/users/bpabiszczak/following{/other_user}","gists_url":"https://api.github.com/users/bpabiszczak/gists{/gist_id}","starred_url":"https://api.github.com/users/bpabiszczak/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bpabiszczak/subscriptions","organizations_url":"https://api.github.com/users/bpabiszczak/orgs","repos_url":"https://api.github.com/users/bpabiszczak/repos","events_url":"https://api.github.com/users/bpabiszczak/events{/privacy}","received_events_url":"https://api.github.com/users/bpabiszczak/received_events","type":"User","site_admin":false},"open_issues":41,"closed_issues":87,"state":"open","created_at":"2015-08-06T19:28:07Z","updated_at":"2015-10-23T09:28:05Z","due_on":"2015-11-15T23:00:00Z","closed_at":null},"comments":11,"created_at":"2015-10-15T19:47:14Z","updated_at":"2015-10-23T09:28:05Z","closed_at":"2015-10-23T09:28:05Z","body":"When I click on Email, then click on the magnifying glass icon, the popup module displays this error message:\r\n\r\nError!!!\r\nSQLSTATE[42000]: Syntax error or access violation: 1064 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 'AND vtiger_project.projectid > 0 ORDER BY projectname ASC LIMIT 0,21' at line 1"},"comment":{"url":"https://api.github.com/repos/YetiForceCompany/YetiForceCRM/issues/comments/150527328","html_url":"https://github.com/YetiForceCompany/YetiForceCRM/issues/2063#issuecomment-150527328","issue_url":"https://api.github.com/repos/YetiForceCompany/YetiForceCRM/issues/2063","id":150527328,"user":{"login":"mariuszkrzaczkowski","id":10198654,"avatar_url":"https://avatars.githubusercontent.com/u/10198654?v=3","gravatar_id":"","url":"https://api.github.com/users/mariuszkrzaczkowski","html_url":"https://github.com/mariuszkrzaczkowski","followers_url":"https://api.github.com/users/mariuszkrzaczkowski/followers","following_url":"https://api.github.com/users/mariuszkrzaczkowski/following{/other_user}","gists_url":"https://api.github.com/users/mariuszkrzaczkowski/gists{/gist_id}","starred_url":"https://api.github.com/users/mariuszkrzaczkowski/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mariuszkrzaczkowski/subscriptions","organizations_url":"https://api.github.com/users/mariuszkrzaczkowski/orgs","repos_url":"https://api.github.com/users/mariuszkrzaczkowski/repos","events_url":"https://api.github.com/users/mariuszkrzaczkowski/events{/privacy}","received_events_url":"https://api.github.com/users/mariuszkrzaczkowski/received_events","type":"User","site_admin":false},"created_at":"2015-10-23T09:28:05Z","updated_at":"2015-10-23T09:28:05Z","body":"The bug has been fixed in the latest version\r\nhttps://github.com/YetiForceCompany/YetiForceCRM/releases"}}