이에러가 잡히지를 않네요....
CREATE TABLE `g4_memo_send` ( `me_id` int(11) NOT NULL, `me_recv_mb_id` varchar(255) NOT NULL default '', `me_send_mb_id` varchar(255) NOT NULL default '', `me_send_datetime` datetime NOT NULL default '0000-00-00 00:00:00', `me_read_datetime` datetime NOT NULL default '0000-00-00 00:00:00', `me_memo` mediumtext NOT NULL, `me_file_local` varchar(255) NOT NULL, `me_file_server` varchar(255) NOT NULL, `me_subject` varchar(255) NOT NULL, `memo_type` varchar(255) NOT NULL, `memo_owner` varchar(255) NOT NULL, PRIMARY KEY (`me_id`), KEY `me_recv_mb_id_idx` (`me_recv_mb_id`), KEY `me_send_mb_id_idx` (`me_send_mb_id`) );
1064 : You have an error in your SQL syntax near '; ' at line 17
error file : /gnu/adm/memo2_upgrade.php
;오류인것 같은데 ...안되네요
참고로 그누빌더이고 다른버전도 전부 같은 오류가 나네요..
해결방법 좀 부탁드립니다.
아래는 2.0.18 버전 /adm/memo2_upgrade.php파일입니다..
<?
$sub_menu = "100600";
include_once("./_common.php");
check_demo();
if ($is_admin != "super")
alert("최고관리자만 접근 가능합니다.", $g4[path]);
$g4[title] = "업그레이드";
include_once("./admin.head.php");
$sql = "
CREATE TABLE `g4_memo_send` (
`me_id` int(11) NOT NULL,
`me_recv_mb_id` varchar(255) NOT NULL default '',
`me_send_mb_id` varchar(255) NOT NULL default '',
`me_send_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
`me_read_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
`me_memo` mediumtext NOT NULL,
`me_file_local` varchar(255) NOT NULL,
`me_file_server` varchar(255) NOT NULL,
`me_subject` varchar(255) NOT NULL,
`memo_type` varchar(255) NOT NULL,
`memo_owner` varchar(255) NOT NULL,
PRIMARY KEY (`me_id`),
KEY `me_recv_mb_id_idx` (`me_recv_mb_id`),
KEY `me_send_mb_id_idx` (`me_send_mb_id`)
);
";
sql_query($sql);
$sql = "
CREATE TABLE `g4_memo_recv` (
`me_id` int(11) NOT NULL auto_increment,
`me_recv_mb_id` varchar(255) NOT NULL default '',
`me_send_mb_id` varchar(255) NOT NULL default '',
`me_send_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
`me_read_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
`me_memo` mediumtext NOT NULL,
`me_file_local` varchar(255) NOT NULL,
`me_file_server` varchar(255) NOT NULL,
`me_subject` varchar(255) NOT NULL,
`memo_type` varchar(255) NOT NULL,
`memo_owner` varchar(255) NOT NULL,
PRIMARY KEY (`me_id`),
KEY `me_recv_mb_id_idx` (`me_recv_mb_id`),
KEY `me_send_mb_id_idx` (`me_send_mb_id`)
);
";
sql_query($sql);
$sql = "
CREATE TABLE `g4_memo_save` (
`me_id` int(11) NOT NULL,
`me_recv_mb_id` varchar(255) NOT NULL default '',
`me_send_mb_id` varchar(255) NOT NULL default '',
`me_send_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
`me_read_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
`me_memo` mediumtext NOT NULL,
`me_file_local` varchar(255) NOT NULL,
`me_file_server` varchar(255) NOT NULL,
`me_subject` varchar(255) NOT NULL,
`memo_type` varchar(255) NOT NULL,
`memo_owner` varchar(255) NOT NULL,
PRIMARY KEY (`me_id`),
KEY `me_recv_mb_id_idx` (`me_recv_mb_id`),
KEY `me_send_mb_id_idx` (`me_send_mb_id`)
);
";
sql_query($sql);
$sql = "
CREATE TABLE `g4_memo_spam` (
`me_id` int(11) NOT NULL,
`me_recv_mb_id` varchar(255) NOT NULL default '',
`me_send_mb_id` varchar(255) NOT NULL default '',
`me_send_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
`me_read_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
`me_memo` mediumtext NOT NULL,
`me_file_local` varchar(255) NOT NULL,
`me_file_server` varchar(255) NOT NULL,
`me_subject` varchar(255) NOT NULL,
`memo_type` varchar(255) NOT NULL,
`memo_owner` varchar(255) NOT NULL,
PRIMARY KEY (`me_id`),
KEY `me_recv_mb_id_idx` (`me_recv_mb_id`),
KEY `me_send_mb_id_idx` (`me_send_mb_id`)
);
";
sql_query($sql);
$sql = "
CREATE TABLE `g4_memo_notice` (
`me_id` int(11) NOT NULL auto_increment,
`me_recv_mb_id` varchar(255) NOT NULL default '',
`me_send_mb_id` varchar(255) NOT NULL default '',
`me_send_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
`me_read_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
`me_memo` mediumtext NOT NULL,
`me_file_local` varchar(255) NOT NULL,
`me_file_server` varchar(255) NOT NULL,
`me_subject` varchar(255) NOT NULL,
`memo_type` varchar(255) NOT NULL,
`memo_owner` varchar(255) NOT NULL,
PRIMARY KEY (`me_id`),
KEY `me_recv_mb_id_idx` (`me_recv_mb_id`),
KEY `me_send_mb_id_idx` (`me_send_mb_id`)
);
";
sql_query($sql);
$sql = "
CREATE TABLE `g4_friend` (
`fr_no` int(11) NOT NULL auto_increment,
`mb_id` varchar(20) NOT NULL,
`fr_id` varchar(20) NOT NULL,
`fr_memo` varchar(255) default NULL,
`fr_type` varchar(20) NOT NULL,
`fr_datetime` datetime NOT NULL,
PRIMARY KEY (`fr_no`),
UNIQUE KEY `mb_id` (`mb_id`,`fr_id`),
KEY `fr_datetime` (`fr_datetime`),
KEY `fr_relation` (`fr_type`)
);
";
sql_query($sql);
$sql = "
CREATE TABLE `g4_memo_group` (
`gr_id` INT( 11 ) NOT NULL auto_increment,
`mb_id` VARCHAR( 255 ) NOT NULL ,
`gr_name` VARCHAR( 255 ) NOT NULL ,
`gr_datetime` datetime NOT NULL,
PRIMARY KEY (`gr_id`)
) ;
";
sql_query($sql);
$sql = "
CREATE TABLE `g4_memo_group_member` (
`gr_mb_no` int(11) NOT NULL auto_increment,
`gr_id` int(11) NOT NULL,
`gr_mb_id` varchar(255) NOT NULL,
`gr_mb_datetime` datetime NOT NULL,
PRIMARY KEY (`gr_mb_no`)
);
";
sql_query($sql);
$sql = "
ALTER TABLE `g4_config` ADD `cf_memo_del_unread` INT( 11 ) NOT NULL AFTER `cf_10` ;
";
sql_query($sql);
$sql = "
ALTER TABLE `g4_config` ADD `cf_memo_delete_datetime` DATETIME NOT NULL AFTER `cf_memo_del` ;
";
sql_query($sql);
$sql = "
UPDATE `g4_config` set `cf_memo_del_unread` = 365;
";
sql_query($sql);
// memo2 첨부파일 디렉토리를 생성
$dir_name = $g4[path] . "/data/memo2";
if(!is_dir($dir_name)){
@mkdir("$dir_name", 0707);
@chmod("$dir_name", 0707);
}
echo "UPGRADE 완료.";
include_once("./admin.tail.php");
?>
1064 : You have an error in your SQL syntax near '; ' at line 17
error file : /gnu/adm/memo2_upgrade.php
;오류인것 같은데 ...안되네요
참고로 그누빌더이고 다른버전도 전부 같은 오류가 나네요..
해결방법 좀 부탁드립니다.
아래는 2.0.18 버전 /adm/memo2_upgrade.php파일입니다..
<?
$sub_menu = "100600";
include_once("./_common.php");
check_demo();
if ($is_admin != "super")
alert("최고관리자만 접근 가능합니다.", $g4[path]);
$g4[title] = "업그레이드";
include_once("./admin.head.php");
$sql = "
CREATE TABLE `g4_memo_send` (
`me_id` int(11) NOT NULL,
`me_recv_mb_id` varchar(255) NOT NULL default '',
`me_send_mb_id` varchar(255) NOT NULL default '',
`me_send_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
`me_read_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
`me_memo` mediumtext NOT NULL,
`me_file_local` varchar(255) NOT NULL,
`me_file_server` varchar(255) NOT NULL,
`me_subject` varchar(255) NOT NULL,
`memo_type` varchar(255) NOT NULL,
`memo_owner` varchar(255) NOT NULL,
PRIMARY KEY (`me_id`),
KEY `me_recv_mb_id_idx` (`me_recv_mb_id`),
KEY `me_send_mb_id_idx` (`me_send_mb_id`)
);
";
sql_query($sql);
$sql = "
CREATE TABLE `g4_memo_recv` (
`me_id` int(11) NOT NULL auto_increment,
`me_recv_mb_id` varchar(255) NOT NULL default '',
`me_send_mb_id` varchar(255) NOT NULL default '',
`me_send_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
`me_read_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
`me_memo` mediumtext NOT NULL,
`me_file_local` varchar(255) NOT NULL,
`me_file_server` varchar(255) NOT NULL,
`me_subject` varchar(255) NOT NULL,
`memo_type` varchar(255) NOT NULL,
`memo_owner` varchar(255) NOT NULL,
PRIMARY KEY (`me_id`),
KEY `me_recv_mb_id_idx` (`me_recv_mb_id`),
KEY `me_send_mb_id_idx` (`me_send_mb_id`)
);
";
sql_query($sql);
$sql = "
CREATE TABLE `g4_memo_save` (
`me_id` int(11) NOT NULL,
`me_recv_mb_id` varchar(255) NOT NULL default '',
`me_send_mb_id` varchar(255) NOT NULL default '',
`me_send_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
`me_read_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
`me_memo` mediumtext NOT NULL,
`me_file_local` varchar(255) NOT NULL,
`me_file_server` varchar(255) NOT NULL,
`me_subject` varchar(255) NOT NULL,
`memo_type` varchar(255) NOT NULL,
`memo_owner` varchar(255) NOT NULL,
PRIMARY KEY (`me_id`),
KEY `me_recv_mb_id_idx` (`me_recv_mb_id`),
KEY `me_send_mb_id_idx` (`me_send_mb_id`)
);
";
sql_query($sql);
$sql = "
CREATE TABLE `g4_memo_spam` (
`me_id` int(11) NOT NULL,
`me_recv_mb_id` varchar(255) NOT NULL default '',
`me_send_mb_id` varchar(255) NOT NULL default '',
`me_send_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
`me_read_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
`me_memo` mediumtext NOT NULL,
`me_file_local` varchar(255) NOT NULL,
`me_file_server` varchar(255) NOT NULL,
`me_subject` varchar(255) NOT NULL,
`memo_type` varchar(255) NOT NULL,
`memo_owner` varchar(255) NOT NULL,
PRIMARY KEY (`me_id`),
KEY `me_recv_mb_id_idx` (`me_recv_mb_id`),
KEY `me_send_mb_id_idx` (`me_send_mb_id`)
);
";
sql_query($sql);
$sql = "
CREATE TABLE `g4_memo_notice` (
`me_id` int(11) NOT NULL auto_increment,
`me_recv_mb_id` varchar(255) NOT NULL default '',
`me_send_mb_id` varchar(255) NOT NULL default '',
`me_send_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
`me_read_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
`me_memo` mediumtext NOT NULL,
`me_file_local` varchar(255) NOT NULL,
`me_file_server` varchar(255) NOT NULL,
`me_subject` varchar(255) NOT NULL,
`memo_type` varchar(255) NOT NULL,
`memo_owner` varchar(255) NOT NULL,
PRIMARY KEY (`me_id`),
KEY `me_recv_mb_id_idx` (`me_recv_mb_id`),
KEY `me_send_mb_id_idx` (`me_send_mb_id`)
);
";
sql_query($sql);
$sql = "
CREATE TABLE `g4_friend` (
`fr_no` int(11) NOT NULL auto_increment,
`mb_id` varchar(20) NOT NULL,
`fr_id` varchar(20) NOT NULL,
`fr_memo` varchar(255) default NULL,
`fr_type` varchar(20) NOT NULL,
`fr_datetime` datetime NOT NULL,
PRIMARY KEY (`fr_no`),
UNIQUE KEY `mb_id` (`mb_id`,`fr_id`),
KEY `fr_datetime` (`fr_datetime`),
KEY `fr_relation` (`fr_type`)
);
";
sql_query($sql);
$sql = "
CREATE TABLE `g4_memo_group` (
`gr_id` INT( 11 ) NOT NULL auto_increment,
`mb_id` VARCHAR( 255 ) NOT NULL ,
`gr_name` VARCHAR( 255 ) NOT NULL ,
`gr_datetime` datetime NOT NULL,
PRIMARY KEY (`gr_id`)
) ;
";
sql_query($sql);
$sql = "
CREATE TABLE `g4_memo_group_member` (
`gr_mb_no` int(11) NOT NULL auto_increment,
`gr_id` int(11) NOT NULL,
`gr_mb_id` varchar(255) NOT NULL,
`gr_mb_datetime` datetime NOT NULL,
PRIMARY KEY (`gr_mb_no`)
);
";
sql_query($sql);
$sql = "
ALTER TABLE `g4_config` ADD `cf_memo_del_unread` INT( 11 ) NOT NULL AFTER `cf_10` ;
";
sql_query($sql);
$sql = "
ALTER TABLE `g4_config` ADD `cf_memo_delete_datetime` DATETIME NOT NULL AFTER `cf_memo_del` ;
";
sql_query($sql);
$sql = "
UPDATE `g4_config` set `cf_memo_del_unread` = 365;
";
sql_query($sql);
// memo2 첨부파일 디렉토리를 생성
$dir_name = $g4[path] . "/data/memo2";
if(!is_dir($dir_name)){
@mkdir("$dir_name", 0707);
@chmod("$dir_name", 0707);
}
echo "UPGRADE 완료.";
include_once("./admin.tail.php");
?>
|
댓글을 작성하시려면 로그인이 필요합니다.
로그인
댓글 11개
); <-- 요기서 콤마 삭제
일부 mysql 버젼의 경우 sql 문장의 마지막에 ; 가 있으면 오류가 나는거 같아요.
sql 문의 마지막에 있는 콤마를 지워보세요.
CREATE TABLE `g4_memo_send` ( `me_id` int(11) NOT NULL, `me_recv_mb_id` varchar(255) NOT NULL default '', `me_send_mb_id` varchar(255) NOT NULL default '', `me_send_datetime` datetime NOT NULL default '0000-00-00 00:00:00', `me_read_datetime` datetime NOT NULL default '0000-00-00 00:00:00', `me_memo` mediumtext NOT NULL, `me_file_local` varchar(255) NOT NULL, `me_file_server` varchar(255) NOT NULL, `me_subject` varchar(255) NOT NULL, `memo_type` varchar(255) NOT NULL, `memo_owner` varchar(255) NOT NULL, PRIMARY KEY (`me_id`), KEY `me_recv_mb_id_idx` (`me_recv_mb_id`), KEY `me_send_mb_id_idx` (`me_send_mb_id`) )
1050 : Table 'g4_memo_send' already exists
error file : /gnu/adm/memo2_upgrade.php
해결이 안되네요..
다시한번 답변주시면 대단히 감사하겠습니다.
메모관련 테이블은 현재 g4_memo,g4_memo_send 두개입니다..
말씀대로라면 이두개의 테이블을 전부 삭제하란 말씀이신지요?
g4_memo_send 테이블만 삭제하고 다시 업그레이드를 하면 같은 현상이 일어나거든요
해당 SQL script를 그냥 phpMyAdmin에서도 실행해 보셨는지요?
사용하시는 mysql 버젼이 무엇이죠?
제가 ; 를 한개만 수정하고 업그레이드를 했었네요..
지금은 전체 테이블이 잘생성이 됩니다...마지막에 아래와 같은 에러가..
ALTER TABLE `g4_config` ADD `cf_memo_del_unread` INT( 11 ) NOT NULL AFTER `cf_10`
1060 : Duplicate column name 'cf_memo_del_unread'
error file : /gnu/adm/memo2_upgrade.php
adm/config_form_update.php 파일에
cf_memo_del_unread = '$cf_memo_del_unread',
위와같이 수정해줬거든요..
초보다 보니 주셔도 먹지를 못하네요...
;를 전체 다삭제하니 되네요...
끝에 한개가 빠졌었네요...
답변주셔서 대단히 감사합니다.
제가 원했던 기능이 다있네요...
잘사용하겠습니다.
감사합니다.