{"action":"created","issue":{"url":"https://api.github.com/repos/owncloud/core/issues/16125","labels_url":"https://api.github.com/repos/owncloud/core/issues/16125/labels{/name}","comments_url":"https://api.github.com/repos/owncloud/core/issues/16125/comments","events_url":"https://api.github.com/repos/owncloud/core/issues/16125/events","html_url":"https://github.com/owncloud/core/issues/16125","id":73630356,"number":16125,"title":"After Upgrade OC7 => OC8.0.3 some encryption keys are broken","user":{"login":"rjaeckel","id":3328799,"avatar_url":"https://avatars.githubusercontent.com/u/3328799?v=3","gravatar_id":"","url":"https://api.github.com/users/rjaeckel","html_url":"https://github.com/rjaeckel","followers_url":"https://api.github.com/users/rjaeckel/followers","following_url":"https://api.github.com/users/rjaeckel/following{/other_user}","gists_url":"https://api.github.com/users/rjaeckel/gists{/gist_id}","starred_url":"https://api.github.com/users/rjaeckel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rjaeckel/subscriptions","organizations_url":"https://api.github.com/users/rjaeckel/orgs","repos_url":"https://api.github.com/users/rjaeckel/repos","events_url":"https://api.github.com/users/rjaeckel/events{/privacy}","received_events_url":"https://api.github.com/users/rjaeckel/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/owncloud/core/labels/app:files_encryption","name":"app:files_encryption","color":"02d7e1"},{"url":"https://api.github.com/repos/owncloud/core/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":{"login":"schiesbn","id":1589737,"avatar_url":"https://avatars.githubusercontent.com/u/1589737?v=3","gravatar_id":"","url":"https://api.github.com/users/schiesbn","html_url":"https://github.com/schiesbn","followers_url":"https://api.github.com/users/schiesbn/followers","following_url":"https://api.github.com/users/schiesbn/following{/other_user}","gists_url":"https://api.github.com/users/schiesbn/gists{/gist_id}","starred_url":"https://api.github.com/users/schiesbn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/schiesbn/subscriptions","organizations_url":"https://api.github.com/users/schiesbn/orgs","repos_url":"https://api.github.com/users/schiesbn/repos","events_url":"https://api.github.com/users/schiesbn/events{/privacy}","received_events_url":"https://api.github.com/users/schiesbn/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/owncloud/core/milestones/42","html_url":"https://github.com/owncloud/core/milestones/8.0.5-current-maintenance","labels_url":"https://api.github.com/repos/owncloud/core/milestones/42/labels","id":1090951,"number":42,"title":"8.0.5-current-maintenance","description":"","creator":{"login":"craigpg","id":160667,"avatar_url":"https://avatars.githubusercontent.com/u/160667?v=3","gravatar_id":"","url":"https://api.github.com/users/craigpg","html_url":"https://github.com/craigpg","followers_url":"https://api.github.com/users/craigpg/followers","following_url":"https://api.github.com/users/craigpg/following{/other_user}","gists_url":"https://api.github.com/users/craigpg/gists{/gist_id}","starred_url":"https://api.github.com/users/craigpg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/craigpg/subscriptions","organizations_url":"https://api.github.com/users/craigpg/orgs","repos_url":"https://api.github.com/users/craigpg/repos","events_url":"https://api.github.com/users/craigpg/events{/privacy}","received_events_url":"https://api.github.com/users/craigpg/received_events","type":"User","site_admin":false},"open_issues":22,"closed_issues":28,"state":"open","created_at":"2015-04-30T11:59:10Z","updated_at":"2015-06-19T07:14:10Z","due_on":null,"closed_at":null},"comments":13,"created_at":"2015-05-06T13:59:44Z","updated_at":"2015-06-19T09:29:19Z","closed_at":null,"body":"### Steps to reproduce\r\n1. working oc7.0.4\r\n2. get folder shared by other users, probably shared to many (?)\r\n3. manually upgrade, `php occ upgrade`\r\n\r\n### Expected behaviour\r\nshared files should be accessible\r\n\r\n### Actual behaviour\r\nBrowser returns 500 error; Details on bottom\r\n\r\n### Server configuration\r\n**Operating system**: ubuntu 14.04 LTS\r\n\r\n**Web server:** apache 2.4\r\n\r\n**Database:** mysql 5.5\r\n\r\n**PHP version:** 5.5.9 with Zend OPCache v7.0.3\r\n\r\n**ownCloud version:** 7.0.4 => 8.0.3\r\n\r\n**Updated from an older ownCloud or fresh install:** upgraded\r\n\r\n**List of activated apps:**\r\n - activity\r\n - files\r\n - files_encryption\r\n - files_external\r\n - files_pdfviewer\r\n - files_sharing\r\n - files_texteditor\r\n - files_versions\r\n - files_videoviewer\r\n - firstrunwizard\r\n - gallery\r\n - updater\r\n - user_ldap\r\n\r\n**The content of config/config.php:**\r\n\r\n```<?php\r\n$CONFIG = array (\r\n  'trusted_domains' =>\r\n  array (\r\n    0 => 'test.cloud.uni-halle.de',\r\n  ),\r\n  'datadirectory' => '/var/www/owncloud-test/oc-data',\r\n  'skeletondirectory' => '/var/www/owncloud-test/user-template',\r\n  'dbtype' => 'mysql',\r\n  'version' => '8.0.3.4',\r\n  'theme' => '',\r\n  'preview_libreoffice_path' => '/usr/bin/libreoffice',\r\n  'loglevel' => '2',\r\n  'maintenance' => false,\r\n  'appstoreenabled' => false,\r\n  'enable_avatars' => false,\r\n  'enabledPreviewProviders' =>\r\n  array (\r\n    0 => 'OC\\\\Preview\\\\Image',\r\n    1 => 'OC\\\\Preview\\\\MP3',\r\n    2 => 'OC\\\\Preview\\\\TXT',\r\n    3 => 'OC\\\\Preview\\\\MarkDown',\r\n    4 => 'OC\\\\Preview\\\\Movie',\r\n    5 => 'OC\\\\Preview\\\\MSOffice2003',\r\n    6 => 'OC\\\\Preview\\\\MSOffice2007',\r\n    7 => 'OC\\\\Preview\\\\MSOfficeDoc',\r\n    8 => 'OC\\\\Preview\\\\OpenDocument',\r\n    9 => 'OC\\\\Preview\\\\PDF',\r\n    10 => 'OC\\\\Preview\\\\StarOffice',\r\n    11 => 'OC\\\\Preview\\\\SVG',\r\n  ),\r\n  'installed' => true,\r\n  'ldapIgnoreNamingRules' => false,\r\n  'config_is_read_only' => true,\r\n);\r\n\r\n```\r\n\r\n**Are you using external storage, if yes which one:** nope\r\n\r\n**Are you using encryption:** yes, enabled for all\r\n\r\n**Are you using an external user-backend, if yes which one:** ActiveDirectory\r\n\r\n\r\n\r\nI'm getting several Errors like this one:\r\n\r\n```\r\nArray\r\n(\r\n    [Message] => Encryption key not found for \"/abewm/files/Relaunch Web/Projekt Relaunch Website 09-03-2015.pdf\" during attempted read via stream\r\n    [Code] => 0\r\n    [Trace] => #0 [internal function]: OCA\\Files_Encryption\\Stream->stream_read(8192)\r\n#1 /var/www/owncloud-test/owncloud-8/lib/private/files/view.php(283): fread(Resource id #174, 8192)\r\n#2 /var/www/owncloud-test/owncloud-8/lib/private/files/filesystem.php(606): OC\\Files\\View->readfile('/Relaunch Web/P...')\r\n#3 /var/www/owncloud-test/owncloud-8/lib/private/files.php(155): OC\\Files\\Filesystem::readfile('/Relaunch Web/P...')\r\n#4 /var/www/owncloud-test/owncloud-8/apps/files/ajax/download.php(37): OC_Files::get('/Relaunch Web', Array, false)\r\n#5 /var/www/owncloud-test/owncloud-8/lib/private/route/route.php(135) : runtime-created function(1): require_once('/var/www/ownclo...')\r\n#6 [internal function]: __lambda_func(Array)\r\n#7 /var/www/owncloud-test/owncloud-8/lib/private/route/router.php(250): call_user_func('?lambda_827', Array)\r\n#8 /var/www/owncloud-test/owncloud-8/lib/base.php(782): OC\\Route\\Router->match('/apps/files/aja...')\r\n#9 /var/www/owncloud-test/owncloud-8/index.php(36): OC::handleRequest()\r\n#10 {main}\r\n    [File] => /var/www/owncloud-test/owncloud-8/apps/files_encryption/lib/stream.php\r\n    [Line] => 281\r\n)\r\n```\r\n\r\nBefore upgrade everything worked fine. The files are shared by another user. Bot not every file shared is affected.\r\nI guess resharing would be a solution to this. But I'd rather prefer to get a reason for this.\r\n\r\nThe Installation was updated manually using `php occ upgrade` . **Is there anyway to get a log about the upgrade process?**"},"comment":{"url":"https://api.github.com/repos/owncloud/core/issues/comments/113445269","html_url":"https://github.com/owncloud/core/issues/16125#issuecomment-113445269","issue_url":"https://api.github.com/repos/owncloud/core/issues/16125","id":113445269,"user":{"login":"SergioBertolinSG","id":9048796,"avatar_url":"https://avatars.githubusercontent.com/u/9048796?v=3","gravatar_id":"","url":"https://api.github.com/users/SergioBertolinSG","html_url":"https://github.com/SergioBertolinSG","followers_url":"https://api.github.com/users/SergioBertolinSG/followers","following_url":"https://api.github.com/users/SergioBertolinSG/following{/other_user}","gists_url":"https://api.github.com/users/SergioBertolinSG/gists{/gist_id}","starred_url":"https://api.github.com/users/SergioBertolinSG/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SergioBertolinSG/subscriptions","organizations_url":"https://api.github.com/users/SergioBertolinSG/orgs","repos_url":"https://api.github.com/users/SergioBertolinSG/repos","events_url":"https://api.github.com/users/SergioBertolinSG/events{/privacy}","received_events_url":"https://api.github.com/users/SergioBertolinSG/received_events","type":"User","site_admin":false},"created_at":"2015-06-19T09:29:19Z","updated_at":"2015-06-19T09:29:19Z","body":"I've tested this, first without active directory there is no problem at all with upgrading from 7 to 8.0.X using encryption.\r\n\r\n\r\nBut in the same situation with an active directory enabled and a folder shared to a active directory group of users I got a mysql exception:\r\n\r\nTurned on maintenance mode\r\nAn exception occurred while executing 'CREATE INDEX 9e69e7zfw5ie1 ON share_5zbksy7wuomzf (`item_type`, `share_type`)':\r\n\r\nSQLSTATE[42000]: Syntax error or access violation: 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 '9e69e7zfw5ie1 ON share_5zbksy7wuomzf (`item_type`, `share_type`)' at line 1\r\nTurned off maintenance mode\r\nUpdate failed"}}