From 4ee9deea00bbaf413ca4cd36d604a3a9bb3f1fa2 Mon Sep 17 00:00:00 2001 From: Julius Härtl Date: Tue, 31 Jan 2023 10:19:35 +0100 Subject: fix(theming): Fix query for configvalue as CLOB on OCI MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Signed-off-by: Julius Härtl --- apps/theming/lib/Jobs/MigrateBackgroundImages.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/apps/theming/lib/Jobs/MigrateBackgroundImages.php b/apps/theming/lib/Jobs/MigrateBackgroundImages.php index 39731ef556f..7ee2b7977d6 100644 --- a/apps/theming/lib/Jobs/MigrateBackgroundImages.php +++ b/apps/theming/lib/Jobs/MigrateBackgroundImages.php @@ -30,6 +30,7 @@ use OCA\Theming\AppInfo\Application; use OCP\AppFramework\Utility\ITimeFactory; use OCP\BackgroundJob\IJobList; use OCP\BackgroundJob\QueuedJob; +use OCP\DB\QueryBuilder\IQueryBuilder; use OCP\Files\AppData\IAppDataFactory; use OCP\Files\IAppData; use OCP\Files\NotFoundException; @@ -92,7 +93,7 @@ class MigrateBackgroundImages extends QueuedJob { ->from('preferences') ->where($selector->expr()->eq('appid', $selector->createNamedParameter('theming'))) ->andWhere($selector->expr()->eq('configkey', $selector->createNamedParameter('background'))) - ->andWhere($selector->expr()->eq('configvalue', $selector->createNamedParameter('custom'))) + ->andWhere($selector->expr()->eq('configvalue', $selector->createNamedParameter('custom', IQueryBuilder::PARAM_STR), IQueryBuilder::PARAM_STR)) ->executeQuery(); $userIds = $result->fetchAll(\PDO::FETCH_COLUMN); -- cgit v1.2.3