mysql 환경설정중 sql-mode 옵션을 수정후 재시작해보셔야 될것 같습니다.

my.ini 파일을 여서서 아래와 같이 수정 하시면 되십니다.

[mysqld] => [mysqld] max_allowed_packet=32M

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" => sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

-------------------- Original message --------------------

수정이 안되는것 같습니다.

계정등록이나 관리자 수정이 안됩니다.

아래 에러 로그는 계정추가시 에러입니다.

[Nmail Error - ERROR]
Message : DB Error: unknown error, Source : C:\NmailPHP
mail\admin_mbr_add_ok.php ( 160 line ), Return messages :
INSERT INTO
nmail_member
(m_no, m_id, m_pwd, m_lostpwd_q, m_lostpwd_a, m_level, m_name, m_last_name, m_email, m_homepage, m_jumin, m_sex, m_birthday, m_birthday_east, m_mobile, m_home_tel, m_home_zipcode, m_home_addr1, m_home_addr2, m_job, m_office, m_office_subject, m_office_tel, m_office_fax, m_office_zipcode, m_office_addr1, m_office_addr2, m_ismarry, m_marrydate, m_isremail, m_memo, m_etc1, m_etc2, m_etc3, m_etc4, m_etc5, m_date1, m_date2, m_date3, m_date4, m_date5, m_file1, m_file2, m_file3, m_file4, m_file5, m_regdate, m_reghost, m_login_cnt, m_last_logindate, m_last_loginhost, m_last_modifydate, m_last_modifyhost, d_no, m_is_use, m_mail_file_group, m_quota, m_bigfile_quota, m_webhard_quota, mg_no, mc_no, m_cfg_from_addr)
VALUES
(NULL, 'help', 'ec0e635db30679a911e733c4842c1438', '', '', '3', '이재식', '', '', '', '-', '', '-00-00', '', '--', '--', '-', '', '', '', '', '', '--', '--', '-', '', '', '', '-00-00', 'Y', '', '', '', '', '', '', '-00-00', '-00-00', '-00-00', '-00-00', '-00-00', '', '', '', '', '', '2014-05-19 17:36:38', '125.129.149.161', '0', '', '', '', '', '1', 'Y', '0001', '102400', '102400', '102400', NULL, '', '')
[nativecode=1265 ** Data truncated for column 'm_sex' at row 1]