{"action":"created","issue":{"url":"https://api.github.com/repos/pi-hole/pi-hole/issues/465","repository_url":"https://api.github.com/repos/pi-hole/pi-hole","labels_url":"https://api.github.com/repos/pi-hole/pi-hole/issues/465/labels{/name}","comments_url":"https://api.github.com/repos/pi-hole/pi-hole/issues/465/comments","events_url":"https://api.github.com/repos/pi-hole/pi-hole/issues/465/events","html_url":"https://github.com/pi-hole/pi-hole/issues/465","id":148163269,"number":465,"title":"Error 500 on api.php?getAllQueries","user":{"login":"Windyo","id":17938171,"avatar_url":"https://avatars.githubusercontent.com/u/17938171?v=3","gravatar_id":"","url":"https://api.github.com/users/Windyo","html_url":"https://github.com/Windyo","followers_url":"https://api.github.com/users/Windyo/followers","following_url":"https://api.github.com/users/Windyo/following{/other_user}","gists_url":"https://api.github.com/users/Windyo/gists{/gist_id}","starred_url":"https://api.github.com/users/Windyo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Windyo/subscriptions","organizations_url":"https://api.github.com/users/Windyo/orgs","repos_url":"https://api.github.com/users/Windyo/repos","events_url":"https://api.github.com/users/Windyo/events{/privacy}","received_events_url":"https://api.github.com/users/Windyo/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/pi-hole/pi-hole/labels/possible%20bug","name":"possible bug","color":"f7c6c7"},{"url":"https://api.github.com/repos/pi-hole/pi-hole/labels/WebAdmin","name":"WebAdmin","color":"fbca04"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":35,"created_at":"2016-04-13T19:40:00Z","updated_at":"2016-04-15T15:01:00Z","closed_at":null,"body":"##### Expected Behaviour:\r\napi.php?getAllQueries should return a list of all queries\r\n\r\n##### Actual Behaviour:\r\nan error 500 is thrown.\r\nthe other calls to api.php actually work.\r\n\r\n##### Steps to reproduce this issue:\r\ngo to admin\r\ngo to \"all queries\"\r\nan AJAX error is thrown.\r\n\r\nTry to go to /api.php?getAllQueries\r\nan error 500 is returned.\r\n\r\n\r\nMahalaka list used, but the other parts of the web interface work fine:\r\n![sans titre](https://cloud.githubusercontent.com/assets/17938171/14506846/2198cba8-01c0-11e6-9d35-821d3bba9715.png)\r\n\r\nThe only thing failing is \"getAllQueries\" which shouldn't be impacted by the presence of the list.\r\n\r\n##### Setup:\r\nPi-hole Version v2.5.3 [clean install]\r\nWeb Interface Version v1.1.7\r\nRaspberry Pi 3\r\nMahalaka list\r\n"},"comment":{"url":"https://api.github.com/repos/pi-hole/pi-hole/issues/comments/210495231","html_url":"https://github.com/pi-hole/pi-hole/issues/465#issuecomment-210495231","issue_url":"https://api.github.com/repos/pi-hole/pi-hole/issues/465","id":210495231,"user":{"login":"PromoFaux","id":1998970,"avatar_url":"https://avatars.githubusercontent.com/u/1998970?v=3","gravatar_id":"","url":"https://api.github.com/users/PromoFaux","html_url":"https://github.com/PromoFaux","followers_url":"https://api.github.com/users/PromoFaux/followers","following_url":"https://api.github.com/users/PromoFaux/following{/other_user}","gists_url":"https://api.github.com/users/PromoFaux/gists{/gist_id}","starred_url":"https://api.github.com/users/PromoFaux/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PromoFaux/subscriptions","organizations_url":"https://api.github.com/users/PromoFaux/orgs","repos_url":"https://api.github.com/users/PromoFaux/repos","events_url":"https://api.github.com/users/PromoFaux/events{/privacy}","received_events_url":"https://api.github.com/users/PromoFaux/received_events","type":"User","site_admin":false},"created_at":"2016-04-15T15:01:00Z","updated_at":"2016-04-15T15:01:00Z","body":"That section of the code is to match domains on the queries page with `gravity.list` so that we can display the status (`pi-holed` or `ok`)\r\n\r\nI'm wondering if over a million domains is too much to load into an array...."}}