여분필드 추가후 에러가 나옵니다..도움 부탁드립니다. > 그누4 질문답변

그누4 질문답변

그누보드4 관련 질문은 QA 로 이전됩니다. QA 그누보드4 바로가기
기존 게시물은 열람만 가능합니다.

여분필드 추가후 에러가 나옵니다..도움 부탁드립니다. 정보

여분필드 추가후 에러가 나옵니다..도움 부탁드립니다.

본문

기존 스킨에서 여분필드를 15개 정도 추가하고
write.php/view.php/write.update.skin.php 3개 파일을
수정했습니다..
그런데 데이타 입력후 아래와 같은 메세지가 나오고
입력값 업데이트가 안됩니다..
메세지 대로 혹시나 싶어서 wr_30필드를 안 쓰고 수정해도
업데이트가 안되네요...

초보인지라 영 해결할 방도가 안나옵니다..
도움 부탁드립니다..

---- 입력후 저장 누르면 나오는 메세지

update g4_write_bgroup8_14 set wr_30 = '||||||||||||' where wr_id = '203'

1054 : Unknown column 'wr_30' in 'field list'

error file : /bbs/write_update.php


--- 혹시 몰라서 write.update.skin.php 내용 첨부합니다

<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가

$wr_11 = "$ext11_00|$ext11_01|$ext11_02|$ext11_03|$ext11_04|$ext11_05|$ext11_06|$ext11_07|$ext11_08|$ext11_09|$ext11_10|$ext11_11|$ext11_12";
$sql11 = " update $write_table set wr_11 = '$wr_11' where wr_id = '$wr_id' ";
sql_query($sql11);

$wr_12 = "$ext12_00|$ext12_01|$ext12_02|$ext12_03|$ext12_04|$ext12_05|$ext12_06|$ext12_07|$ext12_08|$ext12_09|$ext12_10|$ext12_11|$ext12_12";
$sql12 = " update $write_table set wr_12 = '$wr_12' where wr_id = '$wr_id' ";
sql_query($sql12);

$wr_13 = "$ext13_00|$ext13_01|$ext13_02|$ext13_03|$ext13_04|$ext13_05|$ext13_06|$ext13_07|$ext13_08|$ext13_09|$ext13_10|$ext13_11|$ext13_12";
$sql13 = " update $write_table set wr_13 = '$wr_13' where wr_id = '$wr_id' ";
sql_query($sql13);

$wr_14 = "$ext14_00|$ext14_01|$ext14_02|$ext14_03|$ext14_04|$ext14_05|$ext14_06|$ext14_07|$ext14_08|$ext14_09|$ext14_10|$ext14_11|$ext14_12";
$sql14 = " update $write_table set wr_14 = '$wr_14' where wr_id = '$wr_id' ";
sql_query($sql14);

$wr_15 = "$ext15_00|$ext15_01|$ext15_02|$ext15_03|$ext15_04|$ext15_05|$ext15_06|$ext15_07|$ext15_08|$ext15_09|$ext15_10|$ext15_11|$ext15_12";
$sql15 = " update $write_table set wr_15 = '$wr_15' where wr_id = '$wr_id' ";
sql_query($sql15);

$wr_16 = "$ext16_00|$ext16_01|$ext16_02|$ext16_03|$ext16_04|$ext16_05|$ext16_06|$ext16_07|$ext16_08|$ext16_09|$ext16_10|$ext16_11|$ext16_12";
$sql16 = " update $write_table set wr_16 = '$wr_16' where wr_id = '$wr_id' ";
sql_query($sql16);

$wr_17 = "$ext17_00|$ext17_01|$ext17_02|$ext17_03|$ext17_04|$ext17_05|$ext17_06|$ext17_07|$ext17_08|$ext17_09|$ext17_10|$ext17_11|$ext17_12";
$sql17 = " update $write_table set wr_17 = '$wr_17' where wr_id = '$wr_id' ";
sql_query($sql17);

$wr_18 = "$ext18_00|$ext18_01|$ext18_02|$ext18_03|$ext18_04|$ext18_05|$ext18_06|$ext18_07|$ext18_08|$ext18_09|$ext18_10|$ext18_11|$ext18_12";
$sql18 = " update $write_table set wr_18 = '$wr_18' where wr_id = '$wr_id' ";
sql_query($sql18);

