From 77e06435788e7bcb6e5c7cc60ea07dfc7bdb5852 Mon Sep 17 00:00:00 2001 From: Erich Eckner 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(-) 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-70-g09d2