Ad Widget

Collapse

Error in graphs when date mo that 5 days

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • wmp
    Junior Member
    • Apr 2023
    • 8

    #1

    Error in graphs when date mo that 5 days

    Got this error messages. But value for same peroid is avalible

    Error in query [SELECT itemid,SUM(num) AS count,AVG(value_avg) AS avg,MIN(value_min) AS min,MAX(value_max) AS max,round(604.0*(clock-1744794668)/604800,0) AS i,MAX(clock) AS clock FROM trends WHERE itemid='39823' AND clock>='1744794668' AND clock<='1745399468' GROUP BY itemid,round(604.0*(clock-1744794668)/604800,0)] [Unknown column 'num' in 'field list'] [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::getMetr icsData() → CHistoryManager->getGraphAggregationByWidth() → CHistoryManager->getGraphAggregationByWidthFromSql() → DBselect() → trigger_error() in include/db.inc.php:243]
Working...