update whensent when a comment is succesfully sent

1 files changed, 4 insertions, 2 deletions

diff --git a/bin/send-comments b/bin/send-comments
index 70289e9b1..dd60f8451 100755
--- a/bin/send-comments
+++ b/bin/send-comments
@@ -68,8 +68,10 @@ while ( my $council = $councils->next ) {
         my $id = $o->post_service_request_update( $comment );
 
         if ( $id ) {
-            $comment->external_id( $id );
-            $comment->update();
+            $comment->update( {
+                external_id => $id,
+                whensent    => \'ms_current_timestamp()',
+            } );
         } else {
             $comment->update( {
                 send_fail_count => $comment->send_fail_count + 1,