summary refs log tree commit diff
diff options
context:
space:
mode:
authorErik Johnston <erik@matrix.org>2016-03-11 15:09:17 +0000
committerErik Johnston <erik@matrix.org>2016-03-11 15:09:17 +0000
commitc08122843982307dad8d099784bc1a4bc0202eae (patch)
treecd7a314ad38d0512fc18b45b5abc4ea35fc5df75
parentMerge pull request #641 from matrix-org/dbkr/fix_change_password (diff)
downloadsynapse-c08122843982307dad8d099784bc1a4bc0202eae.tar.xz
Fix SQL statement
-rw-r--r--synapse/storage/registration.py2
1 files changed, 1 insertions, 1 deletions
diff --git a/synapse/storage/registration.py b/synapse/storage/registration.py
index 5d45f0c651..5e7a4e371d 100644
--- a/synapse/storage/registration.py
+++ b/synapse/storage/registration.py
@@ -199,7 +199,7 @@ class RegistrationStore(SQLBaseStore):
         def f(txn):
             txn.execute(
                 "SELECT id, token FROM access_tokens "
-                "WHERE user_id = ? AND id not in LIMIT 50",
+                "WHERE user_id = ? AND id NOT IN ? LIMIT 50",
                 (user_id, except_token_ids)
             )
             rows = txn.fetchall()