{"action":"created","issue":{"url":"https://api.github.com/repos/thorsten/phpMyFAQ/issues/1200","repository_url":"https://api.github.com/repos/thorsten/phpMyFAQ","labels_url":"https://api.github.com/repos/thorsten/phpMyFAQ/issues/1200/labels{/name}","comments_url":"https://api.github.com/repos/thorsten/phpMyFAQ/issues/1200/comments","events_url":"https://api.github.com/repos/thorsten/phpMyFAQ/issues/1200/events","html_url":"https://github.com/thorsten/phpMyFAQ/issues/1200","id":164709040,"number":1200,"title":"Problem with categories 2.9.2 and  MS SQL Server 2012","user":{"login":"Velobook","id":20380598,"avatar_url":"https://avatars.githubusercontent.com/u/20380598?v=3","gravatar_id":"","url":"https://api.github.com/users/Velobook","html_url":"https://github.com/Velobook","followers_url":"https://api.github.com/users/Velobook/followers","following_url":"https://api.github.com/users/Velobook/following{/other_user}","gists_url":"https://api.github.com/users/Velobook/gists{/gist_id}","starred_url":"https://api.github.com/users/Velobook/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Velobook/subscriptions","organizations_url":"https://api.github.com/users/Velobook/orgs","repos_url":"https://api.github.com/users/Velobook/repos","events_url":"https://api.github.com/users/Velobook/events{/privacy}","received_events_url":"https://api.github.com/users/Velobook/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/thorsten/phpMyFAQ/labels/Bug","name":"Bug","color":"e10c02"}],"state":"closed","locked":false,"assignee":{"login":"thorsten","id":45284,"avatar_url":"https://avatars.githubusercontent.com/u/45284?v=3","gravatar_id":"","url":"https://api.github.com/users/thorsten","html_url":"https://github.com/thorsten","followers_url":"https://api.github.com/users/thorsten/followers","following_url":"https://api.github.com/users/thorsten/following{/other_user}","gists_url":"https://api.github.com/users/thorsten/gists{/gist_id}","starred_url":"https://api.github.com/users/thorsten/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thorsten/subscriptions","organizations_url":"https://api.github.com/users/thorsten/orgs","repos_url":"https://api.github.com/users/thorsten/repos","events_url":"https://api.github.com/users/thorsten/events{/privacy}","received_events_url":"https://api.github.com/users/thorsten/received_events","type":"User","site_admin":false},"assignees":[{"login":"thorsten","id":45284,"avatar_url":"https://avatars.githubusercontent.com/u/45284?v=3","gravatar_id":"","url":"https://api.github.com/users/thorsten","html_url":"https://github.com/thorsten","followers_url":"https://api.github.com/users/thorsten/followers","following_url":"https://api.github.com/users/thorsten/following{/other_user}","gists_url":"https://api.github.com/users/thorsten/gists{/gist_id}","starred_url":"https://api.github.com/users/thorsten/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thorsten/subscriptions","organizations_url":"https://api.github.com/users/thorsten/orgs","repos_url":"https://api.github.com/users/thorsten/repos","events_url":"https://api.github.com/users/thorsten/events{/privacy}","received_events_url":"https://api.github.com/users/thorsten/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/thorsten/phpMyFAQ/milestones/35","html_url":"https://github.com/thorsten/phpMyFAQ/milestones/2.9.3","labels_url":"https://api.github.com/repos/thorsten/phpMyFAQ/milestones/35/labels","id":1735654,"number":35,"title":"2.9.3","description":"","creator":{"login":"thorsten","id":45284,"avatar_url":"https://avatars.githubusercontent.com/u/45284?v=3","gravatar_id":"","url":"https://api.github.com/users/thorsten","html_url":"https://github.com/thorsten","followers_url":"https://api.github.com/users/thorsten/followers","following_url":"https://api.github.com/users/thorsten/following{/other_user}","gists_url":"https://api.github.com/users/thorsten/gists{/gist_id}","starred_url":"https://api.github.com/users/thorsten/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thorsten/subscriptions","organizations_url":"https://api.github.com/users/thorsten/orgs","repos_url":"https://api.github.com/users/thorsten/repos","events_url":"https://api.github.com/users/thorsten/events{/privacy}","received_events_url":"https://api.github.com/users/thorsten/received_events","type":"User","site_admin":false},"open_issues":8,"closed_issues":1,"state":"open","created_at":"2016-04-28T07:24:45Z","updated_at":"2016-07-13T09:10:18Z","due_on":"2016-07-30T22:00:00Z","closed_at":null},"comments":3,"created_at":"2016-07-10T10:16:03Z","updated_at":"2016-07-13T09:27:11Z","closed_at":"2016-07-10T10:23:39Z","body":"I have just installed new version with MS SQL Server .\r\nBut was enabled to list Categories nowhere. \r\nWith a look in file inc\\PMF\\category.php I have seen in line 212 a sql request  for Categories \r\nBy trying this request directly in Sql Management studio .I got an error in Group By\r\nfaqcategories.group_id   and  faqcategories.active are not in Group By\r\n\r\nI've changed   lines 233-234  like that and it works well now..\r\n\r\n **_GROUP BY\r\n                fc.id, fc.lang, fc.parent_id, fc.name, fc.description, fc.user_id, fc.group_id, fc.active_**\r\n\r\nRegards\r\nP.Dupuis\r\nsupport.velobook.net\r\n"},"comment":{"url":"https://api.github.com/repos/thorsten/phpMyFAQ/issues/comments/232304180","html_url":"https://github.com/thorsten/phpMyFAQ/issues/1200#issuecomment-232304180","issue_url":"https://api.github.com/repos/thorsten/phpMyFAQ/issues/1200","id":232304180,"user":{"login":"thorsten","id":45284,"avatar_url":"https://avatars.githubusercontent.com/u/45284?v=3","gravatar_id":"","url":"https://api.github.com/users/thorsten","html_url":"https://github.com/thorsten","followers_url":"https://api.github.com/users/thorsten/followers","following_url":"https://api.github.com/users/thorsten/following{/other_user}","gists_url":"https://api.github.com/users/thorsten/gists{/gist_id}","starred_url":"https://api.github.com/users/thorsten/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thorsten/subscriptions","organizations_url":"https://api.github.com/users/thorsten/orgs","repos_url":"https://api.github.com/users/thorsten/repos","events_url":"https://api.github.com/users/thorsten/events{/privacy}","received_events_url":"https://api.github.com/users/thorsten/received_events","type":"User","site_admin":false},"created_at":"2016-07-13T09:27:11Z","updated_at":"2016-07-13T09:27:11Z","body":"Please create a new issue, thank you very much in advance!"}}
{"actor":{"display_login":"thorsten"}}