제가 앞에 카테고리별로 히트외할인상품 리스트를 선택해서 노출비노출을 시도했는데요 그걸 참고해서 이벤트역시 만들어봤는데요 노출과 비노출은 먹히는데 이벤트의 아이디를 설정에서 간단하게 입력하려고 해봤는데 아레퍼럼 에러만 나는군요 방법을 잘모르겠내요...ㅠㅠ 어느부분을 수정해야할까요..ㅠㅠ
1054 : Unknown column 'de_type11_list_ev_id' in 'field list'
error file : /adm/shop_admin/configformupdate.php
이벤트 아이디를 입력해야하는데...
adm/shop_admin/configform.php파일의
<section id="anc_scf_index"> <h2 class="h2_frm">쇼핑몰 초기화면</h2> <?php echo $pg_anchor; ?> <div class="local_desc02 local_desc"> <p> 상품관리에서 선택한 상품의 타입대로 쇼핑몰 초기화면에 출력합니다. (상품 타입 히트/추천/최신/인기/할인)<br> 각 타입별로 선택된 상품이 없으면 쇼핑몰 초기화면에 출력하지 않습니다. </p> </div> <div class="tbl_frm01 tbl_wrap"> <table> <caption>쇼핑몰 초기화면 설정</caption> <colgroup> <col class="grid_4"> <col> </colgroup> <tbody> <tr> <th scope="row">이벤트 상품출력</th> <td> <label for="de_type11_list_use">출력</label> <input type="checkbox" name="de_type11_list_use" value="1" id="de_type11_list_use" <?php echo $default['de_type11_list_use']?"checked":""; ?>> <label for="de_type11_list_ev_id">이벤트아이디</label> <input type="text" name="de_type11_list_ev_id" value="<?php echo $default["de_type11_list_ev_id"]; ?>" id="<?php echo $row['ev_id']; ?>" class="frm_input" size="10"> <label for="de_type11_list_skin">스킨</label> <select name="de_type11_list_skin" id="de_type11_list_skin"> <?php echo get_list_skin_options("main.50.skin.php", G5_SHOP_SKIN_PATH, $default['de_type11_list_skin']); ?> </select> <label for="de_type11_list_mod">1줄당 이미지 수</label> <input type="text" name="de_type11_list_mod" value="<?php echo $default['de_type11_list_mod']; ?>" id="de_type11_list_mod" class="frm_input" size="3"> <label for="de_type11_list_row">출력할 줄 수</label> <input type="text" name="de_type11_list_row" value="<?php echo $default['de_type11_list_row']; ?>" id="de_type11_list_row" class="frm_input" size="3"> <label for="de_type11_img_width">이미지 폭</label> <input type="text" name="de_type11_img_width" value="<?php echo $default['de_type11_img_width']; ?>" id="de_type11_img_width" class="frm_input" size="3"> <label for="de_type11_img_height">이미지 높이</label> <input type="text" name="de_type11_img_height" value="<?php echo $default['de_type11_img_height']; ?>" id="de_type11_img_height" class="frm_input" size="3"> </td> </tr> <tr> <th scope="row">히트상품출력</th> <td> <label for="de_type1_list_use">출력</label> <input type="checkbox" name="de_type1_list_use" value="1" id="de_type1_list_use" <?php echo $default['de_type1_list_use']?"checked":""; ?>> <label for="de_type1_list_skin">스킨</label> <select name="de_type1_list_skin" id="de_type1_list_skin"> <?php echo get_list_skin_options("^main.[0-9]+\.skin\.php", G5_SHOP_SKIN_PATH, $default['de_type1_list_skin']); ?> </select> <label for="de_type1_list_mod">1줄당 이미지 수</label> <input type="text" name="de_type1_list_mod" value="<?php echo $default['de_type1_list_mod']; ?>" id="de_type1_list_mod" class="frm_input" size="3"> <label for="de_type1_list_row">출력할 줄 수</label> <input type="text" name="de_type1_list_row" value="<?php echo $default['de_type1_list_row']; ?>" id="de_type1_list_row" class="frm_input" size="3"> <label for="de_type1_img_width">이미지 폭</label> <input type="text" name="de_type1_img_width" value="<?php echo $default['de_type1_img_width']; ?>" id="de_type1_img_width" class="frm_input" size="3"> <label for="de_type1_img_height">이미지 높이</label> <input type="text" name="de_type1_img_height" value="<?php echo $default['de_type1_img_height']; ?>" id="de_type1_img_height" class="frm_input" size="3"> </td> </tr> <tr> <th scope="row">추천상품출력</th> <td> <label for="de_type2_list_use">출력</label> <input type="checkbox" name="de_type2_list_use" value="1" id="de_type2_list_use" <?php echo $default['de_type2_list_use']?"checked":""; ?>> <label for="de_type2_list_skin">스킨</label> <select name="de_type2_list_skin" id="de_type2_list_skin"> <?php echo get_list_skin_options("^main.[0-9]+\.skin\.php", G5_SHOP_SKIN_PATH, $default['de_type2_list_skin']); ?> </select> <label for="de_type2_list_mod">1줄당 이미지 수</label> <input type="text" name="de_type2_list_mod" value="<?php echo $default['de_type2_list_mod']; ?>" id="de_type2_list_mod" class="frm_input" size="3"> <label for="de_type2_list_row">출력할 줄 수</label> <input type="text" name="de_type2_list_row" value="<?php echo $default['de_type2_list_row']; ?>" id="de_type2_list_row" class="frm_input" size="3"> <label for="de_type2_img_width">이미지 폭</label> <input type="text" name="de_type2_img_width" value="<?php echo $default['de_type2_img_width']; ?>" id="de_type2_img_width" class="frm_input" size="3"> <label for="de_type2_img_height">이미지 높이</label> <input type="text" name="de_type2_img_height" value="<?php echo $default['de_type2_img_height']; ?>" id="de_type2_img_height" class="frm_input" size="3"> </td> </tr> <tr> <th scope="row">최신상품출력</th> <td> <label for="de_type3_list_use">출력</label> <input type="checkbox" name="de_type3_list_use" value="1" id="de_type3_list_use" <?php echo $default['de_type3_list_use']?"checked":""; ?>> <label for="de_type3_list_skin">스킨</label> <select name="de_type3_list_skin" id="de_type3_list_skin"> <?php echo get_list_skin_options("^main.[0-9]+\.skin\.php", G5_SHOP_SKIN_PATH, $default['de_type3_list_skin']); ?> </select> <label for="de_type3_list_mod">1줄당 이미지 수</label> <input type="text" name="de_type3_list_mod" value="<?php echo $default['de_type3_list_mod']; ?>" id="de_type3_list_mod" class="frm_input" size="3"> <label for="de_type3_list_row">출력할 줄 수</label> <input type="text" name="de_type3_list_row" value="<?php echo $default['de_type3_list_row']; ?>" id="de_type3_list_row" class="frm_input" size="3"> <label for="de_type3_img_width">이미지 폭</label> <input type="text" name="de_type3_img_width" value="<?php echo $default['de_type3_img_width']; ?>" id="de_type3_img_width" class="frm_input" size="3"> <label for="de_type3_img_height">이미지 높이</label> <input type="text" name="de_type3_img_height" value="<?php echo $default['de_type3_img_height']; ?>" id="de_type3_img_height" class="frm_input" size="3"> </td> </tr> <tr> <th scope="row">인기상품출력</th> <td> <label for="de_type4_list_use">출력</label> <input type="checkbox" name="de_type4_list_use" value="1" id="de_type4_list_use" <?php echo $default['de_type4_list_use']?"checked":""; ?>> <label for="de_type4_list_skin">스킨</label> <select name="de_type4_list_skin" id="de_type4_list_skin"> <?php echo get_list_skin_options("^main.[0-9]+\.skin\.php", G5_SHOP_SKIN_PATH, $default['de_type4_list_skin']); ?> </select> <label for="de_type4_list_mod">1줄당 이미지 수</label> <input type="text" name="de_type4_list_mod" value="<?php echo $default['de_type4_list_mod']; ?>" id="de_type4_list_mod" class="frm_input" size="3"> <label for="de_type4_list_row">출력할 줄 수</label> <input type="text" name="de_type4_list_row" value="<?php echo $default['de_type4_list_row']; ?>" id="de_type4_list_row" class="frm_input" size="3"> <label for="de_type4_img_width">이미지 폭</label> <input type="text" name="de_type4_img_width" value="<?php echo $default['de_type4_img_width']; ?>" id="de_type4_img_width" class="frm_input" size="3"> <label for="de_type4_img_height">이미지 높이</label> <input type="text" name="de_type4_img_height" value="<?php echo $default['de_type4_img_height']; ?>" id="de_type4_img_height" class="frm_input" size="3"> </td> </tr> <tr> <th scope="row">할인상품출력</th> <td> <label for="de_type5_list_use">출력</label> <input type="checkbox" name="de_type5_list_use" value="1" id="de_type5_list_use" <?php echo $default['de_type5_list_use']?"checked":""; ?>> <label for="de_type5_list_skin">스킨</label> <select name="de_type5_list_skin" id="de_type5_list_skin"> <?php echo get_list_skin_options("^main.[0-9]+\.skin\.php", G5_SHOP_SKIN_PATH, $default['de_type5_list_skin']); ?> </select> <label for="de_type5_list_mod">1줄당 이미지 수</label> <input type="text" name="de_type5_list_mod" value="<?php echo $default['de_type5_list_mod']; ?>" id="de_type5_list_mod" class="frm_input" size="3"> <label for="de_type5_list_row">출력할 줄 수</label> <input type="text" name="de_type5_list_row" value="<?php echo $default['de_type5_list_row']; ?>" id="de_type5_list_row" class="frm_input" size="3"> <label for="de_type5_img_width">이미지 폭</label> <input type="text" name="de_type5_img_width" value="<?php echo $default['de_type5_img_width']; ?>" id="de_type5_img_width" class="frm_input" size="3"> <label for="de_type5_img_height">이미지 높이</label> <input type="text" name="de_type5_img_height" value="<?php echo $default['de_type5_img_height']; ?>" id="de_type5_img_height" class="frm_input" size="3"> </td> </tr> </tbody> </table> </div></section> <?php echo preg_replace('#</div>$#i', '<button type="button" class="shop_pc_index">테마설정 가져오기</button></div>', $frm_submit); ?>
그리고adm/shop_admin/configformupdate.php
de_type1_list_use = '{$_POST['de_type1_list_use']}', de_type1_list_skin = '{$_POST['de_type1_list_skin']}', de_type1_list_mod = '{$_POST['de_type1_list_mod']}', de_type1_list_row = '{$_POST['de_type1_list_row']}', de_type1_img_width = '{$_POST['de_type1_img_width']}', de_type1_img_height = '{$_POST['de_type1_img_height']}', de_type2_list_use = '{$_POST['de_type2_list_use']}', de_type2_list_skin = '{$_POST['de_type2_list_skin']}', de_type2_list_mod = '{$_POST['de_type2_list_mod']}', de_type2_list_row = '{$_POST['de_type2_list_row']}', de_type2_img_width = '{$_POST['de_type2_img_width']}', de_type2_img_height = '{$_POST['de_type2_img_height']}', de_type3_list_use = '{$_POST['de_type3_list_use']}', de_type3_list_skin = '{$_POST['de_type3_list_skin']}', de_type3_list_mod = '{$_POST['de_type3_list_mod']}', de_type3_list_row = '{$_POST['de_type3_list_row']}', de_type3_img_width = '{$_POST['de_type3_img_width']}', de_type3_img_height = '{$_POST['de_type3_img_height']}', de_type4_list_use = '{$_POST['de_type4_list_use']}', de_type4_list_skin = '{$_POST['de_type4_list_skin']}', de_type4_list_mod = '{$_POST['de_type4_list_mod']}', de_type4_list_row = '{$_POST['de_type4_list_row']}', de_type4_img_width = '{$_POST['de_type4_img_width']}', de_type4_img_height = '{$_POST['de_type4_img_height']}', de_type5_list_use = '{$_POST['de_type5_list_use']}', de_type5_list_skin = '{$_POST['de_type5_list_skin']}', de_type5_list_mod = '{$_POST['de_type5_list_mod']}', de_type5_list_row = '{$_POST['de_type5_list_row']}', de_type5_img_width = '{$_POST['de_type5_img_width']}', de_type5_img_height = '{$_POST['de_type5_img_height']}', de_type6_list_use = '{$_POST['de_type6_list_use']}', de_type6_list_skin = '{$_POST['de_type6_list_skin']}', de_type6_list_mod = '{$_POST['de_type6_list_mod']}', de_type6_list_row = '{$_POST['de_type6_list_row']}', de_type6_img_width = '{$_POST['de_type6_img_width']}', de_type6_img_height = '{$_POST['de_type6_img_height']}', de_type7_list_use = '{$_POST['de_type7_list_use']}', de_type7_list_skin = '{$_POST['de_type7_list_skin']}', de_type7_list_mod = '{$_POST['de_type7_list_mod']}', de_type7_list_row = '{$_POST['de_type7_list_row']}', de_type7_img_width = '{$_POST['de_type7_img_width']}', de_type7_img_height = '{$_POST['de_type7_img_height']}', de_type8_list_use = '{$_POST['de_type8_list_use']}', de_type8_list_skin = '{$_POST['de_type8_list_skin']}', de_type8_list_mod = '{$_POST['de_type8_list_mod']}', de_type8_list_row = '{$_POST['de_type8_list_row']}', de_type8_img_width = '{$_POST['de_type8_img_width']}', de_type8_img_height = '{$_POST['de_type8_img_height']}', de_type9_list_use = '{$_POST['de_type9_list_use']}', de_type9_list_skin = '{$_POST['de_type9_list_skin']}', de_type9_list_mod = '{$_POST['de_type9_list_mod']}', de_type9_list_row = '{$_POST['de_type9_list_row']}', de_type9_img_width = '{$_POST['de_type9_img_width']}', de_type9_img_height = '{$_POST['de_type9_img_height']}', de_type10_list_use = '{$_POST['de_type10_list_use']}', de_type10_list_skin = '{$_POST['de_type10_list_skin']}', de_type10_list_mod = '{$_POST['de_type10_list_mod']}', de_type10_list_row = '{$_POST['de_type10_list_row']}', de_type10_img_width = '{$_POST['de_type10_img_width']}', de_type10_img_height = '{$_POST['de_type10_img_height']}', de_type11_list_ev_id = '{$_POST['de_type11_list_ev_id']}', de_type11_list_use = '{$_POST['de_type11_list_use']}', de_type11_list_skin = '{$_POST['de_type11_list_skin']}', de_type11_list_mod = '{$_POST['de_type11_list_mod']}', de_type11_list_row = '{$_POST['de_type11_list_row']}', de_type11_img_width = '{$_POST['de_type11_img_width']}', de_type11_img_height = '{$_POST['de_type11_img_height']}', de_mobile_type1_list_use = '{$_POST['de_mobile_type1_list_use']}', de_mobile_type1_list_skin = '{$_POST['de_mobile_type1_list_skin']}', de_mobile_type1_list_mod = '{$_POST['de_mobile_type1_list_mod']}',
이렇게 했거든요 이벤트아이디 부분을 어떻게 수정해야 정상적으로 인식을 할까요..? ㅠㅠ알려주세요
이런 에러화면이 나옵니다 ㅠㅠ
답변을 작성하려면 로그인이 필요합니다.