Nextcloud version (eg, 12.0.2): trying to upgrade to 15.0.4… ish
Operating system and version (eg, Ubuntu 17.04): Linux
Apache or nginx version (eg, Apache 2.4.25): Apache/2.2.34 (Unix)
PHP version (eg, 7.1): PHP 7.0.33 (cli)
The issue you are facing:
Internal Server Error
The server was unable to complete your request.
If this happens again, please send the technical details below to the server administrator.
More details can be found in the server log.
Technical details
- Remote Address: 173.244.44.81
- Request ID: XGu8-0XDfD0AC5IqWlEAAADG
- Type: Doctrine\DBAL\Exception\InvalidFieldNameException
- Code: 0
- Message: An exception occurred while executing ‘SELECT * FROM
oc_authtokenWHERE (token= ?) AND (version= ?)’ with params [“84593c6dd3e23d1bf7ce1e881bfb8d1cd54ef561696a6de6a7719dba41639d6a8b38d20f547c130dce0f0d59da1c314bc9f1d12ca418d5c978cf71e4c934b2b2”, 2]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘version’ in ‘where clause’- File: /home2/boydhana/public_html/cloud.boydhanaleiako.me/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php
- Line: 71
Trace
#0 /home2/boydhana/public_html/cloud.boydhanaleiako.me/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(128): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException(‘An exception oc…’, Object(Doctrine\DBAL\Driver\PDOException)) #1 /home2/boydhana/public_html/cloud.boydhanaleiako.me/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(855): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDOException), ‘SELECT * FROM
...', Array) #2 /home2/boydhana/public_html/cloud.boydhanaleiako.me/lib/private/DB/Connection.php(195): Doctrine\DBAL\Connection->executeQuery('SELECT * FROM…’, Array, Array, NULL) #3 /home2/boydhana/public_html/cloud.boydhanaleiako.me/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): OC\DB\Connection->executeQuery(‘SELECT * FROM `…’, Array, Array) #4 /home2/boydhana/public_html/cloud.boydhanaleiako.me/lib/private/DB/QueryBuilder/QueryBuilder.php(214): Doctrine\DBAL\Query\QueryBuilder->execute() #5 /home2/boydhana/public_html/cloud.boydhanaleiako.me/lib/private/Authentication/Token/PublicKeyTokenMapper.php(79): OC\DB\QueryBuilder\QueryBuilder->execute() #6 /home2/boydhana/public_html/cloud.boydhanaleiako.me/lib/private/Authentication/Token/PublicKeyTokenProvider.php(79): OC\Authentication\Token\PublicKeyTokenMapper->getToken(‘84593c6dd3e23d1…’) #7 /home2/boydhana/public_html/cloud.boydhanaleiako.me/lib/private/Authentication/Token/Manager.php(115): OC\Authentication\Token\PublicKeyTokenProvider->getToken(‘uapfkb5ba3htq2m…’) #8 /home2/boydhana/public_html/cloud.boydhanaleiako.me/lib/private/User/Session.php(588): OC\Authentication\Token\Manager->getToken(‘uapfkb5ba3htq2m…’) #9 /home2/boydhana/public_html/cloud.boydhanaleiako.me/lib/private/User/Session.php(780): OC\User\Session->loginWithToken(‘uapfkb5ba3htq2m…’) #10 /home2/boydhana/public_html/cloud.boydhanaleiako.me/lib/base.php(1031): OC\User\Session->tryTokenLogin(Object(OC\AppFramework\Http\Request)) #11 /home2/boydhana/public_html/cloud.boydhanaleiako.me/lib/base.php(976): OC::handleLogin(Object(OC\AppFramework\Http\Request)) #12 /home2/boydhana/public_html/cloud.boydhanaleiako.me/index.php(42): OC::handleRequest() #13 {main}
Is this the first time you’ve seen this error? (Y/N): Yes
Steps to replicate it:
- Upgrade to 15.0.4
The output of your Nextcloud log in Admin > Logging:
{"reqId":"XGvCzkXDfD0ADN66JEEAAALY","level":3,"time":"2019-02-19T08:48:15+00:00","remoteAddr":"173.244.44.81","user":"bako","app":"PHP","method":"GET","url":"\/ocs\/v2.php\/core\/navigation\/apps?absolute=true&format=json","message":"Doctrine\\DBAL\\Exception\\InvalidFieldNameException: An exception occurred while executing 'SELECT `uid`, `displayname` FROM `oc_users` WHERE `uid_lower` = ?' with params [\"bako\"]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'uid_lower' in 'where clause' at \/home2\/boydhana\/public_html\/cloud.boydhanaleiako.me\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/AbstractMySQLDriver.php#71","userAgent":"Mozilla\/5.0 (Macintosh) mirall\/2.5.1final (build 20181204) (Nextcloud)","version":"15.0.4.0"}
The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):
<?php
$CONFIG = array (
'instanceid' => '<censored>',
'passwordsalt' => '<censored>',
'secret' => '<censored>',
'trusted_domains' =>
array (
0 => 'cloud.boydhanaleiako.me',
1 => 'box861.bluehost.com',
2 => 'localhost',
3 => 'boydhanaleiako.me',
4 => 'bluehost.com',
),
'datadirectory' => '/home2/boydhana/public_html/cloud.boydhanaleiako.me/data',
'overwrite.cli.url' => 'https://cloud.boydhanaleiako.me',
'dbtype' => 'mysql',
'version' => '15.0.4.0',
'dbname' => 'boydhana_owncloud',
'dbhost' => 'localhost',
'dbtableprefix' => 'oc_',
'dbuser' => '<censored>',
'dbpassword' => '<censored>',
'installed' => true,
'mail_smtpmode' => 'smtp',
'mail_smtpsecure' => 'ssl',
'mail_smtphost' => 'smtp.gmail.com',
'mail_smtpport' => '587',
'mail_from_address' => 'jarvis.system.notifier',
'mail_domain' => 'gmail.com',
'loglevel' => 0,
'theme' => '',
'maintenance' => false,
'appstore.experimental.enabled' => true,
'trashbin_retention_obligation' => 'auto',
'mail_smtpauthtype' => 'PLAIN',
'debug' => true,
);
The output of your Apache/nginx/system log in /var/log/____:
No acces from Hosting Provider