{"action":"created","issue":{"url":"https://api.github.com/repos/hrz-unimr/Ilias.RESTPlugin/issues/6","labels_url":"https://api.github.com/repos/hrz-unimr/Ilias.RESTPlugin/issues/6/labels{/name}","comments_url":"https://api.github.com/repos/hrz-unimr/Ilias.RESTPlugin/issues/6/comments","events_url":"https://api.github.com/repos/hrz-unimr/Ilias.RESTPlugin/issues/6/events","html_url":"https://github.com/hrz-unimr/Ilias.RESTPlugin/issues/6","id":60626152,"number":6,"title":"Probable issue with ILIAS-5.0.0 (sql table convention)","user":{"login":"Hufschmidt","id":11391961,"avatar_url":"https://avatars.githubusercontent.com/u/11391961?v=3","gravatar_id":"","url":"https://api.github.com/users/Hufschmidt","html_url":"https://github.com/Hufschmidt","followers_url":"https://api.github.com/users/Hufschmidt/followers","following_url":"https://api.github.com/users/Hufschmidt/following{/other_user}","gists_url":"https://api.github.com/users/Hufschmidt/gists{/gist_id}","starred_url":"https://api.github.com/users/Hufschmidt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Hufschmidt/subscriptions","organizations_url":"https://api.github.com/users/Hufschmidt/orgs","repos_url":"https://api.github.com/users/Hufschmidt/repos","events_url":"https://api.github.com/users/Hufschmidt/events{/privacy}","received_events_url":"https://api.github.com/users/Hufschmidt/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-03-11T08:39:52Z","updated_at":"2015-03-11T08:42:46Z","closed_at":null,"body":"RESTPlugin can't be installed in fresh ILIAS-5.0.0 installation.\r\n\r\nWhen trying to process dbupdate.php ILIAS raises the error\r\n'No plugin record found for 'Services', 'UIComponent', 'uihk', 'Rest'.'\r\n\r\nThis seems to be caused by ILIAS trying to impose a naming convention on plugin sql tables.\r\n( See: http://www.ilias.de/docu/ilias.php?ref_id=42&obj_id=27029&cmd=layout&cmdClass=illmpresentationgui&cmdNode=ih&baseClass=ilLMPresentationGUI&obj_id=27031 -> Database Update )\r\n\r\nThis can be fixed by prefixing all sql table names with \"ui_uihk_\", because REST is currently running as an UI-Component(ui) in the UserInterfaceHook (uihk).\r\nAfterwards some table-names (specifically rest_oauth2_refresh and rest_user_apikey_map) need to be shortened, because ILIAS also enfores a maximum table-name-length of 22 characters/bytes.\r\n( See: \\Services\\Database\\classes\\class.ilDB.php -> checkTableName($a_name) )\r\n\r\n**Sidenode:**\r\nMy guess is, this is to be compatible with OracleDB, which has a maximum table-name-length of 30 characters/bytes. (Still a difference of 8 characters/bytes though...)\r\n\r\n**Fix:**\r\nThis is fixed in my clone at\r\nhttps://github.com/Hufschmidt/Ilias.RESTPlugin\r\n\r\nI also updated all files, functions and class names to adhere to the \"REST\" naming convention instead of \"Rest\".\r\n\r\nI'll try to add a patch.diff once I figured this out. ;)"},"comment":{"url":"https://api.github.com/repos/hrz-unimr/Ilias.RESTPlugin/issues/comments/78224135","html_url":"https://github.com/hrz-unimr/Ilias.RESTPlugin/issues/6#issuecomment-78224135","issue_url":"https://api.github.com/repos/hrz-unimr/Ilias.RESTPlugin/issues/6","id":78224135,"user":{"login":"Hufschmidt","id":11391961,"avatar_url":"https://avatars.githubusercontent.com/u/11391961?v=3","gravatar_id":"","url":"https://api.github.com/users/Hufschmidt","html_url":"https://github.com/Hufschmidt","followers_url":"https://api.github.com/users/Hufschmidt/followers","following_url":"https://api.github.com/users/Hufschmidt/following{/other_user}","gists_url":"https://api.github.com/users/Hufschmidt/gists{/gist_id}","starred_url":"https://api.github.com/users/Hufschmidt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Hufschmidt/subscriptions","organizations_url":"https://api.github.com/users/Hufschmidt/orgs","repos_url":"https://api.github.com/users/Hufschmidt/repos","events_url":"https://api.github.com/users/Hufschmidt/events{/privacy}","received_events_url":"https://api.github.com/users/Hufschmidt/received_events","type":"User","site_admin":false},"created_at":"2015-03-11T08:42:45Z","updated_at":"2015-03-11T08:42:45Z","body":"A more robust solution would be to define the table names as constants, like\r\n"}}