Skip to content

More than 1000 expressions in a list are not allowed on Oracle #578

@solracsf

Description

@solracsf
[core] Error: Doctrine\DBAL\Query\QueryException: More than 1000 expressions in a list are not allowed on Oracle. at <<closure>>

 0. /apps/dav/lib/CardDAV/CardDavBackend.php line 1112
    OC\DB\QueryBuilder\QueryBuilder->execute()
 1. /apps/dav/lib/CardDAV/CardDavBackend.php line 1010
    OCA\DAV\CardDAV\CardDavBackend->searchByAddressBookIds(["1"], "c", ["FN","ORG","EMAIL"], [])
 2. /apps/dav/lib/CardDAV/AddressBookImpl.php line 119
    OCA\DAV\CardDAV\CardDavBackend->search("1", "c", ["FN","ORG","EMAIL"], [])
 3. /lib/private/ContactsManager.php line 52
    OCA\DAV\CardDAV\AddressBookImpl->search("c", ["FN","ORG","EMAIL"], [])
 4. /apps/circles/lib/Search/Contacts.php line 45
    OC\ContactsManager->search("c", ["FN","ORG","EMAIL"])
 5. /apps/circles/lib/Service/SearchService.php line 95
    OCA\Circles\Search\Contacts->search("c")
 6. /apps/circles/lib/Controller/MembersController.php line 246
    OCA\Circles\Service\SearchService->searchGlobal("c")
 7. /lib/private/AppFramework/Http/Dispatcher.php line 218
    OCA\Circles\Controller\MembersController->searchGlobal("c", 5)
 8. /lib/private/AppFramework/Http/Dispatcher.php line 127
    OC\AppFramework\Http\Dispatcher->executeController(OCA\Circles\Cont ... {}, "searchGlobal")
 9. /lib/private/AppFramework/App.php line 157
    OC\AppFramework\Http\Dispatcher->dispatch(OCA\Circles\Cont ... {}, "searchGlobal")
10. /lib/private/Route/Router.php line 302
    OC\AppFramework\App::main("OCA\\Circles\\C ... r", "searchGlobal", OC\AppFramework\ ... {}, {_route: "circles.Members.searchGlobal"})
11. /lib/base.php line 993
    OC\Route\Router->match("/apps/circles/v1/globalsearch")
12. /index.php line 37
    OC::handleRequest()

GET /apps/circles/v1/globalsearch?search=c&order=5

See also nextcloud/mail#4947

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions