]> git.proxmox.com Git - pmg-api.git/commitdiff
statistics: fix update virusinfo
authorDominik Csapak <d.csapak@proxmox.com>
Fri, 30 Jun 2023 08:27:48 +0000 (10:27 +0200)
committerStoiko Ivanov <s.ivanov@proxmox.com>
Fri, 30 Jun 2023 12:21:22 +0000 (14:21 +0200)
by moving the closing parenthesis to the correct place

Fixes: 9972a7c ("postgresql compat: cast result from EXTRACT to INTEGER")
Signed-off-by: Dominik Csapak <d.csapak@proxmox.com>
src/PMG/Statistic.pm

index 950dbc2cc813ec891a2551d1751468c835623cef..ef4f5bac1ffe0234665020cd69b73e63d838e18a 100644 (file)
@@ -342,7 +342,7 @@ sub update_stats_virusinfo  {
        my $sql = '';
 
        push @values, "Count = Count + $ref->{count}" if $ref->{count};
-       push @values, "MTime = EXTRACT(EPOCH FROM now()::INTEGER)";
+       push @values, "MTime = EXTRACT(EPOCH FROM now())::INTEGER";
 
        if (scalar (@values)) {
            $sql .= "UPDATE VirusInfo SET ";