memo4 를 메모5로 변환중에 테이블이 에러났는데요
본문
Access denied for user 'root'@'localhost' (using password: NO)
인스톨하니 이런애러가 나왔구요. db 들어가니 변수값으로 테이블이 생성되어버리더라구요.
memo_config
<?
// 테이블
$g5['memo_config_table'] = $g5['table_prefix'] . "memo_config"; // 메모 설정테이블
$g5['memo_recv_table'] = $g5['table_prefix'] . "memo_recv"; // 메모 테이블 (수신)
$g5['memo_send_table'] = $g5['table_prefix'] . "memo_send"; // 메모 테이블 (발신)
$g5['memo_save_table'] = $g5['table_prefix'] . "memo_save"; // 메모 테이블 (저장)
$g5['memo_temp_table'] = $g5['table_prefix'] . "memo_temp"; // 메모 테이블 (임시저장)
$g5['memo_spam_table'] = $g5['table_prefix'] . "memo_spam"; // 메모 테이블 (스팸)
$g5['memo_notice_table'] = $g5['table_prefix'] . "memo_notice"; // 메모 테이블 (공지)
$g5['memo_trash_table'] = $g5['table_prefix'] . "memo_trash"; // 메모 테이블 (휴지통)
$g5['memo_club_table'] = $g5['table_prefix'] . "memo_club"; // 메모 테이블 (클럽)
$g5['memo_group_table'] = $g5['table_prefix'] . "memo_group"; // 메모 테이블 (그룹)
$g5['memo_group_member_table'] = $g5['table_prefix'] . "memo_group_member"; // 메모 테이블 (그룹멤버)
$g5['friend_table'] = $g5['table_prefix'] . "friend"; // 친구 테이블
// 설정 - $config 테이블로 통합
if (function_exists('sql_fetch')) {
$memo_config = sql_fetch(" select * from $g5[memo_config_table] ", FALSE);
if ($memo_config)
$config = array_merge($config, $memo_config);
}
?>
수정하였는데 저렇게 되는건 어떻게 해야할까요??
답변 1
## 마이에스큐엘 dump 10.11
##
## Host: localhost Database: memo4
## ######################################################
## Server version 5.0.37-log
# 메모2
DROP TABLE IF EXISTS `$g5[memo_group_table]`;
CREATE TABLE `$g5[memo_group_table]` (
`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`)
);
DROP TABLE IF EXISTS `$g5[memo_group_member_table]`;
CREATE TABLE `$g5[memo_group_member_table]` (
`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`)
);
# 쪽지2 - 공지테이블
DROP TABLE IF EXISTS `$g5[memo_notice_table]`;
CREATE TABLE `$g5[memo_notice_table]` (
`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`),
KEY `datetime` (`me_send_datetime`,`me_read_datetime`),
KEY `memo_owner` (`memo_owner`),
KEY `me_file_local` (`me_file_local`)
);
# 쪽지2 - 수신테이블
DROP TABLE IF EXISTS `$g5[memo_recv_table]`;
CREATE TABLE `$g5[memo_recv_table]` (
`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`),
KEY `datetime` (`me_send_datetime`,`me_read_datetime`),
KEY `memo_owner` (`memo_owner`),
KEY `me_file_local` (`me_file_local`)
);
# 쪽지2 - 저장테이블
DROP TABLE IF EXISTS `$g5[memo_save_table]`;
CREATE TABLE `$g5[memo_save_table]` (
`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`),
KEY `datetime` (`me_send_datetime`,`me_read_datetime`),
KEY `memo_owner` (`memo_owner`),
KEY `me_file_local` (`me_file_local`)
);
# 쪽지2 - 발신테이블
DROP TABLE IF EXISTS `$g5[memo_send_table]`;
CREATE TABLE `$g5[memo_send_table]` (
`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`),
KEY `datetime` (`me_send_datetime`,`me_read_datetime`),
KEY `memo_owner` (`memo_owner`),
KEY `me_file_local` (`me_file_local`)
);
# 쪽지2 - 스팸테이블
DROP TABLE IF EXISTS `$g5[memo_spam_table]`;
CREATE TABLE `$g5[memo_spam_table]` (
`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`),
KEY `datetime` (`me_send_datetime`,`me_read_datetime`),
KEY `memo_owner` (`memo_owner`),
KEY `me_file_local` (`me_file_local`)
);
# 쪽지2 - 친구테이블
DROP TABLE IF EXISTS `$g5[friend_table]`;
CREATE TABLE `$g5[friend_table]` (
`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`)
);
# 쪽지4 - 신규 테이블 (설정)
DROP TABLE IF EXISTS `$g5[memo_config_table]`;
CREATE TABLE `$g5[memo_config_table]` (
`cf_memo_page_rows` int(11) NOT NULL,
`cf_memo_del_unread` int(11) NOT NULL default '180',
`cf_memo_del_trash` int(11) NOT NULL default '7',
`cf_memo_delete_datetime` datetime NOT NULL,
`cf_memo_user_dhtml` tinyint(4) NOT NULL default '1',
`cf_memo_use_file` tinyint(4) NOT NULL default '0',
`cf_friend_management` tinyint(4) NOT NULL default '1',
`cf_memo_notice_board` varchar(255) default NULL,
`cf_memo_before_after` tinyint(4) NOT NULL,
`cf_memo_notice_memo` text NOT NULL
) ;
# 쪽지4- 신규 테이블 (임시저장)
DROP TABLE IF EXISTS `$g5[memo_temp_table]`;
CREATE TABLE `$g5[memo_temp_table]` (
`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`),
KEY `datetime` (`me_send_datetime`,`me_read_datetime`),
KEY `memo_owner` (`memo_owner`),
KEY `me_file_local` (`me_file_local`)
);
# 쪽지4 - 신규테이블 (휴지통)
DROP TABLE IF EXISTS `$g5[memo_trash_table]`;
CREATE TABLE `$g5[memo_trash_table]` (
`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`),
KEY `datetime` (`me_send_datetime`,`me_read_datetime`),
KEY `memo_owner` (`memo_owner`),
KEY `me_file_local` (`me_file_local`)
);
# 쪽지4 - 옵션필드 추가
ALTER TABLE `$g5[memo_recv_table]` ADD `me_option` SET( 'html1', 'html2', 'secret', 'mail' ) NOT NULL ;
ALTER TABLE `$g5[memo_send_table]` ADD `me_option` SET( 'html1', 'html2', 'secret', 'mail' ) NOT NULL ;
ALTER TABLE `$g5[memo_save_table]` ADD `me_option` SET( 'html1', 'html2', 'secret', 'mail' ) NOT NULL ;
ALTER TABLE `$g5[memo_temp_table]` ADD `me_option` SET( 'html1', 'html2', 'secret', 'mail' ) NOT NULL ;
ALTER TABLE `$g5[memo_notice_table]` ADD `me_option` SET( 'html1', 'html2', 'secret', 'mail' ) NOT NULL ;
ALTER TABLE `$g5[memo_spam_table]` ADD `me_option` SET( 'html1', 'html2', 'secret', 'mail' ) NOT NULL ;
ALTER TABLE `$g5[memo_trash_table]` ADD `me_option` SET( 'html1', 'html2', 'secret', 'mail' ) NOT NULL ;
# 1.0.24 - 쪽지4 temp, trash 테이블 key 추가
ALTER TABLE `$g5[memo_temp_table]` ADD `me_from_kind` VARCHAR( 255 ) NOT NULL ;
ALTER TABLE `$g5[memo_trash_table]` ADD `me_from_kind` VARCHAR( 255 ) NOT NULL ;
ALTER TABLE `$g5[memo_temp_table]` DROP PRIMARY KEY , ADD PRIMARY KEY ( `me_id` , `me_from_kind` ) ;
ALTER TABLE `$g5[memo_trash_table]` DROP PRIMARY KEY , ADD PRIMARY KEY ( `me_id` , `me_from_kind` ) ;
# 1.0.26 - 쪽지4 설정추가 (실시간메모)
ALTER TABLE `$g5[memo_config_table]` ADD `cf_memo_realtime` TINYINT( 4 ) NOT NULL ;
# 1.0.26 - 쪽지4 설정추가 (실명 사용)
ALTER TABLE `$g5[memo_config_table]` ADD `cf_memo_mb_name` TINYINT( 4 ) NOT NULL ;
# 1.0.31 - 쪽지4 설정추가 (업로드 파일용량)
ALTER TABLE `$g5[memo_config_table]` ADD `cf_memo_file_size` VARCHAR( 20 ) NOT NULL ;
# 1.0.32 - 쪽지4 save 오류 수정
ALTER TABLE `$g5[memo_save_table]` DROP PRIMARY KEY , ADD PRIMARY KEY ( `me_id` , `memo_type` ) ;
