diff options
| -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') { |