(ok 3.4.0-rc2) data containing single quotes prevents sync

hi ruleant,
sorry for answering so late,
and apologies for not giving all the necessary info in the first report.

Environment:
server: Microsoft-IIS/5.1
PHP 5.3.3
mysqlnd 5.0.7
browser: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/534.10 (KHTML, like Gecko) Chrome/8.0.552.224 Safari/534.10

I tried to reproduce from scratch the bug, and I noticed that it doesn't appear during the first synchronization (when the target table is created), but only during the subsequent synchronizations.
Steps to reproduce it:

Step 1.
- The target table does not exists
- Execute the synchronization
- Log:
Target database has been synchronized with source database
The following queries have been executed:
CREATE TABLE `test_export`.`test_table` ( `ID` int(11) NOT NULL auto_increment, `c1` varchar(255) default NULL, `c2` varchar(255) default NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8
- browse the table:
SQL query: SELECT * FROM `test_table` LIMIT 0, 30 ;
Rows: 2
ID c1 c2
1 r1 does work
2 r2 doesn't work
- it's ok.

Step 2.
- empty the target table
- Log:
Table test_table has been emptied

Step 3.
- execute the synchronization once again
- Log:
Target database has been synchronized with source database
The following queries have been executed:
INSERT INTO `test_export`.`test_table` (ID, c1, c2) VALUES('1' ,'r1' ,'does work');
INSERT INTO `test_export`.`test_table` (ID, c1, c2) VALUES('2' ,'r2' ,'doesn't work');
- browse the table:
SQL query: SELECT * FROM `test_table` LIMIT 0, 30 ;
Rows: 1
ID c1 c2
1 r1 does work
- it's not ok anymore, the second row is missing now :-(

I am using phpMyAdmin 3.3.8.1.
In libraries\server_synchronize.lib.php I replaced in line 574:

$insert_query .= "'" . $result[0] . "'";
with
$insert_query .= "'" . str_replace("'","\'",$result[0]) . "'";

and in line 578
$insert_query .= "'" . $result[0][$table_fields[$matching_table_index][$field_index]] . "'";
with
$insert_query .= "'" . str_replace("'","\'",$result[0][$table_fields[$matching_table_index][$field_index]]) . "'";

and now it seems to be ok

In order to perform the synchronization, phpMyAdmin generates a set of queries. The bug arises when, by chance, you get an INSERT INTO query containing a string containing a not escaped single quote char (e.g. 'doesn't work'):

INSERT INTO `test_export`.`test_table` (ID, c1, c2) VALUES('2' ,'r2', 'doesn't work');

Not every synchronization necessarily generates an INSERT INTO query like this, so maybe this is the reason you cannot reproduce the bug.
Does your tests (that you say that are working) generates a query like this? (Pls see the steps I described below for generating the bug.)

Anyway, I think that the above query is syntactically incorrect, and in a string enclosed within single quotes any single quote char should be escaped.

I am experiencing the same issue:

Mac OS 10.6.7 using MAMP Pro
Apache 2.2.17
PHP 5.3.2
MySQL Server version: 5.1.44
MySQL client version: 5.1.44
MySQL charset: UTF-8 Unicode (utf8)
PHP extension: mysql

BTW, I'm using phpMyAdmin 3.3.10