X-Git-Url: https://git.madduck.net/etc/mailfilter.git/blobdiff_plain/61c4c56942148ccabf01dcfee8c71d3564786a61..c0bd106b31e7ceddac35cced23cb32989ac7c8e1:/procmail/record-delayed-mail

diff --git a/procmail/record-delayed-mail b/procmail/record-delayed-mail
index 72ff6b8..c8256e1 100644
--- a/procmail/record-delayed-mail
+++ b/procmail/record-delayed-mail
@@ -8,10 +8,9 @@ DO_QUERY="$SQLITE $DELAYED_QUEUE_DB"
 DATA="$MSGID"
 INCLUDERC=$PMDIR/sql-escape
 
-QUERY="insert into messages values ($DATA, '\\'\$DESTFILE\\'', $RELEASE_TS);
-       select * from messages where msgid = $DATA"
-TRAP="$TRAP; case \"$($DO_QUERY '$QUERY')\" in '') 
-      echo 'delay:       failed to insert reference into database';; esac"
+QUERY="insert into messages values ($DATA, '\$DESTFILE', $RELEASE_TS);"
+TRAP="$TRAP; OUT=\"$(echo \"$QUERY\" | $DO_QUERY 2>&1)\";
+      [ -n \"\$OUT\" ] && echo \"delay:       failed register delayed mail in database: \$OUT\""
 
 QUERY
 DATA