CentOS 6 upgrade to OC 10.0.3 failed

Steps to reproduce

  1. yum update
  2. Load OwnCloud WebUI
  3. Click 'Upgrade'

Expected behaviour

OwnCloud to update and become usable again

Actual behaviour

Upgrade fails with the error:

Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'ALTER TABLE oc_calendarsubscriptions CHANGE `lastmodified` lastmodified INT UNSIGNED DEFAULT NULL NOT NULL': SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'lastmodified'

Appears to be related to this bug: https://github.com/owncloud/core/issues/28695

Server configuration

Operating system: CentOS 6.9 64-bit

Web server: Apache 2.2

Database: MariaDB 10.2.8

PHP version: PHP 7.0.22

ownCloud version: 10.0.3

Updated from an older ownCloud or fresh install: Update

Where did you install ownCloud from: Offical yum repo, stable-ce

Signing status (ownCloud 9.0 and above): Cannot login to OwnCloud instance at this time

The content of config/config.php:

-bash-4.1$ ./occ config:list system
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
{
    "system": {
        "instanceid": "51170c94b12b9",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "datadirectory": "\/data\/wwwPublic\/siteOwncloud\/data",
        "dbtype": "mysql",
        "version": "9.1.6.2",
        "dbname": "appOwncloud",
        "dbhost": "localhost",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "maintenance": true,
        "maxZipInputSize": 0,
        "allowZipDownload": true,
        "theme": "",
        "forcessl": true,
        "loglevel": "3",
        "trusted_domains": [
            "owncloud.fizi.ca"
        ],
        "secret": "***REMOVED SENSITIVE VALUE***",
        "mail_from_address": "no-reply",
        "mail_smtpmode": "sendmail",
        "mail_domain": "owncloud.fizi.ca",
        "trashbin_retention_obligation": "auto",
        "updatechecker": false,
        "htaccess.RewriteBase": "\/"
    }
}

List of activated apps:

-bash-4.1$ ./occ app:list
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
  - comments: 0.3.0
  - configreport: 0.1.1
  - dav: 0.2.7
  - federatedfilesharing: 0.3.0
  - federation: 0.1.0
  - files: 1.5.1
  - files_external: true
  - 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
  - market: true
  - notifications: 0.3.0
  - provisioning_api: 0.5.0
  - systemtags: 0.3.0
  - templateeditor: 0.1
  - updatenotification: 0.2.1
Disabled:
  - encryption
  - external
  - files_antivirus
  - theme-example
  - user_external

Are you using external storage, if yes which one: Local

Are you using encryption: No

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

Client configuration

Browser: Any, mainly Firefox 55.0.3 though

Operating system: Windows 10 1703 Pro and Enterprise

Logs

Web server error log

I don't think these are relevant based on the error message

ownCloud log (data/owncloud.log)

