[pkg-nagios-changes] [Git][nagios-team/pkg-icingaweb2][master] 2 commits: Add patch to fix Event Grid SQLSTATE error.

[Bas Couwenberg (@sebastic)]

Bas Couwenberg pushed to branch master at Debian Nagios Maintainer Group / pkg-icingaweb2


Commits:
0a2b2e8b by Bas Couwenberg at 2022-07-01T20:24:05+02:00
Add patch to fix Event Grid SQLSTATE error.

- - - - -
c5476b0e by Bas Couwenberg at 2022-07-01T20:29:20+02:00
Set distribution to unstable.

- - - - -


3 changed files:

- debian/changelog
- + debian/patches/0001-Fix-Event-Grid-SQLSTATE-error.patch
- + debian/patches/series


Changes:

=====================================
debian/changelog
=====================================
@@ -1,3 +1,10 @@
+icingaweb2 (2.11.0-2) unstable; urgency=medium
+
+  * Team upload.
+  * Add patch to fix Event Grid SQLSTATE error.
+
+ -- Bas Couwenberg <sebastic at debian.org>  Fri, 01 Jul 2022 20:24:08 +0200
+
 icingaweb2 (2.11.0-1) unstable; urgency=medium
 
   * Team upload.


=====================================
debian/patches/0001-Fix-Event-Grid-SQLSTATE-error.patch
=====================================
@@ -0,0 +1,25 @@
+Description: Fix Event Grid SQLSTATE error.
+Author: Bas Couwenberg <sebastic at xs4all.nl>
+Bug: https://github.com/Icinga/icingaweb2/issues/4852
+Forwarded: https://github.com/Icinga/icingaweb2/pull/4855
+
+--- a/modules/monitoring/library/Monitoring/Backend/Ido/Query/EventgridQuery.php
++++ b/modules/monitoring/library/Monitoring/Backend/Ido/Query/EventgridQuery.php
+@@ -11,7 +11,7 @@ abstract class EventgridQuery extends St
+      * @var array
+      */
+     protected $additionalColumns = array(
+-        'day'                   => 'DATE(FROM_UNIXTIME(sth.timestamp))',
++        'day'                   => 'DATE(sth.timestamp)',
+         'cnt_up'                => "SUM(CASE WHEN sth.state = 0 THEN 1 ELSE 0 END)",
+         'cnt_down_hard'         => "SUM(CASE WHEN sth.state = 1 AND sth.type = 'hard_state' THEN 1 ELSE 0 END)",
+         'cnt_down'              => "SUM(CASE WHEN sth.state = 1 THEN 1 ELSE 0 END)",
+@@ -35,7 +35,7 @@ abstract class EventgridQuery extends St
+         parent::joinBaseTables();
+         $this->requireVirtualTable('history');
+         $this->columnMap['statehistory'] += $this->additionalColumns;
+-        $this->select->group(array('DATE(FROM_UNIXTIME(sth.timestamp))'));
++        $this->select->group(array('DATE(sth.timestamp)'));
+     }
+ 
+     /**


=====================================
debian/patches/series
=====================================
@@ -0,0 +1 @@
+0001-Fix-Event-Grid-SQLSTATE-error.patch



View it on GitLab: https://salsa.debian.org/nagios-team/pkg-icingaweb2/-/compare/161a6cb91ff638a0fac982bba6a2405676d3f12a...c5476b0e3de9ec86aa5b256061b9abdc365319bc

-- 
View it on GitLab: https://salsa.debian.org/nagios-team/pkg-icingaweb2/-/compare/161a6cb91ff638a0fac982bba6a2405676d3f12a...c5476b0e3de9ec86aa5b256061b9abdc365319bc
You're receiving this email because of your account on salsa.debian.org.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://alioth-lists.debian.net/pipermail/pkg-nagios-changes/attachments/20220701/4fe870a2/attachment-0001.htm>