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 : /adm/memo2_upgrade.php



insert into (me_id, me_recv_mb_id, me_send_mb_id, me_send_datetime, me_read_datetime, me_memo, me_file_local, me_file_server, me_subject, memo_type, memo_owner) values (0+1, 'yyjae', 'yyjae', '2007-11-04 02:16:19', '2007-11-04 02:16:28', '', '', '', '', 'recv', 'yyjae')

1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(me_id, me_recv_mb_id, me_send_mb_id, me_send_datetime, me_read_datetime, me_mem' at line 1

error file : /adm/memo2_upgrade2.php



insert into (me_id, me_recv_mb_id, me_send_mb_id, me_send_datetime, me_read_datetime, me_memo, me_file_local, me_file_server, me_subject, memo_type, memo_owner) values ('673', 'yyjae', 'yyjae', '2007-11-04 02:16:19', '2007-11-04 02:16:28', '', '', '', 'yyjae님이 보낸 쪽지 입니다', 'recv', 'yyjae')

1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(me_id, me_recv_mb_id, me_send_mb_id, me_send_datetime, me_read_datetime, me_mem' at line 1

error file : /adm/memo2_upgrade2_h.php



디비오류가 나오는데 어찌해야 하나요...