{"reqId":"oU02RFJF5ObzvAN80Y1D","level":0,"time":"2017-09-19T17:02:02+00:00","remoteAddr":"","user":"--","app":"core","method":"--","url":"--","message":"starting upgrade from 9.1.6.2 to 10.0.3.3"}
{"reqId":"oU02RFJF5ObzvAN80Y1D","level":3,"time":"2017-09-19T17:02:28+00:00","remoteAddr":"","user":"--","app":"core","method":"--","url":"--","message":"Exception: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\DriverException\",\"Message\":\"An exception occurred while executing 'ALTER TABLE oc_calendarsubscriptions CHANGE `lastmodified` lastmodified INT UNSIGNED DEFAULT NULL NOT NULL':\\n\\nSQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'lastmodified'\",\"Code\":0,\"Trace\":\"#0 \\\/data\\\/wwwPublic\\\/siteOwncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(128): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/data\\\/wwwPublic\\\/siteOwncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(964): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOMySql\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'ALTER TABLE oc_...')\\n#2 \\\/data\\\/wwwPublic\\\/siteOwncloud\\\/lib\\\/private\\\/DB\\\/Migrator.php(199): Doctrine\\\\DBAL\\\\Connection->query('ALTER TABLE oc_...')\\n#3 \\\/data\\\/wwwPublic\\\/siteOwncloud\\\/lib\\\/private\\\/DB\\\/Migrator.php(81): OC\\\\DB\\\\Migrator->applySchema(Object(Doctrine\\\\DBAL\\\\Schema\\\\Schema))\\n#4 \\\/data\\\/wwwPublic\\\/siteOwncloud\\\/lib\\\/private\\\/DB\\\/Connection.php(424): OC\\\\DB\\\\Migrator->migrate(Object(Doctrine\\\\DBAL\\\\Schema\\\\Schema))\\n#5 \\\/data\\\/wwwPublic\\\/siteOwncloud\\\/lib\\\/private\\\/DB\\\/MigrationService.php(402): OC\\\\DB\\\\Connection->migrateToSchema(Object(Doctrine\\\\DBAL\\\\Schema\\\\Schema))\\n#6 \\\/data\\\/wwwPublic\\\/siteOwncloud\\\/lib\\\/private\\\/DB\\\/MigrationService.php(358): OC\\\\DB\\\\MigrationService->executeStep(20170101215145)\\n#7 \\\/data\\\/wwwPublic\\\/siteOwncloud\\\/lib\\\/private\\\/Updater.php(273): OC\\\\DB\\\\MigrationService->migrate()\\n#8 \\\/data\\\/wwwPublic\\\/siteOwncloud\\\/lib\\\/private\\\/Updater.php(223): OC\\\\Updater->doCoreUpgrade()\\n#9 \\\/data\\\/wwwPublic\\\/siteOwncloud\\\/lib\\\/private\\\/Updater.php(108): OC\\\\Updater->doUpgrade('10.0.3.3', '9.1.6.2')\\n#10 \\\/data\\\/wwwPublic\\\/siteOwncloud\\\/core\\\/Command\\\/Upgrade.php(254): OC\\\\Updater->upgrade()\\n#11 \\\/data\\\/wwwPublic\\\/siteOwncloud\\\/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#12 \\\/data\\\/wwwPublic\\\/siteOwncloud\\\/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#13 \\\/data\\\/wwwPublic\\\/siteOwncloud\\\/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#14 \\\/data\\\/wwwPublic\\\/siteOwncloud\\\/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#15 \\\/data\\\/wwwPublic\\\/siteOwncloud\\\/lib\\\/private\\\/Console\\\/Application.php(160): Symfony\\\\Component\\\\Console\\\\Application->run(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#16 \\\/data\\\/wwwPublic\\\/siteOwncloud\\\/console.php(106): OC\\\\Console\\\\Application->run()\\n#17 \\\/data\\\/wwwPublic\\\/siteOwncloud\\\/occ(11): require_once('\\\/data\\\/wwwPublic...')\\n#18 {main}\",\"File\":\"\\\/data\\\/wwwPublic\\\/siteOwncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php\",\"Line\":115}"}
{"reqId":"WcFjC8CoAGQAAGmlHkQAAAAC","level":3,"time":"2017-09-19T18:33:47+00:00","remoteAddr":"104.128.253.249","user":"--","app":"index","method":"GET","url":"\/core\/js\/oc.js?v=25270803de62e78913f5d555ecad3862","message":"Exception: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\TableNotFoundException\",\"Message\":\"An exception occurred while executing 'SELECT * FROM `oc_accounts` WHERE `lower_user_id` = :dcValue1' with params [\\\"\\\"]:\\n\\nSQLSTATE[42S02]: Base table or view not found: 1146 Table 'appOwncloud.oc_accounts' doesn't exist\",\"Code\":0,\"Trace\":\"#0 \\\/data\\\/wwwPublic\\\/siteOwncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(128): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/data\\\/wwwPublic\\\/siteOwncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Statement.php(177): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOMySql\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'SELECT * FROM `...', Array)\\n#2 \\\/data\\\/wwwPublic\\\/siteOwncloud\\\/lib\\\/public\\\/AppFramework\\\/Db\\\/Mapper.php(252): Doctrine\\\\DBAL\\\\Statement->execute()\\n#3 \\\/data\\\/wwwPublic\\\/siteOwncloud\\\/lib\\\/public\\\/AppFramework\\\/Db\\\/Mapper.php(285): OCP\\\\AppFramework\\\\Db\\\\Mapper->execute('SELECT * FROM `...', Array, NULL, NULL)\\n#4 \\\/data\\\/wwwPublic\\\/siteOwncloud\\\/lib\\\/public\\\/AppFramework\\\/Db\\\/Mapper.php(379): OCP\\\\AppFramework\\\\Db\\\\Mapper->findOneQuery('SELECT * FROM `...', Array, NULL, NULL)\\n#5 \\\/data\\\/wwwPublic\\\/siteOwncloud\\\/lib\\\/private\\\/User\\\/AccountMapper.php(128): OCP\\\\AppFramework\\\\Db\\\\Mapper->findEntity('SELECT * FROM `...', Array)\\n#6 \\\/data\\\/wwwPublic\\\/siteOwncloud\\\/lib\\\/private\\\/User\\\/Manager.php(158): OC\\\\User\\\\AccountMapper->getByUid(false)\\n#7 \\\/data\\\/wwwPublic\\\/siteOwncloud\\\/lib\\\/private\\\/Group\\\/Manager.php(472): OC\\\\User\\\\Manager->get(false)\\n#8 \\\/data\\\/wwwPublic\\\/siteOwncloud\\\/lib\\\/private\\\/legacy\\\/user.php(333): OC\\\\Group\\\\Manager->inGroup(false, 'admin')\\n#9 \\\/data\\\/wwwPublic\\\/siteOwncloud\\\/core\\\/js\\\/config.php(76): OC_User::isAdminUser(false)\\n#10 \\\/data\\\/wwwPublic\\\/siteOwncloud\\\/lib\\\/private\\\/Route\\\/Route.php(155) : runtime-created function(1): require_once('\\\/data\\\/wwwPublic...')\\n#11 [internal function]: __lambda_func(NULL)\\n#12 \\\/data\\\/wwwPublic\\\/siteOwncloud\\\/lib\\\/private\\\/Route\\\/Router.php(307): call_user_func('\\\\x00lambda_415', Array)\\n#13 \\\/data\\\/wwwPublic\\\/siteOwncloud\\\/lib\\\/base.php(928): OC\\\\Route\\\\Router->match('\\\/core\\\/js\\\/oc.js')\\n#14 \\\/data\\\/wwwPublic\\\/siteOwncloud\\\/index.php(56): OC::handleRequest()\\n#15 {main}\",\"File\":\"\\\/data\\\/wwwPublic\\\/siteOwncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php\",\"Line\":53}"}

