From 77e06435788e7bcb6e5c7cc60ea07dfc7bdb5852 Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Fri, 20 Apr 2018 10:35:05 +0200
Subject: bin/interpret-mail: fix mysql queries

---
 bin/interpret-mail | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

(limited to 'bin/interpret-mail')

diff --git a/bin/interpret-mail b/bin/interpret-mail
index 85e81b7..65528b4 100755
--- a/bin/interpret-mail
+++ b/bin/interpret-mail
@@ -123,7 +123,7 @@ if ! hashcash -qXc -b 20 \
   # shellcheck disable=SC2016
   {
     printf 'INSERT INTO `email_log` (`success`,`comment`)'
-    printf ' VALUES 0,"Invalid stamp - ignoring this message.";\n'
+    printf ' VALUES (0,"Invalid stamp - ignoring this message.");\n'
   } | \
     mysql_run_query
   exit
@@ -143,7 +143,7 @@ if ! sed -n '
   # shellcheck disable=SC2016
   {
     printf 'INSERT INTO `email_log` (`success`,`comment`)'
-    printf ' VALUES 0,from_base64("%s");\n' \
+    printf ' VALUES (0,from_base64("%s"));\n' \
       "$(
         {
           printf 'Invalid encryption/signature - ignoring this message.\n'
@@ -183,7 +183,7 @@ if [ -z "${gpg_keys_filter}" ]; then
   # shellcheck disable=SC2016
   {
     printf 'INSERT INTO `email_log` (`success`,`comment`)'
-    printf ' VALUES 0,from_base64("%s");\n' \
+    printf ' VALUES (0,from_base64("%s"));\n' \
       "$(
         {
           printf 'No known signature found - I found:\n'
-- 
cgit v1.2.3