Bug #60396 SQL script generation not working
Submitted: 8 Mar 2011 18:26 Modified: 24 Mar 2011 17:09
Reporter: David Espí Hernández Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S1 (Critical)
Version:5.2.32 OS:MacOS (Snow Leopard 10.6.6)
Assigned to: CPU Architecture:Any
Tags: regression

[8 Mar 2011 18:26] David Espí Hernández 
Description:
My model has 181 tables. In last version of MWB I had no problems in generation of SQL script an execution with forward engineering or with Synchronyze model. Now, when I try to generate the script, the window is clean, there is no script to execute.

How to repeat:
I have the failure all times, don't have the possibility of generate the tables.
Is the size of the script a problem?
[8 Mar 2011 20:28] Valeriy Kravchuk 
Please, upload .mwb file to demonstrate the problem.
[8 Mar 2011 23:58] Alfredo Kojima 
Hi

This is caused by a bug in the new long comment truncation code, which truncates comments longer than the max 60byte limit from MySQL pre-5.5. Because of very bad luck, one of your comments has a utf-8 character that ends in the middle of the 60byte limit, corrupting it.

To workaround, you can shorten the comment of table PERM_PEMO_PERM_MODULO in the attached module and retry the export.
[9 Mar 2011 0:09] Alfredo Kojima 
bug #60356 is a duplicate
[24 Mar 2011 17:09] Tony Bedford 
An entry has been added to the 5.2.33 changelog: 

        It was not possible to forward engineer a model, or synchronize 
        it with a live model.