Browser log

Preparing update
Set log level to debug
Turned on maintenance mode
Updating database schema
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'ALTER TABLE oc_calendarsubscriptions CHANGE `lastmodified` lastmodified INT UNSIGNED DEFAULT NULL NOT NULL': SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'lastmodified'

If you still have the setup available, please post the contents of the "oc_migrations" table.
Post it to the ticket here https://github.com/owncloud/core/issues/28695 as it could contain important clues.

Note that so far we haven't been able to reproduce this at all.

I have done as you asked.

That's a fancy 21 character way of saying "Done"

hi, i saw several questions for the manual upgrade from earlier unsupported versions of owncloud and i had recently had to perform one. i share below my full notes with each command ran in case can be usefull. altho it may seem out of topic but basically i upgraded up to OC X from OC 6.0 on Centos 6.9

it happened during the process that i was not able to login, after upgrade to 8.x. i think it got fixed when i cleaned up the URL and pointed the browser to the root folder of òy owncloud

this is my upgrading procedure from ownCloud 6.0 to OC X 10.0.3.
i share these notes raw, i took them with the idea of doing an upgrade script
all commands below reflect my file tree, if you want to follow along you should put it with this layout, else pay attention to the path
/var/www/owncloudxxx is where all the ownclouds directory end and where apache points to (changin release each time)
/var/tmp/ is where the zipped owncloud upgrades have been temporarily stored. i moved this to /var/www/tmp/ during the upgrade of OC 8.
i started with php 5.3.3 and upgraded to php 5.4 php54-php.x86_64 0:5.4.40-4.el6 during the upgrade to OC 8
these are raw notes, i took them during the upgrade and executed with the succesful result, nonetheless i recommend to double check syntax, paths, names to avoid major mistakes since i never executed them a second time.
I left the data folder in the original folder to facilitate the upgrade process
some how when updating to OC9 it made an authentication issue on one big floder of 15GB that was shared in R/W with 2 groups. the data remained but the admin gets the error of that is not authorized to read. owner was apache:apache. OC X didnt fix. i would reccomend to turn off the share before to perform the whole upgrade.

