- Nextcloud version: 17.0.3
- Operating system and version: CentOS 6
- Apache or nginx version: apache 2.2.15 | nginx 1.16.1 (reverse proxy)
- PHP version: 7.2
The official Nextcloud app for iOS is installed. after logging in with the old authorization method, the error “Request failed: internal server error (500)” is displayed.
it appears once upon the first authorization. after which the error window disappears and the application works as usual.
I use the old authorization method because I can’t use the standard one because I have nginx with reverse proxies and balancers. when I try to log in by default, I get the error “csrf check failed”. the option with “overwriteprotocol => https” helps with this error “csrf …”, but it doesn’t suit me because of the limitations of the infrastructure.
Is this the first time you’ve seen this error?:
Yes
Steps to replicate it:
- Open the Nextcloud app for iOS
- login to your account using the old authorization method
- get error 500
The output of your Nextcloud log:
[webdav] Fatal: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'SELECT "fileid", "storage", "path", "parent", "name", "mimetype", "mimepart", "size", "mtime", "storage_mtime", "encrypted", "etag", "permissions", "checksum" FROM "oc_filecache" "file" WHERE ("storage" = ?) AND ((("mimepart" = ?) OR ("mimepart" = ?)) AND (("mtime" <= ?) AND ("mtime" >= ?))) ORDER BY "mtime" desc, "name" desc' with params [35, 6, 14, 1583236445, -62135587783]:
SQLSTATE[22003]: Numeric value out of range: 7 ERROR: value "-62135587783" out of range for type integer at <<closure>>
0. /var/www/html/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 169
Doctrine\DBAL\Driver\AbstractPostgreSQLDriver->convertException("An exception oc ... r", Doctrine\DBAL\Dr ... ]})
1. /var/www/html/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 145
Doctrine\DBAL\DBALException::wrapException(Doctrine\DBAL\Driver\PDOPgSql\Driver {}, Doctrine\DBAL\Dr ... ]}, "An exception oc ... r")
2. /var/www/html/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 911
Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Doctrine\DBAL\Driver\PDOPgSql\Driver {}, Doctrine\DBAL\Dr ... ]}, "SELECT \"fileid ... c", {1: 35,2: 6,3: 1 ... 3})
3. /var/www/html/owncloud/lib/private/DB/Connection.php line 195
Doctrine\DBAL\Connection->executeQuery("SELECT \"fileid ... c", [35,6,14,1583236445,-62135587783], [2,1,1,1,1], null)
4. /var/www/html/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php line 200
OC\DB\Connection->executeQuery("SELECT \"fileid ... c", {dcValue1: 35,dc ... 3}, {dcValue1: 2,dcV ... 1})
5. /var/www/html/owncloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 214
Doctrine\DBAL\Query\QueryBuilder->execute()
6. /var/www/html/owncloud/lib/private/Files/Cache/Cache.php line 722
OC\DB\QueryBuilder\QueryBuilder->execute()
7. <<closure>>
OC\Files\Cache\Cache->searchQuery(OC\Files\Search\SearchQuery {})
8. /var/www/html/owncloud/lib/private/Files/Node/Folder.php line 249
undefinedundefinedcall_user_func_array([OC\Files\Cache\ ... "], [OC\Files\Search\SearchQuery {}])
9. /var/www/html/owncloud/lib/private/Files/Node/Folder.php line 205
OC\Files\Node\Folder->searchCommon("searchQuery", [OC\Files\Search\SearchQuery {}])
10. /var/www/html/owncloud/apps/dav/lib/Files/FileSearchBackend.php line 158
OC\Files\Node\Folder->search(OC\Files\Search\SearchQuery {})
11. /var/www/html/owncloud/apps/dav/lib/Files/LazySearchBackend.php line 65
OCA\DAV\Files\FileSearchBackend->search(SearchDAV\Query\ ... }})
12. /var/www/html/owncloud/3rdparty/icewind/searchdav/src/DAV/SearchHandler.php line 81
OCA\DAV\Files\LazySearchBackend->search(SearchDAV\Query\ ... }})
13. /var/www/html/owncloud/3rdparty/icewind/searchdav/src/DAV/SearchPlugin.php line 123
SearchDAV\DAV\SearchHandler->handleSearchRequest({{DAV:}basicsear ... }}, Sabre\HTTP\Response {})
14. <<closure>>
SearchDAV\DAV\SearchPlugin->searchHandler(Sabre\HTTP\Reque ... "}, Sabre\HTTP\Response {})
15. /var/www/html/owncloud/3rdparty/sabre/event/lib/EventEmitterTrait.php line 105
undefinedundefinedcall_user_func_array([SearchDAV\DAV\S ... "], [Sabre\HTTP\Requ ... }])
16. /var/www/html/owncloud/3rdparty/sabre/dav/lib/DAV/Server.php line 479
Sabre\Event\EventEmitter->emit("method:SEARCH", [Sabre\HTTP\Requ ... }])
17. /var/www/html/owncloud/3rdparty/sabre/dav/lib/DAV/Server.php line 254
Sabre\DAV\Server->invokeMethod(Sabre\HTTP\Reque ... "}, Sabre\HTTP\Response {})
18. /var/www/html/owncloud/apps/dav/lib/Server.php line 317
Sabre\DAV\Server->exec()
19. /var/www/html/owncloud/apps/dav/appinfo/v2/remote.php line 35
OCA\DAV\Server->exec()
20. /var/www/html/owncloud/remote.php line 163
undefinedundefinedrequire_once("/var/www/html/o ... p")
SEARCH /remote.php/dav
from 31.111.29.111 by grigor at 2020-03-03T14:54:08+03:00
The output of your config.php:
<?php
$CONFIG = array (
'instanceid' => 'XXXXX',
'passwordsalt' => 'XXXXX',
'secret' => 'XXXXX',
'trusted_domains' =>.
array (
0 => 'share.domain.ru',
1 => 'share.domain.loc',
2 => 'wmail.domain.ru',
3 => 'wmail.domain.loc',
),
'datadirectory' => '/var/www/html/owncloud-data',
'overwrite.cli.url' => 'https://share.domain.ru',
'dbtype' => 'pgsql',
'version' => '17.0.3.1',
'dbname' => 'share.domain.ru',
'dbhost' => '11.1.1.11:XXXX',
'dbtableprefix' => 'oc_',
'dbuser' => 'share.domain.ru_owner',
'dbpassword' => 'XXXX',
'logtimezone' => 'Europe/Moscow',
'installed' => true,
'ldapIgnoreNamingRules' => false,
'theme' => '',
'kolaburl' => 'https://wmail.domain.ru',
'kolabsecret' => 'XXXX',
'mail_from_address' => 'share',
'mail_smtpmode' => 'smtp',
'mail_domain' => 'domain.ru',
'mail_smtpauth' => 1,
'mail_smtpname' => 'share',
'mail_smtppassword' => 'XXXX',
'log_type' => 'owncloud',
'logfile' => '/var/www/html/owncloud-data/owncloud.log',
'loglevel' => 3,
'log_query' => false,
'cron_log' => true,
'maintenance' => false,
'mail_smtphost' => 'mx2.domain.ru',
'mail_smtpport' => '25',
'mail_smtpauthtype' => 'PLAIN',
'mail_smtpsecure' => 'tls',
'appstore.experimental.enabled' => true,
'preview_libreoffice_path' => '/usr/bin/libreoffice',
'updatechecker' => false,
'trashbin_retention_obligation' => 'auto',
'memcache.local' => '\\OC\\Memcache\\APCu',
'memcache.locking' => '\\OC\\Memcache\\Redis',
'redis' =>.
array (
'host' => 'localhost',
'port' => XXXX,
),
'asset-pipeline.enabled' => true,
'ldapProviderFactory' => '\\OCA\\User_LDAP\\LDAPProviderFactory',
'mail_sendmailmode' => 'smtp',
);
The output of your Apache/nginx/system log in /var/log/____
:
I can`t provide logs