Cannot restore owncloud 8.2.10


#1

Hi

I'm in trouble at the moment. I'm trying to restore my owncloud instance after some pb. I've backuped before in a regular way the owncloud directory and the mysql database.

I'm using debian packages on 7.11.

I've restored owncloud directory and then restored mysql database. But then in web browser I get
Internal Server Error
The server encountered an internal error and was unable to complete your request.
Please contact the server administrator if this error reappears multiple times, please include the technical details below in your report.
More details can be found in the server log.

Checking owncloud.log I get also

{"reqId":"XiNhfPq6frOLYPevJxSR","remoteAddr":"176.179.128.32","app":"core","message":"Exception: {\"Exception\":\"Doctrine\\DBAL\\Exception\\TableNotFoundException\",\"Message\":\"An exception occurred while executing 'SELECT * FROM oc_appconfig WHERE (appid <> ?) OR (configkey IN (?, ?, ?, ?, ?))' with params [\\"files_sharing\\", \\"enabled\\", \\"installed_version\\", \\"types\\", \\"incoming_server2server_share_enabled\\", \\"outgoing_server2server_share_enabled\\"]:\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table 'owncloud.oc_appconfig' doesn't exist\",\"Code\":0,\"Trace\":\"#0 \\/var\\/www\\/owncloud\\/3rdparty\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/DBALException.php(116): Doctrine\\DBAL\\Driver\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\DBAL\\Driver\\PDOException))\n#1 \\/var\\/www\\/owncloud\\/3rdparty\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Connection.php(836): Doctrine\\DBAL\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\DBAL\\Driver\\PDOMySql\\Driver), Object(Doctrine\\DBAL\\Driver\\PDOException), 'SELECT * FROM ...', Array)\\n#2 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/db\\\/connection.php(182): Doctrine\\\\DBAL\\\\Connection->executeQuery('SELECT * FROM...', Array, Array, NULL)\n#3 \\/var\\/www\\/owncloud\\/3rdparty\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Query\\/QueryBuilder.php(206): OC\\DB\\Connection->executeQuery('SELECT * FROM `...', Array, Array)\n#4 \\/var\\/www\\/owncloud\\/lib\\/private\\/db\\/querybuilder\\/querybuilder.php(121): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 \\/var\\/www\\/owncloud\\/lib\\/private\\/appconfig.php(294): OC\\DB\\QueryBuilder\\QueryBuilder->execute()\n#6 \\/var\\/www\\/owncloud\\/lib\\/private\\/appconfig.php(121): OC\\AppConfig->loadConfigValues()\n#7 \\/var\\/www\\/owncloud\\/lib\\/private\\/util.php(410): OC\\AppConfig->getValue('core', 'OC_Channel')\n#8 \\/var\\/www\\/owncloud\\/lib\\/private\\/util.php(343): OC_Util::loadVersion()\n#9 \\/var\\/www\\/owncloud\\/lib\\/private\\/defaults.php(52): OC_Util::getVersion()\n#10 \\/var\\/www\\/owncloud\\/lib\\/private\\/template.php(81): OC_Defaults->construct()\n#11 \\/var\\/www\\/owncloud\\/lib\\/private\\/template.php(328): OC_Template->construct('', 'exception', 'error', false)\n#12 \\/var\\/www\\/owncloud\\/remote.php(81): OC_Template::printExceptionErrorPage(Object(Doctrine\\DBAL\\Exception\\TableNotFoundException))\n#13 \\/var\\/www\\/owncloud\\/remote.php(140): handleException(Object(Doctrine\\DBAL\\Exception\\TableNotFoundException))\n#14 {main}\",\"File\":\"\\/var\\/www\\/owncloud\\/3rdparty\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Driver\\/AbstractMySQLDriver.php\",\"Line\":53}","level":3,"time":"2017-04-09T23:52:46+00:00"}

and many others.

Trying to use php occ command but also got errors:

$ php occ
An unhandled exception has been thrown:
exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'owncloud.oc_appconfig' doesn't exist' in /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91

Any clue ?


#2

Forget about it, wrong database restore... sorry for the noise