From ffe17e47cef75fe3d2a5f4c3fbf9c65f6caee1a8 Mon Sep 17 00:00:00 2001 From: Erik Johnston Date: Mon, 28 Jun 2021 14:29:27 +0100 Subject: Fix SQL --- synapse/storage/databases/main/transactions.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'synapse/storage') diff --git a/synapse/storage/databases/main/transactions.py b/synapse/storage/databases/main/transactions.py index 67655fc215..b3250084c5 100644 --- a/synapse/storage/databases/main/transactions.py +++ b/synapse/storage/databases/main/transactions.py @@ -411,7 +411,7 @@ class TransactionWorkerStore(CacheInvalidationWorkerStore): JOIN events USING (stream_ordering) WHERE destination = ? AND stream_ordering > ? - AND room_id != '!OGEhHVWSdvArJzumhm:matrix.org' + AND destination_rooms.room_id != '!OGEhHVWSdvArJzumhm:matrix.org' ORDER BY stream_ordering LIMIT 50 """ -- cgit 1.5.1