From 913a395d9480578cbd4f12dc133ca2afd05540f5 Mon Sep 17 00:00:00 2001 From: Alexander Ebert Date: Tue, 15 Aug 2023 14:18:23 +0200 Subject: [PATCH] Improve the performance of the export of conversation participants --- files/lib/system/exporter/VB3or4xExporter.class.php | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/files/lib/system/exporter/VB3or4xExporter.class.php b/files/lib/system/exporter/VB3or4xExporter.class.php index 861c8db..dad8b7a 100644 --- a/files/lib/system/exporter/VB3or4xExporter.class.php +++ b/files/lib/system/exporter/VB3or4xExporter.class.php @@ -1175,9 +1175,10 @@ class VB3or4xExporter extends AbstractExporter ON pm.userid = user.userid INNER JOIN " . $this->databasePrefix . "pmtext pmtext ON pmtext.pmtextid = pm.pmtextid + WHERE pm.pmid BETWEEN ? AND ? ORDER BY pm.pmid"; - $statement = $this->database->prepareStatement($sql, $limit, $offset); - $statement->execute(); + $statement = $this->database->prepareStatement($sql); + $statement->execute([$offset + 1, $offset + $limit]); while ($row = $statement->fetchArray()) { $participants = \explode(',', $row['participants']); $participants[] = $row['fromuserid']; -- 2.20.1