{"action":"created","issue":{"url":"https://api.github.com/repos/brandaorodrigo/moodle-theme_board/issues/3","repository_url":"https://api.github.com/repos/brandaorodrigo/moodle-theme_board","labels_url":"https://api.github.com/repos/brandaorodrigo/moodle-theme_board/issues/3/labels{/name}","comments_url":"https://api.github.com/repos/brandaorodrigo/moodle-theme_board/issues/3/comments","events_url":"https://api.github.com/repos/brandaorodrigo/moodle-theme_board/issues/3/events","html_url":"https://github.com/brandaorodrigo/moodle-theme_board/issues/3","id":145683239,"number":3,"title":"Fails badly on PostgreSQL","user":{"login":"mudrd8mz","id":85831,"avatar_url":"https://avatars.githubusercontent.com/u/85831?v=3","gravatar_id":"","url":"https://api.github.com/users/mudrd8mz","html_url":"https://github.com/mudrd8mz","followers_url":"https://api.github.com/users/mudrd8mz/followers","following_url":"https://api.github.com/users/mudrd8mz/following{/other_user}","gists_url":"https://api.github.com/users/mudrd8mz/gists{/gist_id}","starred_url":"https://api.github.com/users/mudrd8mz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mudrd8mz/subscriptions","organizations_url":"https://api.github.com/users/mudrd8mz/orgs","repos_url":"https://api.github.com/users/mudrd8mz/repos","events_url":"https://api.github.com/users/mudrd8mz/events{/privacy}","received_events_url":"https://api.github.com/users/mudrd8mz/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-04-04T13:26:09Z","updated_at":"2016-04-04T13:42:10Z","closed_at":null,"body":"The function `format_board_process_css()` contains MySQL specific MySQL query that fails badly on other systems such as MySQL.\r\n\r\nFirstly, table column names should not be enclosed with single ticks. Just remove them.\r\n\r\nSecondly, even after removing the single ticks, I am getting an error\r\n```\r\nLIMIT #,# syntax is not supported\r\n```\r\n\r\nbecause you have the LIMIT statements hard-coded as a part of the query and this is not cross-db compatible.\r\n\r\nAt the end, I believe that the whole SQL there and the manual composition of the URL to the file is wrong and you should simply use the [File API](https://docs.moodle.org/dev/File_API) to obtain such URL - see the section \"Serving files to users\" there."},"comment":{"url":"https://api.github.com/repos/brandaorodrigo/moodle-theme_board/issues/comments/205300022","html_url":"https://github.com/brandaorodrigo/moodle-theme_board/issues/3#issuecomment-205300022","issue_url":"https://api.github.com/repos/brandaorodrigo/moodle-theme_board/issues/3","id":205300022,"user":{"login":"mudrd8mz","id":85831,"avatar_url":"https://avatars.githubusercontent.com/u/85831?v=3","gravatar_id":"","url":"https://api.github.com/users/mudrd8mz","html_url":"https://github.com/mudrd8mz","followers_url":"https://api.github.com/users/mudrd8mz/followers","following_url":"https://api.github.com/users/mudrd8mz/following{/other_user}","gists_url":"https://api.github.com/users/mudrd8mz/gists{/gist_id}","starred_url":"https://api.github.com/users/mudrd8mz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mudrd8mz/subscriptions","organizations_url":"https://api.github.com/users/mudrd8mz/orgs","repos_url":"https://api.github.com/users/mudrd8mz/repos","events_url":"https://api.github.com/users/mudrd8mz/events{/privacy}","received_events_url":"https://api.github.com/users/mudrd8mz/received_events","type":"User","site_admin":false},"created_at":"2016-04-04T13:42:10Z","updated_at":"2016-04-04T13:42:10Z","body":"Also note `theme_board_core_renderer::redirect_to_singlecourse()`"}}