Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-15374

SQL and PHP errors in chart3.php

    XMLWordPrintable

    Details

    • Team:
      Team B
    • Sprint:
      Sprint 47, Dec 2018, Sprint 48, Jan 2019
    • Story Points:
      0.125

      Description

      Steps to reproduce:

      1. create new graph
      2. select Item in the "Y axis MIN value" drop-down (item field should be left blank)
      3. select Item in the "Y axis MAX value" drop-down (item field should be left blank)
      4. add one or more items to the "Items" field
      5. 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.

        Attachments

          Activity

            People

            Assignee:
            sasha Alexander Vladishev
            Reporter:
            sasha Alexander Vladishev
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: