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.
