{"action":"created","issue":{"url":"https://api.github.com/repos/thorsten/phpMyFAQ/issues/1248","repository_url":"https://api.github.com/repos/thorsten/phpMyFAQ","labels_url":"https://api.github.com/repos/thorsten/phpMyFAQ/issues/1248/labels{/name}","comments_url":"https://api.github.com/repos/thorsten/phpMyFAQ/issues/1248/comments","events_url":"https://api.github.com/repos/thorsten/phpMyFAQ/issues/1248/events","html_url":"https://github.com/thorsten/phpMyFAQ/issues/1248","id":174852118,"number":1248,"title":"Field fc.group_id AS group_id not exist in the table categories","user":{"login":"neemiasjr","id":19786154,"avatar_url":"https://avatars.githubusercontent.com/u/19786154?v=3","gravatar_id":"","url":"https://api.github.com/users/neemiasjr","html_url":"https://github.com/neemiasjr","followers_url":"https://api.github.com/users/neemiasjr/followers","following_url":"https://api.github.com/users/neemiasjr/following{/other_user}","gists_url":"https://api.github.com/users/neemiasjr/gists{/gist_id}","starred_url":"https://api.github.com/users/neemiasjr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/neemiasjr/subscriptions","organizations_url":"https://api.github.com/users/neemiasjr/orgs","repos_url":"https://api.github.com/users/neemiasjr/repos","events_url":"https://api.github.com/users/neemiasjr/events{/privacy}","received_events_url":"https://api.github.com/users/neemiasjr/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/thorsten/phpMyFAQ/labels/Bug","name":"Bug","color":"e10c02"},{"url":"https://api.github.com/repos/thorsten/phpMyFAQ/labels/Needs%20feedback","name":"Needs feedback","color":"e102d8"}],"state":"open","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/39","html_url":"https://github.com/thorsten/phpMyFAQ/milestones/2.9.6","labels_url":"https://api.github.com/repos/thorsten/phpMyFAQ/milestones/39/labels","id":1917941,"number":39,"title":"2.9.6","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":4,"closed_issues":2,"state":"open","created_at":"2016-08-02T11:15:06Z","updated_at":"2016-09-03T05:45:27Z","due_on":"2016-09-29T22:00:00Z","closed_at":null},"comments":5,"created_at":"2016-09-02T21:34:42Z","updated_at":"2016-09-05T19:47:07Z","closed_at":null,"body":"After migrating to version 2.9.5, an error occurs in the SQL below for the Categories table does not contain the group_id field. I believe that the correct reference would fg. But as I'm not sure, I'm opening the issue for correction. Thank you.\r\n\r\nNote: SQL statement below found in the file inc/PMF/Category.php\r\n\r\n SELECT\r\n                fc.id AS id,\r\n                fc.lang AS lang,\r\n                fc.parent_id AS parent_id,\r\n                fc.name AS name,\r\n                fc.description AS description,\r\n                fc.user_id AS user_id,\r\n                fc.group_id AS group_id,\r\n                fc.active AS active\r\n            FROM\r\n                %sfaqcategories fc\r\n            LEFT JOIN\r\n                %sfaqcategory_group fg\r\n            ON\r\n                fc.id = fg.category_id\r\n            LEFT JOIN\r\n                %sfaqcategory_user fu\r\n            ON\r\n                fc.id = fu.category_id\r\n            %s\r\n            GROUP BY\r\n                fc.id, fc.lang, fc.parent_id, fc.name, fc.description, fc.user_id\r\n            ORDER BY\r\n                fc.parent_id, fc.id'"},"comment":{"url":"https://api.github.com/repos/thorsten/phpMyFAQ/issues/comments/244804205","html_url":"https://github.com/thorsten/phpMyFAQ/issues/1248#issuecomment-244804205","issue_url":"https://api.github.com/repos/thorsten/phpMyFAQ/issues/1248","id":244804205,"user":{"login":"neemiasjr","id":19786154,"avatar_url":"https://avatars.githubusercontent.com/u/19786154?v=3","gravatar_id":"","url":"https://api.github.com/users/neemiasjr","html_url":"https://github.com/neemiasjr","followers_url":"https://api.github.com/users/neemiasjr/followers","following_url":"https://api.github.com/users/neemiasjr/following{/other_user}","gists_url":"https://api.github.com/users/neemiasjr/gists{/gist_id}","starred_url":"https://api.github.com/users/neemiasjr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/neemiasjr/subscriptions","organizations_url":"https://api.github.com/users/neemiasjr/orgs","repos_url":"https://api.github.com/users/neemiasjr/repos","events_url":"https://api.github.com/users/neemiasjr/events{/privacy}","received_events_url":"https://api.github.com/users/neemiasjr/received_events","type":"User","site_admin":false},"created_at":"2016-09-05T19:47:07Z","updated_at":"2016-09-05T19:47:07Z","body":"Disregarding the cmdbuild file name. The above is a file dump of the database structure."}}
{"actor":{"display_login":"neemiasjr"}}