From: Ian Jackson Date: Wed, 19 Aug 2009 22:44:23 +0000 (+0100) Subject: Actually add unrecognised commodities in email processor X-Git-Tag: 3.2~1 X-Git-Url: http://www.chiark.greenend.org.uk/ucgi/~yarrgweb/git?p=ypp-sc-tools.web-live.git;a=commitdiff_plain;h=e722e7f00fbf26f0c310ae84a5a3b1b0f8b4ed39;hp=01c14767c024ac56686dbbfcd88d9f3a0b4b1574 Actually add unrecognised commodities in email processor --- diff --git a/yarrg/commod-email-processor b/yarrg/commod-email-processor index 79db83d..3f802ad 100755 --- a/yarrg/commod-email-processor +++ b/yarrg/commod-email-processor @@ -134,7 +134,7 @@ sub main () { "SELECT stallid FROM stalls WHERE islandid == $islandid AND stallname == ? "); - $sth_insert{'commods'}= $dbh->prepare( + $sth_insert{'commod'}= $dbh->prepare( "INSERT OR IGNORE INTO commods (commodname) VALUES (?)