ownCloud 8.0.4.2 Internal Server Error (QNAP) - InnoDB issue?

qnap
mysql
webserver_issue

#1

Hi all,

I have been using my QNAP NAS primarily for running ownCloud version 8.0.4. I know the software has not been updated by QNAP for a long time but it has been running smoothly for a couple of years. However, I suddenly got this 'Internal Server Error' and it stopped working. I cannot recall I had updated the firmware, the MySQL software or any other software prior to this error.

I have tried to login as admin but I only get the error message. I am not an expert at this at all and I don't understand this problem. Is there anybody who can help me fix this problem? Any help is greatly appreciated.

PS: Since I am a new user, I can only attach one attachment.

Server configuration

QNAP TS-670 PRO
- Firmware: 4.3.4.0435 build 20171230 (latest version)
- 2 GB RAM
- Owcloud 8.0.4.2 from the QNAP App store (latest version I can install)
- phpMyAdmin 4.7.4.0 from the QNAP App store (latest version I can install)
- PHP version: 5.6.31
- Server type: MariaDB
- Server version: 5.5.57-MariaDB - MariaDB Server

Owncloud error message

Log file

I have checked the log files (web/owncloud/data/owncloud.log) and this is what I got:

{"reqId":"d8dfec3887872889cc07e927b1a3e400","remoteAddr":"192.168.0.116","app":"index","message":"Exception: {\"Message\":\"An exception occurred while executing 'SELECT configvalue, appid FROM oc_appconfig WHERE configkey = ?' with params [\\"enabled\\"]:\n\nSQLSTATE[42000]: Syntax error or access violation: nm
\",\"Code\":0,\"Trace\":\"#0 \\/share\\/CACHEDEV1_DATA\\/.qpkg\\/owncloud\\/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 \\/share\\/CACHEDEV1_DATA\\/.qpkg\\/owncloud\\/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 configv...', Array)\\n#2 \\\/share\\\/CACHEDEV1_DATA\\\/.qpkg\\\/owncloud\\\/owncloud\\\/lib\\\/private\\\/db\\\/connection.php(113): Doctrine\\\\DBAL\\\\Connection->executeQuery('SELECTconfigv...', Array, Array, NULL)\n#3 \\/share\\/CACHEDEV1_DATA\\/.qpkg\\/owncloud\\/owncloud\\/lib\\/private\\/appconfig.php(259): OC\\DB\\Connection->executeQuery('SELECT `configv...', Array)\n#4 \\/share\\/CACHEDEV1_DATA\\/.qpkg\\/owncloud\\/owncloud\\/lib\\/private\\/app.php(219): OC\\AppConfig->getValues(false, 'enabled')\n#5 \\/share\\/CACHEDEV1_DATA\\/.qpkg\\/owncloud\\/owncloud\\/lib\\/private\\/app.php(71): OC_App::getEnabledApps()\n#6 \\/share\\/CACHEDEV1_DATA\\/.qpkg\\/owncloud\\/owncloud\\/lib\\/base.php(551): OC_App::loadApps(Array)\n#7 \\/share\\/CACHEDEV1_DATA\\/.qpkg\\/owncloud\\/owncloud\\/lib\\/base.php(1039): OC::init()\n#8 \\/share\\/CACHEDEV1_DATA\\/.qpkg\\/owncloud\\/owncloud\\/index.php(34): require_once('\\/share\\/CACHEDEV...')\n#9 {main}\",\"File\":\"\\/share\\/CACHEDEV1_DATA\\/.qpkg\\/owncloud\\/owncloud\\/3rdparty\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Driver\\/AbstractMySQLDriver.php\",\"Line\":115}","level":4,"time":"2017-12-24T13:30:35+00:00”}[/code]

SQL - phpMyAdmin

When I open the phpMyAdmin app and go to the owncloud database, I see the following error message related to InnoDB: #1286 - unknown storage engine 'InnoDB'

I don't know if this is related to the problem, but I do see another message in phpMyAdmin:
"The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why."

When I click on 'Find out why' I get this:
"Configuration of pmadb… not OK
General relation features Disabled
Create a database named 'phpmyadmin' and setup the phpMyAdmin configuration storage there."