Internal Server Error with easy apache 4

sqlite
help

#1

I curently using owncloud(not sure about the version...
I jsut go in WHM and update to easyapache 4 and not my main site did't work and also owncloud.
I got this erreur:
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.

Of course it's a generic error, so I check inside the log od owncloud and get this:

{"reqId":"V7Kw0sOOSsRsWx0L4BOwfAAAAAQ","remoteAddr":"70.51.173.150","app":"index","message":"Exception: {\"Exception\":\"Doctrine\\DBAL\\Exception\\DriverException\",\"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[HY000]: General error: 26 file is encrypted or is not a database\",\"Code\":0,\"Trace\":\"#0 \\/home\\/uniactionadmin\\/public_html\\/cloud\\/3rdparty\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/DBALException.php(116): Doctrine\\DBAL\\Driver\\AbstractSQLiteDriver->convertException('An exception oc...', Object(Doctrine\\DBAL\\Driver\\PDOException))\n#1 \\/home\\/uniactionadmin\\/public_html\\/cloud\\/3rdparty\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Connection.php(836): Doctrine\\DBAL\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\DBAL\\Driver\\PDOSqlite\\Driver), Object(Doctrine\\DBAL\\Driver\\PDOException), 'SELECT * FROM \\"...', Array)\n#2 \\/home\\/uniactionadmin\\/public_html\\/cloud\\/lib\\/private\\/db\\/connection.php(182): Doctrine\\DBAL\\Connection->executeQuery('SELECT * FROM \\"...', Array, Array, NULL)\n#3 \\/home\\/uniactionadmin\\/public_html\\/cloud\\/3rdparty\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Query\\/QueryBuilder.php(206): OC\\DB\\Connection->executeQuery('SELECT * FROM ...', Array, Array)\\n#4 \\\/home\\\/uniactionadmin\\\/public_html\\\/cloud\\\/lib\\\/private\\\/db\\\/querybuilder\\\/querybuilder.php(121): Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder->execute()\\n#5 \\\/home\\\/uniactionadmin\\\/public_html\\\/cloud\\\/lib\\\/private\\\/appconfig.php(294): OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder->execute()\\n#6 \\\/home\\\/uniactionadmin\\\/public_html\\\/cloud\\\/lib\\\/private\\\/appconfig.php(79): OC\\\\AppConfig->loadConfigValues()\\n#7 \\\/home\\\/uniactionadmin\\\/public_html\\\/cloud\\\/lib\\\/private\\\/appconfig.php(256): OC\\\\AppConfig->getApps()\\n#8 \\\/home\\\/uniactionadmin\\\/public_html\\\/cloud\\\/lib\\\/private\\\/app\\\/appmanager.php(80): OC\\\\AppConfig->getValues(false, 'enabled')\\n#9 \\\/home\\\/uniactionadmin\\\/public_html\\\/cloud\\\/lib\\\/private\\\/app\\\/appmanager.php(95): OC\\\\App\\\\AppManager->getInstalledAppsValues()\\n#10 \\\/home\\\/uniactionadmin\\\/public_html\\\/cloud\\\/lib\\\/private\\\/app.php(267): OC\\\\App\\\\AppManager->getInstalledApps()\\n#11 \\\/home\\\/uniactionadmin\\\/public_html\\\/cloud\\\/lib\\\/private\\\/app.php(104): OC_App::getEnabledApps()\\n#12 \\\/home\\\/uniactionadmin\\\/public_html\\\/cloud\\\/lib\\\/base.php(564): OC_App::loadApps(Array)\\n#13 \\\/home\\\/uniactionadmin\\\/public_html\\\/cloud\\\/lib\\\/base.php(1083): OC::init()\\n#14 \\\/home\\\/uniactionadmin\\\/public_html\\\/cloud\\\/index.php(37): require_once('\\\/home\\\/uniaction...')\\n#15 {main}\",\"File\":\"\\\/home\\\/uniactionadmin\\\/public_html\\\/cloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractSQLiteDriver.php\",\"Line\":85}","level":3,"time":"2016-08-16T06:21:06+00:00"}
{"reqId":"V7Kw0sOOSsRsWx0L4BOwfAAAAAQ","remoteAddr":"70.51.173.150","app":"core","message":"Exception: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\DriverException\",\"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[HY000]: General error: 26 file is encrypted or is not a database\",\"Code\":0,\"Trace\":\"#0 \\\/home\\\/uniactionadmin\\\/public_html\\\/cloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(116): Doctrine\\\\DBAL\\\\Driver\\\\AbstractSQLiteDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/home\\\/uniactionadmin\\\/public_html\\\/cloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(836): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOSqlite\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'SELECT * FROM \\\"...', Array)\\n#2 \\\/home\\\/uniactionadmin\\\/public_html\\\/cloud\\\/lib\\\/private\\\/db\\\/connection.php(182): Doctrine\\\\DBAL\\\\Connection->executeQuery('SELECT * FROM \\\"...', Array, Array, NULL)\\n#3 \\\/home\\\/uniactionadmin\\\/public_html\\\/cloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Query\\\/QueryBuilder.php(206): OC\\\\DB\\\\Connection->executeQuery('SELECT * FROM
...', Array, Array)\n#4 \\/home\\/uniactionadmin\\/public_html\\/cloud\\/lib\\/private\\/db\\/querybuilder\\/querybuilder.php(121): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 \\/home\\/uniactionadmin\\/public_html\\/cloud\\/lib\\/private\\/appconfig.php(294): OC\\DB\\QueryBuilder\\QueryBuilder->execute()\n#6 \\/home\\/uniactionadmin\\/public_html\\/cloud\\/lib\\/private\\/appconfig.php(79): OC\\AppConfig->loadConfigValues()\n#7 \\/home\\/uniactionadmin\\/public_html\\/cloud\\/lib\\/private\\/appconfig.php(256): OC\\AppConfig->getApps()\n#8 \\/home\\/uniactionadmin\\/public_html\\/cloud\\/lib\\/private\\/app\\/appmanager.php(80): OC\\AppConfig->getValues(false, 'enabled')\n#9 \\/home\\/uniactionadmin\\/public_html\\/cloud\\/lib\\/private\\/app\\/appmanager.php(95): OC\\App\\AppManager->getInstalledAppsValues()\n#10 \\/home\\/uniactionadmin\\/public_html\\/cloud\\/lib\\/private\\/app.php(267): OC\\App\\AppManager->getInstalledApps()\n#11 \\/home\\/uniactionadmin\\/public_html\\/cloud\\/lib\\/private\\/app.php(104): OC_App::getEnabledApps()\n#12 \\/home\\/uniactionadmin\\/public_html\\/cloud\\/lib\\/base.php(564): OC_App::loadApps(Array)\n#13 \\/home\\/uniactionadmin\\/public_html\\/cloud\\/lib\\/base.php(1083): OC::init()\n#14 \\/home\\/uniactionadmin\\/public_html\\/cloud\\/index.php(37): require_once('\\/home\\/uniaction...')\n#15 {main}\",\"File\":\"\\/home\\/uniactionadmin\\/public_html\\/cloud\\/3rdparty\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Driver\\/AbstractSQLiteDriver.php\",\"Line\":85}","level":3,"time":"2016-08-16T06:21:06+00:00"}
{"reqId":"V7Kw0sOOSsRsWx0L4BOwfAAAAAQ","remoteAddr":"70.51.173.150","app":"core","message":"Exception: {\"Exception\":\"Doctrine\\DBAL\\Exception\\DriverException\",\"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[HY000]: General error: 26 file is encrypted or is not a database\",\"Code\":0,\"Trace\":\"#0 \\/home\\/uniactionadmin\\/public_html\\/cloud\\/3rdparty\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/DBALException.php(116): Doctrine\\DBAL\\Driver\\AbstractSQLiteDriver->convertException('An exception oc...', Object(Doctrine\\DBAL\\Driver\\PDOException))\n#1 \\/home\\/uniactionadmin\\/public_html\\/cloud\\/3rdparty\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Connection.php(836): Doctrine\\DBAL\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\DBAL\\Driver\\PDOSqlite\\Driver), Object(Doctrine\\DBAL\\Driver\\PDOException), 'SELECT * FROM \\"...', Array)\n#2 \\/home\\/uniactionadmin\\/public_html\\/cloud\\/lib\\/private\\/db\\/connection.php(182): Doctrine\\DBAL\\Connection->executeQuery('SELECT * FROM \\"...', Array, Array, NULL)\n#3 \\/home\\/uniactionadmin\\/public_html\\/cloud\\/3rdparty\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Query\\/QueryBuilder.php(206): OC\\DB\\Connection->executeQuery('SELECT * FROM `...', Array, Array)\n#4 \\/home\\/uniactionadmin\\/public_html\\/cloud\\/lib\\/private\\/db\\/querybuilder\\/querybuilder.php(121): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 \\/home\\/uniactionadmin\\/public_html\\/cloud\\/lib\\/private\\/appconfig.php(294): OC\\DB\\QueryBuilder\\QueryBuilder->execute()\n#6 \\/home\\/uniactionadmin\\/public_html\\/cloud\\/lib\\/private\\/appconfig.php(121): OC\\AppConfig->loadConfigValues()\n#7 \\/home\\/uniactionadmin\\/public_html\\/cloud\\/lib\\/private\\/util.php(410): OC\\AppConfig->getValue('core', 'OC_Channel')\n#8 \\/home\\/uniactionadmin\\/public_html\\/cloud\\/lib\\/private\\/util.php(343): OC_Util::loadVersion()\n#9 \\/home\\/uniactionadmin\\/public_html\\/cloud\\/lib\\/private\\/defaults.php(52): OC_Util::getVersion()\n#10 \\/home\\/uniactionadmin\\/public_html\\/cloud\\/lib\\/private\\/template.php(81): OC_Defaults->construct()\n#11 \\/home\\/uniactionadmin\\/public_html\\/cloud\\/lib\\/private\\/template.php(328): OC_Template->construct('', 'exception', 'error', false)\n#12 \\/home\\/uniactionadmin\\/public_html\\/cloud\\/index.php(55): OC_Template::printExceptionErrorPage(Object(Doctrine\\DBAL\\Exception\\DriverException))\n#13 {main}\",\"File\":\"\\/home\\/uniactionadmin\\/public_html\\/cloud\\/3rdparty\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Driver\\/AbstractSQLiteDriver.php\",\"Line\":85}","level":3,"time":"2016-08-16T06:21:06+00:00"}

Any idead what happening? Did I make a big mistake by updating easyapache to version 4?
Thanks for you help.


500 error after upgrading from easyApache 3 to easyApache 4
#2

Just had a short search on google for this error:

General error: 26 file is encrypted or is not a database

It seems your system previously used SQLite2 and was now upgraded to SQLite3. Both versions have incompatible database formats.

You need to somehow manage to upgrade this database file (data/owncloud.db) to SQLite3. Maybe the SQLite documentation:

https://www.sqlite.org/docs.html

or their support can help you with this task:

https://www.sqlite.org/support.html


#3

thanks for your answer.
I will reed documentation, but im not to good at server management....
Did that mean that if I jsut install back the script that will work? Even if that mean lost all past stuff...


#4

In general this means if you can manage to get the migration from SQLite2 to SQLite3 to work oC should continue to work.

Some info how to do the migration are available here:

https://www.sqlite.org/version3.html


#5

I found documentation that ask to run sqlite OLD.DB .dump | sqlite3 NEW.DB, but that need to find the location of the database, I used the file explorer in cpanel but never found the file, any idea how to know where they are located?


#6

Its located in:

/path/to/owncloud/data/owncloud.db


#7

I found it, but I can't acces it in ssh, location was in home and ssh blocked in root directory


#8

I tryed to downlaod on my pc sqllite and sqllite 3 and follow step.
I got this error: Unable to open database "name" : file is encrypted or is not a database.
I only use owncloud for password manager.


#9

database seem to be at same version, and now I get same error with another site reseauchat.com


#10

Time to follow the already posted advice and ask the SQLite support for help.