Problem with add new entries
-
Hellow! Help me!
When I click to "New" icon program back this error:
isys_exception_database : Query error: 'INSERT INTO isys_obj (isys_obj__id, isys_obj__title, isys_obj__isys_obj_type__id, isys_obj__status, isys_obj__created,isys_obj__created_by,isys_obj__updated,isys_obj__updated_by,isys_obj__hostname,isys_obj__scantime,isys_obj__imported,isys_obj__logical) VALUES (DEFAULT, '', '10', '1', NOW(),'admin',NOW(),'admin','','','NULL','0');': Incorrect datetime value: '' for column 'isys_obj__scantime' at row 1Backtrace: #0 _get_backtrace() called at [D:\apache\localhost\www\idoit\src\classes\exceptions\isys_exception_database.class.php:24] #1 isys_exception_database->__construct(Query error: 'INSERT INTO isys_obj (isys_obj__id, isys_obj__title, isys_obj__isys_obj_type__id, isys_obj__status, isys_obj__created,isys_obj__created_by,isys_obj__updated,isys_obj__updated_by,isys_obj__hostname,isys_obj__scantime,isys_obj__imported,isys_obj__logical) VALUES (DEFAULT, '', '10', '1', NOW(),'admin',NOW(),'admin','','','NULL','0');': Incorrect datetime value: '' for column 'isys_obj__scantime' at row 1, Array ([server] => 5.1.31-community,[host] => localhost via TCP/IP,[client] => 5.0.51a,[proto] => 10)) called at [D:\apache\localhost\www\idoit\src\classes\components\isys_component_database.class.php:151] #2 isys_component_database->query(INSERT INTO isys_obj (isys_obj__id, isys_obj__title, isys_obj__isys_obj_type__id, isys_obj__status, isys_obj__created,isys_obj__created_by,isys_obj__updated,isys_obj__updated_by,isys_obj__hostname,isys_obj__scantime,isys_obj__imported,isys_obj__logical) VALUES (DEFAULT, '', '10', '1', NOW(),'admin',NOW(),'admin','','','NULL','0');) called at [D:\apache\localhost\www\idoit\src\classes\components\isys_component_dao.class.php:254] #3 isys_component_dao->update(INSERT INTO isys_obj (isys_obj__id, isys_obj__title, isys_obj__isys_obj_type__id, isys_obj__status, isys_obj__created,isys_obj__created_by,isys_obj__updated,isys_obj__updated_by,isys_obj__hostname,isys_obj__scantime,isys_obj__imported,isys_obj__logical) VALUES (DEFAULT, '', '10', '1', NOW(),'admin',NOW(),'admin','','','NULL','0');) called at [D:\apache\localhost\www\idoit\src\classes\cmdb\dao\isys_cmdb_dao.class.php:2247] #4 isys_cmdb_dao->insert_new_obj(10, ) called at [D:\apache\localhost\www\idoit\src\classes\cmdb\action\isys_cmdb_action_object_create.class.php:67] #5 isys_cmdb_action_object_create->handle(isys_cmdb_dao Object ([] => Array ([0] => isys_catg_location_list__isys_obj__id,[1] => isysgui_obj_pos__isys_obj__id,[2] => isys_catg_backup_list__isys_obj__id,[3] => isys_catg_emergency_plan_list__isys_obj__id,[4] => isys_catg_file_list__isys_obj__id,[5] => isys_catg_maintenance_list__isys_obj__id,[6] => isys_catg_manual_list__isys_obj__id,[7] => isys_catp_netport__isys_obj__id,[8] => isys_file_version__isys_obj__id,[9] => isystemp_search__obj_id),[] => Array ([0] => isys_netp_ifacel__isys_obj__id,[1] => isys_workflow__isys_obj__id),[] => isys_component_database Object ([] => idoit_data,[] => Resource id #42,[] => isys_component_database_transaction_manager Object ([] => isys_component_database Object ( RECURSION,[] => 0)),[] => isys_component_database_transaction_manager Object ([] => isys_component_database Object ([] => idoit_data,[] => Resource id #42,[] => isys_component_database_transaction_manager Object ( RECURSION),[] => 0),[] => SELECT * FROM isys_obj_type WHERE isys_obj_type__id = '10' ORDER BY isys_obj_type__sort DESC;,[] => Array ()), Array ([0] => 10,[__ACTIONPROC] => isys_cmdb_action_processor Object ([] => isys_cmdb_dao Object ([] => Array ([0] => isys_catg_location_list__isys_obj__id,[1] => isysgui_obj_pos__isys_obj__id,[2] => isys_catg_backup_list__isys_obj__id,[3] => isys_catg_emergency_plan_list__isys_obj__id,[4] => isys_catg_file_list__isys_obj__id,[5] => isys_catg_maintenance_list__isys_obj__id,[6] => isys_catg_manual_list__isys_obj__id,[7] => isys_catp_netport__isys_obj__id,[8] => isys_file_version__isys_obj__id,[9] => isystemp_search__obj_id),[] => Array ([0] => isys_netp_ifacel__isys_obj__id,[1] => isys_workflow__isys_obj__id),[] => isys_component_database Object ([] => idoit_data,[] => Resource id #42,[] => isys_component_database_transaction_manager Object ([] => isys_component_database Object ( RECURSION,[] => 0)),[] => isys_component_database_transaction_manager Object ([] => isys_component_database Object ([] => idoit_data,[] => Resource id #42,[] => isys_component_database_transaction_manager Object ( RECURSION),[] => 0),[] => SELECT * FROM isys_obj_type WHERE isys_obj_type__id = '10' ORDER BY isys_obj_type__sort DESC;,[] => Array ()),[] => Array ([0] => Array ([0] => 513,[1] => Array ([0] => 10))),[] => Array ()))) called at [D:\apache\localhost\www\idoit\src\classes\cmdb\action\isys_cmdb_action_processor.class.php:178] #6 isys_cmdb_action_processor->action_process(isys_cmdb_action_object_create, Array ([0] => 10)) called at [D:\apache\localhost\www\idoit\src\classes\cmdb\action\isys_cmdb_action_processor.class.php:222] #7 isys_cmdb_action_processor->process() called at [D:\apache\localhost\www\idoit\src\classes\cmdb\view\isys_cmdb_view_list_object.class.php:285] #8 isys_cmdb_view_list_object->handle_navmode(1) called at [D:\apache\localhost\www\idoit\src\classes\cmdb\view\isys_cmdb_view_list.class.php:36] #9 isys_cmdb_view_list->process() called at [D:\apache\localhost\www\idoit\src\classes\modules\isys_module_cmdb.class.php:624] #10 isys_module_cmdb->start() called at [D:\apache\localhost\www\idoit\src\classes\modules\isys_module_manager.class.php:554] #11 isys_module_manager->load(2) called at [D:\apache\localhost\www\idoit\src\i-doit.inc.php:173] #12 include_once(D:\apache\localhost\www\idoit\src\i-doit.inc.php) called at [D:\apache\localhost\www\idoit\src\hypergate.inc.php:252] #13 include_once(D:\apache\localhost\www\idoit\src\hypergate.inc.php) called at [D:\apache\localhost\www\idoit\index.php:304] (Extended Information: array ( 'server' => '5.1.31-community', 'host' => 'localhost via TCP/IP', 'client' => '5.0.51a', 'proto' => 10, ))
-
Disable the mysql safe mode
-
Directive Local Value Master Value
safe_mode Off Off
sql.safe_mode Off Off -
I mean the mysql server, not the php client library
-
Where i can cheñk this option?
-
Depends on your Environment. You should check the mysql documentation
-
Hi. I had the same issue. I solved it by removing "STRICT_TRANS_TABLES" from sql-mode value in my.ini config file.
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