NEW Nmail PHP 3 업그레이드 할인
자세히 보기

nmail 계정 추가와 게시판 글 작성 에러

개* 2022.04.19 09:36 조회 1922

※ 필수입력정보 ※


▷ 제품버젼 :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 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, '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문제라고 뜨긴 하는데 정확히 무슨 에러이고 해결 방법이 뭔지 궁금합니다.

댓글 5
이전 글 메일이 안들어가져요 국*****링 2022.04.21
다음 글 외국어메일 보기 1 (****웹 2022.04.18