{"action":"created","issue":{"url":"https://api.github.com/repos/owncloud/core/issues/20501","labels_url":"https://api.github.com/repos/owncloud/core/issues/20501/labels{/name}","comments_url":"https://api.github.com/repos/owncloud/core/issues/20501/comments","events_url":"https://api.github.com/repos/owncloud/core/issues/20501/events","html_url":"https://github.com/owncloud/core/issues/20501","id":116842196,"number":20501,"title":"UPDATE FAIL from 8.1.3.0 to 8.1.4.2","user":{"login":"ruccc","id":15837687,"avatar_url":"https://avatars.githubusercontent.com/u/15837687?v=3","gravatar_id":"","url":"https://api.github.com/users/ruccc","html_url":"https://github.com/ruccc","followers_url":"https://api.github.com/users/ruccc/followers","following_url":"https://api.github.com/users/ruccc/following{/other_user}","gists_url":"https://api.github.com/users/ruccc/gists{/gist_id}","starred_url":"https://api.github.com/users/ruccc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ruccc/subscriptions","organizations_url":"https://api.github.com/users/ruccc/orgs","repos_url":"https://api.github.com/users/ruccc/repos","events_url":"https://api.github.com/users/ruccc/events{/privacy}","received_events_url":"https://api.github.com/users/ruccc/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2015-11-13T20:06:01Z","updated_at":"2015-11-14T17:32:54Z","closed_at":"2015-11-14T17:32:54Z","body":"### Steps to reproduce\r\n1. Update with the Updater plugin\r\n2. Go to the index, and click \"Start update\"\r\n\r\n### Expected behaviour\r\nTo get updated to the new version.\r\n\r\n### Actual behaviour\r\n```\r\nDoctrine\\DBAL\\Exception\\UniqueConstraintViolationException: An exception occurred while executing 'INSERT INTO oc_filecache (fileid, storage, path, path_hash, parent, name, mimetype, mimepart, size, mtime, storage_mtime, encrypted, unencrypted_size, etag, permissions) SELECT fileid, storage, path, path_hash, parent, name, mimetype, mimepart, size, mtime, storage_mtime, encrypted, unencrypted_size, etag, permissions FROM __temp__oc_filecache': SQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed: oc_filecache.fileid\r\n```\r\n\r\n### Server configuration\r\n**Operating system**: Linux (Shared Hosting)\r\n\r\n**Web server:** OVH\r\n\r\n**Database:** MySQL on /data/owncloud.db\r\n\r\n**PHP version:** \r\n\r\n**ownCloud version:** updating from 8.1.3.0 to 8.1.4.2\r\n**Updated from an older ownCloud or fresh install:** Updated from 8.1.3.0\r\n\r\n**List of activated apps:** Activity, Calendar, Cotacts, Dashboard, Direct Menu, Documents, Encryption, ownBackup, Tasks, Updater, WebDAV...\r\n\r\n```\r\nI don't have access to the command line\r\n\r\n```\r\n\r\n**The content of config/config.php:**\r\n\r\n```\r\n<?php\r\n$CONFIG = array (\r\n  'instanceid' => 'oc40l11pgwqf',\r\n  'datadirectory' => '/home/xxxx/www/intern/data',\r\n  'overwrite.cli.url' => 'xxxx/intern',\r\n  'dbtype' => 'sqlite3',\r\n  'version' => '8.1.3.0',\r\n  'logtimezone' => 'UTC',\r\n  'installed' => true,\r\n  'mail_smtpmode' => 'php',\r\n  'enable_previews' => true,\r\n  'preview_max_x' => NULL,\r\n  'preview_max_y' => NULL,\r\n  'theme' => '',\r\n  'loglevel' => 2,\r\n  'maintenance' => false,\r\n);\r\n```\r\n\r\n**Are you using external storage, if yes which one:** \r\n\r\n**Are you using encryption:** yes\r\n\r\n**Are you using an external user-backend, if yes which one:** LDAP/ActiveDirectory/Webdav/...\r\n\r\n\r\n```\r\n[I get blank output... Nothing...]\r\n```\r\n\r\n### Client configuration\r\n**Browser:** Firefox 41.0\r\n\r\n**Operating system:** Windows 8.1 x64\r\n\r\n\r\n#### ownCloud log (data/owncloud.log)\r\n\r\n```\r\n{\"reqId\":\"VkZBfAoAPkIAAC@BBGoAAABX\",\"remoteAddr\":\"176.84.2.83\",\"app\":\"core\",\"message\":\"starting upgrade from 8.1.3.0 to 8.1.4.2\",\"level\":0,\"time\":\"2015-11-13T20:01:00+00:00\",\"method\":\"GET\",\"url\":\"\\/intern\\/core\\/ajax\\/update.php?requesttoken=zX88%2BsRUQdUUBGgZx5BgQQqov2BeMs\"}\r\n{\"reqId\":\"VkZBfAoAPkIAAC@BBGoAAABX\",\"remoteAddr\":\"176.84.2.83\",\"app\":\"update\",\"message\":\"Exception: {\\\"Exception\\\":\\\"Doctrine\\\\\\\\DBAL\\\\\\\\Exception\\\\\\\\UniqueConstraintViolationException\\\",\\\"Message\\\":\\\"An exception occurred while executing 'INSERT INTO oc_filecache (fileid, storage, path, path_hash, parent, name, mimetype, mimepart, size, mtime, storage_mtime, encrypted, unencrypted_size, etag, permissions) SELECT fileid, storage, path, path_hash, parent, name, mimetype, mimepart, size, mtime, storage_mtime, encrypted, unencrypted_size, etag, permissions FROM __temp__oc_filecache':\\\\n\\\\nSQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed: oc_filecache.fileid\\\",\\\"Code\\\":0,\\\"Trace\\\":\\\"#0 \\\\\\/home\\\\\\/promoetidj\\\\\\/www\\\\\\/intern\\\\\\/3rdparty\\\\\\/doctrine\\\\\\/dbal\\\\\\/lib\\\\\\/Doctrine\\\\\\/DBAL\\\\\\/DBALException.php(116): Doctrine\\\\\\\\DBAL\\\\\\\\Driver\\\\\\\\AbstractSQLiteDriver->convertException('An exception oc...', Object(Doctrine\\\\\\\\DBAL\\\\\\\\Driver\\\\\\\\PDOException))\\\\n#1 \\\\\\/home\\\\\\/promoetidj\\\\\\/www\\\\\\/intern\\\\\\/3rdparty\\\\\\/doctrine\\\\\\/dbal\\\\\\/lib\\\\\\/Doctrine\\\\\\/DBAL\\\\\\/Connection.php(945): Doctrine\\\\\\\\DBAL\\\\\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\\\\\DBAL\\\\\\\\Driver\\\\\\\\PDOSqlite\\\\\\\\Driver), Object(Doctrine\\\\\\\\DBAL\\\\\\\\Driver\\\\\\\\PDOException), 'INSERT INTO oc_...')\\\\n#2 \\\\\\/home\\\\\\/promoetidj\\\\\\/www\\\\\\/intern\\\\\\/lib\\\\\\/repair\\\\\\/sqliteautoincrement.php(94): Doctrine\\\\\\\\DBAL\\\\\\\\Connection->query('INSERT INTO oc_...')\\\\n#3 \\\\\\/home\\\\\\/promoetidj\\\\\\/www\\\\\\/intern\\\\\\/lib\\\\\\/private\\\\\\/repair.php(84): OC\\\\\\\\Repair\\\\\\\\SqliteAutoincrement->run()\\\\n#4 \\\\\\/home\\\\\\/promoetidj\\\\\\/www\\\\\\/intern\\\\\\/lib\\\\\\/private\\\\\\/updater.php(313): OC\\\\\\\\Repair->run()\\\\n#5 \\\\\\/home\\\\\\/promoetidj\\\\\\/www\\\\\\/intern\\\\\\/lib\\\\\\/private\\\\\\/updater.php(208): OC\\\\\\\\Updater->doUpgrade('8.1.4.2', '8.1.3.0')\\\\n#6 \\\\\\/home\\\\\\/promoetidj\\\\\\/www\\\\\\/intern\\\\\\/core\\\\\\/ajax\\\\\\/update.php(93): OC\\\\\\\\Updater->upgrade()\\\\n#7 {main}\\\",\\\"File\\\":\\\"\\\\\\/home\\\\\\/promoetidj\\\\\\/www\\\\\\/intern\\\\\\/3rdparty\\\\\\/doctrine\\\\\\/dbal\\\\\\/lib\\\\\\/Doctrine\\\\\\/DBAL\\\\\\/Driver\\\\\\/AbstractSQLiteDriver.php\\\",\\\"Line\\\":48}\",\"level\":4,\"time\":\"2015-11-13T20:01:01+00:00\",\"method\":\"GET\",\"url\":\"\\/intern\\/core\\/ajax\\/update.php?requesttoken=zX88%2BsRUQdUUBGgZx5BgQQqov2BeMs\"}\r\n```"},"comment":{"url":"https://api.github.com/repos/owncloud/core/issues/comments/156722019","html_url":"https://github.com/owncloud/core/issues/20501#issuecomment-156722019","issue_url":"https://api.github.com/repos/owncloud/core/issues/20501","id":156722019,"user":{"login":"ruccc","id":15837687,"avatar_url":"https://avatars.githubusercontent.com/u/15837687?v=3","gravatar_id":"","url":"https://api.github.com/users/ruccc","html_url":"https://github.com/ruccc","followers_url":"https://api.github.com/users/ruccc/followers","following_url":"https://api.github.com/users/ruccc/following{/other_user}","gists_url":"https://api.github.com/users/ruccc/gists{/gist_id}","starred_url":"https://api.github.com/users/ruccc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ruccc/subscriptions","organizations_url":"https://api.github.com/users/ruccc/orgs","repos_url":"https://api.github.com/users/ruccc/repos","events_url":"https://api.github.com/users/ruccc/events{/privacy}","received_events_url":"https://api.github.com/users/ruccc/received_events","type":"User","site_admin":false},"created_at":"2015-11-14T17:32:54Z","updated_at":"2015-11-14T17:32:54Z","body":"@RealRancor Ok, thanks!"}}