Workbench Error 1005: Can't create table (errno: 150) durante la sincronizzazione

[pmi]

Ciao a tutti,
ho creato un modello con workbench, ma quando vado a sincronizzare con il database, ricevo il questo errore. Ho provato e riprovata ma proprio non capisco dove è l'errore. Qualcuno di voi riesce a capire dov'è il problema?

Executing SQL script in server
ERROR: Error 1005: Can't create table 'test_001.vnt_products' (errno: 150)
SQL Code:
        CREATE TABLE IF NOT EXISTS `test_001`.`vnt_products` (
          `id` INT(10) UNSIGNED NOT NULL COMMENT '',
          `item_id` INT(10) UNSIGNED NOT NULL COMMENT '',
          `product_state_id` INT(10) UNSIGNED NOT NULL COMMENT '',
          `sku` VARCHAR(45) NULL DEFAULT NULL COMMENT '',
          `supplier_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL COMMENT '',
          `price` DECIMAL(10,2) NULL DEFAULT NULL COMMENT '',
          `availability` INT(11) NULL DEFAULT 1 COMMENT '',
          `updated` DATETIME NULL DEFAULT NULL COMMENT '',
          `created` DATETIME NULL DEFAULT NULL COMMENT '',
          `note` TEXT NULL DEFAULT NULL COMMENT '',
          `product_type_id` INT(10) UNSIGNED NOT NULL COMMENT '',
          `product_vat_id` INT(10) UNSIGNED NOT NULL COMMENT '',
          `product_um_id` INT(10) UNSIGNED NOT NULL COMMENT '',
          PRIMARY KEY (`id`)  COMMENT '',
          INDEX `fk_vnt_products_vnt_users1_idx` (`supplier_id` ASC)  COMMENT '',
          INDEX `fk_vnt_products_vnt_product_states1_idx` (`product_state_id` ASC)  COMMENT '',
          INDEX `fk_vnt_products_vnt_items1_idx` (`item_id` ASC)  COMMENT '',
          INDEX `fk_vnt_products_vnt_product_types1_idx` (`product_type_id` ASC)  COMMENT '',
          INDEX `fk_vnt_products_vnt_product_vats1_idx` (`product_vat_id` ASC)  COMMENT '',
          INDEX `fk_vnt_products_vnt_product_ums1_idx` (`product_um_id` ASC)  COMMENT '',
          CONSTRAINT `fk_vnt_products_vnt_users1`
            FOREIGN KEY (`supplier_id`)
            REFERENCES `vedanet_001`.`vnt_users` (`id`)
            ON DELETE NO ACTION
            ON UPDATE NO ACTION,
          CONSTRAINT `fk_vnt_products_vnt_product_states1`
            FOREIGN KEY (`product_state_id`)
            REFERENCES `vedanet_001`.`vnt_product_states` (`id`)
            ON DELETE NO ACTION
            ON UPDATE NO ACTION,
          CONSTRAINT `fk_vnt_products_vnt_items1`
            FOREIGN KEY (`item_id`)
            REFERENCES `vedanet_001`.`vnt_items` (`id`)
            ON DELETE NO ACTION
            ON UPDATE NO ACTION,
          CONSTRAINT `fk_vnt_products_vnt_product_types1`
            FOREIGN KEY (`product_type_id`)
            REFERENCES `vedanet_001`.`vnt_product_types` (`id`)
            ON DELETE NO ACTION
            ON UPDATE NO ACTION,
          CONSTRAINT `fk_vnt_products_vnt_product_vats1`
            FOREIGN KEY (`product_vat_id`)
            REFERENCES `vedanet_001`.`vnt_product_vats` (`id`)
            ON DELETE NO ACTION
            ON UPDATE NO ACTION,
          CONSTRAINT `fk_vnt_products_vnt_product_ums1`
            FOREIGN KEY (`product_um_id`)
            REFERENCES `vedanet_001`.`vnt_product_ums` (`id`)
            ON DELETE NO ACTION
            ON UPDATE NO ACTION)
        ENGINE = InnoDB
        DEFAULT CHARACTER SET = utf8
        COLLATE = utf8_unicode_ci

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

Fetching back view definitions in final form.
Nothing to fetch

[nman]

Non conosco MySql, e hp letto la domanda solo per 2 minuti .....
Pero lo Script mi sembra regolare .....

è molto probabile che l'errore arrivi dalle 6 relazioni
- innanzitutto hai le 6 tabelle citate ?? ( domanda scontata )
- nelle 6 tabelle citate hai i 6 campi citati ???
- i 6 campi sono del formato adeguato ???
- eccetera

Io eliminerei dallo Script le 6 relazioni
-- da qui incluso INDEX `fk_vnt_products_vnt_users1_idx` (`supplier_id` ASC) COMMENT '',
-- a qui incluso ON UPDATE NO ACTION)
per aggiungerle poi una per volta

.

[optime]

http://stackoverflow.com/questions/9...able-errno-150