count_daily_users failed if db was sqlite due to type failure - presumably this prevcented all sqlite homeservers reporting home

1 files changed, 1 insertions, 1 deletions

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

index de00cae447..b97e5e5ff4 100644
--- a/synapse/storage/__init__.py
+++ b/synapse/storage/__init__.py
@@ -260,7 +260,7 @@ class DataStore(RoomMemberStore, RoomStore,
                 ) u
             """
 
-            txn.execute(sql, (yesterday,))
+            txn.execute(sql, (str(yesterday),))
             count, = txn.fetchone()
             return count