{"action":"created","issue":{"url":"https://api.github.com/repos/owncloud/news/issues/540","labels_url":"https://api.github.com/repos/owncloud/news/issues/540/labels{/name}","comments_url":"https://api.github.com/repos/owncloud/news/issues/540/comments","events_url":"https://api.github.com/repos/owncloud/news/issues/540/events","html_url":"https://github.com/owncloud/news/issues/540","id":35233983,"number":540,"title":"Error \"1038 Out of sort memory, consider increasing server sort buffer size\"","user":{"login":"wwark","id":469461,"avatar_url":"https://avatars.githubusercontent.com/u/469461?v=3","gravatar_id":"","url":"https://api.github.com/users/wwark","html_url":"https://github.com/wwark","followers_url":"https://api.github.com/users/wwark/followers","following_url":"https://api.github.com/users/wwark/following{/other_user}","gists_url":"https://api.github.com/users/wwark/gists{/gist_id}","starred_url":"https://api.github.com/users/wwark/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wwark/subscriptions","organizations_url":"https://api.github.com/users/wwark/orgs","repos_url":"https://api.github.com/users/wwark/repos","events_url":"https://api.github.com/users/wwark/events{/privacy}","received_events_url":"https://api.github.com/users/wwark/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":9,"created_at":"2014-06-08T11:31:14Z","updated_at":"2015-08-19T08:40:56Z","closed_at":"2014-06-08T12:31:49Z","body":"Dear Support,\r\n\r\nI have recently installed Owncloud in my NAS DS411 http://nas.findthebest.com/l/748346/Synology-DS111\r\n\r\nI had an issue with this news app. I have got this fatal error when i tried to add a site to feed.\r\n<br>Doctrine\\DBAL\\DBALException: An exception occurred while executing 'SELECT `feeds`.*, COUNT(`items`.`id`) AS `unread_count` FROM `news_feeds` `feeds` LEFT JOIN `news_items` `items` ON `feeds`.`id` = `items`.`feed_id` AND (`items`.`status` & 2) = 2 WHERE `feeds`.`url_hash` = ? AND `feeds`.`user_id` = ? GROUP BY `feeds`.`id`, `feeds`.`user_id`, `feeds`.`url_hash`,`feeds`.`url`, `feeds`.`title`, `feeds`.`link`,`feeds`.`favicon_link`, `feeds`.`added`, `feeds`.`articles_per_update`,`feeds`.`folder_id`, `feeds`.`prevent_update`, `feeds`.`deleted_at`' with params [\"********\", \"*****\"]: SQLSTATE[HY001]: Memory allocation error: 1038 Out of sort memory, consider increasing server sort buffer size</br>\r\n\r\nMy NAS has just 256 mo so maybe it is the problem.\r\n\r\nCould yo please give me some hints to this error ?\r\n\r\nRegards,\r\nWark."},"comment":{"url":"https://api.github.com/repos/owncloud/news/issues/comments/132494438","html_url":"https://github.com/owncloud/news/issues/540#issuecomment-132494438","issue_url":"https://api.github.com/repos/owncloud/news/issues/540","id":132494438,"user":{"login":"patlajan","id":3504837,"avatar_url":"https://avatars.githubusercontent.com/u/3504837?v=3","gravatar_id":"","url":"https://api.github.com/users/patlajan","html_url":"https://github.com/patlajan","followers_url":"https://api.github.com/users/patlajan/followers","following_url":"https://api.github.com/users/patlajan/following{/other_user}","gists_url":"https://api.github.com/users/patlajan/gists{/gist_id}","starred_url":"https://api.github.com/users/patlajan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/patlajan/subscriptions","organizations_url":"https://api.github.com/users/patlajan/orgs","repos_url":"https://api.github.com/users/patlajan/repos","events_url":"https://api.github.com/users/patlajan/events{/privacy}","received_events_url":"https://api.github.com/users/patlajan/received_events","type":"User","site_admin":false},"created_at":"2015-08-19T08:40:56Z","updated_at":"2015-08-19T08:40:56Z","body":"Thanks for the answer Raydiation,\r\nAny way to configure/override that behavior?"}}