Welcome to mirror list, hosted at ThFree Co, Russian Federation.

github.com/nextcloud/server.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorCarl Schwan <carl@carlschwan.eu>2022-02-19 15:26:03 +0300
committerbackportbot[bot] <backportbot[bot]@users.noreply.github.com>2022-03-11 19:03:23 +0300
commitf7557d84421563a426475bec4716f3d046424ab2 (patch)
tree23f170d556cd86ea5ad6dadf9ed9dff23dc9d0da /apps/dav/lib
parent0d3c19c6aa76c7479fbb4b3784ae20b5b7b7ed89 (diff)
Fix more than 1000 entries in queries exception in CardDavBackend
Signed-off-by: Carl Schwan <carl@carlschwan.eu>
Diffstat (limited to 'apps/dav/lib')
-rw-r--r--apps/dav/lib/CardDAV/CardDavBackend.php17
1 files changed, 10 insertions, 7 deletions
diff --git a/apps/dav/lib/CardDAV/CardDavBackend.php b/apps/dav/lib/CardDAV/CardDavBackend.php
index 3e360fb2e41..98e85096b3b 100644
--- a/apps/dav/lib/CardDAV/CardDavBackend.php
+++ b/apps/dav/lib/CardDAV/CardDavBackend.php
@@ -1130,15 +1130,18 @@ class CardDavBackend implements BackendInterface, SyncSupport {
return (int)$match['cardid'];
}, $matches);
- $query = $this->db->getQueryBuilder();
- $query->select('c.addressbookid', 'c.carddata', 'c.uri')
- ->from($this->dbCardsTable, 'c')
- ->where($query->expr()->in('c.id', $query->createNamedParameter($matches, IQueryBuilder::PARAM_INT_ARRAY)));
+ $cards = [];
+ foreach (array_chunk($matches, 1000) as $matche) {
+ $query = $this->db->getQueryBuilder();
+ $query->select('c.addressbookid', 'c.carddata', 'c.uri')
+ ->from($this->dbCardsTable, 'c')
+ ->where($query->expr()->in('c.id', $query->createNamedParameter($matche, IQueryBuilder::PARAM_INT_ARRAY)));
- $result = $query->execute();
- $cards = $result->fetchAll();
+ $result = $query->execute();
+ $cards = array_merge($cards, $result->fetchAll());
+ $result->closeCursor();
+ }
- $result->closeCursor();
return array_map(function ($array) {
$array['addressbookid'] = (int) $array['addressbookid'];