Public bug reported: The Zabbix 2.4 is installed from standard Ubuntu repositories, on top of MariaDB.
1) The release of Ubuntu you are using, via 'lsb_release -rd' or System -> About Ubuntu Ubuntu 16.04.1 LTS 2) The version of the package you are using, via 'apt-cache policy pkgname' or by checking in Software Center zabbix-frontend-php: Installed: 1:2.4.7+dfsg-2ubuntu2 Candidate: 1:2.4.7+dfsg-2ubuntu2 Version table: *** 1:2.4.7+dfsg-2ubuntu2 500 500 http://fi.archive.ubuntu.com/ubuntu xenial/universe amd64 Packages 500 http://fi.archive.ubuntu.com/ubuntu xenial/universe i386 Packages 100 /var/lib/dpkg/status mariadb-server-10.0: Installed: 10.0.25-0ubuntu0.16.04.1 Candidate: 10.0.25-0ubuntu0.16.04.1 Version table: *** 10.0.25-0ubuntu0.16.04.1 500 500 http://fi.archive.ubuntu.com/ubuntu xenial-updates/universe amd64 Packages 500 http://security.ubuntu.com/ubuntu xenial-security/universe amd64 Packages 100 /var/lib/dpkg/status 10.0.24-7 500 500 http://fi.archive.ubuntu.com/ubuntu xenial/universe amd64 Packages php-mysql: Installed: 1:7.0+35ubuntu6 Candidate: 1:7.0+35ubuntu6 Version table: *** 1:7.0+35ubuntu6 500 500 http://fi.archive.ubuntu.com/ubuntu xenial/main amd64 Packages 500 http://fi.archive.ubuntu.com/ubuntu xenial/main i386 Packages 100 /var/lib/dpkg/status 3) What you expected to happen Just the normal Zabbix front-end operation. 4) What happened instead Following errors are printed on Zabbix dashboard. However, they don't seem to prohibit the "normal" operation of Zabbix i.e. showing data on screens, using of triggers etc. ---8<---8<--- 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] ---8<---8<--- ProblemType: Bug DistroRelease: Ubuntu 16.04 Package: zabbix-frontend-php 1:2.4.7+dfsg-2ubuntu2 [modified: usr/share/zabbix/include/classes/api/wrappers/CApiWrapper.php usr/share/zabbix/include/classes/setup/CFrontendSetup.php] ProcVersionSignature: Ubuntu 4.4.0-34.53-generic 4.4.15 Uname: Linux 4.4.0-34-generic x86_64 ApportVersion: 2.20.1-0ubuntu2.1 Architecture: amd64 Date: Fri Sep 2 09:02:03 2016 PackageArchitecture: all SourcePackage: zabbix UpgradeStatus: No upgrade log present (probably fresh install) modified.conffile..etc.apache2.conf-available.zabbix-frontend-php.conf: [modified] mtime.conffile..etc.apache2.conf-available.zabbix-frontend-php.conf: 2016-09-02T08:38:09.435278 ** Affects: zabbix (Ubuntu) Importance: Undecided Status: New ** Tags: amd64 apport-bug xenial -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1619546 Title: PHP and SQL errors on Zabbix dashboard To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/zabbix/+bug/1619546/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs