{"action":"created","issue":{"url":"https://api.github.com/repos/joomlaworks/k2/issues/235","labels_url":"https://api.github.com/repos/joomlaworks/k2/issues/235/labels{/name}","comments_url":"https://api.github.com/repos/joomlaworks/k2/issues/235/comments","events_url":"https://api.github.com/repos/joomlaworks/k2/issues/235/events","html_url":"https://github.com/joomlaworks/k2/issues/235","id":62628154,"number":235,"title":"[module rss feed] sef generated rss feed gives an error","user":{"login":"raramuridesign","id":902376,"avatar_url":"https://avatars.githubusercontent.com/u/902376?v=3","gravatar_id":"","url":"https://api.github.com/users/raramuridesign","html_url":"https://github.com/raramuridesign","followers_url":"https://api.github.com/users/raramuridesign/followers","following_url":"https://api.github.com/users/raramuridesign/following{/other_user}","gists_url":"https://api.github.com/users/raramuridesign/gists{/gist_id}","starred_url":"https://api.github.com/users/raramuridesign/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/raramuridesign/subscriptions","organizations_url":"https://api.github.com/users/raramuridesign/orgs","repos_url":"https://api.github.com/users/raramuridesign/repos","events_url":"https://api.github.com/users/raramuridesign/events{/privacy}","received_events_url":"https://api.github.com/users/raramuridesign/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-03-18T08:56:07Z","updated_at":"2015-03-23T07:54:59Z","closed_at":null,"body":"HI Guys\r\njoomla 3.4.0\r\nk2, latest dev build\r\nusing joomla SEF\r\n\r\nWhen creating a module to generate a RSS feed from different categories, we are getting an error when SEF is on.\r\nWhen SEF is off the rss link works with no issue.\r\n\r\nLink looks like this: http://mydomain.com/xxx/itemlist.feed?moduleID=276\r\nerror generated\r\n-------------------------------------\r\nYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=SELECT a.id FROM gd_k2_categories as a WHERE a.published = 1 AND a.access IN(1,1) AND a.trash = 0 AND a.parent=\r\n-------------------------------------\r\n\r\nThis only happens when SEF is on.\r\nTurn SEF off and it works.\r\n\r\nCould you please let us know if this is an issue with the module or something else.\r\nThanks\r\nMatthew"},"comment":{"url":"https://api.github.com/repos/joomlaworks/k2/issues/comments/84868836","html_url":"https://github.com/joomlaworks/k2/issues/235#issuecomment-84868836","issue_url":"https://api.github.com/repos/joomlaworks/k2/issues/235","id":84868836,"user":{"login":"raramuridesign","id":902376,"avatar_url":"https://avatars.githubusercontent.com/u/902376?v=3","gravatar_id":"","url":"https://api.github.com/users/raramuridesign","html_url":"https://github.com/raramuridesign","followers_url":"https://api.github.com/users/raramuridesign/followers","following_url":"https://api.github.com/users/raramuridesign/following{/other_user}","gists_url":"https://api.github.com/users/raramuridesign/gists{/gist_id}","starred_url":"https://api.github.com/users/raramuridesign/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/raramuridesign/subscriptions","organizations_url":"https://api.github.com/users/raramuridesign/orgs","repos_url":"https://api.github.com/users/raramuridesign/repos","events_url":"https://api.github.com/users/raramuridesign/events{/privacy}","received_events_url":"https://api.github.com/users/raramuridesign/received_events","type":"User","site_admin":false},"created_at":"2015-03-23T07:54:59Z","updated_at":"2015-03-23T07:54:59Z","body":"Thanks, I will see if a 3rd party is causing this and revert and let you know."}}