diff options
author | Matthew Somerville <matthew@dracos.co.uk> | 2011-02-19 11:31:03 +0000 |
---|---|---|
committer | Matthew Somerville <matthew@dracos.co.uk> | 2011-02-19 11:31:03 +0000 |
commit | 733ed07f2a5dba4e121949341a9ecfd75413037a (patch) | |
tree | 8c9ed1fb4418e82d0e37017495ecb6a7e9e12bda /perllib/FixMyStreet/Alert.pm | |
parent | d8f3d08b2e1bd840cbbe6424c531dbd38403e0f1 (diff) |
Fix cron trying to run over rows it doesn't understand, URL escaping, capitalisation of street names, and tabs.
Diffstat (limited to 'perllib/FixMyStreet/Alert.pm')
-rw-r--r-- | perllib/FixMyStreet/Alert.pm | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/perllib/FixMyStreet/Alert.pm b/perllib/FixMyStreet/Alert.pm index 4a6e63564..6b50e62e6 100644 --- a/perllib/FixMyStreet/Alert.pm +++ b/perllib/FixMyStreet/Alert.pm @@ -90,7 +90,7 @@ sub delete ($) { sub email_alerts ($) { my ($testing_email) = @_; my $url; - my $q = dbh()->prepare("select * from alert_type where ref not like 'local_problems%'"); + my $q = dbh()->prepare("select * from alert_type where ref not like '%local_problems%'"); $q->execute(); my $testing_email_clause = ''; while (my $alert_type = $q->fetchrow_hashref) { |