3 files changed, 2 insertions, 3 deletions
diff --git a/bin/fixmystreet.com/import-categories b/bin/fixmystreet.com/import-categories
index e9008b93f..fe4c2e027 100755
--- a/bin/fixmystreet.com/import-categories
+++ b/bin/fixmystreet.com/import-categories
@@ -70,7 +70,7 @@ sub add_categories {
         dbh()->do("insert into contacts
             (area_id, category, email, editor, whenedited, note, confirmed, deleted)
             values
-            (?, ?, ?, 'import', ms_current_timestamp(), 'Initial copy', ?, 'f')", {},
+            (?, ?, ?, 'import', current_timestamp, 'Initial copy', ?, 'f')", {},
             $id, $_, $email, ($confirmed ? 1 : 0)
         );
     }
diff --git a/bin/fixmystreet.com/load-contacts b/bin/fixmystreet.com/load-contacts
index b18699db1..78bb77e8f 100755
--- a/bin/fixmystreet.com/load-contacts
+++ b/bin/fixmystreet.com/load-contacts
@@ -42,7 +42,7 @@ while (<FP>) {
     s/\r?\n//g;
     my ($id, $email) = split /,/;
     dbh()->do("INSERT INTO contacts (area_id, email, editor, whenedited, note)
-        VALUES (?, ?, 'import', ms_current_timestamp(), 'Initial import')",
+        VALUES (?, ?, 'import', current_timestamp, 'Initial import')",
         {}, $id, $email);
 }
 dbh()->commit();
diff --git a/bin/fixmystreet.com/showcouncilrates b/bin/fixmystreet.com/showcouncilrates
index 1dacae597..a3465c575 100755
--- a/bin/fixmystreet.com/showcouncilrates
+++ b/bin/fixmystreet.com/showcouncilrates
@@ -38,7 +38,6 @@ my $stats = dbh()->selectall_arrayref($query, { Slice => {} });
 my @councils;
 foreach my $row (@$stats) {
     if ($row->{council}) {
-        $row->{council} =~ s/\|.*//g;
         my @council_ids = split(/,/, $row->{council});
         push(@councils, @council_ids);
         $row->{council} = \@council_ids;