my system is on ubuntu 17.10 server
php7.2
apache with mpm-event
nextcloud 13.02
pgsql 9.6
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” >= ?))’ with params [17, 5, 7, -62104252760]: SQLSTATE[22003]: Numeric value out of range: 7 ERROR: value “-62104252760” is out of range for type integer
/var/www/html/nexcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php - line 128: Doctrine\DBAL\Driver\AbstractPostgreSQLDriver->convertException(‘An exception oc…’, Object(Doctrine\DBAL\Driver\PDOException))
/var/www/html/nexcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php - line 855: Doctrine\DBAL\DBALException driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOPgSql\Driver), Object(Doctrine\DBAL\Driver\PDOException), ‘SELECT “fileid”…’, Array)
/var/www/html/nexcloud/lib/private/DB/Connection.php - line 195: Doctrine\DBAL\Connection->executeQuery(‘SELECT “fileid”…’, Array, Array, NULL)
/var/www/html/nexcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php - line 206: OC\DB\Connection->executeQuery(‘SELECT “fileid”…’, Array, Array)
/var/www/html/nexcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 214: Doctrine\DBAL\Query\QueryBuilder->execute()
/var/www/html/nexcloud/lib/private/Files/Cache/Cache.php - line 697: OC\DB\QueryBuilder\QueryBuilder->execute()
/var/www/html/nexcloud/lib/private/Files/Cache/Wrapper/CacheWrapper.php - line 233: OC\Files\Cache\Cache->searchQuery(Object(OC\Files\Search\SearchQuery))
[internal function] OC\Files\Cache\Wrapper\CacheWrapper->searchQuery(Object(OC\Files\Search\SearchQuery))
/var/www/html/nexcloud/lib/private/Files/Node/Folder.php - line 245: call_user_func_array(Array, Array)
/var/www/html/nexcloud/lib/private/Files/Node/Folder.php - line 201: OC\Files\Node\Folder->searchCommon(‘searchQuery’, Array)
/var/www/html/nexcloud/apps/dav/lib/Files/FileSearchBackend.php - line 158: OC\Files\Node\Folder->search(Object(OC\Files\Search\SearchQuery))
/var/www/html/nexcloud/3rdparty/icewind/searchdav/src/DAV/SearchHandler.php - line 75: OCA\DAV\Files\FileSearchBackend->search(Object(SearchDAV\XML\BasicSearch))
/var/www/html/nexcloud/3rdparty/icewind/searchdav/src/DAV/SearchPlugin.php - line 123: SearchDAV\DAV\SearchHandler->handleSearchRequest(Array, Object(Sabre\HTTP\Response))
[internal function] SearchDAV\DAV\SearchPlugin->searchHandler(Object(Sabre\HTTP\Request), Object(Sabre\HTTP\Response))
/var/www/html/nexcloud/3rdparty/sabre/event/lib/EventEmitterTrait.php - line 105: call_user_func_array(Array, Array)
/var/www/html/nexcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 479: Sabre\Event\EventEmitter->emit(‘method SEARCH’, Array)
/var/www/html/nexcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 254: Sabre\DAV\Server->invokeMethod(Object(Sabre\HTTP\Request), Object(Sabre\HTTP\Response))
/var/www/html/nexcloud/apps/dav/lib/Server.php - line 283: Sabre\DAV\Server->exec()
/var/www/html/nexcloud/apps/dav/appinfo/v2/remote.php - line 35: OCA\DAV\Server->exec()
/var/www/html/nexcloud/remote.php - line 164: require_once(’/var/www/html/A…’)
{main}