aboutsummaryrefslogtreecommitdiffstats
path: root/perllib/FixMyStreet/Alert.pm
diff options
context:
space:
mode:
authorMatthew Somerville <matthew@dracos.co.uk>2011-02-19 11:31:03 +0000
committerMatthew Somerville <matthew@dracos.co.uk>2011-02-19 11:31:03 +0000
commit733ed07f2a5dba4e121949341a9ecfd75413037a (patch)
tree8c9ed1fb4418e82d0e37017495ecb6a7e9e12bda /perllib/FixMyStreet/Alert.pm
parentd8f3d08b2e1bd840cbbe6424c531dbd38403e0f1 (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.pm2
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) {