my system

cat /etc/centos-release 
	CentOS release 6.9 (Final)
uname -r
	2.6.32-696.1.1.el6.x86_64
mysql -V  # although i am using sqlite3 on this ownCloud installation
	mysql  Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1
sqlite3 -version
	3.6.20
php -v
	PHP 5.3.3 (cli) (built: Mar 22 2017 12:27:09) 
	Copyright (c) 1997-2010 The PHP Group
	Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies

Preparation

#Backups data and DB:
sqlite3 www/cloud-osefrance-org/data/clouddb.db .dump > 20170921-cloud.osefrance.org-sqlite3-dbdump.bak
tar -czf 20170921-cloudPartial-Osefrance.tzf www/cloud-osefrance-org/data/ www/cloud-osefrance-org/config/ /etc/httpd/conf.d/ &

downloads from:

https://owncloud.org/changelog/

downloaded files:

ls tmp/
-rw-r--r-- 1 root root 37M 3 lug 2015 owncloud-6.0.9.zip
-rw-r--r-- 1 root root 40M 12 mag 2016 owncloud-7.0.15.zip
-rw-r--r-- 1 root root 32M 8 nov 2016 owncloud-8.0.16.zip
-rw-r--r-- 1 root root 33M 1 feb 2017 owncloud-8.1.12.zip
-rw-r--r-- 1 root root 38M 30 mag 19:08 owncloud-9.0.10.zip
-rw-r--r-- 1 root root 39M 30 mag 19:16 owncloud-9.1.6.zip
-rw-r--r-- 1 root root 45M 15 set 16:55 owncloud-10.0.3.zip

upgrade to 6.0.9

cd tmp
unzip owncloud-6.0.19.zip
php ../../www/cloud-osefrance-org/occ maintenance:mode --on #failed - need to manual put the maintenance mode "true" in theoldowncloud/config/config.php
cd ..
mv tmp/owncloud www/owncloud609
cd www/
cp -r cloud-osefrance-org/config owncloud609/
ls owncloud609/config/
chown apache:apache owncloud609/ -R
nano /etc/httpd/conf.d/b_osefrance.org.conf # point to the new document root
nano owncloud7015/config/config.php # set  maintenance to true
php owncloud609/occ upgrade
	##once completed check on browser it's working status + version in admin.

upgrade to 7.0.15

cd ../tmp
unzip owncloud-7.0.15.zip
php ../www/owncloud609/occ maintenance:mode --on #failed - need to manual put the maintenance mode "true" in oldowncloud/config/config.php
cd ..
mv tmp/owncloud www/owncloud7015
cd www/
cp -r owncloud609/config owncloud7015/
chown apache:apache owncloud7015/ -R
nano /etc/httpd/conf.d/b_osefrance.org.conf # point to the new document root
nano owncloud7015/config/config.php # set  maintenance to true
service httpd restart
php owncloud7015/occ upgrade
	##once completed check on browser it's working status + version in admin.


# PHP 5.4 upgrade if you need, else continue after indent with the ownlcoud upgrade -  ownCloud 8 requires  PHP >= 5.4.0
	yum install centos-release-SCL
	yum install php54 php54-php php54-php-gd php54-php-mbstring
	yum install php54-php-mysqlnd
	mv /etc/httpd/conf.d/php.conf /etc/httpd/conf.d/php53.off
	service httpd restart
		## had to enable the command line if your php -v is 5.4 skip this further indent
			php -v
				PHP 5.3.3 (cli) (built: Mar 22 2017 12:27:09) 
				Copyright (c) 1997-2010 The PHP Group
				Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
			which php
				/usr/bin/php
			mkdir /opt/rh/php53
			mv /usr/bin/php /opt/rh/php53/
			mv /usr/bin/php-cgi /opt/rh/php53/
			ln -s /opt/rh/php54/root/usr/bin/php /usr/bin/php
			ln -s /opt/rh/php54/root/usr/bin/php-cgi /usr/bin/php-cgi
			php -v
				PHP 5.4.40 (cli) (built: Aug 30 2016 13:52:21) 
				Copyright (c) 1997-2014 The PHP Group
				Zend Engine v2.4.0, Copyright (c) 1998-2014 Zend Technologies

