summary refs log tree commit diff
diff options
context:
space:
mode:
authorNeil Johnson <neil@fragile.org.uk>2018-04-09 17:50:36 +0100
committerNeil Johnson <neil@fragile.org.uk>2018-04-09 17:50:36 +0100
commit64bc2162ef1c51cf5d5baa3cd3b303216b55df8c (patch)
treec349fd05a2f3e579c4f7e362a24530e9efabe2cf
parentversion bump v0.27.3-rc2 (diff)
downloadsynapse-64bc2162ef1c51cf5d5baa3cd3b303216b55df8c.tar.xz
Fix psycopg2 interpolation
-rw-r--r--synapse/storage/__init__.py10
1 files changed, 5 insertions, 5 deletions
diff --git a/synapse/storage/__init__.py b/synapse/storage/__init__.py
index 4800584b59..01c580b66e 100644
--- a/synapse/storage/__init__.py
+++ b/synapse/storage/__init__.py
@@ -289,11 +289,11 @@ class DataStore(RoomMemberStore, RoomStore,
                          user_id,
                          last_seen,
                          CASE
-                             WHEN user_agent LIKE '%Android%' THEN 'android'
-                             WHEN user_agent LIKE '%iOS%' THEN 'ios'
-                             WHEN user_agent LIKE '%Electron%' THEN 'electron'
-                             WHEN user_agent LIKE '%Mozilla%' THEN 'web'
-                             WHEN user_agent LIKE '%Gecko%' THEN 'web'
+                             WHEN user_agent LIKE '%%Android%%' THEN 'android'
+                             WHEN user_agent LIKE '%%iOS%%' THEN 'ios'
+                             WHEN user_agent LIKE '%%Electron%%' THEN 'electron'
+                             WHEN user_agent LIKE '%%Mozilla%%' THEN 'web'
+                             WHEN user_agent LIKE '%%Gecko%%' THEN 'web'
                              ELSE 'unknown'
                          END
                          AS platform