Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-16462

Services IT : Error in query

XMLWordPrintable

    • Sprint 55 (Aug 2019)
    • 0.125

      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.

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

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

              Created:
              Updated:
              Resolved: