이게 무슨 말이죠?
본문
CREATE TABLE IF NOT EXISTS `wj_menu_statistic` ( `st_table` varchar(255) NOT NULL, `wr_id` int(11) NOT NULL, `click` int(11) NOT NULL, `date` date NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4
1115 : Unknown character set: 'utf8mb4'
error file : /adm/wj_menu_statistic/install/index.php
뭘 어떻해 하라는 건지..
답변 2
케릭터셋이 잘못된거 같네요
CREATE TABLE IF NOT EXISTS `wj_menu_statistic` ( `st_table` varchar(255) NOT NULL, `wr_id` int(11) NOT NULL, `click` int(11) NOT NULL, `date` date NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 이나
CREATE TABLE IF NOT EXISTS `wj_menu_statistic` ( `st_table` varchar(255) NOT NULL, `wr_id` int(11) NOT NULL, `click` int(11) NOT NULL, `date` date NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf-8
해보세요
캐릭터셋을 어떻게 수정하죠?
그리고 캐릭터 셋이 뭔지 좀...
<?php
$sub_menu = "920300";
define('G5_IS_ADMIN', true);
include_once ('../../../common.php');
include_once(G5_ADMIN_PATH.'/admin.lib.php');
auth_check($auth[$sub_menu], "w");
if($action == 'install')
{
// 테이블 생성 ------------------------------------
$file = implode('', file('./install.sql'));
eval("\$file = \"$file\";");
$file = preg_replace('/^--.*$/m', '', $file);
$file = preg_replace('/`g5_([^`]+`)/', '`'.$table_prefix.'$1', $file);
$f = explode(';', $file);
for ($i=0; $i<count($f); $i++) {
if (trim($f[$i]) == '') continue;
sql_query($f[$i], true);
}
// 테이블 생성 ------------------------------------
@set_session('install','success');
alert('메뉴클리수통게플러그인 설치성공.','../index.php');
}
$g5['title'] = "메뉴클리수통게플러그인 - 설치";
include_once(G5_ADMIN_PATH.'/admin.head.php');
add_stylesheet('<link rel="stylesheet" href="../css/style.css" />');
?>
<form id="install" name="install" method="post">
<!--
<div class="tbl_frm01 tbl_wrap">
<table>
<colgroup>
<col class="grid_4">
<col>
</colgroup>
<tbody>
<tr>
<th scope="row"><label for="username">고객아이디</label></th>
<td>
<input type="text" name="username" class="frm_input required" style="width:150px;" placeholder="고객아이디" value="" autofocus="autofocos" />
</td>
</tr>
<tr>
<th scope="row"><label for="code">프로그램코드</label></th>
<td>
<input type="text" name="code" class="frm_input required" style="width:280px;" placeholder="프로그램코드" value="" />
</td>
</tr>
</tbody>
</table>
</div>
-->
<div class="btn_confirm01 btn_confirm">
<input type="hidden" name="id" value="0">
<input type="hidden" id="action" name="action" value="install">
<input type="submit" value="설치하기" class="btn_submit" accesskey="s">
</div>
</form>
<?php
include_once(G5_ADMIN_PATH.'/admin.tail.php');
?>
여기의 어딘가가 에러라는 것 같은뎅..
install.sql 화일을 열어서 수정하세요
