[nativecode=1265 ** Data truncated for column 'm_sex' at row 1]
=>
위 에러로 볼때 MySQL 설정중 sql-mode 옵션을 수정후 재시작해보셔야 할 것 같습니다.
http://passkorea.net/nmailphp/nmail-php-2.3.1_windows_manual.htm#_Toc184543743
설치된 폴더(C:\Program Files\MySQL\MySQL Server 5.0\)에서 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--------------
※ 필수입력정보 ※
▷ 제품버젼 : 2.3.1
▷ 오류발생 메뉴/주소 : 메일계정 추가 시
▷ 에러메세지 :
[Nmail Error - ERROR]
Message : DB Error: unknown error, Source : C:\NmailPHP
mail\admin_mbr_add_ok.php ( 76 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, mg_no)
VALUES
(NULL, 'webmaster', 'edae02242ff19b2a3cf2a544b28c06f3', '', '', '3', '관리자', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Y', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2008-06-08 23:50:44', '75.86.182.46', '0', '', '', '', '', '1', 'Y', '0001', '30720', '')
[nativecode=1265 ** Data truncated for column 'm_sex' at row 1]
▷ 질문내용 : win2003의 iis에서 세팅하였습니다.
다른 기능은 이상없이 되는데 메일계정 추가가 안됩니다.
왜 이런걸까요?