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_2FOREIGN 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)
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login