diff options
author | Matthew Somerville <matthew-github@dracos.co.uk> | 2015-08-13 12:21:20 +0100 |
---|---|---|
committer | Matthew Somerville <matthew@mysociety.org> | 2015-08-13 13:38:14 +0100 |
commit | ef3a3a789e8f91b62dc562ff69781dc0daa80871 (patch) | |
tree | 6045ce7399229bfcb2eca4090f1707d6fc79830b /bin/fixmystreet.com | |
parent | 864fcb6a81b17ec6324598973ff29dd734a7baf8 (diff) |
Remove ms_current_timestamp() override function.
This override is not used anywhere, it dates from a very old long-gone
test script, and causes issues with database query planning.
Diffstat (limited to 'bin/fixmystreet.com')
-rwxr-xr-x | bin/fixmystreet.com/import-categories | 2 | ||||
-rwxr-xr-x | bin/fixmystreet.com/load-contacts | 2 |
2 files changed, 2 insertions, 2 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(); |