게시판 생성할때마다 여분필드 미리넣기
본문
게시판 생성해서 여분필드 일일히 추가하는게 귀찮아서
아예 첨부터 만들어질때 여분필드 100개정도 생성시키려고 합니다.
찾아보니
adm/sql_write.sql
`wr_11` varchar(255) NOT NULL,
부터 아래로 쭈욱 넣어야한다는데 맞는지 해서요
실제 해보니,
관리자에서 게시판을 만들면
게시판은 보이는데 글 저장이 안되고
디비에서는 table생성이 안되어있네요
CREATE TABLE `__TABLE_NAME__` (
`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,
`wr_11` varchar(255) NOT NULL,
`wr_12` varchar(255) NOT NULL,
`wr_13` varchar(255) NOT NULL,
`wr_14` varchar(255) NOT NULL,
`wr_15` varchar(255) NOT NULL,
`wr_16` varchar(255) NOT NULL,
`wr_17` varchar(255) NOT NULL,
`wr_18` varchar(255) NOT NULL,
`wr_19` varchar(255) NOT NULL,
`wr_20` varchar(255) NOT NULL,
`wr_21` varchar(255) NOT NULL,
`wr_22` varchar(255) NOT NULL,
`wr_23` varchar(255) NOT NULL,
`wr_24` varchar(255) NOT NULL,
`wr_25` varchar(255) NOT NULL,
`wr_26` varchar(255) NOT NULL,
`wr_27` varchar(255) NOT NULL,
`wr_28` varchar(255) NOT NULL,
`wr_29` varchar(255) NOT NULL,
`wr_30` varchar(255) NOT NULL,
`wr_31` varchar(255) NOT NULL,
`wr_32` varchar(255) NOT NULL,
`wr_33` varchar(255) NOT NULL,
`wr_34` varchar(255) NOT NULL,
`wr_35` varchar(255) NOT NULL,
`wr_36` varchar(255) NOT NULL,
`wr_37` varchar(255) NOT NULL,
`wr_38` varchar(255) NOT NULL,
`wr_39` varchar(255) NOT NULL,
`wr_40` varchar(255) NOT NULL,
`wr_41` varchar(255) NOT NULL,
`wr_42` varchar(255) NOT NULL,
`wr_43` varchar(255) NOT NULL,
`wr_44` varchar(255) NOT NULL,
`wr_45` varchar(255) NOT NULL,
`wr_46` varchar(255) NOT NULL,
`wr_47` varchar(255) NOT NULL,
`wr_48` varchar(255) NOT NULL,
`wr_49` varchar(255) NOT NULL,
`wr_50` varchar(255) NOT NULL,
`wr_51` varchar(255) NOT NULL,
`wr_52` varchar(255) NOT NULL,
`wr_53` varchar(255) NOT NULL,
`wr_54` varchar(255) NOT NULL,
`wr_55` varchar(255) NOT NULL,
`wr_56` varchar(255) NOT NULL,
`wr_57` varchar(255) NOT NULL,
`wr_58` varchar(255) NOT NULL,
`wr_59` varchar(255) NOT NULL,
`wr_60` varchar(255) NOT NULL,
`wr_61` varchar(255) NOT NULL,
`wr_62` varchar(255) NOT NULL,
`wr_63` varchar(255) NOT NULL,
`wr_64` varchar(255) NOT NULL,
`wr_65` varchar(255) NOT NULL,
`wr_66` varchar(255) NOT NULL,
`wr_67` varchar(255) NOT NULL,
`wr_68` varchar(255) NOT NULL,
`wr_69` varchar(255) NOT NULL,
`wr_70` varchar(255) NOT NULL,
`wr_71` varchar(255) NOT NULL,
`wr_72` varchar(255) NOT NULL,
`wr_73` varchar(255) NOT NULL,
`wr_74` varchar(255) NOT NULL,
`wr_75` varchar(255) NOT NULL,
`wr_76` varchar(255) NOT NULL,
`wr_77` varchar(255) NOT NULL,
`wr_78` varchar(255) NOT NULL,
`wr_79` varchar(255) NOT NULL,
`wr_80` varchar(255) NOT NULL,
`wr_81` varchar(255) NOT NULL,
`wr_82` varchar(255) NOT NULL,
`wr_83` varchar(255) NOT NULL,
`wr_84` varchar(255) NOT NULL,
`wr_85` varchar(255) NOT NULL,
`wr_86` varchar(255) NOT NULL,
`wr_87` varchar(255) NOT NULL,
`wr_88` varchar(255) NOT NULL,
`wr_89` varchar(255) NOT NULL,
`wr_90` varchar(255) NOT NULL,
`wr_91` varchar(255) NOT NULL,
`wr_92` varchar(255) NOT NULL,
`wr_93` varchar(255) NOT NULL,
`wr_94` varchar(255) NOT NULL,
`wr_95` varchar(255) NOT NULL,
`wr_96` varchar(255) NOT NULL,
`wr_97` varchar(255) NOT NULL,
`wr_98` varchar(255) NOT NULL,
`wr_99` varchar(255) NOT NULL,
`wr_100` varchar(255) 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`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
답변 4
테이블의 용량초과입니다.
하찌님의 말씀대로
길게 사용하지 않을거라면
varchar를 text로 바꾸거나
255를 20이나 50등으로 낮추셔도됩니다.
10(성공)-20(성공)-40(성공)-80(실패) 중입니다. 초과라면, 님말씀대로 바꿔봐야겠습니다.
답변 감사합니다. '그누스터디' 가 저에겐 백약이군요 ^^
소스는 문제 없어 보이는데..
혹시 모르니 해당 쿼리를 phpMyAdmin 등에서 직접 넣어 생성 해보시는게 좋을 것 같습니다.
답변 감사합니다.
테이블의 모든 필드의 전체 크기가 한계 인 65535를 초과하여 오류가 발생하는것 같은데요
varchar를 text로 바꾸셔도 될 듯 합니다
https://dev.mysql.com/doc/refman/5.7/en/column-count-limit.html
40개까지는 성공했는데 80개 해보니까 그떄부터 안되네요. 50개가 한돈가 싶기도 하고.
답변을 작성하시기 전에 로그인 해주세요.
