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
          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

            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: