에러 코드좀 봐주셔요
본문
insert into ez_write_re03 set wr_num = '-15', wr_reply = '', wr_comment = 0, ca_name = '', wr_option = ',,', wr_subject = '2�몄떎', wr_content = 'kk', wr_link1 = '', wr_link2 = '', wr_link1_hit = 0, wr_link2_hit = 0, wr_trackback = '', wr_hit = 0, wr_good = 0, wr_nogood = 0, mb_id = 'admin', wr_password = '3007195b0cec296f', wr_name = '愿�由ъ옄', wr_email = '*** 개인정보보호를 위한 이메일주소 노출방지 ***', wr_homepage = '', wr_datetime = '2016-03-24 15:15:58', wr_last = '2016-03-24 15:15:58', wr_ip = '118.38.75.14', wr_1 = '10', wr_2 = '4', wr_3 = '6', wr_4 = '50000', wr_5 = '70000', wr_6 = '160000', wr_7 = '160000', wr_8 = '10000', wr_9 = '70000', wr_10 = '160000', wr_20 = '111111', wr_21 = '222222, wr_22 = '888886'
1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '888886'' at line 36
error file : /V1/page/write_update_bbs.php
위에처럼 에러가 뜨는데 초보라 뭔지 모르겠네요....
답변 2
wr_21 = '222222, wr_22 = '888886'
여기 보시면 작은따옴표 하나 빠졌어요.
wr_21 = '222222', wr_22 = '888886'
답변 감사 드려요~~
수정하고 나니...
insert into ez_write_re03 set wr_num = '-15', wr_reply = '', wr_comment = 0, ca_name = '', wr_option = ',,', wr_subject = '2�몄떎', wr_content = '�뤵뀖', wr_link1 = '', wr_link2 = '', wr_link1_hit = 0, wr_link2_hit = 0, wr_trackback = '', wr_hit = 0, wr_good = 0, wr_nogood = 0, mb_id = 'admin', wr_password = '3007195b0cec296f', wr_name = '愿�由ъ옄', wr_email = '*** 개인정보보호를 위한 이메일주소 노출방지 ***', wr_homepage = '', wr_datetime = '2016-03-24 16:19:48', wr_last = '2016-03-24 16:19:48', wr_ip = '118.38.75.14', wr_1 = '10', wr_2 = '4', wr_3 = '6', wr_4 = '50000', wr_5 = '70000', wr_6 = '160000', wr_7 = '160000', wr_8 = '10000', wr_9 = '70000', wr_10 = '160000', wr_12 = '', wr_13 = '', wr_14 = ''
1054 : Unknown column 'wr_12' in 'field list'
error file : /V1/page/write_update_bbs.php
필드값이 없다는거 같은데요...우째 해야 할까요?? 한번만 더 질문 드릴게요..
wr_12라는 칼럼이 없다는 내용입니다.
그누보드 기본 테이블이라면 wr_10까지만 있습니다.
해당 테이블에 칼럼을 추가해야 합니다.
여분 필드로 검색해 보세요.
ez_write_re03 테이블에 wr_12 필드가 있는지 확인하세요.
sql> show columns from ez_write_re03
아무래도 필드가 없는것 같습니다.
넵 ...답변 감사드려요