{"action":"opened","issue":{"url":"https://api.github.com/repos/mistic100/Piwigo/issues/258","labels_url":"https://api.github.com/repos/mistic100/Piwigo/issues/258/labels{/name}","comments_url":"https://api.github.com/repos/mistic100/Piwigo/issues/258/comments","events_url":"https://api.github.com/repos/mistic100/Piwigo/issues/258/events","html_url":"https://github.com/mistic100/Piwigo/issues/258","id":97226791,"number":258,"title":"[albums] Batch-managing a since-deleted album gives SQL error","user":{"login":"plegall","id":9326959,"avatar_url":"https://avatars.githubusercontent.com/u/9326959?v=3","gravatar_id":"","url":"https://api.github.com/users/plegall","html_url":"https://github.com/plegall","followers_url":"https://api.github.com/users/plegall/followers","following_url":"https://api.github.com/users/plegall/following{/other_user}","gists_url":"https://api.github.com/users/plegall/gists{/gist_id}","starred_url":"https://api.github.com/users/plegall/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/plegall/subscriptions","organizations_url":"https://api.github.com/users/plegall/orgs","repos_url":"https://api.github.com/users/plegall/repos","events_url":"https://api.github.com/users/plegall/events{/privacy}","received_events_url":"https://api.github.com/users/plegall/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/mistic100/Piwigo/labels/minor","name":"minor","color":"ededed"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-07-25T13:26:56Z","updated_at":"2015-07-25T13:26:56Z","closed_at":null,"body":"**Reported by samwilson on 24 May 2014 23:26**\n\n**Version:** 2.6.2\n\nHello,\r\n\r\nI had the batch-manager open for a single album, then in another window deleted that album (it no longer had any photos in it), and when I came back to the batch-manager to move to a different album it gave me the following error:\r\n\r\nWarning:  [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near &#039;)&#039; at line 3\r\n\r\n SELECT DISTINCT(image_id)\r\n   FROM image_category\r\n   WHERE category_id IN ()\r\n ; in /home/user/photos.example.com/include/dblayer/functions_mysqli.inc.php on line 798\r\n\r\n\r\nFatal error: Call to a member function fetch_assoc() on a non-object in /home/user/photos.example.com/include/dblayer/functions_mysqli.inc.php on line 181\r\n\r\nThe URL was: http://photos.example.com/admin.php?page=batch_manager\r\n\r\nPlease let me know if I can provide any more information.\n\n[Piwigo Bugtracker #3084](http://piwigo.org/bugs/view.php?id=3084)"}}