upgrade 10.0.2 -> 10.0.3 failed

[rohrauer]

Steps to reproduce

1.Terminal: sudo -u www-data php /var/www/owncloud/occ upgrade
2.
3.

Expected behaviour

owncloud should be upgraded to version 10.0.3

Actual behaviour

Error-messge in terminal: Doctrine\DBAL\Schema\SchemaException: There is no column with name 'fileid' on table 'oc_properties'. Update failed

Server configuration

Operating system: Linux Mint Debian Edition (LMDE)

Web server: apache

Database: mySQL

PHP version: 5.6.30

ownCloud version: (see ownCloud admin page) 10.0.2 -> 10.0.3

Updated from an older ownCloud or fresh install: try to update

Where did you install ownCloud from: download.owncloud.org/download/repositories/stable/Debian_8.0/ /

Signing status (ownCloud 9.0 and above):

Login as admin user into your ownCloud and access 
http://example.com/index.php/settings/integrity/failed 
paste the results into https://gist.github.com/ and puth the link here.

sorry, can't follow this instructions (I'm not an IT-specialist)

The content of config/config.php:

false, 'instanceid' => 'xxxxxxxxxxxxxxxxx', 'passwordsalt' => 'xxxxxxxxxxxxxxxxxxxxxxxxxxxx', 'secret' => 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', 'trusted_domains' => array ( 0 => '127.0.0.1', 1 => '192.168.xxx.xxx', 2 => 'xxxxxxxxxxxxxxxxxxxxxxx', 3 => 'xxxxxxxxxxxxxxxxxxxxxxx', ), 'datadirectory' => '/xxxxxxxxxx', 'overwrite.cli.url' => 'http://127.0.0.1/owncloud', 'dbtype' => 'mysql', 'version' => '9.1.6.2', 'dbname' => 'xxxxxxxxxx', 'dbhost' => 'localhost', 'dbtableprefix' => 'oc_', 'dbuser' => 'oc_xxxxxx', 'dbpassword' => 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', 'logtimezone' => 'UTC', 'installed' => true, 'loglevel' => 0, 'maintenance' => false, 'singleuser' => false, 'appstore.experimental.enabled' => true, 'theme' => '', ); ``` Log in to the web-UI with an administrator account and click on 'admin' -> 'Generate Config Report' -> 'Download ownCloud config report' This report includes the config.php settings, the list of activated apps and other details in a well sanitized form. or If you have access to your command line run e.g.: sudo -u www-data php occ config:list system from within your ownCloud installation folder { "system": { "updatechecker": false, "instanceid": "ocgtamba8rzz", "passwordsalt": "***REMOVED SENSITIVE VALUE***", "secret": "***REMOVED SENSITIVE VALUE***", "trusted_domains": [ "127.0.0.1", "192.168.255.10", "10.0.0.7", "rohrauer.zapto.org" ], "datadirectory": "\/var\/www\/owncloud\/data", "overwrite.cli.url": "http:\/\/127.0.0.1\/owncloud", "dbtype": "mysql", "version": "9.1.6.2", "dbname": "wolke", "dbhost": "localhost", "dbtableprefix": "oc_", "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "logtimezone": "UTC", "installed": true, "loglevel": 0, "maintenance": false, "singleuser": false, "appstore.experimental.enabled": true, "theme": "" } } **List of activated apps:** ownCloud or one of the apps require upgrade - only a limited number of commands are available You may use your browser or the occ upgrade command to do the upgrade Enabled: - activity: 2.3.6 - audioplayer: 2.1.0 - calendar: 1.5.4 - comments: 0.3.0 - configreport: 0.1.1 - contacts: 1.5.3 - dav: 0.2.8 - federatedfilesharing: 0.3.1 - federation: 0.1.0 - files: 1.5.1 - files_external: 0.7.0 - files_pdfviewer: 0.8.2 - files_sharing: 0.10.0 - files_texteditor: 2.2.1 - files_trashbin: 0.9.0 - files_versions: 1.3.0 - files_videoplayer: 0.9.8 - firstrunwizard: 1.1 - gallery: 16.0.2 - market: 0.2.2 - notifications: 0.3.0 - ownbackup: 17.7.0 - provisioning_api: 0.5.0 - search_lucene: true - systemtags: 0.3.0 - templateeditor: 0.1 - updatenotification: 0.2.1 Disabled: - documents - encryption - external - files_antivirus - notes - theme-example - user_external ``` ``` **Are you using external storage, if yes which one:** local/smb/sftp/... no **Are you using encryption:** yes/no no **Are you using an external user-backend, if yes which one:** LDAP/ActiveDirectory/Webdav/... no ``` ### Client configuration **Browser:** firefox **Operating system:** LMDE (Linux Mint Debia Edition) ### Logs #### Web server error log ``` Insert your webserver log here ``` #### ownCloud log (data/owncloud.log) ``` {"reqId":"UeCql7dC9bbcF2zbcpvO","level":0,"time":"2017-09-20T04:00:02+00:00","remoteAddr":"","user":"--","app":"core","method":"--","url":"--","message":"starting upgrade from 9.1.6.2 to 10.0.3.3"} {"reqId":"UeCql7dC9bbcF2zbcpvO","level":3,"time":"2017-09-20T04:00:02+00:00","remoteAddr":"","user":"--","app":"PHP","method":"--","url":"--","message":"file_put_contents(\/var\/www\/owncloud\/data\/.htaccess): failed to open stream: Permission denied at \/var\/www\/owncloud\/lib\/private\/Setup.php#487"} {"reqId":"UeCql7dC9bbcF2zbcpvO","level":3,"time":"2017-09-20T04:05:10+00:00","remoteAddr":"","user":"--","app":"core","method":"--","url":"--","message":"Exception: {\"Exception\":\"OC\\\\RepairException\",\"Message\":\"Upgrade is not possible\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Repair.php(88): OC\\\\Repair\\\\Apps->run(Object(OC\\\\Repair))\\n#1 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Updater.php(221): OC\\\\Repair->run()\\n#2 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Updater.php(108): OC\\\\Updater->doUpgrade('10.0.3.3', '9.1.6.2')\\n#3 \\\/var\\\/www\\\/owncloud\\\/core\\\/Command\\\/Upgrade.php(254): OC\\\\Updater->upgrade()\\n#4 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/symfony\\\/console\\\/Command\\\/Command.php(262): OC\\\\Core\\\\Command\\\\Upgrade->execute(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#5 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/symfony\\\/console\\\/Application.php(826): Symfony\\\\Component\\\\Console\\\\Command\\\\Command->run(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#6 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/symfony\\\/console\\\/Application.php(189): Symfony\\\\Component\\\\Console\\\\Application->doRunCommand(Object(OC\\\\Core\\\\Command\\\\Upgrade), Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#7 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/symfony\\\/console\\\/Application.php(120): Symfony\\\\Component\\\\Console\\\\Application->doRun(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#8 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Console\\\/Application.php(160): Symfony\\\\Component\\\\Console\\\\Application->run(NULL, NULL)\\n#9 \\\/var\\\/www\\\/owncloud\\\/console.php(106): OC\\\\Console\\\\Application->run()\\n#10 \\\/var\\\/www\\\/owncloud\\\/occ(11): require_once('\\\/var\\\/www\\\/ownclo...')\\n#11 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Repair\\\/Apps.php\",\"Line\":196}"} {"reqId":"2KI8LwSBYlp304pgvXfe","level":3,"time":"2017-09-20T05:23:00+00:00","remoteAddr":"192.168.255.34","user":"--","app":"index","method":"GET","url":"\/owncloud\/index.php\/core\/js\/oc.js?v=164c87b19e267c17cdeddd9ecd3aaa07","message":"Exception: {\"Exception\":\"OC\\\\NeedsUpdateException\",\"Message\":\"\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/legacy\\\/app.php(121): OC_App::loadApp('dav')\\n#1 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/legacy\\\/util.php(145): OC_App::loadApps(Array)\\n#2 \\\/var\\\/www\\\/owncloud\\\/lib\\\/base.php(927): OC_Util::setupFS()\\n#3 \\\/var\\\/www\\\/owncloud\\\/index.php(56): OC::handleRequest()\\n#4 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/legacy\\\/app.php\",\"Line\":162}"} {"reqId":"18aPinO2wC29bfun9UeX","level":0,"time":"2017-09-20T05:23:45+00:00","remoteAddr":"192.168.255.34","user":"--","app":"core","method":"GET","url":"\/owncloud\/core\/ajax\/update.php?requesttoken=ABw3KiciADh%2FAjFKaBQDNCwcBhcSeRkLJjZdRGc5ZUk%3D%3AruxDTjxrInH2%2FfJAASnzV822GGh00XW%2BWKPc75YygKU%3D","message":"starting upgrade from 9.1.6.2 to 10.0.3.3"} {"reqId":"18aPinO2wC29bfun9UeX","level":3,"time":"2017-09-20T05:23:45+00:00","remoteAddr":"192.168.255.34","user":"--","app":"PHP","method":"GET","url":"\/owncloud\/core\/ajax\/update.php?requesttoken=ABw3KiciADh%2FAjFKaBQDNCwcBhcSeRkLJjZdRGc5ZUk%3D%3AruxDTjxrInH2%2FfJAASnzV822GGh00XW%2BWKPc75YygKU%3D","message":"file_put_contents(\/var\/www\/owncloud\/data\/.htaccess): failed to open stream: Permission denied at \/var\/www\/owncloud\/lib\/private\/Setup.php#487"} {"reqId":"18aPinO2wC29bfun9UeX","level":3,"time":"2017-09-20T05:24:44+00:00","remoteAddr":"192.168.255.34","user":"--","app":"core","method":"GET","url":"\/owncloud\/core\/ajax\/update.php?requesttoken=ABw3KiciADh%2FAjFKaBQDNCwcBhcSeRkLJjZdRGc5ZUk%3D%3AruxDTjxrInH2%2FfJAASnzV822GGh00XW%2BWKPc75YygKU%3D","message":"Exception: {\"Exception\":\"OC\\\\RepairException\",\"Message\":\"Upgrade is not possible\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Repair.php(88): OC\\\\Repair\\\\Apps->run(Object(OC\\\\Repair))\\n#1 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Updater.php(221): OC\\\\Repair->run()\\n#2 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Updater.php(108): OC\\\\Updater->doUpgrade('10.0.3.3', '9.1.6.2')\\n#3 \\\/var\\\/www\\\/owncloud\\\/core\\\/ajax\\\/update.php(190): OC\\\\Updater->upgrade()\\n#4 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Repair\\\/Apps.php\",\"Line\":196}"} {"reqId":"kJpYEFkuFgbpBbAd9Jec","level":0,"time":"2017-09-20T06:28:17+00:00","remoteAddr":"","user":"--","app":"core","method":"--","url":"--","message":"starting upgrade from 9.1.6.2 to 10.0.3.3"} {"reqId":"kJpYEFkuFgbpBbAd9Jec","level":3,"time":"2017-09-20T06:28:17+00:00","remoteAddr":"","user":"--","app":"PHP","method":"--","url":"--","message":"file_put_contents(\/var\/www\/owncloud\/data\/.htaccess): failed to open stream: Permission denied at \/var\/www\/owncloud\/lib\/private\/Setup.php#487"} {"reqId":"kJpYEFkuFgbpBbAd9Jec","level":3,"time":"2017-09-20T06:28:28+00:00","remoteAddr":"","user":"--","app":"core","method":"--","url":"--","message":"Exception: {\"Exception\":\"OC\\\\RepairException\",\"Message\":\"Upgrade is not possible\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Repair.php(88): OC\\\\Repair\\\\Apps->run(Object(OC\\\\Repair))\\n#1 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Updater.php(221): OC\\\\Repair->run()\\n#2 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Updater.php(108): OC\\\\Updater->doUpgrade('10.0.3.3', '9.1.6.2')\\n#3 \\\/var\\\/www\\\/owncloud\\\/core\\\/Command\\\/Upgrade.php(254): OC\\\\Updater->upgrade()\\n#4 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/symfony\\\/console\\\/Command\\\/Command.php(262): OC\\\\Core\\\\Command\\\\Upgrade->execute(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#5 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/symfony\\\/console\\\/Application.php(826): Symfony\\\\Component\\\\Console\\\\Command\\\\Command->run(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#6 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/symfony\\\/console\\\/Application.php(189): Symfony\\\\Component\\\\Console\\\\Application->doRunCommand(Object(OC\\\\Core\\\\Command\\\\Upgrade), Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#7 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/symfony\\\/console\\\/Application.php(120): Symfony\\\\Component\\\\Console\\\\Application->doRun(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#8 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Console\\\/Application.php(160): Symfony\\\\Component\\\\Console\\\\Application->run(NULL, NULL)\\n#9 \\\/var\\\/www\\\/owncloud\\\/console.php(106): OC\\\\Console\\\\Application->run()\\n#10 \\\/var\\\/www\\\/owncloud\\\/occ(11): require_once('\\\/var\\\/www\\\/ownclo...')\\n#11 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Repair\\\/Apps.php\",\"Line\":196}"} {"reqId":"FcEJxjgQs31XQ5M2qNKq","level":0,"time":"2017-09-20T06:34:37+00:00","remoteAddr":"","user":"--","app":"core","method":"--","url":"--","message":"starting upgrade from 9.1.6.2 to 10.0.3.3"} {"reqId":"FcEJxjgQs31XQ5M2qNKq","level":3,"time":"2017-09-20T06:34:37+00:00","remoteAddr":"","user":"--","app":"PHP","method":"--","url":"--","message":"file_put_contents(\/var\/www\/owncloud\/data\/.htaccess): failed to open stream: Permission denied at \/var\/www\/owncloud\/lib\/private\/Setup.php#487"} {"reqId":"FcEJxjgQs31XQ5M2qNKq","level":1,"time":"2017-09-20T06:38:56+00:00","remoteAddr":"","user":"--","app":"dav","method":"--","url":"--","message":"3 birthday calendars updated."} {"reqId":"FcEJxjgQs31XQ5M2qNKq","level":3,"time":"2017-09-20T06:38:58+00:00","remoteAddr":"","user":"--","app":"core","method":"--","url":"--","message":"Exception: {\"Exception\":\"Doctrine\\\\DBAL\\\\Schema\\\\SchemaException\",\"Message\":\"There is no column with name 'fileid' on table 'oc_properties'.\",\"Code\":30,\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Schema\\\/Table.php(671): Doctrine\\\\DBAL\\\\Schema\\\\SchemaException::columnDoesNotExist('fileid', 'oc_properties')\\n#1 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/appinfo\\\/Migrations\\\/Version20170711193427.php(25): Doctrine\\\\DBAL\\\\Schema\\\\Table->getColumn('fileid')\\n#2 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/MigrationService.php(401): OCA\\\\DAV\\\\Migrations\\\\Version20170711193427->changeSchema(Object(Doctrine\\\\DBAL\\\\Schema\\\\Schema), Array)\\n#3 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/MigrationService.php(358): OC\\\\DB\\\\MigrationService->executeStep(20170711193427)\\n#4 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/legacy\\\/app.php(1064): OC\\\\DB\\\\MigrationService->migrate()\\n#5 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Updater.php(311): OC_App::updateApp('dav')\\n#6 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Updater.php(234): OC\\\\Updater->doAppUpgrade()\\n#7 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Updater.php(108): OC\\\\Updater->doUpgrade('10.0.3.3', '9.1.6.2')\\n#8 \\\/var\\\/www\\\/owncloud\\\/core\\\/Command\\\/Upgrade.php(254): OC\\\\Updater->upgrade()\\n#9 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/symfony\\\/console\\\/Command\\\/Command.php(262): OC\\\\Core\\\\Command\\\\Upgrade->execute(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#10 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/symfony\\\/console\\\/Application.php(826): Symfony\\\\Component\\\\Console\\\\Command\\\\Command->run(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#11 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/symfony\\\/console\\\/Application.php(189): Symfony\\\\Component\\\\Console\\\\Application->doRunCommand(Object(OC\\\\Core\\\\Command\\\\Upgrade), Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#12 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/symfony\\\/console\\\/Application.php(120): Symfony\\\\Component\\\\Console\\\\Application->doRun(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#13 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Console\\\/Application.php(160): Symfony\\\\Component\\\\Console\\\\Application->run(NULL, NULL)\\n#14 \\\/var\\\/www\\\/owncloud\\\/console.php(106): OC\\\\Console\\\\Application->run()\\n#15 \\\/var\\\/www\\\/owncloud\\\/occ(11): require_once('\\\/var\\\/www\\\/ownclo...')\\n#16 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Schema\\\/SchemaException.php\",\"Line\":86}"} {"reqId":"ZmH5rlxis2pbgPSz41Ij","level":3,"time":"2017-09-20T11:57:50+00:00","remoteAddr":"10.0.0.7","user":"--","app":"index","method":"GET","url":"\/owncloud\/index.php\/core\/js\/oc.js?v=ff9a83d55496f04a73dfdf3ae3caf03f","message":"Exception: {\"Exception\":\"OC\\\\NeedsUpdateException\",\"Message\":\"\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/legacy\\\/app.php(121): OC_App::loadApp('dav')\\n#1 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/legacy\\\/util.php(145): OC_App::loadApps(Array)\\n#2 \\\/var\\\/www\\\/owncloud\\\/lib\\\/base.php(927): OC_Util::setupFS()\\n#3 \\\/var\\\/www\\\/owncloud\\\/index.php(56): OC::handleRequest()\\n#4 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/legacy\\\/app.php\",\"Line\":162}"} {"reqId":"BM02YQjQxRC24A4BQiAi","level":0,"time":"2017-09-20T12:00:43+00:00","remoteAddr":"","user":"--","app":"core","method":"--","url":"--","message":"starting upgrade from 9.1.6.2 to 10.0.3.3"} {"reqId":"BM02YQjQxRC24A4BQiAi","level":3,"time":"2017-09-20T12:00:43+00:00","remoteAddr":"","user":"--","app":"PHP","method":"--","url":"--","message":"file_put_contents(\/var\/www\/owncloud\/data\/.htaccess): failed to open stream: Permission denied at \/var\/www\/owncloud\/lib\/private\/Setup.php#487"} {"reqId":"BM02YQjQxRC24A4BQiAi","level":3,"time":"2017-09-20T12:01:38+00:00","remoteAddr":"","user":"--","app":"core","method":"--","url":"--","message":"Exception: {\"Exception\":\"Doctrine\\\\DBAL\\\\Schema\\\\SchemaException\",\"Message\":\"There is no column with name 'fileid' on table 'oc_properties'.\",\"Code\":30,\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Schema\\\/Table.php(671): Doctrine\\\\DBAL\\\\Schema\\\\SchemaException::columnDoesNotExist('fileid', 'oc_properties')\\n#1 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/appinfo\\\/Migrations\\\/Version20170711193427.php(25): Doctrine\\\\DBAL\\\\Schema\\\\Table->getColumn('fileid')\\n#2 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/MigrationService.php(401): OCA\\\\DAV\\\\Migrations\\\\Version20170711193427->changeSchema(Object(Doctrine\\\\DBAL\\\\Schema\\\\Schema), Array)\\n#3 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/MigrationService.php(358): OC\\\\DB\\\\MigrationService->executeStep(20170711193427)\\n#4 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/legacy\\\/app.php(1064): OC\\\\DB\\\\MigrationService->migrate()\\n#5 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Updater.php(311): OC_App::updateApp('dav')\\n#6 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Updater.php(234): OC\\\\Updater->doAppUpgrade()\\n#7 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Updater.php(108): OC\\\\Updater->doUpgrade('10.0.3.3', '9.1.6.2')\\n#8 \\\/var\\\/www\\\/owncloud\\\/core\\\/Command\\\/Upgrade.php(254): OC\\\\Updater->upgrade()\\n#9 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/symfony\\\/console\\\/Command\\\/Command.php(262): OC\\\\Core\\\\Command\\\\Upgrade->execute(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#10 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/symfony\\\/console\\\/Application.php(826): Symfony\\\\Component\\\\Console\\\\Command\\\\Command->run(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#11 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/symfony\\\/console\\\/Application.php(189): Symfony\\\\Component\\\\Console\\\\Application->doRunCommand(Object(OC\\\\Core\\\\Command\\\\Upgrade), Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#12 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/symfony\\\/console\\\/Application.php(120): Symfony\\\\Component\\\\Console\\\\Application->doRun(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#13 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Console\\\/Application.php(160): Symfony\\\\Component\\\\Console\\\\Application->run(NULL, NULL)\\n#14 \\\/var\\\/www\\\/owncloud\\\/console.php(106): OC\\\\Console\\\\Application->run()\\n#15 \\\/var\\\/www\\\/owncloud\\\/occ(11): require_once('\\\/var\\\/www\\\/ownclo...')\\n#16 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Schema\\\/SchemaException.php\",\"Line\":86}"} {"reqId":"5nKsMcFyWB5mjE5GrP4w","level":0,"time":"2017-09-20T12:04:53+00:00","remoteAddr":"10.0.0.7","user":"--","app":"core","method":"GET","url":"\/owncloud\/core\/ajax\/update.php?requesttoken=amIBX18nEHI%2FFnYsAGIaJwIiQ0QbFC8pAlEpUyZMJn8%3D%3ASVE7%2FcBKoXYgmW1jvR40LbazFhgxCylJRMUK%2F3jDGP0%3D","message":"starting upgrade from 9.1.6.2 to 10.0.3.3"} {"reqId":"5nKsMcFyWB5mjE5GrP4w","level":3,"time":"2017-09-20T12:04:53+00:00","remoteAddr":"10.0.0.7","user":"--","app":"PHP","method":"GET","url":"\/owncloud\/core\/ajax\/update.php?requesttoken=amIBX18nEHI%2FFnYsAGIaJwIiQ0QbFC8pAlEpUyZMJn8%3D%3ASVE7%2FcBKoXYgmW1jvR40LbazFhgxCylJRMUK%2F3jDGP0%3D","message":"file_put_contents(\/var\/www\/owncloud\/data\/.htaccess): failed to open stream: Permission denied at \/var\/www\/owncloud\/lib\/private\/Setup.php#487"} {"reqId":"5nKsMcFyWB5mjE5GrP4w","level":3,"time":"2017-09-20T12:05:43+00:00","remoteAddr":"10.0.0.7","user":"--","app":"core","method":"GET","url":"\/owncloud\/core\/ajax\/update.php?requesttoken=amIBX18nEHI%2FFnYsAGIaJwIiQ0QbFC8pAlEpUyZMJn8%3D%3ASVE7%2FcBKoXYgmW1jvR40LbazFhgxCylJRMUK%2F3jDGP0%3D","message":"Exception: {\"Exception\":\"Doctrine\\\\DBAL\\\\Schema\\\\SchemaException\",\"Message\":\"There is no column with name 'fileid' on table 'oc_properties'.\",\"Code\":30,\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Schema\\\/Table.php(671): Doctrine\\\\DBAL\\\\Schema\\\\SchemaException::columnDoesNotExist('fileid', 'oc_properties')\\n#1 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/appinfo\\\/Migrations\\\/Version20170711193427.php(25): Doctrine\\\\DBAL\\\\Schema\\\\Table->getColumn('fileid')\\n#2 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/MigrationService.php(401): OCA\\\\DAV\\\\Migrations\\\\Version20170711193427->changeSchema(Object(Doctrine\\\\DBAL\\\\Schema\\\\Schema), Array)\\n#3 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/MigrationService.php(358): OC\\\\DB\\\\MigrationService->executeStep(20170711193427)\\n#4 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/legacy\\\/app.php(1064): OC\\\\DB\\\\MigrationService->migrate()\\n#5 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Updater.php(311): OC_App::updateApp('dav')\\n#6 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Updater.php(234): OC\\\\Updater->doAppUpgrade()\\n#7 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Updater.php(108): OC\\\\Updater->doUpgrade('10.0.3.3', '9.1.6.2')\\n#8 \\\/var\\\/www\\\/owncloud\\\/core\\\/ajax\\\/update.php(190): OC\\\\Updater->upgrade()\\n#9 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Schema\\\/SchemaException.php\",\"Line\":86}"} ``` #### Browser log ``` Insert your browser log here, this could for example include: a) The javascript console log b) The network log c) ... ```