$wr_19 = "$ext19_00|$ext19_01|$ext19_02|$ext19_03|$ext19_04|$ext19_05|$ext19_06|$ext19_07|$ext19_08|$ext19_09|$ext19_10|$ext19_11|$ext19_12";
$sql19 = " update $write_table set wr_19 = '$wr_19' where wr_id = '$wr_id' ";
sql_query($sql19);

$wr_20 = "$ext20_00|$ext20_01|$ext20_02|$ext20_03|$ext20_04|$ext20_05|$ext20_06|$ext20_07|$ext20_08|$ext20_09|$ext20_10|$ext20_11|$ext20_12";
$sql20 = " update $write_table set wr_20 = '$wr_20' where wr_id = '$wr_id' ";
sql_query($sql20);

$wr_21 = "$ext21_00|$ext21_01|$ext21_02|$ext21_03|$ext21_04|$ext21_05|$ext21_06|$ext21_07|$ext21_08|$ext21_09|$ext21_10|$ext21_11|$ext21_12";
$sql21 = " update $write_table set wr_21 = '$wr_21' where wr_id = '$wr_id' ";
sql_query($sql21);

$wr_22 = "$ext22_00|$ext22_01|$ext22_02|$ext22_03|$ext22_04|$ext22_05|$ext22_06|$ext22_07|$ext22_08|$ext22_09|$ext22_10|$ext22_11|$ext22_12";
$sql22 = " update $write_table set wr_22 = '$wr_22' where wr_id = '$wr_id' ";
sql_query($sql22);

$wr_23 = "$ext23_00|$ext23_01|$ext23_02|$ext23_03|$ext23_04|$ext23_05|$ext23_06|$ext23_07|$ext23_08|$ext23_09|$ext23_10|$ext23_11|$ext23_12";
$sql23 = " update $write_table set wr_23 = '$wr_23' where wr_id = '$wr_id' ";
sql_query($sql23);

$wr_24 ="$ext24_00|$ext24_01|$ext24_02|$ext24_03|$ext24_04|$ext24_05|$ext24_06|$ext24_07|$ext24_08|$ext24_09|$ext24_10|$ext24_11|$ext24_12|$ext24_13|$ext24_14|$ext24_15|$ext24_16|$ext24_17|$ext24_18|$ext24_19|$ext24_20|$ext24_21|$ext24_22|$ext24_23";
$sql24 = " update $write_table set wr_24 = '$wr_24' where wr_id = '$wr_id' ";
sql_query($sql24);

$wr_25 = "$ext25_00|$ext25_01|$ext25_02|$ext25_03|$ext25_04|$ext25_05|$ext25_06|$ext25_07|$ext25_08|$ext25_09";
$sql25 = " update $write_table set wr_25 = '$wr_25' where wr_id = '$wr_id' ";
sql_query($sql25);

$wr_26 = "$ext26_00|$ext26_01|$ext26_02|$ext26_03|$ext26_04|$ext26_05|$ext26_06|$ext26_07|$ext26_08|$ext26_09|$ext26_10|$ext26_11|$ext26_12";
$sql26 = " update $write_table set wr_26 = '$wr_26' where wr_id = '$wr_id' ";
sql_query($sql26);

$wr_27 = "$ext27_00|$ext27_01|$ext27_02|$ext27_03|$ext27_04|$ext27_05|$ext27_06|$ext27_07|$ext27_08|$ext27_09|$ext27_10|$ext27_11|$ext27_12";
$sql27 = " update $write_table set wr_27 = '$wr_27' where wr_id = '$wr_id' ";
sql_query($sql27);

$wr_28 = "$ext28_00|$ext28_01|$ext28_02|$ext28_03|$ext28_04|$ext28_05|$ext28_06|$ext28_07|$ext28_08|$ext28_09|$ext28_10|$ext28_11|$ext28_12";
$sql28 = " update $write_table set wr_28 = '$wr_28' where wr_id = '$wr_id' ";
sql_query($sql28);

$wr_29 = "$ext29_00|$ext29_01|$ext29_02|$ext29_03|$ext29_04|$ext29_05|$ext29_06|$ext29_07|$ext29_08|$ext29_09|$ext29_10|$ext29_11|$ext29_12";
$sql29 = " update $write_table set wr_29 = '$wr_29' where wr_id = '$wr_id' ";
sql_query($sql29);

