Community
    • Categories
    • Recent
    • Popular
    • Users
    • Search
    • Register
    • Login

    Database error (foreign key) adding network connection

    Scheduled Pinned Locked Moved Development
    1 Posts 1 Posters 1.5k Views 1 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Y Offline
      yyu
      last edited by

      Using i-doit open 1.4.8, when adding an "Network connections > Connection", database error occurs. Seems to be a foreign key issue.

      i-doit Code Version    1.4.8
      i-doit Database Version    1.4.8 Revision 18308

      [2015-11-10 10:01:12] ERROR:  Exception Trace:

      • File: /var/www/index.php (line: 138)
          require_once
      • File: /var/www/src/ajax.inc.php (line: 137)
          include_once
      • File: /var/www/src/hypergate.inc.php (line: 456)
          include_once
      • File: /var/www/src/i-doit.inc.php (line: 144)
          isys_module_manager->load
      • File: /var/www/src/classes/modules/manager/isys_module_manager.class.php (line: 823)
          isys_module_cmdb->start
      • File: /var/www/src/classes/modules/cmdb/isys_module_cmdb.class.php (line: 613)
          isys_cmdb_view_category->process_save
      • File: /var/www/src/classes/cmdb/view/isys_cmdb_view_category.class.php (line: 796)
          isys_cmdb_view_category->handle_navmode
      • File: /var/www/src/classes/cmdb/view/isys_cmdb_view_category.class.php (line: 509)
          isys_cmdb_action_processor->process
      • File: /var/www/src/classes/cmdb/action/isys_cmdb_action_processor.class.php (line: 252)
          isys_cmdb_action_processor->action_process
      • File: /var/www/src/classes/cmdb/action/isys_cmdb_action_processor.class.php (line: 198)
          isys_cmdb_action_category_update->handle
      • File: /var/www/src/classes/cmdb/action/isys_cmdb_action_category_update.class.php (line: 179)
          isys_cmdb_dao_category->save_element
      • File: /var/www/src/classes/cmdb/dao/category/isys_cmdb_dao_category.class.php (line: 1678)
          isys_cmdb_dao_category->save_user_data
      • File: /var/www/src/classes/cmdb/dao/category/isys_cmdb_dao_category.class.php (line: 1649)
          isys_cmdb_dao_category->create
      • File: /var/www/src/classes/cmdb/dao/category/isys_cmdb_dao_category.class.php (line: 1464)
          isys_cmdb_dao_category->create_data
      • File: /var/www/src/classes/cmdb/dao/category/isys_cmdb_dao_category.class.php (line: 1439)
          isys_component_dao->update
      • File: /var/www/src/classes/components/isys_component_dao.class.php (line: 383)
          isys_component_database_mysql->query
      • File: /var/www/src/classes/components/isys_component_database_mysql.class.php (line: 195)
          Message: "Database error : Query error: 'INSERT INTO isys_catg_net_connector_list SET isys_catg_net_connector_list__isys_obj__id = 403, isys_catg_net_connector_list__status = 2, isys_catg_net_connector_list__ip_addresses_list__id = 45, isys_catg_net_connector_list__port_from = 1024, isys_catg_net_connector_list__port_to = 65535, isys_catg_net_connector_list__isys_catg_net_listener_list__id = 3, isys_catg_net_connector_list__gateway = NULL, isys_catg_net_connector_list__description = '';':
        Cannot add or update a child row: a foreign key constraint fails (idoit_data.isys_catg_net_connector_list, CONSTRAINT isys_catg_net_connector_list_ibfk_2 FOREIGN KEY (isys_catg_net_connector_list__isys_catg_relation_list__id) REFERENCES `isys_catg_re)
        "

      No problem on the official demo site, maybe because they are using a different db schema (1.6.1 Revision 21601)

      Anyone can help?

      Thanks

      1 Reply Last reply Reply Quote 0
      • First post
        Last post