-
Problem report
-
Resolution: Unresolved
-
Trivial
-
7.0.22rc1, 7.2.15rc1, 7.4.6rc1, 8.0.0alpha2 (master)
-
S25-W48/49
-
0.5
Steps to reproduce:
1. Go to Dashboards;
2. Create Item history widget;
3. Create Pie chart/Graph/Scatter plot and add Item list -> Add widget -> Item history;
or
4. Create Gauge/Item value widget and add Item history widget in the Item.
Result:
Runtime error appears:
array_flip(): Can only flip string and integer values, entry skipped [zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → Widgets\SvgGraph\Actions\WidgetView->doAction() → Widgets\SvgGraph\Includes\CSvgGraphHelper::get() → Widgets\SvgGraph\Includes\CSvgGraphHelper::getMetricsItems() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CItem->get() → dbConditionInt() → array_flip() → CConfigFile->{closure}() in conf/zabbix.conf.php:89]
pg_query(): Query failed: ERROR: syntax error at or near "AND"
LINE 1: ...N i.itemid=irn.itemid WHERE i.flags IN (0,4) AND AND i.valu...
^ [zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → Widgets\SvgGraph\Actions\WidgetView->doAction() → Widgets\SvgGraph\Includes\CSvgGraphHelper::get() → Widgets\SvgGraph\Includes\CSvgGraphHelper::getMetricsItems() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CItem->get() → DBselect() → pg_query() → CConfigFile->{closure}() in conf/zabbix.conf.php:89]
Error in query [SELECT i.itemid,i.hostid,i.type,i.key_,i.master_itemid,i.delay,i.history,i.trends,i.units,i.value_type,COALESCE(irn.name_resolved,'') AS name_resolved FROM items i LEFT JOIN item_rtname irn ON i.itemid=irn.itemid WHERE i.flags IN (0,4) AND AND i.value_type IN (0,3) LIMIT 50] [ERROR: syntax error at or near "AND"
LINE 1: ...N i.itemid=irn.itemid WHERE i.flags IN (0,4) AND AND i.valu...
^] [zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → Widgets\SvgGraph\Actions\WidgetView->doAction() → Widgets\SvgGraph\Includes\CSvgGraphHelper::get() → Widgets\SvgGraph\Includes\CSvgGraphHelper::getMetricsItems() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CItem->get() → DBselect() → trigger_error() → CConfigFile->{closure}() in conf/zabbix.conf.php:89]
Item card widget:
Expected:
All widgets works without errors.
