diff options
author | Carl Schwan <carl@carlschwan.eu> | 2022-02-19 13:26:03 +0100 |
---|---|---|
committer | Carl Schwan <carl@carlschwan.eu> | 2022-02-21 14:30:00 +0100 |
commit | cb7485e7640497c29423e72fba5c47a26e84e811 (patch) | |
tree | ecc5dbe555bade90b8d78a0af5eab40cd4ce3180 /apps | |
parent | 4cdc8900f7325d38056060b355e8f25b79b96413 (diff) | |
download | nextcloud-server-cb7485e7640497c29423e72fba5c47a26e84e811.tar.gz nextcloud-server-cb7485e7640497c29423e72fba5c47a26e84e811.zip |
Fix more than 1000 entries in queries exception in CardDavBackend
Signed-off-by: Carl Schwan <carl@carlschwan.eu>
Diffstat (limited to 'apps')
-rw-r--r-- | apps/dav/lib/CardDAV/CardDavBackend.php | 17 |
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']; |