From d4391cc6c5d249e1b61bdc49b9e5947176ebe628 Mon Sep 17 00:00:00 2001
From: jesopo
Date: Mon, 17 Jun 2019 17:51:27 +0100
Subject: Fix Database.ChannelSettings.find SQL

---
 src/Database.py | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'src')

diff --git a/src/Database.py b/src/Database.py
index f25921fb..6a5a4d58 100644
--- a/src/Database.py
+++ b/src/Database.py
@@ -146,7 +146,7 @@ class ChannelSettings(Table):
     def find(self, channel_id: int, pattern: str, default: typing.Any=[]):
         values = self.database.execute_fetchall(
             """SELECT setting, value FROM channel_settings WHERE
-            channel_id=? setting LIKE '?'""", [channel_id, pattern.lower()])
+            channel_id=? AND setting LIKE ?""", [channel_id, pattern.lower()])
         if values:
             for i, value in enumerate(values):
                 values[i] = value[0], json.loads(value[1])
-- 
cgit v1.3.1-10-gc9f91