Posts made by yyu

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