Details

    • Team:
      Team D
    • Sprint:
      Sprint 55 (Aug 2019)
    • Story Points:
      0.125

      Description

      Hi, on the zabbix webUI interface, when I go to IT services and click on a HostTrigger, I get errors for all services:

      Error in query [SELECT sa.serviceid,sa.value FROM (SELECT sa2.serviceid,MAX(sa2.servicealarmid) AS servicealarmid FROM service_alarms sa2 WHERE sa2.clock<'1546210800' AND sa2.serviceid=570GROUP BY sa2.serviceid) ss2 JOIN service_alarms sa ON sa.servicealarmid = ss2.servicealarmid] [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BY sa2.serviceid) ss2 JOIN service_alarms sa ON sa.servicealarmid = ss2.service' at line 1]
      

       Thank you in advance.

        Attachments

        1. Capture.PNG
          Capture.PNG
          130 kB
        2. SSH1.jpg
          SSH1.jpg
          91 kB
        3. SSH2.jpg
          SSH2.jpg
          65 kB
        4. SSH3.jpg
          SSH3.jpg
          39 kB
        5. SSH4.jpg
          SSH4.jpg
          97 kB
        6. SSH5.jpg
          SSH5.jpg
          468 kB

          Activity

            People

            • Assignee:
              agriscenko Andrejs Griščenko
              Reporter:
              romain.si159 Romain SICAUD
            • Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: