Database error (foreign key) adding network connection



  • 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


Log in to reply
 

Looks like your connection to Community was lost, please wait while we try to reconnect.