한가지만 더..ㅜㅜ 정보
한가지만 더..ㅜㅜ
본문
게시판을 복사해서 새게시판을 만들때
CREATE TABLE g4_write_eng ( wr_id int(11) NOT NULL auto_increment, wr_num int(11) DEFAULT '0' NOT NULL, wr_reply varchar(10) NOT NULL, wr_parent int(11) DEFAULT '0' NOT NULL, wr_is_comment tinyint(4) DEFAULT '0' NOT NULL, wr_comment int(11) DEFAULT '0' NOT NULL, wr_comment_reply varchar(5) NOT NULL, ca_name varchar(255) NOT NULL, wr_option set('html1','html2','secret','mail','adult') NOT NULL, wr_subject varchar(255) NOT NULL, wr_content text NOT NULL, wr_link1 text NOT NULL, wr_link2 text NOT NULL, wr_link1_hit int(11) DEFAULT '0' NOT NULL, wr_link2_hit int(11) DEFAULT '0' NOT NULL, wr_trackback varchar(255) NOT NULL, wr_hit int(11) DEFAULT '0' NOT NULL, wr_good int(11) DEFAULT '0' NOT NULL, wr_nogood int(11) DEFAULT '0' NOT NULL, mb_id varchar(255) NOT NULL, wr_password varchar(255) NOT NULL, wr_name varchar(255) NOT NULL, wr_email varchar(255) NOT NULL, wr_homepage varchar(255) NOT NULL, wr_datetime datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, wr_last varchar(19) NOT NULL, wr_ip varchar(255) NOT NULL, wr_1 varchar(255) NOT NULL, wr_2 varchar(255) NOT NULL, wr_3 varchar(255) NOT NULL, wr_4 varchar(255) NOT NULL, wr_5 varchar(255) NOT NULL, wr_6 varchar(255) NOT NULL, wr_7 varchar(255) NOT NULL, wr_8 varchar(255) NOT NULL, wr_9 varchar(255) NOT NULL, wr_10 varchar(255) NOT NULL, wr_ccl varchar(10) NOT NULL, wr_singo tinyint(4) DEFAULT '0' NOT NULL, wr_zzal varchar(255) DEFAULT '짤방' NOT NULL, wr_related varchar(255) NOT NULL, wr_comment_ban char(1) NOT NULL, wr_contents_price int(11) NOT NULL, wr_contents_domain char(1) NOT NULL, wr_umz varchar(30) NOT NULL, wr_subject_font varchar(10) NOT NULL, wr_subject_color varchar(10) NOT NULL, PRIMARY KEY (wr_id), KEY wr_num_reply_parent (wr_num, wr_reply, wr_parent), KEY wr_is_comment (wr_is_comment, wr_id) )
1067 : Invalid default value for 'wr_zzal'
error file : /ybnara/adm/board_copy_update.php
이런 오류가 생기는데..
해결방법 좀.ㅜㅜ
CREATE TABLE g4_write_eng ( wr_id int(11) NOT NULL auto_increment, wr_num int(11) DEFAULT '0' NOT NULL, wr_reply varchar(10) NOT NULL, wr_parent int(11) DEFAULT '0' NOT NULL, wr_is_comment tinyint(4) DEFAULT '0' NOT NULL, wr_comment int(11) DEFAULT '0' NOT NULL, wr_comment_reply varchar(5) NOT NULL, ca_name varchar(255) NOT NULL, wr_option set('html1','html2','secret','mail','adult') NOT NULL, wr_subject varchar(255) NOT NULL, wr_content text NOT NULL, wr_link1 text NOT NULL, wr_link2 text NOT NULL, wr_link1_hit int(11) DEFAULT '0' NOT NULL, wr_link2_hit int(11) DEFAULT '0' NOT NULL, wr_trackback varchar(255) NOT NULL, wr_hit int(11) DEFAULT '0' NOT NULL, wr_good int(11) DEFAULT '0' NOT NULL, wr_nogood int(11) DEFAULT '0' NOT NULL, mb_id varchar(255) NOT NULL, wr_password varchar(255) NOT NULL, wr_name varchar(255) NOT NULL, wr_email varchar(255) NOT NULL, wr_homepage varchar(255) NOT NULL, wr_datetime datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, wr_last varchar(19) NOT NULL, wr_ip varchar(255) NOT NULL, wr_1 varchar(255) NOT NULL, wr_2 varchar(255) NOT NULL, wr_3 varchar(255) NOT NULL, wr_4 varchar(255) NOT NULL, wr_5 varchar(255) NOT NULL, wr_6 varchar(255) NOT NULL, wr_7 varchar(255) NOT NULL, wr_8 varchar(255) NOT NULL, wr_9 varchar(255) NOT NULL, wr_10 varchar(255) NOT NULL, wr_ccl varchar(10) NOT NULL, wr_singo tinyint(4) DEFAULT '0' NOT NULL, wr_zzal varchar(255) DEFAULT '짤방' NOT NULL, wr_related varchar(255) NOT NULL, wr_comment_ban char(1) NOT NULL, wr_contents_price int(11) NOT NULL, wr_contents_domain char(1) NOT NULL, wr_umz varchar(30) NOT NULL, wr_subject_font varchar(10) NOT NULL, wr_subject_color varchar(10) NOT NULL, PRIMARY KEY (wr_id), KEY wr_num_reply_parent (wr_num, wr_reply, wr_parent), KEY wr_is_comment (wr_is_comment, wr_id) )
1067 : Invalid default value for 'wr_zzal'
error file : /ybnara/adm/board_copy_update.php
이런 오류가 생기는데..
해결방법 좀.ㅜㅜ
댓글 전체

현재 전체 소스를 보면 인코딩이 잘못된 소스가 포함되어 있습니다.
즉 utf-8 에서 euc-kr(ANSI) 로 작성된 문서가 있습니다.
확인해 보세요.
즉 utf-8 에서 euc-kr(ANSI) 로 작성된 문서가 있습니다.
확인해 보세요.

board_copy_update.php 이게 잘못되어일수도 있겠네요
확인해 보겠습니다.
확인해 보겠습니다.
wr_zzal varchar(255) DEFAULT '짤방' NOT NULL ->
wr_zzal varchar(255) NOT NULL 또는, wr_zzal varchar(255) DEFAULT '0' NOT NULL 로 고쳐보세요
wr_zzal varchar(255) NOT NULL 또는, wr_zzal varchar(255) DEFAULT '0' NOT NULL 로 고쳐보세요

어느 파일에서 고치면 되나요??