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

when adding new graph to template get lot's of SQL error

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.0.3
    • Fix Version/s: 2.0.4rc1, 2.1.0
    • Component/s: Frontend (F)
    • Labels:
    • Environment:
      Debian 6.0.6, Oracle 11g, Apache2

      Description

      I'm trying to add graph to template and get this errors in frontend:
      ==
      Details
      Graph added

      ociexecute(): ORA-01722: invalid number [include/db.inc.php:517]
      SQL error [ORA-01722: invalid number] in [INSERT INTO graphs (name,width,height,ymin_type,ymax_type,yaxismin,yaxismax,ymin_itemid,ymax_itemid,show_work_period,show_triggers,graphtype,show_legend,show_3d,percent_left,percent_right,graphid) VALUES ('States','900','200','0','1','0.00','100.00',NULL,NULL,'1','1','0','1','0','0','0','527')]
      ociexecute(): ORA-02291: integrity constraint (MONITORING.C_GRAPHS_ITEMS_1) violated - parent key not found [include/db.inc.php:517]
      SQL error [ORA-02291: integrity constraint (MONITORING.C_GRAPHS_ITEMS_1) violated - parent key not found] in [INSERT INTO graphs_items (gitemid,graphid,itemid,sortorder,type,calc_fnc,drawtype,yaxisside,color) VALUES ('1733','527','23570','0','0','2','3','0','FF0000')]
      ociexecute(): ORA-02291: integrity constraint (MONITORING.C_GRAPHS_ITEMS_1) violated - parent key not found [include/db.inc.php:517]
      SQL error [ORA-02291: integrity constraint (MONITORING.C_GRAPHS_ITEMS_1) violated - parent key not found] in [INSERT INTO graphs_items (gitemid,graphid,itemid,sortorder,type,calc_fnc,drawtype,yaxisside,color) VALUES ('1734','527','23588','1','0','2','1','0','009900')]
      ociexecute(): ORA-02291: integrity constraint (MONITORING.C_GRAPHS_ITEMS_1) violated - parent key not found [include/db.inc.php:517]
      SQL error [ORA-02291: integrity constraint (MONITORING.C_GRAPHS_ITEMS_1) violated - parent key not found] in [INSERT INTO graphs_items (gitemid,graphid,itemid,sortorder,type,calc_fnc,drawtype,yaxisside,color) VALUES ('1735','527','23589','2','0','2','0','0','FFAA00')]
      ociexecute(): ORA-02291: integrity constraint (MONITORING.C_GRAPHS_ITEMS_1) violated - parent key not found [include/db.inc.php:517]
      SQL error [ORA-02291: integrity constraint (MONITORING.C_GRAPHS_ITEMS_1) violated - parent key not found] in [INSERT INTO graphs_items (gitemid,graphid,itemid,sortorder,type,calc_fnc,drawtype,yaxisside,color) VALUES ('1736','527','23590','3','0','2','0','0','FF0000')]
      ociexecute(): ORA-02291: integrity constraint (MONITORING.C_GRAPHS_ITEMS_1) violated - parent key not found [include/db.inc.php:517]
      SQL error [ORA-02291: integrity constraint (MONITORING.C_GRAPHS_ITEMS_1) violated - parent key not found] in [INSERT INTO graphs_items (gitemid,graphid,itemid,sortorder,type,calc_fnc,drawtype,yaxisside,color) VALUES ('1737','527','23591','4','0','2','0','0','0000FF')]
      ==
      and of course graph wasn't add

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                netflash Alexander Romanov
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: