아래 환경변수 적용해서 재구동 해보시기 바랍니다.
vi /etc/my.cnf [mysqld] sql_mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
-------------------- Original message --------------------
※ 필수입력정보 ※
▷ 제품버젼 :nmail 3.0
▷ 오류발생 메뉴/주소 :
▷ 에러메세지 : 계정 추가시 [Nmail Error - ERROR]Message : DB Error: unknown error, Source : /home/nmail2/nmail/admin_mbr_add_ok.php ( 166 line ), Return messages :INSERT INTOnmail_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, 'tnehwk4', '****', '', '', '3', 'ㄴㅇㄹㅇ', '', '', '', '-', '', '-00-00', '', '--', '--', '', '', '', '', '', '', '--', '--', '', '', '', '', '-00-00', 'Y', '', '', '', '', '', '', '-00-00', '-00-00', '-00-00', '-00-00', '-00-00', '', '', '', '', '', '2022-04-19 09:33:17', '210.220.150.109', '0', '', '', '', '', '1', 'Y', '0001', '102400', '102400', '102400', NULL, '', '')[nativecode=1265 ** Data truncated for column 'm_sex' at row 1]
게시판 글 등록 시 [Nmail Error - ERROR]
Message : DB Error: unknown error, Source : /home/nmail2/nmail/board.php ( 1,358 line ), Return messages : INSERT INTO nmail_board (b_no, ba_no, bca_no, m_no, b_name, b_pwd, b_email, b_homepage, b_isuse_reply_mail, b_subject, b_html, b_memo, b_link, b_file, b_files, b_file_size, b_refer, b_down, b_vote, b_comment, b_ref, b_re_step, b_re_level, b_regdate, b_reghost, b_last_modifydate, b_last_modifyhost) VALUES (NULL, '1', '', '1', 'PostMaster', '' , '****@****', '', 'N', 'fvfdv', 'Y', '', '', '', '', '0', 0, 0, 0, 0, '0', '0', '0', '2022-04-19 09:31:01', '제ip', NULL, NULL) [nativecode=1366 ** Incorrect integer value: '' for column 'bca_no' at row 1]
▷ 질문내용 : 계정 추가와 게시판 글 등록시 이런 에러가 뜹니다. db문제라고 뜨긴 하는데 정확히 무슨 에러이고 해결 방법이 뭔지 궁금합니다. |
|
