Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Erro No 1064 – When Syncing

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Erro No 1064 – When Syncing

  • This topic is empty.
Viewing 6 reply threads
  • Author
    Posts
    • September 23, 2005 at 9:16 am #19271
      Ritesh
      Member

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

    • September 23, 2005 at 9:30 am #19272
      pete
      Member

      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

    • September 23, 2005 at 11:22 am #19273
      Ritesh
      Member

      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.

    • September 23, 2005 at 2:11 pm #19274
      Ritesh
      Member

      Bug fixed in 4.2 development tree 🙂

    • September 23, 2005 at 2:46 pm #19275
      pete
      Member

      Excellent!

      Thanks for the help!

      You guys rock!

    • September 23, 2005 at 2:51 pm #19276
      Ritesh
      Member
      pete wrote on Sep 23 2005, 02:46 PM:
      Excellent!

      Thanks for the help!

      You guys rock!

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

      😛 😛

    • September 26, 2005 at 5:12 pm #19277
      Ritesh
      Member

      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
Viewing 6 reply threads
  • You must be logged in to reply to this topic.