[ZBX-10139] PHP and SQL errors on the dashboard and screens Created: 2015 Dec 07  Updated: 2017 May 30  Resolved: 2015 Dec 10

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 3.0.0alpha4
Fix Version/s: 3.0.0alpha5

Type: Incident report Priority: Major
Reporter: Alexander Vladishev Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: dashboard, errors, undefinedindex, undefinedvariable
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

Dashboard -> System status

Undefined variable: item [zabbix.php:21 ? require_once() ? ZBase->run() ? ZBase->processRequest() ? CView->getOutput() ? include() ? make_system_status() ? makeTriggersPopup() ? CMacrosResolverHelper::resolveTriggerNames() ? CMacrosResolver->resolveTriggerNames() ? CMacrosResolverGeneral->getItemMacros() in include/classes/macros/CMacrosResolverGeneral.php:680]
Argument 2 passed to CMacrosResolverGeneral::getItemLastValueMacro() must be of the type array, null given, called in include/classes/macros/CMacrosResolverGeneral.php on line 680 and defined [zabbix.php:21 ? require_once() ? ZBase->run() ? ZBase->processRequest() ? CView->getOutput() ? include() ? make_system_status() ? makeTriggersPopup() ? CMacrosResolverHelper::resolveTriggerNames() ? CMacrosResolver->resolveTriggerNames() ? CMacrosResolverGeneral->getItemMacros() ? CMacrosResolverGeneral->getItemLastValueMacro() in include/classes/macros/CMacrosResolverGeneral.php:563]
Argument 2 passed to formatHistoryValue() must be of the type array, null given, called in include/classes/macros/CMacrosResolverGeneral.php on line 564 and defined [zabbix.php:21 ? require_once() ? ZBase->run() ? ZBase->processRequest() ? CView->getOutput() ? include() ? make_system_status() ? makeTriggersPopup() ? CMacrosResolverHelper::resolveTriggerNames() ? CMacrosResolver->resolveTriggerNames() ? CMacrosResolverGeneral->getItemMacros() ? CMacrosResolverGeneral->getItemLastValueMacro() ? formatHistoryValue() in include/items.inc.php:873]

Dashboard -> Last 20 issues

Undefined variable: item [zabbix.php:21 ? require_once() ? ZBase->run() ? ZBase->processRequest() ? CView->getOutput() ? include() ? make_latest_issues() ? CMacrosResolverHelper::resolveEventDescription() ? CMacrosResolver->resolveTriggerNames() ? CMacrosResolverGeneral->getItemMacros() in include/classes/macros/CMacrosResolverGeneral.php:673]
Undefined index: [zabbix.php:21 ? require_once() ? ZBase->run() ? ZBase->processRequest() ? CView->getOutput() ? include() ? make_latest_issues() ? CMacrosResolverHelper::resolveEventDescription() ? CMacrosResolver->resolveTriggerNames() ? CMacrosResolverGeneral->getItemMacros() ? item_get_history() ? CHistoryManager::getTableName() in include/classes/api/managers/CHistoryManager.php:72]
Error in query [SELECT value FROM WHERE itemid='' AND clock='1397646122' AND ns='999999999' LIMIT 1 OFFSET 0] [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 'WHERE itemid='' AND clock='1397646122' AND ns='999999999' LIMIT 1 OFFSET 0' at line 1]
Error in query [SELECT DISTINCT clock FROM WHERE itemid='' AND clock='1397646122' AND ns<'999999999'] [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 'WHERE itemid='' AND clock='1397646122' AND ns<'999999999'' at line 1]
Error in query [SELECT MAX(clock) AS clock FROM WHERE itemid='' AND clock<'1397646122'] [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 'WHERE itemid='' AND clock<'1397646122'' at line 1]


 Comments   
Comment by Alexander Vladishev [ 2015 Dec 07 ]

Fixed in the development branch svn://svn.zabbix.com/branches/dev/ZBX-10139

Comment by Ivo Kurzemnieks [ 2015 Dec 09 ]

(1) No translation string changes.

sasha CLOSED

Comment by Ivo Kurzemnieks [ 2015 Dec 09 ]

TESTED.

Don't forget to close (1).

Comment by Alexander Vladishev [ 2015 Dec 10 ]

Fixed in pre-3.0.0alpha5 r57120.

Generated at Thu Apr 25 07:34:30 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.