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

Schema Sync Tool Bug

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Schema Sync Tool Bug

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • March 16, 2012 at 6:27 pm #12620
      rccf
      Member

      Hi,

      I just bought SQLyog and the first thing I try to do with it turns out to have a bug. I tried to sync the schema of a table between two servers, and the MySQL code it produced to do it is incorrectly formatted and causes MySQL to produce an error (I changed the column names):

      ALTER TABLE `products`

      CHANGE `PROD_Col3` `PROD_Col3` bit(1) NOT NULL DEFAULT 'b'0'' after `PROD_Col1`,

      ADD COLUMN `PROD_Col4` bit(1) NOT NULL DEFAULT 'b'1'' after `PROD_Col2`;

      Notice in the “DEFAULT” part of each line it uses 'b'0'' and 'b'1'' rather than just b'0' and b'1'.

      Please fix this bug as soon as possible since I bought your product specifically for the schema and data synching ability.

      Thanks,

      Russ

    • March 19, 2012 at 5:13 am #33199
      ashwin
      Member

      We will look into this and update here.

    • March 19, 2012 at 10:57 am #33200
      ashwin
      Member

      We will fix this in the next public release(This week). Thank you for reporting.

    • March 22, 2012 at 12:23 pm #33201
      ashwin
      Member

      We have released SQLyog v9.63 with this fix.

      Please refer: http://www.webyog.com/blog/2012/03/22/sqlyog-mysql-gui-9-63-released/

  • Author
    Posts
Viewing 3 reply threads
  • You must be logged in to reply to this topic.