upgrade to 8.0.16 (carefull here: i am moving the tmp directory up to www/tmp)

cd ../tmp
unzip owncloud-8.0.16.zip
php ../www/owncloud7015/occ maintenance:mode --on # yes, maintenance:mode is supported from 7.0.15
cd ..
mv tmp www/
cd www/
mv tmp/owncloud owncloud8016
cp -r owncloud7015/config/config.php owncloud8016/config/
chown apache:apache owncloud8016/ -R
sudo -u apache php owncloud8016/occ maintenance:mode --on
nano /etc/httpd/conf.d/b_osefrance.org.conf # point to the new document root
service httpd restart
sudo -u apache php owncloud8016/occ upgrade
	##once completed check on browser it's working status + version in admin.

upgrade to 8.1.12

cd tmp
unzip owncloud-8.1.12.zip
cd ..

sudo -u apache php owncloud8016/occ maintenance:mode --on
mv tmp/owncloud owncloud8112
cp owncloud8016/config/config.php owncloud8112/config/
chown apache:apache owncloud8112/ -R
sudo -u apache php owncloud8112/occ upgrade ## upgrade from 7.0.15 not accepted, step down to 8.0.16
nano /etc/httpd/conf.d/b_osefrance.org.conf # point to the new document root
service httpd restart
sudo -u apache php owncloud8112/occ maintenance:mode --off

	##once completed check on browser it's working status + version in admin.
	 ## memcache can be installed to enhance performances

upgrade to 8.2.11:

## upgraded from web from the admin interface

upgrade to 9.0.10:

cd tmp
unzip owncloud-9.0.10.zip
cd ..

sudo -u apache php owncloud8112/occ maintenance:mode --on
mv tmp/owncloud owncloud9010
cp owncloud8112/config/config.php owncloud9010/config/
chown apache:apache owncloud9010/ -R
sudo -u apache php owncloud9010/occ upgrade
nano /etc/httpd/conf.d/b_osefrance.org.conf # point to the new document root
service httpd restart
sudo -u apache php owncloud9010/occ maintenance:mode --off

	##once completed check on browser it's working status + version in admin.
# PHP 5.6 upgrade if you need, else continue after indent with the ownlcoud upgrade -  ownCloud X requires  PHP >= 5.6.0. it requires also posix and xml
	wget https://dl.fedoraproject.org/pub/epel/epel-release-latest-6.noarch.rpm && rpm -Uvh epel-release-latest-6.noarch.rpm
	wget http://rpms.famillecollet.com/enterprise/remi-release-6.rpm && rpm -Uvh remi-release-6*.rpm
	nano /etc/yum.repos.d/remi.repo # enable remi and remi-php56
	wget https://dl.fedoraproject.org/pub/epel/epel-release-latest-6.noarch.rpm && rpm -Uvh epel-release-latest-6.noarch.rpm
	yum remove php-common
	yum install php php-gd php-mysql php-mcrypt -y
	yum install php-mbstring php-mysqlnd -y
	yum install php-posix php-ZendFramework2-Dom.noarch libxml2  -y
	yum install php-ZendFramework2-Dom.noarch libxml2

upgrade to 10.0.3:

cd tmp
unzip owncloud-10.0.3.zip
cd ..
sudo -u apache php owncloud9010/occ maintenance:mode --on 
mv tmp/owncloud owncloud1003
cp  owncloud9010/config/config.php owncloud1003/config/
chown apache:apache owncloud1003/ -R
sudo -u apache php owncloud1003/occ upgrade nano /etc/httpd/conf.d/b_osefrance.org.conf # point to the new document root
service httpd restart
sudo -u apache php owncloud1003/occ  maintenance:mode --off
sudo -u apache php owncloud1003/occ upgrade  # not sure why i had run it the second time 

	##once completed check on browser it's working status + version in admin.

done completed.

1 Like

Doctrine / MariaDB 10.2 - specific

Please read 3 comments on github starting from this one https://github.com/owncloud/core/issues/28695#issuecomment-331634540