diff options
| author | Matthew Somerville <matthew@mysociety.org> | 2011-06-12 23:07:19 +0100 |
|---|---|---|
| committer | Matthew Somerville <matthew@mysociety.org> | 2011-06-12 23:07:19 +0100 |
| commit | dee9dc7f7456a304cd351de2d10fe2979455f691 (patch) | |
| tree | 3160e72cd146b8dad61443f4cdc0db42ee890965 | |
| parent | 436274a1b69c5d25488492ecd70e4b4bee204cc1 (diff) | |
If in location where no details, don't store council ID. Fix small schema issue.
| -rw-r--r-- | db/schema_0004-create_users_from_comments_and_link.sql | 2 | ||||
| -rw-r--r-- | perllib/FixMyStreet/App/Controller/Report/New.pm | 4 |
2 files changed, 3 insertions, 3 deletions
diff --git a/db/schema_0004-create_users_from_comments_and_link.sql b/db/schema_0004-create_users_from_comments_and_link.sql index 0e4e2b5f2..6343aec58 100644 --- a/db/schema_0004-create_users_from_comments_and_link.sql +++ b/db/schema_0004-create_users_from_comments_and_link.sql @@ -26,7 +26,7 @@ UPDATE users order by created desc limit 1 ) -WHERE users.name = ''; +WHERE users.name IS NULL; -- set up the anonymous flag ALTER table comment diff --git a/perllib/FixMyStreet/App/Controller/Report/New.pm b/perllib/FixMyStreet/App/Controller/Report/New.pm index 375b36a51..cb6ac670e 100644 --- a/perllib/FixMyStreet/App/Controller/Report/New.pm +++ b/perllib/FixMyStreet/App/Controller/Report/New.pm @@ -628,8 +628,8 @@ sub process_report : Private { if ( $c->cobrand->moniker eq 'emptyhomes' ) { - # all councils have all categories for emptyhomes - $report->council( join( ',', keys %$councils) ); + $councils = join( ',', @{ $c->stash->{area_ids_to_list} } ) || -1; + $report->council( $councils ); } elsif ( $first_council->{type} eq 'LBO') { |