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: | |
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
[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.