Sql query error in dashboard web monitoring widget.

XMLWordPrintable

    • Type: Incident report
    • Resolution: Won't fix
    • Priority: Major
    • None
    • Affects Version/s: 2.1.0
    • Component/s: Frontend (F)
    • None

      Error in query [SELECT DISTINCT g.groupid,g.name FROM groups g,hosts_groups hg WHERE 1=0 AND g.groupid=hg.groupid AND EXISTS (SELECT NULL FROM hosts h WHERE hg.hostid=h.hostid AND h.status=0) AND EXISTS (SELECT NULL FROM httptest ht WHERE hg.hostid=ht.hostid AND ht.status=0)] [Unknown column 'ht.hostid' in 'where clause']
      mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [db.inc.php:573]
      mysql_free_result() expects parameter 1 to be resource, boolean given [db.inc.php:574]

            Assignee:
            Unassigned
            Reporter:
            Eduards Samersovs (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: