Duplicate entry 'test_col-1-1' for key 1

hanpedro

I want to move data fromt test_dba to test_dbb.

I am working on xp, and will upload this file to linux box - fedora 3.
On xp, this file shows some problems.

"Duplicate entry for key 1" came back.
Files are not fully copied.

the source file link is here.

<?
include_once("./_common.php");
include_once 'dbconn.php';

$sql = " select * from test_dba_board_{$src} order by headnum ,arrangenum ";
$test_dba_result = mysql_query($sql);
?>
<?
$tmp_target = $test_dbb[write_prefix] . $dst;

@mkdir("$test_dbb[dir]/data/file/$dst", 0707);
@chmod("$test_dbb[dir]/data/file/$dst", 0707);


mysql_select_db($test_dbb[db], $test_dba[conn]) or die("$test_dbb[db] ??.");
mysql_query(" delete from test_dbb_board_file where bo_table = '$dst' ") or die(mysql_error());
$sql_test_dbbgb="TRUNCATE TABLE test_dbb_write_{$dst}";
mysql_query($sql_test_dbbgb) or die(mysql_error());

$cnt = 0;
$count_write = 0;
$count_comment = 0;
$save_num = null;
while ($row=mysql_fetch_array($test_dba_result))
{
    $id = mysql_insert_id();

if ($save_num == $num) {
    $parent_id = $save_id;
} else {
    $parent_id = $id;
    $save_id = $id;
}
mysql_query(" update test_dbb_write_{$dst} set wr_parent_id = '$save_id' where wr_id = '$id' ");
mysql_query("update test_dbb_board set bo_total_count = bo_total_count + 1 where bo_table = '$dst'");

  	 $file1 = "";
	 $file1_source = "";
    $bf_no = +1;
  if ($row[file_name1]) {
	        //file copy
	        $file1 = substr(md5($i),0,8) . "_" . $row[s_file_name1];
	        $file1_source = $row[s_file_name1];
	        if (copy("$test_dba[dir]/$row[file_name1]", "$test_dbb[dir]/data/file/$dst/$file1")) {
	        print ("copied *$test_dbb[dir]/data/file/$dst/$file1"); } else { print ("failed copy $test_dbb[dir]/data/file/$dst/$file1");
	        	}
    		 @chmod("$test_dbb[dir]/data/file/$dst/$file1", 0606);
			$bf_file1 = addslashes($file1);
			$bf_source1 = addslashes($row[s_file_name1]);
	       $sql_fc1 = " insert into test_dbb_board_file set bo_table = '$dst', wr_id = '$id', bf_no = '$bf_no', bf_source = '$bf_source1', bf_file = '$bf_file1', bf_download = '$row[download1]' ";
	            mysql_query($sql_fc1) or die(mysql_error());
        $bf_no++;
   }
  if ($row[file_name2]) {
	        $file2 = substr(md5($i),0,8) . "_" . $row[s_file_name2];
	        $file2_source = $row[s_file_name2];
	        if (copy("$test_dba[dir]/$row[file_name2]", "$test_dbb[dir]/data/file/$dst/$file2")) {
	        print ("copied [$test_dbb[dir]/data/file/$dst/$file2]"); } else { print ("failed copy [$test_dbb[dir]/data/file/$dst/$file2]");
	        	}
    		 @chmod("$test_dbb[dir]/data/file/$dst/$s_file_name2", 0606);
			$bf_file2 = addslashes($file2);
			$bf_source2 = addslashes($file2);
	       $sql_fc2 = " insert into test_dbb_board_file set bo_table = '$dst', wr_id = '$id', bf_no = '$bf_no', bf_source = '$bf_source2', bf_file = '$bf_file2', bf_download = '$row[download2]' ";
	            mysql_query($sql_fc2) or die(mysql_error());
   }

$count_write++;
}

$sql = " update test_dbb_board set bo_count_write = '$count_write', bo_count_comment = '$count_comment' where bo_table = '$dst' ";
mysql_query($sql);
?>

Any comment would appreciated.

mrhappiness

Originally posted by hanpedro
1. "Duplicate entry for key 1" came back.

That's the complete message?

