-
Problem report
-
Resolution: Fixed
-
Minor
-
None
-
Sprint 47, Dec 2018, Sprint 48, Jan 2019
-
0.125
Steps to reproduce:
- create new graph
- select Item in the "Y axis MIN value" drop-down (item field should be left blank)
- select Item in the "Y axis MAX value" drop-down (item field should be left blank)
- add one or more items to the "Items" field
- click on preview
Result:
- Undefined index: [chart3.php:186 -> CLineGraphDraw->draw() -> CLineGraphDraw->calcSides() -> CLineGraphDraw->calculateMinY() -> CHistoryManager->getLastValues() -> CHistoryManager->getLastValuesFromSql() -> CHistoryManager::getTableName() -> CConfigFile->{closure}() in include/classes/api/managers/CHistoryManager.php:725]
- pg_query(): Query failed: ERROR: relation "h" does not exist
- LINE 1: SELECT * FROM h WHERE h.itemid='' ORDER BY h.clock DESC LIM...
- ^ [chart3.php:186 -> CLineGraphDraw->draw() -> CLineGraphDraw->calcSides() -> CLineGraphDraw->calculateMinY() -> CHistoryManager->getLastValues() -> CHistoryManager->getLastValuesFromSql() -> DBselect() -> pg_query() -> CConfigFile->{closure}() in include/db.inc.php:369]
- Undefined index: [chart3.php:186 -> CLineGraphDraw->draw() -> CLineGraphDraw->calcSides() -> CLineGraphDraw->calculateMaxY() -> CHistoryManager->getLastValues() -> CHistoryManager->getLastValuesFromSql() -> CHistoryManager::getTableName() -> CConfigFile->{closure}() in include/classes/api/managers/CHistoryManager.php:725]
- pg_query(): Query failed: ERROR: relation "h" does not exist
- LINE 1: SELECT * FROM h WHERE h.itemid='' ORDER BY h.clock DESC LIM...
- ^ [chart3.php:186 -> CLineGraphDraw->draw() -> CLineGraphDraw->calcSides() -> CLineGraphDraw->calculateMaxY() -> CHistoryManager->getLastValues() -> CHistoryManager->getLastValuesFromSql() -> DBselect() -> pg_query() -> CConfigFile->{closure}() in include/db.inc.php:369]
these messages are produced by the graph builder and they are not visible in the UI.
