On Thu, Apr 8, 2010 at 3:15 AM, Marc Delisle
<marc@infomarc.info> wrote:
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...
--
*** 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);
}
}
/**
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel