7 Apr
2010
7 Apr
'10
11:45 p.m.
ANKIT GUPTA a écrit :
Hi, sorry for the trouble. i am sending u one file "server_synchronize_lib.php" with this mail.
also as mentioned in my previous mail there is one more bug in the synchronization section. now i have started working on it.
Thanks Ankit Gupta
The attached file would be your patch, look at it to confirm that these are your changes.
If it's ok, upload it to the Patches tracker.
P.S. you'll need to find a way to generate patches...
--
Marc Delisle
http://infomarc.info
*** pma-git/phpmyadmin/libraries/server_synchronize.lib.php 2010-04-07 17:31:22.665485919 -0400
--- server_synchronize.lib.php 2010-04-07 17:40:36.395117798 -0400
***************
*** 671,681 ****
function PMA_populateTargetTables($src_db, $trg_db, $src_link, $trg_link, $uncommon_tables, $table_index, $uncommon_tables_fields, $display)
{
$display = false; // todo: maybe display some of the queries if they are not too numerous
-
$unbuffered_result = PMA_DBI_try_query('SELECT * FROM ' . PMA_backquote($src_db) . '.' . PMA_backquote($uncommon_tables[$table_index]), $src_link, PMA_DBI_QUERY_UNBUFFERED);
if (false !== $unbuffered_result) {
! while ($one_row = PMA_DBI_fetch_row($unbuffered_result)) {
! $insert_query = 'INSERT INTO ' . PMA_backquote($trg_db) . '.' .PMA_backquote($uncommon_tables[$table_index]) . ' VALUES(';
$key_of_last_value = count($one_row) - 1;
foreach($one_row as $key => $value) {
$insert_query .= "'" . PMA_sqlAddslashes($value) . "'";
--- 671,681 ----
function PMA_populateTargetTables($src_db, $trg_db, $src_link, $trg_link, $uncommon_tables, $table_index, $uncommon_tables_fields, $display)
{
$display = false; // todo: maybe display some of the queries if they are not too numerous
$unbuffered_result = PMA_DBI_try_query('SELECT * FROM ' . PMA_backquote($src_db) . '.' . PMA_backquote($uncommon_tables[$table_index]), $src_link, PMA_DBI_QUERY_UNBUFFERED);
if (false !== $unbuffered_result) {
! $insert_query = 'INSERT INTO ' . PMA_backquote($trg_db) . '.' .PMA_backquote($uncommon_tables[$table_index]) . ' VALUES';
! while ($one_row = PMA_DBI_fetch_row($unbuffered_result)) {
! $insert_query.='(';
$key_of_last_value = count($one_row) - 1;
foreach($one_row as $key => $value) {
$insert_query .= "'" . PMA_sqlAddslashes($value) . "'";
***************
*** 683,694 ****
$insert_query .= ",";
}
}
! $insert_query .= ');';
! if ($display == true) {
! PMA_displayQuery($insert_query);
! }
! PMA_DBI_try_query($insert_query, $trg_link, 0);
}
}
}
/**
--- 683,696 ----
$insert_query .= ",";
}
}
! $insert_query .= '),';
! }
! $insert_query=substr($insert_query,0,-1);
! $insert_query.=';';
! if ($display == true) {
! PMA_displayQuery($insert_query);
}
+ PMA_DBI_try_query($insert_query, $trg_link, 0);
}
}
/**