그누보드5 mysql #1067오류
http://sir.kr/bbs/view_image.php?fn=%2Fdata%2Feditor%2F1702%2Fc131671d7a3e8be3feb2213ee80b5d63_1486825646_4041.jpg" target="_blank" class="view_image" style="color: rgb(0, 0, 0); font-family: 돋움, Dotum, sans-serif; font-size: 14.004px;">http://sir.kr/data/editor/1702/thumb-c131671d7a3e8be3feb2213ee80b5d63_1486825646_4041_650x152.jpg" alt="c131671d7a3e8be3feb2213ee80b5d63_1486825" style="margin: 0px; padding: 0px; border: 0px; vertical-align: middle; max-width: 100%;">
mysql에서 고칠려하면 계속 저게 뜨내요 그냥 가만히 놔두고 저장만눌러도 저렇게 뜨내요
CREATE TABLE IF NOT EXISTS `g5_write_Gesif_02` (
`wr_id` int(11) NOT NULL AUTO_INCREMENT,
`wr_num` int(11) NOT NULL DEFAULT '0',
`wr_reply` varchar(10) NOT NULL,
`wr_parent` int(11) NOT NULL DEFAULT '0',
`wr_is_comment` tinyint(4) NOT NULL DEFAULT '0',
`wr_comment` int(11) NOT NULL DEFAULT '0',
`wr_comment_reply` varchar(5) NOT NULL,
`ca_name` varchar(255) NOT NULL,
`wr_option` set('html1','html2','secret','mail') 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) NOT NULL DEFAULT '0',
`wr_link2_hit` int(11) NOT NULL DEFAULT '0',
`wr_hit` int(11) NOT NULL DEFAULT '0',
`wr_good` int(11) NOT NULL DEFAULT '0',
`wr_nogood` int(11) NOT NULL DEFAULT '0',
`mb_id` varchar(20) 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 NOT NULL DEFAULT '0000-00-00 00:00:00',
`wr_file` tinyint(4) NOT NULL DEFAULT '0',
`wr_last` varchar(19) NOT NULL,
`wr_ip` varchar(255) NOT NULL,
`wr_facebook_user` varchar(255) NOT NULL,
`wr_twitter_user` 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,
`as_type` tinyint(4) NOT NULL DEFAULT '0',
`as_shingo` tinyint(4) NOT NULL DEFAULT '0',
`as_img` tinyint(4) NOT NULL DEFAULT '0',
`as_list` tinyint(4) NOT NULL DEFAULT '0',
`as_publish` tinyint(4) NOT NULL DEFAULT '0',
`as_extra` tinyint(4) NOT NULL DEFAULT '0',
`as_extend` tinyint(4) NOT NULL DEFAULT '0',
`as_level` int(11) NOT NULL DEFAULT '1',
`as_download` int(11) NOT NULL DEFAULT '0',
`as_down` int(11) NOT NULL DEFAULT '0',
`as_view` int(11) NOT NULL DEFAULT '0',
`as_lucky` int(11) NOT NULL DEFAULT '0',
`as_poll` int(11) NOT NULL DEFAULT '0',
`as_star_score` int(11) NOT NULL DEFAULT '0',
`as_choice` int(11) NOT NULL DEFAULT '0',
`as_choice_cnt` int(11) NOT NULL DEFAULT '0',
`as_re_mb` varchar(255) NOT NULL DEFAULT '',
`as_re_name` varchar(255) NOT NULL,
`as_tag` varchar(255) NOT NULL,
`as_map` varchar(255) NOT NULL,
`as_icon` varchar(255) NOT NULL,
`as_thumb` varchar(255) NOT NULL,
`as_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`as_star_cnt` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`wr_id`),
KEY `wr_num_reply_parent` (`wr_num`,`wr_reply`,`wr_parent`),
KEY `wr_is_comment` (`wr_is_comment`,`wr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;
여기서 뭘 고쳐야 저게 되는거죠?
답변 2개
답변에 대한 댓글 1개
댓글을 작성하려면 로그인이 필요합니다.
http://static.se2.naver.com/static/img/bg_b1.png) repeat;_background:none;_filter:progid:DXImageTransform.Microsoft.AlphaImageLoader(src='http://static.se2.naver.com/static/img/bg_b1.png',sizingMethod='scale');color:#888888;">
`wr_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',`wr_datetime` datetime NOT NULL DEFAULT '0000-00-00',
`as_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',`as_update` datetime NOT NULL DEFAULT '0000-00-00',
답변에 대한 댓글 2개
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인
에러는 wr_datetime 필드의 디폴트 값이 맞지않다 인데요
아래처럼 디폴트 값을 설정하면 될겁니다(아니면 필드 타입을 char로 바꾸던가...)
datetime NOT NULL DEFAULT '1970-01-01 00:00:00'