-
Problem report
-
Resolution: Won't fix
-
Trivial
-
None
-
6.4.14
-
AlmaLinux 9, postgresql16
AlmaLinux 9, postgresql16, TimescaleDB 2.13.0
Error:
pg_query(): Query failed: ОШИБКА: ORDER/GROUP BY expression not found in targetlist [zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → Widgets\TopHosts\Actions\WidgetView->doAction() → Widgets\TopHosts\Actions\WidgetView->getData() → Widgets\TopHosts\Actions\WidgetView::getItemValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSqlWithPk() → DBselect() → pg_query() in include/db.inc.php:254] Error in query [SELECT h.itemid,MAX(h.clock) AS clock FROM history h WHERE h.itemid=42269 AND h.clock>1714054823 GROUP BY h.itemid] [ОШИБКА: ORDER/GROUP BY expression not found in targetlist]
How to fix?
- duplicates
-
ZBXNEXT-8857 Timescale 2.13.0
- Closed