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

4.2 Beta2 Sync Bug? Or No Support Yet?

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › 4.2 Beta2 Sync Bug? Or No Support Yet?

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • September 24, 2005 at 12:30 am #9250
      sdozono
      Member

      (Still, I need to add 'SET NAMES UJIS' in my SQLyogtunnel.php… 😎 )

      Error messages appeared during sync tests of tables that has combined index keys…

      Message:

      SQLYOG Wizard: “There was an error while execute a query. The query and the error has been logged in the log file.

      Check D:Program FilesSQLyog Enterprisesja.log for complete error details.

      “

      SJALOG:

      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 `CAL_DATE`, max(char_length(abs(`PLAN_ID`))) as `PLAN_ID

      Error SQL syntax. (Source Server:)

      select max(char_length(`CAL_DATE` 0)) as `CAL_DATE`, max(char_length(abs(`PLAN_ID`))) as `PLAN_ID` from `calendar`

      CREATE TABLE `calendar` (

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

      `PLAN_ID` int(11) NOT NULL default '0',

      `******` tinyint(4) default NULL,

      `******` tinyint(4) default NULL,

      `******` tinyint(4) default NULL,

      `******` tinyint(4) default NULL,

      `******` time default NULL,

      `******` time default NULL,

      PRIMARY KEY (`CAL_DATE`,`PLAN_ID`)

      ) ENGINE=MyISAM DEFAULT CHARSET=ujis;

      A character '0' is the problem..

    • September 24, 2005 at 2:36 am #19282
      Ritesh
      Member
      sdozono wrote on Sep 24 2005, 12:30 AM:
      (Still, I need to add 'SET NAMES UJIS' in my SQLyogtunnel.php…  😎 )

      Error messages appeared during sync tests of tables that has combined index keys…

      Message:

      SQLYOG Wizard: “There was an error while execute a query. The query and the error has been logged in the log file.

      Check D:Program FilesSQLyog Enterprisesja.log for complete error details.

      “

      SJALOG:

      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 `CAL_DATE`, max(char_length(abs(`PLAN_ID`))) as `PLAN_ID

      Error SQL syntax. (Source Server:)

      select max(char_length(`CAL_DATE` 0)) as `CAL_DATE`, max(char_length(abs(`PLAN_ID`))) as `PLAN_ID` from `calendar`

      CREATE TABLE `calendar` (

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

      `PLAN_ID` int(11) NOT NULL default '0',

      `******` tinyint(4) default NULL,

      `******` tinyint(4) default NULL,

      `******` tinyint(4) default NULL,

      `******` tinyint(4) default NULL,

      `******` time default NULL,

      `******` time default NULL,

      PRIMARY KEY (`CAL_DATE`,`PLAN_ID`)

      ) ENGINE=MyISAM DEFAULT CHARSET=ujis;

      A character '0' is the problem..

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

      This is the same bug as:

      http://www.webyog.com/forums/index.php?showtopic=1694

      We will be releasing BETA 3 today that has the bug fix.

      Your second request has also been implemented in BETA 3 🙂

    • September 26, 2005 at 5:11 pm #19283
      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 2 reply threads
  • You must be logged in to reply to this topic.