코멘트가 10자만 나오고 잘리는 현상.. 정보
코멘트가 10자만 나오고 잘리는 현상..본문
오류가 나는곳의 주소를 알려주시면 더 빠르고 정확하게 답변 받을 수 있습니다.
오류 주소 :
코멘트가 10자만 나오고 잘리는현상이 있어서요
그동안 그냥 썼는데 너무 불편해서 고치려고 하는데요..
스킨 만든분이 해당 필드는 TEXT로 해주면 된다고 하는데 어느 부분을 TEXT로 해줘야 되는건가요?
그리고 DB에서 wr_comment 를 text로 수정해 봤지만 에러 어쩌고 드면서 변경이 안돼던데요.
아시는 분 방법 좀 부탁드립니다
change 로 들어가서 Type, Length/Set, Attributes, Null, Default Extra 이건 각각 뭘 넣으면 되나요
Field Type Attributes Null Default Extra Action
wr_id int(11) No auto_increment Change Drop Primary Index Unique
wr_num int(11) No 0 Change Drop Primary Index Unique
wr_reply varchar(10) No Change Drop Primary Index Unique
wr_parent int(11) No 0 Change Drop Primary Index Unique
wr_is_comment tinyint(4) No 0 Change Drop Primary Index Unique
wr_comment int(11) No 0 Change Drop Primary Index Unique
wr_comment_reply varchar(5) No Change Drop Primary Index Unique
ca_name varchar(255) No Change Drop Primary Index Unique
wr_option set('html1', 'html2', 'secret', 'mail') No Change Drop Primary Index Unique
wr_subject varchar(255) No Change Drop Primary Index Unique
wr_content text No Change Drop Primary Index Unique
wr_link1 text No Change Drop Primary Index Unique
wr_link2 text No Change Drop Primary Index Unique
wr_link1_hit int(11) No 0 Change Drop Primary Index Unique
wr_link2_hit int(11) No 0 Change Drop Primary Index Unique
wr_trackback varchar(255) No Change Drop Primary Index Unique
wr_hit int(11) No 0 Change Drop Primary Index Unique
wr_good int(11) No 0 Change Drop Primary Index Unique
wr_nogood int(11) No 0 Change Drop Primary Index Unique
mb_id varchar(255) No Change Drop Primary Index Unique
wr_password varchar(255) No Change Drop Primary Index Unique
wr_name varchar(255) No Change Drop Primary Index Unique
wr_email varchar(255) No Change Drop Primary Index Unique
wr_homepage varchar(255) No Change Drop Primary Index Unique
wr_datetime datetime No 0000-00-00 00:00:00 Change Drop Primary Index Unique
wr_last varchar(19) No Change Drop Primary Index Unique
wr_ip varchar(255) No Change Drop Primary Index Unique
wr_1 varchar(255) No Change Drop Primary Index Unique
wr_2 varchar(255) No Change Drop Primary Index Unique
wr_3 varchar(255) No Change Drop Primary Index Unique
wr_4 varchar(255) No Change Drop Primary Index Unique
wr_5 varchar(255) No Change Drop Primary Index Unique
wr_6 varchar(255) No Change Drop Primary Index Unique
wr_7 varchar(255) No Change Drop Primary Index Unique
wr_8 varchar(255) No Change Drop Primary Index Unique
wr_9 varchar(255) No Change Drop Primary Index Unique
wr_10 varchar(255) No Change Drop Primary Index Unique
array1_0 varchar(20) No Change Drop Primary Index Unique
array1_1 varchar(20) No Change Drop Primary Index Unique
array1_2 varchar(20) No Change Drop Primary Index Unique
array1_3 varchar(20) No Change Drop Primary Index Unique
array1_4 varchar(20) No Change Drop Primary Index Unique
array2_0 varchar(20) No Change Drop Primary Index Unique
array2_1 varchar(20) No Change Drop Primary Index Unique
array2_2 varchar(20) No Change Drop Primary Index Unique
array2_3 varchar(20) No Change Drop Primary Index Unique
array2_4 varchar(20) No Change Drop Primary Index Unique
array2_5 varchar(20) No Change Drop Primary Index Unique
오류 주소 :
코멘트가 10자만 나오고 잘리는현상이 있어서요
그동안 그냥 썼는데 너무 불편해서 고치려고 하는데요..
스킨 만든분이 해당 필드는 TEXT로 해주면 된다고 하는데 어느 부분을 TEXT로 해줘야 되는건가요?
그리고 DB에서 wr_comment 를 text로 수정해 봤지만 에러 어쩌고 드면서 변경이 안돼던데요.
아시는 분 방법 좀 부탁드립니다
change 로 들어가서 Type, Length/Set, Attributes, Null, Default Extra 이건 각각 뭘 넣으면 되나요
Field Type Attributes Null Default Extra Action
wr_id int(11) No auto_increment Change Drop Primary Index Unique
wr_num int(11) No 0 Change Drop Primary Index Unique
wr_reply varchar(10) No Change Drop Primary Index Unique
wr_parent int(11) No 0 Change Drop Primary Index Unique
wr_is_comment tinyint(4) No 0 Change Drop Primary Index Unique
wr_comment int(11) No 0 Change Drop Primary Index Unique
wr_comment_reply varchar(5) No Change Drop Primary Index Unique
ca_name varchar(255) No Change Drop Primary Index Unique
wr_option set('html1', 'html2', 'secret', 'mail') No Change Drop Primary Index Unique
wr_subject varchar(255) No Change Drop Primary Index Unique
wr_content text No Change Drop Primary Index Unique
wr_link1 text No Change Drop Primary Index Unique
wr_link2 text No Change Drop Primary Index Unique
wr_link1_hit int(11) No 0 Change Drop Primary Index Unique
wr_link2_hit int(11) No 0 Change Drop Primary Index Unique
wr_trackback varchar(255) No Change Drop Primary Index Unique
wr_hit int(11) No 0 Change Drop Primary Index Unique
wr_good int(11) No 0 Change Drop Primary Index Unique
wr_nogood int(11) No 0 Change Drop Primary Index Unique
mb_id varchar(255) No Change Drop Primary Index Unique
wr_password varchar(255) No Change Drop Primary Index Unique
wr_name varchar(255) No Change Drop Primary Index Unique
wr_email varchar(255) No Change Drop Primary Index Unique
wr_homepage varchar(255) No Change Drop Primary Index Unique
wr_datetime datetime No 0000-00-00 00:00:00 Change Drop Primary Index Unique
wr_last varchar(19) No Change Drop Primary Index Unique
wr_ip varchar(255) No Change Drop Primary Index Unique
wr_1 varchar(255) No Change Drop Primary Index Unique
wr_2 varchar(255) No Change Drop Primary Index Unique
wr_3 varchar(255) No Change Drop Primary Index Unique
wr_4 varchar(255) No Change Drop Primary Index Unique
wr_5 varchar(255) No Change Drop Primary Index Unique
wr_6 varchar(255) No Change Drop Primary Index Unique
wr_7 varchar(255) No Change Drop Primary Index Unique
wr_8 varchar(255) No Change Drop Primary Index Unique
wr_9 varchar(255) No Change Drop Primary Index Unique
wr_10 varchar(255) No Change Drop Primary Index Unique
array1_0 varchar(20) No Change Drop Primary Index Unique
array1_1 varchar(20) No Change Drop Primary Index Unique
array1_2 varchar(20) No Change Drop Primary Index Unique
array1_3 varchar(20) No Change Drop Primary Index Unique
array1_4 varchar(20) No Change Drop Primary Index Unique
array2_0 varchar(20) No Change Drop Primary Index Unique
array2_1 varchar(20) No Change Drop Primary Index Unique
array2_2 varchar(20) No Change Drop Primary Index Unique
array2_3 varchar(20) No Change Drop Primary Index Unique
array2_4 varchar(20) No Change Drop Primary Index Unique
array2_5 varchar(20) No Change Drop Primary Index Unique
댓글 전체
wr_reply 부분인 것 같은데요?... 아래와 같이 바꾸면 되지 않을까요?
wr_reply varchar(10) No Change Drop Primary Index Unique => wr_reply text No Change Drop Primary Index Unique
wr_reply varchar(10) No Change Drop Primary Index Unique => wr_reply text No Change Drop Primary Index Unique
바꿔도 여전히 10자만 나오네요..왜그러지..
phpmyadmin으로 접속하시고 수정을 원하시는 테이블을 선택합니다.
구조 (structure) 를 찾아 선택 한 후 해당 필드의 실행(Action) 부분의 연필 부분을 선택하여
종류(Type) 를 LONGTEXT로 변경 그리고 저장(Save) 합니다.
결론은 Type 에서 int(11) 으로 되어 있는것은
text, mediumtext, longtext 세가지중 하나로 입력하고 저장 하시면 됩니다.
구조 (structure) 를 찾아 선택 한 후 해당 필드의 실행(Action) 부분의 연필 부분을 선택하여
종류(Type) 를 LONGTEXT로 변경 그리고 저장(Save) 합니다.
결론은 Type 에서 int(11) 으로 되어 있는것은
text, mediumtext, longtext 세가지중 하나로 입력하고 저장 하시면 됩니다.