Re: [pmg-devel] [PATCH pmg-api 2/2] statistics: fix update virusinfo

Re: [pmg-devel] [PATCH pmg-api 2/2] statistics: fix update virusinfo

[Stoiko Ivanov]

Hi,

Thanks for putting an effort to contribute to Proxmox Mail Gateway!
Very much appreciated!

The patch you sent did not arrive at our mailing-list - maybe a glitch
with git send-email?

See our developer documentation for how to send patches:
https://pmg.proxmox.com/wiki/index.php/Developer_Documentation

Additionally we would need a signed copy of the Harmony CLA, sent to
office@proxmox.com:
https://pmg.proxmox.com/wiki/index.php/Developer_Documentation#Software_License_and_Copyright

It would help the workflow quite a lot if you'd subscribe to the pmg-devel
mailing list, as else all your mails need to get approved by an
list-administrator, and you might miss replies someone sends to the list:
https://lists.proxmox.com/cgi-bin/mailman/listinfo/pmg-devel

Thanks,
stoiko

On Fri, 7 Jun 2024 01:17:59 -0500
Tony Collins <tonylee6102@gmail.com> wrote:

> 


_______________________________________________
pmg-devel mailing list
pmg-devel@lists.proxmox.com
https://lists.proxmox.com/cgi-bin/mailman/listinfo/pmg-devel

[pmg-devel] [PATCH pmg-api 2/2] statistics: fix update virusinfo

[Dominik Csapak]

by adding the missing closing parenthesis

Fixes: 9972a7c ("postgresql compat: cast result from EXTRACT to INTEGER")
Signed-off-by: Dominik Csapak <d.csapak@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