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

Errors in SQL query in db.inc.php with MariaDB

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Won't fix
    • Icon: Trivial Trivial
    • None
    • 2.4.8
    • Frontend (F)
    • Ubuntu 16.04.1 LTS (64bit) with following:
      PHP 7.0.8
      MariaDB 10.0.25
      Zabbix 2.4.7
      Zabbix-frontend-php 2.4.7

      NOTE - Ubuntu 16.04.01 does not seem to have the standard 2.4.8 version, instead it has the 2.4.7 version.

      Following error message is given in dashboard:

      Illegal offset type [dashboard.php:145 ? make_latest_issues() ? CApiWrapper->__call() ? CFrontendApiWrapper->callMethod() ? CApiWrapper->callMethod() ? CFrontendApiWrapper->callClientMethod() ? CLocalApiClient->callMethod() ? CScript->getScriptsByHosts() in /usr/share/zabbix/include/classes/api/services/CScript.php:322]
      array_flip(): Can only flip STRING and INTEGER values! [dashboard.php:145 ? make_latest_issues() ? CApiWrapper->__call() ? CFrontendApiWrapper->callMethod() ? CApiWrapper->callMethod() ? CFrontendApiWrapper->callClientMethod() ? CLocalApiClient->callMethod() ? CScript->getScriptsByHosts() ? CScript->get() ? CHostGroup->get() ? dbConditionInt() ? array_flip() in /usr/share/zabbix/include/db.inc.php:861]
      Error in query [SELECT DISTINCT g.groupid FROM groups g,hosts_groups hg WHERE AND hg.groupid=g.groupid] [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND hg.groupid=g.groupid' at line 1]
      array_flip(): Can only flip STRING and INTEGER values! [dashboard.php:145 ? make_latest_issues() ? CApiWrapper->__call() ? CFrontendApiWrapper->callMethod() ? CApiWrapper->callMethod() ? CFrontendApiWrapper->callClientMethod() ? CLocalApiClient->callMethod() ? CScript->getScriptsByHosts() ? CScript->get() ? CScript->addRelatedObjects() ? CHost->get() ? dbConditionInt() ? array_flip() in /usr/share/zabbix/include/db.inc.php:861]
      Error in query [SELECT h.hostid FROM hosts h WHERE h.flags IN (0,4) AND AND h.status IN (0,1)] [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND h.status IN (0,1)' at line 1]

            Unassigned Unassigned
            tuulos Kalle Tuulos
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: