Upgrade Owncloud from 10.0.7 to 10.4.1

Server
1

Steps to reproduce

  1. Upgrading and migrating the owncloud from 10.0.7 to 10.4.1
  2. Currently I am using owncloud 10.0.7 which is running in a server environment and I need to upgrade to latest version of owncloud 10.4.1 and for testing I have installed my ubuntu server in a Virtual Machine Environment in a local PC
  3. I have tried to take a sqldump in a owncloud 10.0.7 version the table has an empty set.

Expected behaviour

Owncloud database dump file should have tables

Actual behaviour

Empty table set in my owncloud database

Server configuration

Operating system : Ubuntu 16.04 Server LTS

Web server: Apache2

Database: Mariadb

PHP version: PHP 7.0.

ownCloud version: “10.0.7.2”,

Updated from an older ownCloud or fresh install: Fresh Install

Where did you install ownCloud from: owncloud.org

Signing status (ownCloud 9.0 and above):

Login as admin user into your ownCloud and access http://example.com/owncloud/index.php/settings/integrity/failed

paste the results into https: No errors have been found.

.

The content of config/config.php:

{

“system”: {

“instanceid”: “oc3lo3f6rcjd”,

“passwordsalt”: “REMOVED SENSITIVE VALUE”,

“secret”: “REMOVED SENSITIVE VALUE”,

“trusted_domains”: [

“192.168.1.11”,

],

“datadirectory”: “/var/www/html/owncloud/data”,

“overwrite.cli.url”: “https://192.168.1.11/owncloud”,

“dbtype”: “sqlite3”,

“version”: “10.0.7.2”,

“logtimezone”: “UTC”,

“installed”: true,

“mail_smtpmode”: “smtp”,

“loglevel”: 1

}

List of activated apps:

Enabled:

  • afterlogic: 1.1.2

  • comments: 0.3.0

  • configreport: 0.1.1

  • contacts: 1.5.4

  • customgroups: 0.3.6

  • dav: 0.3.2

  • federatedfilesharing: 0.3.1

  • federation: 0.1.0

  • files: 1.5.1

  • files_external: 0.7.1

  • files_external_ftp: 0.2.0

  • files_pdfviewer: 0.11.0

  • files_sharing: 0.10.1

  • files_trashbin: 0.9.1

  • files_versions: 1.3.0

  • files_videoplayer: 0.9.8

  • firstrunwizard: 1.1

  • gallery: 16.1.0

  • gpxpod: 2.2.2

  • groupalert: 1.0.5

  • guests: 0.5.0

  • market: 0.2.4

  • notifications: 0.3.2

  • onlyoffice: 2.2.1

  • phonetrack: 0.2.8

  • provisioning_api: 0.5.0

  • systemtags: 0.3.0

  • templateeditor: 0.3

  • twofactor_backup_codes: 0.0.4

  • updatenotification: 0.2.1

Disabled:

  • encryption

  • external

  • theme-example

  • user_external.

Are you using external storage, if yes which one: yes local/smb/sftp/…

Are you using encryption: no

Are you using an external user-backend, if yes which one: no

Client configuration

Browser: Apache/2.4.18 (Ubuntu)

Operating system: ubuntu

Logs

Web server error log

[Fri Jul 24 14:47:37.282560 2020] [:error] [pid 17108] [client 183.83.241.2:35737] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 14:48:08.939750 2020] [:error] [pid 17344] [client 183.83.241.2:35756] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 14:48:09.290535 2020] [:error] [pid 17344] [client 183.83.241.2:35756] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 14:48:40.918366 2020] [:error] [pid 16179] [client 183.83.241.2:35763] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 14:48:41.249415 2020] [:error] [pid 16179] [client 183.83.241.2:35763] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 14:49:12.949405 2020] [:error] [pid 17335] [client 183.83.241.2:35776] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 14:49:13.324344 2020] [:error] [pid 17335] [client 183.83.241.2:35776] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 14:49:44.932445 2020] [:error] [pid 15691] [client 183.83.241.2:35800] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 14:49:45.303921 2020] [:error] [pid 15691] [client 183.83.241.2:35800] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 14:50:16.926054 2020] [:error] [pid 16143] [client 183.83.241.2:35810] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 14:50:17.271708 2020] [:error] [pid 16143] [client 183.83.241.2:35810] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 14:50:48.928660 2020] [:error] [pid 17108] [client 183.83.241.2:35842] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 14:50:49.281363 2020] [:error] [pid 17108] [client 183.83.241.2:35842] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 14:51:20.950767 2020] [:error] [pid 17335] [client 183.83.241.2:35862] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 14:51:21.326396 2020] [:error] [pid 17335] [client 183.83.241.2:35862] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 14:51:52.927111 2020] [:error] [pid 17854] [client 183.83.241.2:35888] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 14:51:53.285428 2020] [:error] [pid 17854] [client 183.83.241.2:35888] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 14:52:24.927819 2020] [:error] [pid 17108] [client 183.83.241.2:35894] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 14:52:25.287108 2020] [:error] [pid 17108] [client 183.83.241.2:35894] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 14:52:56.922190 2020] [:error] [pid 17854] [client 183.83.241.2:35933] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 14:52:57.278308 2020] [:error] [pid 17854] [client 183.83.241.2:35933] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 14:53:28.928510 2020] [:error] [pid 17724] [client 183.83.241.2:35941] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 14:53:29.303424 2020] [:error] [pid 17724] [client 183.83.241.2:35941] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 14:54:00.931843 2020] [:error] [pid 16179] [client 183.83.241.2:35949] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 14:54:01.295086 2020] [:error] [pid 16179] [client 183.83.241.2:35949] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 14:54:32.931887 2020] [:error] [pid 17969] [client 183.83.241.2:35964] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 14:54:33.294222 2020] [:error] [pid 17969] [client 183.83.241.2:35964] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 14:55:04.921887 2020] [:error] [pid 16179] [client 183.83.241.2:35968] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 14:55:05.281185 2020] [:error] [pid 16179] [client 183.83.241.2:35968] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 14:55:36.941676 2020] [:error] [pid 18493] [client 183.83.241.2:35982] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 14:55:37.327893 2020] [:error] [pid 18493] [client 183.83.241.2:35982] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 14:56:08.920513 2020] [:error] [pid 18170] [client 183.83.241.2:35986] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 14:56:09.255521 2020] [:error] [pid 18170] [client 183.83.241.2:35986] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 14:56:40.942503 2020] [:error] [pid 18505] [client 183.83.241.2:36001] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 14:56:41.299840 2020] [:error] [pid 18505] [client 183.83.241.2:36001] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 14:57:12.931189 2020] [:error] [pid 16179] [client 183.83.241.2:36008] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 14:57:13.300122 2020] [:error] [pid 16179] [client 183.83.241.2:36008] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 14:57:44.919812 2020] [:error] [pid 16179] [client 183.83.241.2:36016] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 14:57:45.271907 2020] [:error] [pid 16179] [client 183.83.241.2:36016] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 14:58:16.930376 2020] [:error] [pid 18496] [client 183.83.241.2:36027] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 14:58:17.297699 2020] [:error] [pid 18496] [client 183.83.241.2:36027] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 14:59:03.928843 2020] [:error] [pid 18632] [client 183.83.241.2:36031] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 14:59:04.290572 2020] [:error] [pid 18632] [client 183.83.241.2:36031] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 14:59:35.929706 2020] [:error] [pid 19046] [client 183.83.241.2:36075] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 14:59:36.300010 2020] [:error] [pid 19046] [client 183.83.241.2:36075] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 14:59:52.921117 2020] [:error] [pid 18795] [client 183.83.241.2:36093] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 14:59:53.277006 2020] [:error] [pid 18795] [client 183.83.241.2:36093] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 15:00:24.937787 2020] [:error] [pid 18496] [client 183.83.241.2:36248] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 15:00:25.768534 2020] [:error] [pid 18496] [client 183.83.241.2:36248] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 15:00:57.086126 2020] [:error] [pid 19282] [client 183.83.241.2:36324] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 15:00:57.626405 2020] [:error] [pid 19282] [client 183.83.241.2:36324] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 15:01:28.931259 2020] [:error] [pid 19372] [client 183.83.241.2:36351] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 15:01:29.291836 2020] [:error] [pid 19372] [client 183.83.241.2:36351] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 15:02:00.921365 2020] [:error] [pid 19438] [client 183.83.241.2:36400] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 15:02:01.278217 2020] [:error] [pid 19438] [client 183.83.241.2:36400] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 15:02:32.966551 2020] [:error] [pid 19414] [client 183.83.241.2:36417] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 15:02:33.424591 2020] [:error] [pid 19414] [client 183.83.241.2:36417] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 15:03:19.927987 2020] [:error] [pid 19355] [client 183.83.241.2:36473] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 15:03:20.287363 2020] [:error] [pid 19355] [client 183.83.241.2:36473] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 15:03:36.957934 2020] [:error] [pid 19572] [client 183.83.241.2:36513] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 15:03:37.320787 2020] [:error] [pid 19572] [client 183.83.241.2:36513] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 15:04:08.933582 2020] [:error] [pid 19732] [client 183.83.241.2:36547] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 15:04:09.302256 2020] [:error] [pid 19732] [client 183.83.241.2:36547] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 15:04:40.923457 2020] [:error] [pid 19795] [client 183.83.241.2:36586] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 15:04:41.288261 2020] [:error] [pid 19795] [client 183.83.241.2:36586] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 15:05:12.933111 2020] [:error] [pid 19523] [client 183.83.241.2:36604] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 15:05:13.303091 2020] [:error] [pid 19523] [client 183.83.241.2:36604] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 15:05:59.977950 2020] [:error] [pid 19947] [client 183.83.241.2:36711] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 15:06:00.341410 2020] [:error] [pid 19947] [client 183.83.241.2:36711] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 15:06:31.957168 2020] [:error] [pid 19738] [client 183.83.241.2:34824] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 15:06:32.304163 2020] [:error] [pid 19738] [client 183.83.241.2:34824] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 15:06:48.939939 2020] [:error] [pid 19434] [client 183.83.241.2:34855] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 15:06:49.315171 2020] [:error] [pid 19434] [client 183.83.241.2:34855] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 15:07:20.928497 2020] [:error] [pid 19523] [client 183.83.241.2:34892] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 15:07:21.297825 2020] [:error] [pid 19523] [client 183.83.241.2:34892] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 15:07:52.925893 2020] [:error] [pid 20143] [client 183.83.241.2:34923] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 15:07:53.283969 2020] [:error] [pid 20143] [client 183.83.241.2:34923] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 15:08:24.938196 2020] [:error] [pid 19840] [client 183.83.241.2:34958] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 15:08:25.310752 2020] [:error] [pid 19840] [client 183.83.241.2:34958] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 15:08:56.940730 2020] [:error] [pid 20091] [client 183.83.241.2:34966] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 15:08:57.317722 2020] [:error] [pid 20091] [client 183.83.241.2:34966] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 15:09:28.922363 2020] [:error] [pid 20307] [client 183.83.241.2:34995] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 15:09:29.276087 2020] [:error] [pid 20307] [client 183.83.241.2:34995] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 15:10:00.924498 2020] [:error] [pid 20307] [client 183.83.241.2:35020] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 15:10:01.287320 2020] [:error] [pid 20307] [client 183.83.241.2:35020] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 15:10:32.928224 2020] [:error] [pid 19523] [client 183.83.241.2:35040] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 15:10:33.283540 2020] [:error] [pid 19523] [client 183.83.241.2:35040] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 15:11:04.931648 2020] [:error] [pid 19523] [client 183.83.241.2:35075] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 15:11:05.305474 2020] [:error] [pid 19523] [client 183.83.241.2:35075] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 15:11:36.923347 2020] [:error] [pid 19737] [client 183.83.241.2:35140] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 15:11:37.283044 2020] [:error] [pid 19737] [client 183.83.241.2:35140] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 15:12:08.923448 2020] [:error] [pid 19737] [client 183.83.241.2:35169] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 15:12:09.265107 2020] [:error] [pid 19737] [client 183.83.241.2:35169] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 15:12:40.924868 2020] [:error] [pid 20091] [client 183.83.241.2:35226] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 15:12:41.272374 2020] [:error] [pid 20091] [client 183.83.241.2:35226] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 15:13:12.925158 2020] [:error] [pid 20091] [client 183.83.241.2:35243] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 15:13:13.288144 2020] [:error] [pid 20091] [client 183.83.241.2:35243] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 15:13:59.935587 2020] [:error] [pid 19952] [client 183.83.241.2:35254] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 15:14:00.305454 2020] [:error] [pid 19952] [client 183.83.241.2:35254] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 15:15:03.929260 2020] [:error] [pid 19523] [client 183.83.241.2:35359] script ‘/var/www/html/status.php’ not found or unable to stat