$wr_41 = "$ext41_00|$ext41_01|$ext41_02|$ext41_03|$ext41_04|$ext41_05|$ext41_06|$ext41_07|$ext41_08|$ext41_09|$ext41_10|$ext41_11|$ext41_12";
$sql41 = " update $write_table set wr_41 = '$wr_41' where wr_id = '$wr_id' ";
sql_query($sql41);

$wr_31 = "$ext31_00|$ext31_01|$ext31_02|$ext31_03|$ext31_04|$ext31_05|$ext31_06|$ext31_07|$ext31_08|$ext31_09|$ext31_10|$ext31_11|$ext31_12";
$sql31 = " update $write_table set wr_31 = '$wr_31' where wr_id = '$wr_id' ";
sql_query($sql31);

$wr_32 = "$ext32_00|$ext32_01|$ext32_02|$ext32_03|$ext32_04|$ext32_05|$ext32_06|$ext32_07|$ext32_08|$ext32_09|$ext32_10|$ext32_11|$ext32_12";
$sql32 = " update $write_table set wr_32 = '$wr_32' where wr_id = '$wr_id' ";
sql_query($sql32);

$wr_33 = "$ext33_00|$ext33_01|$ext33_02|$ext33_03|$ext33_04|$ext33_05|$ext33_06|$ext33_07|$ext33_08|$ext33_09|$ext33_10|$ext33_11|$ext33_12";
$sql33 = " update $write_table set wr_33 = '$wr_33' where wr_id = '$wr_id' ";
sql_query($sql33);

$wr_34 = "$ext34_00|$ext34_01|$ext34_02|$ext34_03|$ext34_04|$ext34_05|$ext34_06|$ext34_07|$ext34_08|$ext34_09|$ext34_10|$ext34_11|$ext34_12";
$sql34 = " update $write_table set wr_34 = '$wr_34' where wr_id = '$wr_id' ";
sql_query($sql34);

$wr_35 = "$ext35_00|$ext35_01|$ext35_02|$ext35_03|$ext35_04|$ext35_05|$ext35_06|$ext35_07|$ext35_08|$ext35_09|$ext35_10|$ext35_11|$ext35_12";
$sql35 = " update $write_table set wr_35 = '$wr_35' where wr_id = '$wr_id' ";
sql_query($sql35);

$wr_36 = "$ext36_00|$ext36_01|$ext36_02|$ext36_03|$ext36_04|$ext36_05|$ext36_06|$ext36_07|$ext36_08|$ext36_09|$ext36_10|$ext36_11|$ext36_12";
$sql36 = " update $write_table set wr_36 = '$wr_36' where wr_id = '$wr_id' ";
sql_query($sql36);

$wr_37 = "$ext37_00|$ext37_01|$ext37_02|$ext37_03|$ext37_04|$ext37_05|$ext37_06|$ext37_07|$ext37_08|$ext37_09|$ext37_10|$ext37_11|$ext37_12";
$sql37 = " update $write_table set wr_37 = '$wr_37' where wr_id = '$wr_id' ";
sql_query($sql37);

$sql38 = " update $write_table set wr_38 = '$wr_38' where wr_id = '$wr_id' ";
sql_query($sql38);

$sql39 = " update $write_table set wr_39 = '$wr_39' where wr_id = '$wr_id' ";
sql_query($sql39);

$sql40 = " update $write_table set wr_40 = '$wr_40' where wr_id = '$wr_id' ";
sql_query($sql40);


if ($w == "u"){


    if ($sca) {
 goto_url("./board.php?bo_table=$bo_table&wr_id=$write[wr_id]&sca=$write[ca_name]");  
  } else if ($wr_08) {
 goto_url("./board.php?bo_table=$bo_table&wr_id=$write[wr_id]&wr_08=$write[wr_8]");
 } else if ($wr_09) {
 goto_url("./board.php?bo_table=$bo_table&wr_id=$write[wr_id]&wr_09=$write[wr_9]");
 } else if ($wr_010) {
 goto_url("./board.php?bo_table=$bo_table&wr_id=$write[wr_id]&wr_010=$write[wr_10]");
 } else {
 goto_url("./board.php?bo_table=$bo_table&wr_id={$write[wr_id]}");
 }

}
?>

  • 복사

댓글 전체

디비 테이블에 컬럼 추가는 어떻게 하는지 ?...;
워낙 초보라 ㅈㅅ
링크해주신 글 따라가 읽어보았으나 해당되는 내용도 없는것 같고
어찌해야할지 잘 모르겠습니다...;;
© SIRSOFT
현재 페이지 제일 처음으로