ownCloud 9 -> 10.0.12 Update issue


#1

Hi,
Updated my OC from 9.x to 10.0.0.12
First the Update stuck because of an db error the column "last_checked" was missing in table "oc_jobs"
mysql> ALTER TABLE oc_jobs ADD COLUMN last_checked int(11);
Added the column and the occ update was successful.

After quiting the maintenance mode, I get a Internal Server Error instead of my login page

Please, help me

Log message in owncloud.log
{"reqId":"RF4WO4lSgH0402je97lg","level":3,"time":"2017-05-03T13:13:08+00:00","remoteAddr":"1.1.1.1","user":"--","app":"index","method":"GET","url":"\/owncloud\/","message":"Exception: {\"Exception\":\"Doctrine\\DBAL\\Exception\\TableNotFoundException\",\"Message\":\"An exception occurred while executing 'SELECT id, uid, login_name, password, name, type, token, last_activity, last_check FROM oc_authtoken WHERE token = ?' with params [\\"b3ba829aaf75996238425a1aafd8929dcfb7466db4d74e6496d8554f6544b1aba4e8e5b76ef8691492660098bb7644be3ff0c3d2a1226ba509bf410f2f6e6759\\"]:\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table 'owncloud.oc_authtoken' doesn't exist\",\"Code\":0,\"Trace\":\"#0 \\/var\\/www\\/owncloud\\/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 \\/var\\/www\\/owncloud\\/lib\\/composer\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Connection.php(855): Doctrine\\DBAL\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\DBAL\\Driver\\PDOMySql\\Driver), Object(Doctrine\\DBAL\\Driver\\PDOException), 'SELECT id, u...', Array)\\n#2 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/Connection.php(190): Doctrine\\\\DBAL\\\\Connection->executeQuery('SELECTid,u...', Array, Array, NULL)\n#3 \\/var\\/www\\/owncloud\\/lib\\/composer\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Query\\/QueryBuilder.php(206): OC\\DB\\Connection->executeQuery('SELECT id, `u...', Array, Array)\n#4 \\/var\\/www\\/owncloud\\/lib\\/private\\/DB\\/QueryBuilder\\/QueryBuilder.php(141): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 \\/var\\/www\\/owncloud\\/lib\\/private\\/Authentication\\/Token\\/DefaultTokenMapper.php(77): OC\\DB\\QueryBuilder\\QueryBuilder->execute()\n#6 \\/var\\/www\\/owncloud\\/lib\\/private\\/Authentication\\/Token\\/DefaultTokenProvider.php(147): OC\\Authentication\\Token\\DefaultTokenMapper->getToken( sensitive parameters replaced )\n#7 \\/var\\/www\\/owncloud\\/lib\\/private\\/User\\/Session.php(492): OC\\Authentication\\Token\\DefaultTokenProvider->getToken( sensitive parameters replaced )\n#8 \\/var\\/www\\/owncloud\\/lib\\/private\\/User\\/Session.php(688): OC\\User\\Session->loginWithToken('p5g88cekm3dim1l...')\n#9 \\/var\\/www\\/owncloud\\/lib\\/base.php(960): OC\\User\\Session->tryTokenLogin(Object(OC\\AppFramework\\Http\\Request))\n#10 \\/var\\/www\\/owncloud\\/lib\\/base.php(897): OC::handleLogin(Object(OC\\AppFramework\\Http\\Request))\n#11 \\/var\\/www\\/owncloud\\/index.php(49): OC::handleRequest()\n#12 {main}\",\"File\":\"\\/var\\/www\\/owncloud\\/lib\\/composer\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Driver\\/AbstractMySQLDriver.php\",\"Line\":53}"}


#2

oc_authtoken table was introduced in 9.1.4. It is always recommended to update to the last point release before migration to the next major release.


#3

backuped my data and config folder
removed oc 10.0.0.12
installed 9.1.5-1.1
changed version in my config.php to 9.0.0.0
startet occ upgrade again
... now works ... thanks for you help :slight_smile: