{"action":"closed","issue":{"url":"https://api.github.com/repos/ramiusGitHub/ProjectManager/issues/1","repository_url":"https://api.github.com/repos/ramiusGitHub/ProjectManager","labels_url":"https://api.github.com/repos/ramiusGitHub/ProjectManager/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/ramiusGitHub/ProjectManager/issues/1/comments","events_url":"https://api.github.com/repos/ramiusGitHub/ProjectManager/issues/1/events","html_url":"https://github.com/ramiusGitHub/ProjectManager/issues/1","id":154108118,"number":1,"title":"Caching without MySQL PROCESS privileges","user":{"login":"Padarom","id":3678770,"avatar_url":"https://avatars.githubusercontent.com/u/3678770?v=3","gravatar_id":"","url":"https://api.github.com/users/Padarom","html_url":"https://github.com/Padarom","followers_url":"https://api.github.com/users/Padarom/followers","following_url":"https://api.github.com/users/Padarom/following{/other_user}","gists_url":"https://api.github.com/users/Padarom/gists{/gist_id}","starred_url":"https://api.github.com/users/Padarom/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Padarom/subscriptions","organizations_url":"https://api.github.com/users/Padarom/orgs","repos_url":"https://api.github.com/users/Padarom/repos","events_url":"https://api.github.com/users/Padarom/events{/privacy}","received_events_url":"https://api.github.com/users/Padarom/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-05-10T21:12:18Z","updated_at":"2016-07-12T09:29:14Z","closed_at":"2016-07-12T09:29:14Z","body":"Currently the `ProjectDatabaseCacheBuilder` [queries](https://github.com/ramiusGitHub/ProjectManager/blob/4273692b2b53ba4b0f3d8f020d29a9b2acb34945/wcf/lib/system/cache/builder/ProjectDatabaseCacheBuilder.class.php#L635) from `INFORMATION_SCHEMA.INNODB_SYS_FOREIGN` to retrieve foreign keys. This approach does not work when the MySQL user does not have `PROCESS` privileges, which are required to query the table.\r\n\r\nMy team is working on a shared host that does not give us the ability to grant our mysql users this privilege. Could you think of any way around this, perhaps an alternative solution in case no `PROCESS` privileges have been granted?"}}
{"actor":{"display_login":"Padarom"}}