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
