diff options
| author | Struan Donald <struan@exo.org.uk> | 2012-04-30 18:57:58 +0100 |
|---|---|---|
| committer | Struan Donald <struan@exo.org.uk> | 2012-04-30 18:57:58 +0100 |
| commit | b0c313a027aa931fc47cc905bb009fa90dfb1b0c (patch) | |
| tree | 4f2b448ac6c796cdaf1f68b8d38e54327c902ef0 /bin | |
| parent | ece5fb35819f90b608766ce5677a5134951b7545 (diff) | |
specify which table we want for fields
Diffstat (limited to 'bin')
| -rwxr-xr-x | bin/send-comments | 4 |
1 files changed, 2 insertions, 2 deletions
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 .'%' }, |