Bug #77492 MySQL Workbench - ERROR: Error 1064
Submitted: 25 Jun 2015 22:39 Modified: 2 Jul 2015 11:18
Reporter: No Name Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S2 (Serious)
Version:6.3.4 OS:Windows (Microsoft Windows 8.1)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[25 Jun 2015 22:39] No Name
Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\No\AppData\Roaming\MySQL\Workbench\log\wb.log]

I can't synchronize from my model to the database.
I have the following error :
ERROR: Error 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 'COMMENT '',
  INDEX `fk_produit_fabricant_idx` (`id_fabricant` ASC)  COMMENT '',' at line 14

How to repeat:
I don't know. Maybe by using my model file
[25 Jun 2015 22:42] No Name
log file

Attachment: wb.log (application/octet-stream, text), 24.18 KiB.

[26 Jun 2015 4:59] MySQL Verification Team
Hi!

Thank you for the report.
Could you please provide model file(mark it as private if you want) to repeat this issue at our end?

Thanks,
Umesh
[26 Jun 2015 7:29] No Name
Preview Database Changes to be Applied

Attachment: Synchronize Model with Database - Preview Database Changes to be Applied.txt (text/plain), 23.10 KiB.

[26 Jun 2015 10:39] MySQL Verification Team
Thank you for the model file. Is it the exact model file which is causing issue? I see only duplicate column error with this model file and after removing duplicate column error I was able to synchronize without any issues. 

Executing SQL script in server
ERROR: Error 1060: Duplicate column name 'id_panier_client'
SQL Code:
        CREATE TABLE IF NOT EXISTS `test`.`produits_panier_client` (
          `id_panier_client` INT(11) NOT NULL AUTO_INCREMENT COMMENT '',
          `id_panier_client` INT(11) NOT NULL COMMENT '',
          `id_produits_stockés` INT(11) NOT NULL COMMENT '',
          `prix_achat` FLOAT(11) NOT NULL COMMENT '',
          `prix_vente` FLOAT(11) NOT NULL COMMENT '',
          `quantite` INT(11) NULL DEFAULT NULL COMMENT '',
          PRIMARY KEY (`id_panier_client`)  COMMENT '',
          INDEX `fk_produit_commandé_client_produits_stockés1_idx` (`id_produits_stockés` ASC)  COMMENT '',
          INDEX `fk_produits_panier_client_panier_client1_idx` (`id_panier_client` ASC)  COMMENT '',
          CONSTRAINT `fk_produit_commandé_client_produits_stockés1`
            FOREIGN KEY (`id_produits_stockés`)
            REFERENCES `test`.`produits_stockés` (`id_produits_stockés`)
            ON DELETE NO ACTION
            ON UPDATE NO ACTION,
          CONSTRAINT `fk_produits_panier_client_panier_client1`
            FOREIGN KEY (`id_panier_client`)
            REFERENCES `test`.`panier_client` (`id_panier_client`)
            ON DELETE NO ACTION
            ON UPDATE NO ACTION)
        ENGINE = InnoDB
        DEFAULT CHARACTER SET = utf8
        COLLATE = utf8_unicode_ci

SQL script execution finished: statements: 16 succeeded, 1 failed

Fetching back view definitions in final form.
Nothing to fetch

I suspect that comment is truncated somewhere which is resulting in SQL
[26 Jun 2015 12:03] No Name
Yes this is the good file.

Please see other attached files :
- last version of the model file (same issue)
- all screen shots of synchronize operation

I have tested to add a simple table manually from the same user (test) with PHPmyAdmin and it works fine.

Regards
[26 Jun 2015 12:15] No Name
I just see the duplicate id.
I have corrected it but not in the file I sended you.
I have always the same error message.

Before adding tables in the model diagram, I have synchronized the database without any table and it worked fine. Only replace in model utf8_general_ci by utf8_unicode_ci.

regards
[27 Jun 2015 6:38] MySQL Verification Team
Thank you, but it seems to me that uploaded model file has still issues (duplicate column names, table definition missing etc). Please correct all issues in model file and then re-upload.

ERROR: Error 1060: Duplicate column name 'id_panier_client'
ERROR: Error 1060: Duplicate column name 'id_moyen_paiement'

and unfinished table

SQL Code:
        CREATE TABLE IF NOT EXISTS `website_test`.`suivi_livraison (todo)` (
        )
        ENGINE = InnoDB
        DEFAULT CHARACTER SET = utf8
        COLLATE = utf8_unicode_ci
[27 Jun 2015 8:08] No Name
Hello

I'm sorry for the inconvenience, I continue working on the project and I send you the projet in the actual state.

I think having solved all problems now.

Please see the new attached file

Is there a way to check the model without doing synchronize task ?

Regards
[2 Jul 2015 11:18] No Name
Hello

I would like get some news about my problem.
Can you see my error message ?
Have you got an idea to find a workaround solution ?

Regards

Guillaume J.