Merge pull request #5770 from matrix-org/erikj/fix_current_state_event_sqlite

Fix current_state bg update to work on old SQLite

1 files changed, 2 insertions, 2 deletions

diff --git a/synapse/storage/roommember.py b/synapse/storage/roommember.py

index cb88e49b51..a1b9fd8199 100644
--- a/synapse/storage/roommember.py
+++ b/synapse/storage/roommember.py
@@ -870,10 +870,10 @@ class RoomMemberStore(RoomMemberWorkerStore):
                 next_room, = row
 
                 sql = """
-                    UPDATE current_state_events AS c
+                    UPDATE current_state_events
                     SET membership = (
                         SELECT membership FROM room_memberships
-                        WHERE event_id = c.event_id
+                        WHERE event_id = current_state_events.event_id
                     )
                     WHERE room_id = ?
                 """