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 /perllib/FixMyStreet/DB/ResultSet/Problem.pm | |
| 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 'perllib/FixMyStreet/DB/ResultSet/Problem.pm')
| -rw-r--r-- | perllib/FixMyStreet/DB/ResultSet/Problem.pm | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/perllib/FixMyStreet/DB/ResultSet/Problem.pm b/perllib/FixMyStreet/DB/ResultSet/Problem.pm index 7885c28b3..611c1582e 100644 --- a/perllib/FixMyStreet/DB/ResultSet/Problem.pm +++ b/perllib/FixMyStreet/DB/ResultSet/Problem.pm @@ -168,9 +168,9 @@ sub timeline { return $rs->search( { -or => { - created => { '>=', \"ms_current_timestamp()-'7 days'::interval" }, - confirmed => { '>=', \"ms_current_timestamp()-'7 days'::interval" }, - whensent => { '>=', \"ms_current_timestamp()-'7 days'::interval" }, + created => { '>=', \"current_timestamp-'7 days'::interval" }, + confirmed => { '>=', \"current_timestamp-'7 days'::interval" }, + whensent => { '>=', \"current_timestamp-'7 days'::interval" }, } }, { @@ -433,8 +433,8 @@ sub send_reports { unless ($result) { $row->update( { - whensent => \'ms_current_timestamp()', - lastupdate => \'ms_current_timestamp()', + whensent => \'current_timestamp', + lastupdate => \'current_timestamp', } ); if ( $cobrand->report_sent_confirmation_email && !$h{anonymous_report}) { _send_report_sent_email( $row, \%h, $nomail, $cobrand ); |