스킨이 압데이트 하라는 메세지가 출력 됩니다.
아래 보험 설계 스킨을 적용 하였는데요..
입력하고 나면 업데이트 하라는 메세지가 뜹니다.
스킨은
에러 메세지는
insert into g4_write_z6_1 set wr_11 = '알리안츠', wr_12 = '', wr_13 = '', wr_14 = '111222', wr_15 = '1235545', wr_16 = '', wr_17 = '', wr_18 = '남자', wr_19 = '', wr_20 = '', wr_21 = '남자', wr_22 = '', wr_23 = '', wr_24 = '남자', wr_25 = '', wr_26 = '', wr_27 = '남자', wr_28 = '', wr_29 = '', wr_30 = '남자', wr_31 = '333', wr_32 = '3333', wr_33 = '3333', wr_34 = '010', wr_35 = '2222', wr_36 = '2222', wr_37 = '법조인', wr_38 = '변호사', wr_39 = '비흡연', wr_40 = '결혼예정', wr_41 = '3명', wr_42 = '서울', wr_43 = '잠실', wr_44 = '150만원이하', wr_45 = '5~10만원', wr_46 = '전화+이메일', wr_47 = '1월', wr_48 = '1일', wr_49 = '점심 12:00 ~ 01:00', wr_50 = ''
1054 : Unknown 칼럼 'wr_11' in 'field list'
error file : /bbs/write_update.php
이것을 어떻게 하라는 것인지 알 수가 없네요..
저는 초보입니다.
|
댓글을 작성하시려면 로그인이 필요합니다.
로그인
댓글 5개
db_plus.php
<?
include_once("./_common.php");
include_once("./_head.php");
//wr_11 ~15필드 늘리기
sql_fetch(" alter table g4_write_테이블명 add wr_11 text ");
sql_fetch(" alter table g4_write_테이블명 add wr_12 text ");
sql_fetch(" alter table g4_write_테이블명 add wr_13 text ");
sql_fetch(" alter table g4_write_테이블명 add wr_14 text ");
sql_fetch(" alter table g4_write_테이블명 add wr_15 text ");
include_once("./_tail.php");
?>
위 내용을 저장한후
http://홈페이지/db_plus.php
------------------------------------------------------------------------------------------------------------------------
보너스팩
반대로 삭제하기..
db_drop.php
<?
include_once("./_common.php");
include_once("./_head.php");
//wr_11 ~15필드 삭제하기
sql_fetch(" alter table g4_write_테이블명 drop wr_11 text ");
sql_fetch(" alter table g4_write_테이블명 drop wr_12 text ");
sql_fetch(" alter table g4_write_테이블명 drop wr_13 text ");
sql_fetch(" alter table g4_write_테이블명 drop wr_14 text ");
sql_fetch(" alter table g4_write_테이블명 drop wr_15 text ");
include_once("./_tail.php");
?>
위 내용을 저장한후
http://홈페이지/db_drop.php
---------------------------
write_update.skin.php
$wr_11 = "$wr_11";
$sql11 = " update $write_table set wr_11 = '$wr_11' where wr_id = '$wr_id' ";
sql_query($sql11);
계속 여러개 만들어 주세요...빠진 필드를 만드세요..
개념이 없어서 다시 질문 드립니다. 아래 스킨에
write_update.skin.php
다음 내용으로 수정하고 db_plus.php 를 실행 하니까 이런 에러가 나옵니다.
alter table g4_write_테이블명 add wr_11 text
1146 : 테이블 'ganaaech2222.g4_write_테이블명' 는 존재하지 않습니다.
error file : /db_plus.php
스킨을 수정하였는데요..잘 하였는지 모르겠습니다.
한번 봐 주세요..write_update.skin.php
<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
// 자신만의 코드를 넣어주세요.
if(!$wr_comment) { // 코멘일때는 저장하면 안됩.
$wr_11 = "$wr_11";
$sql11 = " update $write_table set wr_11 = '$wr_11' where wr_id = '$wr_id' ";
sql_query($sql1);
$wr_12 = "$wr_12";
$sql12 = " update $write_table set wr_12 = '$wr_12' where wr_id = '$wr_id' ";
sql_query($sql12);
$wr_13 = "$wr_13";
$sql13 = " update $write_table set wr_13 = '$wr_13' where wr_id = '$wr_id' ";
sql_query($sql13);
$wr_14 = "$wr_14";
$sql14 = " update $write_table set wr_14 = '$wr_14' where wr_id = '$wr_id' ";
sql_query($sql14);
$wr_15 = "$wr_15";
$sql15 = " update $write_table set wr_15 = '$wr_15' where wr_id = '$wr_id' ";
sql_query($sql15);
wr_16 = '$wr_16',
wr_17 = '$wr_17',
wr_18 = '$wr_18',
wr_19 = '$wr_19',
wr_20 = '$wr_20',
wr_21 = '$wr_21',
wr_22 = '$wr_22',
wr_23 = '$wr_23',
wr_24 = '$wr_24',
wr_25 = '$wr_25',
wr_26 = '$wr_26',
wr_27 = '$wr_27',
wr_28 = '$wr_28',
wr_29 = '$wr_29',
wr_30 = '$wr_30',
wr_31 = '$wr_31',
wr_32 = '$wr_32',
wr_33 = '$wr_33',
wr_34 = '$wr_34',
wr_35 = '$wr_35',
wr_36 = '$wr_36',
wr_37 = '$wr_37',
wr_38 = '$wr_38',
wr_39 = '$wr_39',
wr_40 = '$wr_40',
wr_41 = '$wr_41',
wr_42 = '$wr_42',
wr_43 = '$wr_43',
wr_44 = '$wr_44',
wr_45 = '$wr_45',
wr_46 = '$wr_46',
wr_47 = '$wr_47',
wr_48 = '$wr_48',
wr_49 = '$wr_49',
wr_50 = '$wr_50' ";
sql_query($sql);
$wr_11 = "$wr_11";
$sql11 = " update $write_table set wr_11 = '$wr_11' where wr_id = '$wr_id' ";
sql_query($sql1);
$wr_12 = "$wr_12";
$sql12 = " update $write_table set wr_12 = '$wr_12' where wr_id = '$wr_id' ";
sql_query($sql12);
$wr_13 = "$wr_13";
$sql13 = " update $write_table set wr_13 = '$wr_13' where wr_id = '$wr_id' ";
sql_query($sql13);
$wr_14 = "$wr_14";
$sql14 = " update $write_table set wr_14 = '$wr_14' where wr_id = '$wr_id' ";
sql_query($sql14);
$wr_15 = "$wr_15";
$sql15 = " update $write_table set wr_15 = '$wr_15' where wr_id = '$wr_id' ";
sql_query($sql15);
wr_16 = '$wr_16',
wr_17 = '$wr_17',
wr_18 = '$wr_18',
wr_19 = '$wr_19',
wr_20 = '$wr_20',
wr_21 = '$wr_21',
wr_22 = '$wr_22',
wr_23 = '$wr_23',
wr_24 = '$wr_24',
wr_25 = '$wr_25',
wr_26 = '$wr_26',
wr_27 = '$wr_27',
wr_28 = '$wr_28',
wr_29 = '$wr_29',
wr_30 = '$wr_30',
wr_31 = '$wr_31',
wr_32 = '$wr_32',
wr_33 = '$wr_33',
wr_34 = '$wr_34',
wr_35 = '$wr_35',
wr_36 = '$wr_36',
wr_37 = '$wr_37',
wr_38 = '$wr_38',
wr_39 = '$wr_39',
wr_40 = '$wr_40',
wr_41 = '$wr_41',
wr_42 = '$wr_42',
wr_43 = '$wr_43',
wr_44 = '$wr_44',
wr_45 = '$wr_45',
wr_46 = '$wr_46',
wr_47 = '$wr_47',
wr_48 = '$wr_48',
wr_49 = '$wr_49',
wr_50 = '$wr_50' ";
sql_query($sql);
}
?>
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
// 자신만의 코드를 넣어주세요.
$wr_11 = "$wr_11";
$sql11 = " update $write_table set wr_11 = '$wr_11' where wr_id = '$wr_id' ";
sql_query($sql11);
$wr_12 = "$wr_12";
$sql12 = " update $write_table set wr_12 = '$wr_12' where wr_id = '$wr_id' ";
sql_query($sql12);
부터
$wr_50 = "$wr_50";
$sql50 = " update $write_table set wr_50 = '$wr_50' where wr_id = '$wr_id' ";
sql_query($sql50);
?>
----------------------------------------------
db_drop.php
<?
include_once("./_common.php");
include_once("./_head.php");
//wr_11 ~15필드 삭제하기
sql_fetch(" alter table g4_write_테이블명 drop wr_11 text "); <<~~테이블이름을 적으세요
sql_fetch(" alter table g4_write_테이블명 drop wr_12 text ");
sql_fetch(" alter table g4_write_테이블명 drop wr_13 text ");
sql_fetch(" alter table g4_write_테이블명 drop wr_14 text ");
sql_fetch(" alter table g4_write_테이블명 drop wr_15 text ");
include_once("./_tail.php");
?>
예) 테이블 이름이 abc인 경우
sql_fetch(" alter table g4_write_abc drop wr_11 text ");
sql_fetch(" alter table g4_write_abc drop wr_12 text ");
설명 하신데로 삽질하여 작업 하였는데요..
이런 오류메세지가 뜹니다.여기에도 뭘 추가하라는 뜻인가요?
update g4_write_z6_1 set wr_11 = '' where wr_id = '8'
1054 : Unknown 칼럼 'wr_11' in 'field list'
error file : /bbs/write_update.php