{"action":"created","issue":{"url":"https://api.github.com/repos/owncloud/music/issues/402","labels_url":"https://api.github.com/repos/owncloud/music/issues/402/labels{/name}","comments_url":"https://api.github.com/repos/owncloud/music/issues/402/comments","events_url":"https://api.github.com/repos/owncloud/music/issues/402/events","html_url":"https://github.com/owncloud/music/issues/402","id":95353501,"number":402,"title":"Error while running background job: An exception occurred while executing 'UPDATE `oc_music_albums`","user":{"login":"binarykitchen","id":177641,"avatar_url":"https://avatars.githubusercontent.com/u/177641?v=3","gravatar_id":"","url":"https://api.github.com/users/binarykitchen","html_url":"https://github.com/binarykitchen","followers_url":"https://api.github.com/users/binarykitchen/followers","following_url":"https://api.github.com/users/binarykitchen/following{/other_user}","gists_url":"https://api.github.com/users/binarykitchen/gists{/gist_id}","starred_url":"https://api.github.com/users/binarykitchen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/binarykitchen/subscriptions","organizations_url":"https://api.github.com/users/binarykitchen/orgs","repos_url":"https://api.github.com/users/binarykitchen/repos","events_url":"https://api.github.com/users/binarykitchen/events{/privacy}","received_events_url":"https://api.github.com/users/binarykitchen/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/owncloud/music/milestones/6","html_url":"https://github.com/owncloud/music/milestones/0.3.7","labels_url":"https://api.github.com/repos/owncloud/music/milestones/6/labels","id":1202355,"number":6,"title":"0.3.7","description":"","creator":{"login":"MorrisJobke","id":245432,"avatar_url":"https://avatars.githubusercontent.com/u/245432?v=3","gravatar_id":"","url":"https://api.github.com/users/MorrisJobke","html_url":"https://github.com/MorrisJobke","followers_url":"https://api.github.com/users/MorrisJobke/followers","following_url":"https://api.github.com/users/MorrisJobke/following{/other_user}","gists_url":"https://api.github.com/users/MorrisJobke/gists{/gist_id}","starred_url":"https://api.github.com/users/MorrisJobke/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MorrisJobke/subscriptions","organizations_url":"https://api.github.com/users/MorrisJobke/orgs","repos_url":"https://api.github.com/users/MorrisJobke/repos","events_url":"https://api.github.com/users/MorrisJobke/events{/privacy}","received_events_url":"https://api.github.com/users/MorrisJobke/received_events","type":"User","site_admin":false},"open_issues":0,"closed_issues":9,"state":"closed","created_at":"2015-07-10T11:33:16Z","updated_at":"2015-07-16T08:01:15Z","due_on":null,"closed_at":"2015-07-16T08:01:15Z"},"comments":6,"created_at":"2015-07-16T05:26:04Z","updated_at":"2015-08-10T23:04:58Z","closed_at":"2015-07-16T07:52:26Z","body":"### Steps to reproduce\r\nHappens during cron's background job\r\n\r\n### Expected behaviour\r\nDo the job and complete it successfully\r\n\r\n### Actual behaviour\r\nHere's the log output\r\n\r\n```\r\n$ tail owncloud.log\r\n{\"reqId\":\"TkW6fALsXZnTNh7Nyjwk\",\"remoteAddr\":\"\",\"app\":\"PHP\",\"message\":\"Undefined index: REQUEST_URI at \\/var\\/www\\/owncloud\\/apps\\/contacts\\/appinfo\\/app.php#35\",\"level\":3,\"time\":\"2015-07-16T04:15:01+00:00\"}\r\n{\"reqId\":\"TkW6fALsXZnTNh7Nyjwk\",\"remoteAddr\":\"\",\"app\":\"no app in context\",\"message\":\"Error while running background job: An exception occurred while executing 'UPDATE `oc_music_albums` SET `cover_file_id` = NULL WHERE `cover_file_id` IS NOT NULL AND `cover_file_id` IN (SELECT `cover_file_id` FROM `oc_music_albums` LEFT JOIN `oc_filecache` ON `cover_file_id`=`fileid` WHERE `fileid` IS NULL);':\\n\\nSQLSTATE[HY000]: General error: 1093 You can't specify target table 'oc_music_albums' for update in FROM clause\",\"level\":3,\"time\":\"2015-07-16T04:15:07+00:00\"}\r\n{\"reqId\":\"dw9vJKjH7y4iyXZZwjmh\",\"remoteAddr\":\"\",\"app\":\"PHP\",\"message\":\"Undefined index: REQUEST_URI at \\/var\\/www\\/owncloud\\/apps\\/contacts\\/appinfo\\/app.php#35\",\"level\":3,\"time\":\"2015-07-16T04:30:01+00:00\"}\r\n{\"reqId\":\"dw9vJKjH7y4iyXZZwjmh\",\"remoteAddr\":\"\",\"app\":\"no app in context\",\"message\":\"Error while running background job: An exception occurred while executing 'UPDATE `oc_music_albums` SET `cover_file_id` = NULL WHERE `cover_file_id` IS NOT NULL AND `cover_file_id` IN (SELECT `cover_file_id` FROM `oc_music_albums` LEFT JOIN `oc_filecache` ON `cover_file_id`=`fileid` WHERE `fileid` IS NULL);':\\n\\nSQLSTATE[HY000]: General error: 1093 You can't specify target table 'oc_music_albums' for update in FROM clause\",\"level\":3,\"time\":\"2015-07-16T04:30:17+00:00\"}\r\n{\"reqId\":\"m6xFaKOPqusZ4vgJtQec\",\"remoteAddr\":\"\",\"app\":\"PHP\",\"message\":\"Undefined index: REQUEST_URI at \\/var\\/www\\/owncloud\\/apps\\/contacts\\/appinfo\\/app.php#35\",\"level\":3,\"time\":\"2015-07-16T04:45:01+00:00\"}\r\n{\"reqId\":\"m6xFaKOPqusZ4vgJtQec\",\"remoteAddr\":\"\",\"app\":\"no app in context\",\"message\":\"Error while running background job: An exception occurred while executing 'UPDATE `oc_music_albums` SET `cover_file_id` = NULL WHERE `cover_file_id` IS NOT NULL AND `cover_file_id` IN (SELECT `cover_file_id` FROM `oc_music_albums` LEFT JOIN `oc_filecache` ON `cover_file_id`=`fileid` WHERE `fileid` IS NULL);':\\n\\nSQLSTATE[HY000]: General error: 1093 You can't specify target table 'oc_music_albums' for update in FROM clause\",\"level\":3,\"time\":\"2015-07-16T04:45:06+00:00\"}\r\n{\"reqId\":\"3ZS9Zfamm9oRVK7zS+Kq\",\"remoteAddr\":\"\",\"app\":\"PHP\",\"message\":\"Undefined index: REQUEST_URI at \\/var\\/www\\/owncloud\\/apps\\/contacts\\/appinfo\\/app.php#35\",\"level\":3,\"time\":\"2015-07-16T05:00:01+00:00\"}\r\n{\"reqId\":\"3ZS9Zfamm9oRVK7zS+Kq\",\"remoteAddr\":\"\",\"app\":\"no app in context\",\"message\":\"Error while running background job: An exception occurred while executing 'UPDATE `oc_music_albums` SET `cover_file_id` = NULL WHERE `cover_file_id` IS NOT NULL AND `cover_file_id` IN (SELECT `cover_file_id` FROM `oc_music_albums` LEFT JOIN `oc_filecache` ON `cover_file_id`=`fileid` WHERE `fileid` IS NULL);':\\n\\nSQLSTATE[HY000]: General error: 1093 You can't specify target table 'oc_music_albums' for update in FROM clause\",\"level\":3,\"time\":\"2015-07-16T05:00:14+00:00\"}\r\n{\"reqId\":\"SmA241yzR9ICvQaOOYgf\",\"remoteAddr\":\"\",\"app\":\"PHP\",\"message\":\"Undefined index: REQUEST_URI at \\/var\\/www\\/owncloud\\/apps\\/contacts\\/appinfo\\/app.php#35\",\"level\":3,\"time\":\"2015-07-16T05:15:02+00:00\"}\r\n{\"reqId\":\"SmA241yzR9ICvQaOOYgf\",\"remoteAddr\":\"\",\"app\":\"no app in context\",\"message\":\"Error while running background job: An exception occurred while executing 'UPDATE `oc_music_albums` SET `cover_file_id` = NULL WHERE `cover_file_id` IS NOT NULL AND `cover_file_id` IN (SELECT `cover_file_id` FROM `oc_music_albums` LEFT JOIN `oc_filecache` ON `cover_file_id`=`fileid` WHERE `fileid` IS NULL);':\\n\\nSQLSTATE[HY000]: General error: 1093 You can't specify target table 'oc_music_albums' for update in FROM clause\",\"level\":3,\"time\":\"2015-07-16T05:15:06+00:00\"}\r\n\r\n```\r\n\r\n### Server configuration\r\n\r\n```\r\n$ lsb_release -a\r\nNo LSB modules are available.\r\nDistributor ID: Ubuntu\r\nDescription:    Ubuntu 14.04.2 LTS\r\nRelease:        14.04\r\nCodename:       trusty\r\n```\r\n\r\n```\r\n$ uname -a      \r\nLinux binarykitchen.com 3.12.27-xenU #1 SMP Thu Aug 28 23:13:07 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux\r\n```\r\n\r\nWeb server:\r\n\r\n```\r\n$ nginx -v\r\nnginx version: nginx/1.8.0\r\n```\r\n\r\nDatabase:\r\n\r\n```\r\n$ mysql --version\r\nmysql  Ver 14.14 Distrib 5.5.43, for debian-linux-gnu (x86_64) using readline 6.3\r\n```\r\n\r\nPHP version:\r\n\r\n```\r\n$ php -v\r\nPHP 5.5.27-1+deb.sury.org~trusty+1 (cli) (built: Jul 15 2015 12:14:44) \r\nCopyright (c) 1997-2015 The PHP Group\r\nZend Engine v2.5.0, Copyright (c) 1998-2015 Zend Technologies\r\n    with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2015, by Zend Technologies\r\n```\r\n\r\nownCloud version:\r\nownCloud 8.1.0-3 (stable) \r\n\r\nUpdated from an older ownCloud or fresh install:\r\nFresh install via apt-get\r\n\r\n```\r\n$ sudo -u www-data php ./occ app:list\r\nEnabled:\r\n - activity: 2.0.1\r\n - bookmarks: 0.4\r\n - calendar: 0.7.1\r\n - contacts: 0.4.0.0\r\n - documents: 0.9.0\r\n - encryption: 1.0.0\r\n - external: 1.2\r\n - files: 1.1.9\r\n - files_locking: \r\n - files_pdfviewer: 0.7\r\n - files_sharing: 0.6.2\r\n - files_texteditor: 0.4\r\n - files_versions: 1.0.6\r\n - files_videoviewer: 0.1.3\r\n - galleryplus: 12\r\n - mozilla_sync: 1.4\r\n - music: 0.3.5\r\n - provisioning_api: 0.2\r\n - storagecharts2: 2.6.1\r\n - tasks: 0.7.1\r\n - templateeditor: 0.1\r\n - videos: 1.0\r\nDisabled:\r\n - files_external\r\n - files_trashbin\r\n - firstrunwizard\r\n - gallery\r\n - user_external\r\n - user_ldap\r\n - user_webdavauth\r\n```\r\n\r\nThe content of config/config.php: (Without sensitive data)\r\n\r\n```\r\n$ cat config.php                                                                                                                                                                                       Â î‚²Â 1Â \r\n<?php\r\n$CONFIG = array (\r\n  'instanceid' => 'oc02ca513338',\r\n  'passwordsalt' => 'xxx',\r\n  'datadirectory' => '/var/www/owncloud/data',\r\n  'dbtype' => 'mysql',\r\n  'version' => '8.1.0.8',\r\n  'dbname' => 'owncloud',\r\n  'dbhost' => 'localhost',\r\n  'dbtableprefix' => 'oc_',\r\n  'dbuser' => 'owncloud',\r\n  'dbpassword' => 'xxx',\r\n  'installed' => true,\r\n  'forcessl' => true,\r\n  'loglevel' => 1,\r\n  'logfile' => '/var/log/owncloud.log',\r\n  'theme' => '',\r\n  'maintenance' => false,\r\n  'memcache.local' => '\\OC\\Memcache\\APCu',\r\n  'trusted_domains' => \r\n  array (\r\n    0 => 'xxx',\r\n  ),\r\n  'mail_smtpmode' => 'smtp',\r\n  'secret' => 'xxx',\r\n  'forceSSLforSubdomains' => true,\r\n  'mail_smtpsecure' => 'tls',\r\n  'mail_smtphost' => '127.0.0.1',\r\n  'mail_smtpport' => 'xxx',\r\n  'mail_smtpauth' => 1,\r\n  'mail_smtpname' => 'xxx',\r\n  'mail_smtppassword' => 'xxx',\r\n  'mail_smtpauthtype' => 'PLAIN',\r\n);\r\n\r\n```\r\n\r\nAre you using external storage, if yes which one:\r\nNone\r\n\r\n### Client configuration\r\nBrowser:\r\nFirefox 40\r\n\r\nOperating system:\r\nUbuntu 15.04\r\n\r\n### Logs\r\n\r\n#### Web server error log\r\n\r\nPlenty of those nginx entries:\r\n\r\n```\r\n2015/07/16 17:22:10 [error] 2041#0: *1726 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 203.84.135.120, server: cloud.binarykitchen.com, request: \"GET / HTTP/1.1\", upstream: \"fastcgi://unix:/var/run/php5-fpm.sock\", host: \"cloud.binarykitchen.com\"\r\n```\r\n\r\n#### ownCloud log (data/owncloud.log)\r\nN/A\r\n\r\n#### Browser log\r\nIrrelevant\r\n"},"comment":{"url":"https://api.github.com/repos/owncloud/music/issues/comments/129642695","html_url":"https://github.com/owncloud/music/issues/402#issuecomment-129642695","issue_url":"https://api.github.com/repos/owncloud/music/issues/402","id":129642695,"user":{"login":"binarykitchen","id":177641,"avatar_url":"https://avatars.githubusercontent.com/u/177641?v=3","gravatar_id":"","url":"https://api.github.com/users/binarykitchen","html_url":"https://github.com/binarykitchen","followers_url":"https://api.github.com/users/binarykitchen/followers","following_url":"https://api.github.com/users/binarykitchen/following{/other_user}","gists_url":"https://api.github.com/users/binarykitchen/gists{/gist_id}","starred_url":"https://api.github.com/users/binarykitchen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/binarykitchen/subscriptions","organizations_url":"https://api.github.com/users/binarykitchen/orgs","repos_url":"https://api.github.com/users/binarykitchen/repos","events_url":"https://api.github.com/users/binarykitchen/events{/privacy}","received_events_url":"https://api.github.com/users/binarykitchen/received_events","type":"User","site_admin":false},"created_at":"2015-08-10T23:04:58Z","updated_at":"2015-08-10T23:04:58Z","body":"How would you install it then? I cannot find it under the \"Apps\" tab"}}