2 files changed, 2 insertions, 21 deletions
diff --git a/perllib/FixMyStreet/App/Controller/Contact.pm b/perllib/FixMyStreet/App/Controller/Contact.pm
index 3f282f0dc..a3e397022 100644
--- a/perllib/FixMyStreet/App/Controller/Contact.pm
+++ b/perllib/FixMyStreet/App/Controller/Contact.pm
@@ -70,11 +70,7 @@ sub determine_contact_type : Private {
                 'select' => [
                     'title', 'detail', 'name',
                     'anonymous',
-                    'user_id',
-                    {
-                        extract => 'epoch from confirmed',
-                        -as     => 'confirmed'
-                    }
+                    'user_id', 'confirmed',
                 ]
             }
         );
diff --git a/perllib/FixMyStreet/App/Controller/Report.pm b/perllib/FixMyStreet/App/Controller/Report.pm
index 8fd94dfba..3a915b0a0 100644
--- a/perllib/FixMyStreet/App/Controller/Report.pm
+++ b/perllib/FixMyStreet/App/Controller/Report.pm
@@ -94,22 +94,7 @@ sub load_problem_or_display_error : Private {
 
     my $updates = $c->model('DB::Comment')->search(
         { problem_id => $problem->id, state => 'confirmed' },
-        {
-            select => [
-                'id', 'name', 'text',
-                'user_id',
-                'anonymous',
-                'mark_fixed',
-                'mark_open',
-                'photo',
-                'cobrand',
-                {
-                    extract => 'epoch from confirmed',
-                    -as     => 'confirmed',
-                }
-            ],
-            order_by => 'confirmed',
-        }
+        { order_by => 'confirmed' }
     );
 
     $c->stash->{updates} = $updates;