[PVince81]

could be similar to other reported cases where migrations failed or seemed to be skipped: #28695 and #28285

[fbenaventc]

Hello.

I had the same problem upgrading from version 9.1.7 RC1 to 10.0.3.
I checked the table oc_properties and found that it was empty, so I droped and recreated it.
To recreate the table I took the description from a clean 10.0.3 installation.

-- Table structure for table oc_properties

DROP TABLE IF EXISTS oc_properties;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE oc_properties (
id bigint(20) NOT NULL AUTO_INCREMENT,
fileid bigint(20) unsigned DEFAULT NULL,
propertyname varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
propertyvalue varchar(255) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (id),
KEY fileid_index (fileid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/!40101 SET character_set_client = @saved_cs_client */;

Then I reexecuted the upgrade and all went fine.

---

The wrong table structure was:
-- Table structure for table oc_properties

DROP TABLE IF EXISTS oc_properties;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE oc_properties (
id int(11) NOT NULL AUTO_INCREMENT,
userid varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
propertypath varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
propertyname varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
propertyvalue varchar(255) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (id),
KEY property_index (userid)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/!40101 SET character_set_client = @saved_cs_client */;

[ownclouders]

Hey, this issue has been closed because the label status/STALE is set and there were no updates for 7 days. Feel free to reopen this issue if you deem it appropriate.

(This is an automated comment from GitMate.io.)

[PVince81]

keeping closed, let's use #28285 for these weird DB schemas differences

[voroyam]

Error reported again on central:

OS: Gentoo
ownCloud Update: upgrade through package-manager
PHP 7.1
Apache2

Doctrine\DBAL\Schema\SchemaException: 
There is no column with name 'fileid' on table 'oc_properties'.
Update failed

https://central.owncloud.org/t/upgrade-from-9-x-to-10-0-7-fail-there-is-no-column-with-name-fileid-on-table-oc-properties/12837

[ownclouders]

Hey, this issue has been closed because the label status/STALE is set and there were no updates for 7 days. Feel free to reopen this issue if you deem it appropriate.

(This is an automated comment from GitMate.io.)

[lock]

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.