글쓰기 에러... 정보
그누보드 글쓰기 에러...본문
글을 입력 할때 작은 따옴표( ' ) 있으면 sql 에러가 발생합니다...
아래와 같이...
그누보드데모에 테스트 해보면 되는데... 뭐가 잘못 된건가요??
insert into gb_write_test set ca_id = '1', wr_notice = '', wr_html = '', wr_secret = '', wr_recv_email = '1', wr_num = '-9', wr_reply = '', wr_comment = '0', wr_commentcnt = '0', wr_subject = 'test', wr_content = '' ' '', wr_link1 = '', wr_link2 = '', wr_file1 = '', wr_file2 = '', wr_file1_source = '', wr_file2_source = '', wr_file1_download = '0', wr_file2_download = '0', wr_hit = '0', mb_id = 'admin', wr_name = '권익순', wr_passwd = '43e9a4ab75570f5b', wr_email = '*** 개인정보보호를 위한 이메일주소 노출방지 ***', wr_homepage = '', wr_datetime = '2003-07-16 18:40:40', wr_ip = '192.168.1.46', wr_user_agent = 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)'
1064 : You have an error in your SQL syntax near '0', wr_file2_download = '0', wr_hit = '0' at line 12
아래와 같이...
그누보드데모에 테스트 해보면 되는데... 뭐가 잘못 된건가요??
insert into gb_write_test set ca_id = '1', wr_notice = '', wr_html = '', wr_secret = '', wr_recv_email = '1', wr_num = '-9', wr_reply = '', wr_comment = '0', wr_commentcnt = '0', wr_subject = 'test', wr_content = '' ' '', wr_link1 = '', wr_link2 = '', wr_file1 = '', wr_file2 = '', wr_file1_source = '', wr_file2_source = '', wr_file1_download = '0', wr_file2_download = '0', wr_hit = '0', mb_id = 'admin', wr_name = '권익순', wr_passwd = '43e9a4ab75570f5b', wr_email = '*** 개인정보보호를 위한 이메일주소 노출방지 ***', wr_homepage = '', wr_datetime = '2003-07-16 18:40:40', wr_ip = '192.168.1.46', wr_user_agent = 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)'
1064 : You have an error in your SQL syntax near '0', wr_file2_download = '0', wr_hit = '0' at line 12
댓글 전체