memo4 를 메모5로 변환중에 테이블이 에러났는데요 채택완료
Access denied for user 'root'@'localhost' (using password: NO)
인스톨하니 이런애러가 나왔구요. db 들어가니 변수값으로 테이블이 생성되어버리더라구요.
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` ) ;
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인