[Fri Jul 24 15:15:04.292187 2020] [:error] [pid 19523] [client 183.83.241.2:35359] script ‘/var/www/html/remote.php’ not found or unable to stat

[Fri Jul 24 15:15:41.935317 2020] [:error] [pid 19737] [client 183.83.241.2:35405] script ‘/var/www/html/status.php’ not found or unable to stat

I have upgraded the owncloud version 10.0.7 to 10.4.1 by these steps.

Step 1 : I have installed the owncloud setup by this article

AvoidErrors – 21 Jun 18

Install OwnCloud on Ubuntu 18.04 LTS with Apache2, MariaDB and PHP 7.1 -…

I recently installed Ubuntu 18.04 LTS on a mini PC, I decided why don’t we install OwnCloud and use this mini PC as a free cloud storage server. Here are the steps I took that shows how I got OwnCloud installed on Ubuntu. OwnCloud is free robust open…

In this article they didn’t Mention to install the php7.2-sqlite3 after i have installed php7.2-sqlite3 i started to run my owncloud 10.4.1 in an web browser.

Step 2: For migrating the db i stopped the apache service and put my owncloud in an maintenance mode and started replacing the db file.In owncloud 10.0.7 i have copied the sqlite3 source db file and replaced with my current owncloud 10.4.1 sqlite3 db file which exists in /var/www/html/owncloud/data/owncloud.db

Step3 : After i have replaced the owncloud db file i started to upgrade the occ to execute the db file by referring to this article
https://doc.owncloud.org/server/10.4/admin_manual/configuration/server/occ_command.html#apps-commands

Step4: After the upgrade my db file got reflected in my current owncloud 10.4.1 which still has sqlite3 db type and i have synced my data from my previous owncloud 10.0.7

Step 5: I want to convert my database from sqlite3 to mariadb i just referrred this article to convert my db type https://doc.owncloud.com/server/10.2/admin_manual/configuration/database/db_conversion.html

2

A post was merged into an existing topic: Upgrading owncloud from 10.0.7 to 10.4.1