[pmg-devel] [PATCH pmg-api 2/2] statistics: fix update virusinfo
Dominik Csapak
d.csapak at proxmox.com
Thu Jun 29 16:14:38 CEST 2023
by adding the missing closing parenthesis
Fixes: 9972a7c ("postgresql compat: cast result from EXTRACT to INTEGER")
Signed-off-by: Dominik Csapak <d.csapak at proxmox.com>
---
src/PMG/Statistic.pm | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/src/PMG/Statistic.pm b/src/PMG/Statistic.pm
index 950dbc2..e0dea5e 100644
--- a/src/PMG/Statistic.pm
+++ b/src/PMG/Statistic.pm
@@ -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 ";
--
2.30.2
More information about the pmg-devel
mailing list