MySQL Forums
Forum List  »  MySQL Workbench

Table create fails
Posted by: Abbott Fleur
Date: August 13, 2021 11:56AM

I am trying to add a new table to a local WordPress wpinventory db. I get the error message ERROR 1824: Failed to open the referenced table 'wp_wpinventory_item' see below, even though I can do a SELECT * wp_wpinventory_item.

Thanks - MySQL newbie but years of SqlServer.

Abbott

Operation failed: There was an error while applying the SQL script to the database.
Executing:
CREATE TABLE `abbott_wp6`.`kbo_inventorycategory` (
`inventorycategoy_id` INT NOT NULL AUTO_INCREMENT,
`inventory_id` INT NOT NULL,
`categoy_id` INT NOT NULL,
`category_type` VARCHAR(10) NOT NULL DEFAULT 'subject',
PRIMARY KEY (`inventorycategoy_id`),
INDEX `fk_inventorycatalog_inventory_idx` (`inventory_id` ASC) VISIBLE,
INDEX `fk_inventorycaegory_category_idx` (`categoy_id` ASC) VISIBLE,
CONSTRAINT `fk_inventorycategory_inventory`
FOREIGN KEY (`inventory_id`)
REFERENCES `abbott_wp6`.`wp_wpinventory_item` (`inventory_id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_inventorycaegory_category`
FOREIGN KEY (`categoy_id`)
REFERENCES `abbott_wp6`.`wp_wpinventory_category` (`category_id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
COMMENT = 'Has entries for each inventory item that point to its age, suject matter(s) and special catalog groups - teachers choice, bargains, new titles, under $2. Used to display age/subject(s) on inventory item page and list the various special catalogs.';

ERROR 1824: Failed to open the referenced table 'wp_wpinventory_item'
SQL Statement:
CREATE TABLE `abbott_wp6`.`kbo_inventorycategory` (
`inventorycategoy_id` INT NOT NULL AUTO_INCREMENT,
`inventory_id` INT NOT NULL,
`categoy_id` INT NOT NULL,
`category_type` VARCHAR(10) NOT NULL DEFAULT 'subject',
PRIMARY KEY (`inventorycategoy_id`),
INDEX `fk_inventorycatalog_inventory_idx` (`inventory_id` ASC) VISIBLE,
INDEX `fk_inventorycaegory_category_idx` (`categoy_id` ASC) VISIBLE,
CONSTRAINT `fk_inventorycategory_inventory`
FOREIGN KEY (`inventory_id`)
REFERENCES `abbott_wp6`.`wp_wpinventory_item` (`inventory_id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_inventorycaegory_category`
FOREIGN KEY (`categoy_id`)
REFERENCES `abbott_wp6`.`wp_wpinventory_category` (`category_id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
COMMENT = 'Has entries for each inventory item that point to its age, subject matter(s) and special catalog groups - teachers choice, bargains, new titles, under $2. Used to display age/subject(s) on inventory item page and list the various special catalogs.'

Options: ReplyQuote


Subject
Views
Written By
Posted
Table create fails
842
August 13, 2021 11:56AM
277
August 13, 2021 12:20PM
295
August 13, 2021 02:11PM
329
August 13, 2021 02:32PM
290
August 13, 2021 02:50PM
268
August 14, 2021 02:53PM
278
August 14, 2021 03:49PM
257
August 15, 2021 08:40AM
257
August 15, 2021 12:37PM
242
August 16, 2021 12:57PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.