Community

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Popular
    • Users
    • Search

    Problem with add new entries

    Operating
    3
    7
    2851
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • D
      dexoid last edited by

      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, ))

      1 Reply Last reply Reply Quote 0
      • ds
        ds last edited by

        Disable the mysql safe mode

        1 Reply Last reply Reply Quote 0
        • D
          dexoid last edited by

          Directive  Local Value Master Value
          safe_mode Off Off
          sql.safe_mode Off Off

          1 Reply Last reply Reply Quote 0
          • ds
            ds last edited by

            I mean the mysql server, not the php client library

            1 Reply Last reply Reply Quote 0
            • D
              dexoid last edited by

              Where i can cheñk this option?

              1 Reply Last reply Reply Quote 0
              • ds
                ds last edited by

                Depends on your Environment. You should check the mysql documentation

                1 Reply Last reply Reply Quote 0
                • P
                  patrik_t last edited by

                  Hi. I had the same issue. I solved it by removing "STRICT_TRANS_TABLES" from sql-mode value in my.ini config file.

                  1 Reply Last reply Reply Quote 0
                  • First post
                    Last post