pleae copy&paste the result of

DESC test_dbb_board_file

hanpedro

Originally posted by mrhappiness
That's the complete message?

pleae copy&paste the result of
DESC test_dbb_board_file
[/B]

Dear mrhappiness,

Here is test_dbb_board_file's sql.

##
## Table structure for table `test_dbb_board_file`
##

DROP TABLE IF EXISTS test_dbb_board_file;
CREATE TABLE test_dbb_board_file (
  bo_table varchar(20) NOT NULL default '',
  wr_id int(11) NOT NULL default '0',
  bf_no int(11) NOT NULL default '0',
  bf_source varchar(255) NOT NULL default '',
  bf_file varchar(255) NOT NULL default '',
  bf_download varchar(255) NOT NULL default '',
  bf_content text NOT NULL,
  PRIMARY KEY  (bo_table,wr_id,bf_no)
) TYPE=MyISAM;

Thanks for your kindness.

mrhappiness

Originally posted by mrhappiness
That's the complete message?

Change

mysql_query($sql_fc2) or die(mysql_error());

mysql_query($sql_fc2) or die(mysql_error().'<hr />'.$sql_fc2);

an dpost the result

seems like you wanna update a row using an INSERT

hanpedro

Originally posted by mrhappiness
Change
mysql_query($sql_fc2) or die(mysql_error());
to
mysql_query($sql_fc2) or die(mysql_error().'<hr />'.$sql_fc2);
an dpost the result

seems like you wanna update a row using an INSERT [/B]

The result is same.

Yes, I already wrote I want to move data from test_dba to test_dbb for changing web program.
But new new program different data format and style.

Duplicate entry 'test_col-1-1' for key 1

And I've changed

mysql_query($sql_fc2) or die(mysql_error().'<hr />'.$sql_fc1);
mysql_query($sql_fc2) or die(mysql_error().'<hr />'.$sql_fc2);

And this time, the result was

Duplicate entry 'test_col-1-1' for key 1
insert into test_dbb_board_file set bo_table = 'test_col', wr_id = '1', bf_no = '1', 
bf_source = 'wallpaper_xmas_1024768.exe', bf_file = 'eccbc87e_wallpaper_xmas_1024768.exe', bf_download = '1'

mrhappiness

Originally posted by hanpedro
And this time, the result was

Duplicate entry 'test_col-1-1' for key 1
insert into test_dbb_board_file set bo_table = 'test_col', wr_id = '1', bf_no = '1', 
bf_source = 'wallpaper_xmas_1024768.exe', bf_file = 'eccbc87e_wallpaper_xmas_1024768.exe', bf_download = '1'

[/B]

And you're sure you don't already have an entry in test_dbb_board_file with bo_table = test_col, wr_id = 1 and bf_no = 1?

hanpedro

Originally posted by mrhappiness
And you're sure you don't already have an entry in test_dbb_board_file with bo_table = test_col, wr_id = 1 and bf_no = 1?

Dear mrhappiness,

I have this result.

echo "[a$dst]" = test_col
echo ""= 1
echo "[c=$bf_no]" =1
echo "[d=$bf_source2]" = eccbc87e_wallpaper_xmas_1024768.exe
echo "[e=$bf_file2]" = 1
echo "[f=$row[download2]]"= wallpaper_xmas_jesus1024768.exe
$wr_id = " = 1

And,

id1=1id2=1copied /test_dbb/eccbc87e_wallpaper_xmas_1024768.exe[a=test_col][c=1][d=eccbc87e_wallpaper_xmas_1024768.exe][e=1]f=wallpaper_xmas_jesus1024768.exe1
Duplicate entry 'test_col-1-1' for key 1

mrhappiness

That does not answer my question

How did you check if you don't already have an entry with this data in the table?

hanpedro

Sorry.

I have put delete code as

mysql_query(" delete from test_dbb_board_file where bo_table = '$dst' ") or die(mysql_error()); $sql_test_dbbgb="TRUNCATE TABLE test_dbb_write_{$dst}";

And, I tried to delete an entry in test_dbb_board_file with bo_table = test_col, wr_id = 1 and bf_no = 1 with phpmyadmin.