From b0c313a027aa931fc47cc905bb009fa90dfb1b0c Mon Sep 17 00:00:00 2001
From: Struan Donald <struan@exo.org.uk>
Date: Mon, 30 Apr 2012 18:57:58 +0100
Subject: specify which table we want for fields

---
 bin/send-comments | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'bin/send-comments')

diff --git a/bin/send-comments b/bin/send-comments
index 1bd68e916..0fb3a75b9 100755
--- a/bin/send-comments
+++ b/bin/send-comments
@@ -44,8 +44,8 @@ while ( my $council = $councils->next ) {
     my $comments = FixMyStreet::App->model('DB::Comment')->search( {
             'me.whensent'    => undef,
             'me.external_id' => undef,
-            'state'          => 'confirmed',
-            'confirmed'      => { '!=' => undef },
+            'me.state'          => 'confirmed',
+            'me.confirmed'      => { '!=' => undef },
             'problem.whensent'    => { '!=' => undef },
             'problem.external_id'  => { '!=' => undef },
             'problem.council'      => { -like => '%' . $council->area_id .'%' },
-- 
cgit v1.2.3