Erro No 1064 – When Syncing

[pete]

Hi,

I'm getting an SQL error when attempting to sync 2 tables.

The source table is on a remote server (accessed using http tunneling) and the target table is on a computer in the office.

Here is the error :

Error No. 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 '0)) as `datecollected`, max(char_length(abs(`collectedfromid`)))

Home Database (target) is MySQL 4.14 and Server Database (Source) is MySQL 4.11

Any ideas what the problem could be?

Thanks,

Pete

[Ritesh]

Can you send me the table structure and sample data to reprodce the error?

[pete]

Thanks for the swift response.

I hope this is what you need…

CREATE TABLE `tmp_person` (

`email` varchar(255) NOT NULL default '',

`datecollected` date NOT NULL default '0000-00-00',

`collectedfromid` int(10) NOT NULL default '0',

PRIMARY KEY (`email`,`datecollected`,`collectedfromid`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `tmp_person` */

insert into `tmp_person` values ('[email protected]','2005-09-23','11'),('[email protected]','2005-09-23','11'),('[email protected]','2005-09-23','11'),('[email protected]','2005-09-23','11');

Thanks,

Pete

[Ritesh]

Thanks for the sample data.

We are able to reproduce the error. We will be releasing 4.2 BETA 3 tomorrow that will have the bug fix.

[Ritesh]

Bug fixed in 4.2 development tree 🙂

[pete]

Excellent!

Thanks for the help!

You guys rock!

[Ritesh]

pete wrote on Sep 23 2005, 02:46 PM:

Excellent!

Thanks for the help!

You guys rock!

[post=”7291″]<{POST_SNAPBACK}>[/post]

😛 😛

[Ritesh]

Sorry for the delay in replying. We are still working on BETA 3 (there are number of bugs that are still to be fixed).

Though the Error 1064 bug can fixed by applying the following patch in SQLyogTunnel.php.

Change:

Code:

   /* fix in v4.1 that checks for global configuration flag get_magic_quotes_gpc() to stripslashes or not */
   if (get_magic_quotes_gpc()) {
       $xmlrecvd = stripslashes ( urldecode ( $_POST['textfield'] ) );
   } else {
       $xmlrecvd = urldecode ( $_POST['textfield'] );
   }    

to

Code:

   /* fix in v4.1 that checks for global configuration flag get_magic_quotes_gpc() to stripslashes or not */
   if (get_magic_quotes_gpc()) {
       $xmlrecvd = stripslashes ( rawurldecode ( $_POST['textfield'] ) );
   } else {
       $xmlrecvd = rawurldecode ( $_POST['textfield'] );
   }    

[Author]

Posts