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
, CONSTRAINTisys_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
- File: /var/www/index.php (line: 138)