bensd00
1
Hi, I’v been looking around for my problem but still cant find it, I’m new to mySQL. I keep getting this error. Please help
Thank You
ERROR: Error 1005: Can't create table '.\\san10117028r\\quoteproduct.frm' (errno: 121)
-- -----------------------------------------------------
-- Table `san10117028r`.`QuoteProduct`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `san10117028r`.`QuoteProduct` (
`ProductID` INT NOT NULL ,
`Quantity` VARCHAR(45) NULL ,
`Comments` VARCHAR(45) NULL ,
`QuoteID` INT NOT NULL ,
INDEX `ProductID` (`ProductID` ASC) ,
INDEX `QuoteID` (`QuoteID` ASC) ,
PRIMARY KEY (`ProductID`) ,
CONSTRAINT `ProductID`
FOREIGN KEY (`ProductID` )
REFERENCES `san10117028r`.`Products` (`ProductID` )
ON DELETE CASCADE
ON UPDATE CASCADE,
CONSTRAINT `QuoteID`
FOREIGN KEY (`QuoteID` )
REFERENCES `san10117028r`.`QuoteSummery` (`QuoteID` )
ON DELETE CASCADE
ON UPDATE CASCADE)
ENGINE = InnoDB
post your create table statements for the two tables you reference in your foreign keys. that might offer a clue.
bensd00
3
-- -----------------------------------------------------
-- Table `san10117028r`.`Products`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `san10117028r`.`Products` (
`ProductID` INT NOT NULL ,
`EnvelopeID` INT NULL ,
`BasketID` INT NULL ,
`BurnerID` INT NULL ,
`FuelCylinderID` INT NULL ,
`AccessoriesID` INT NULL ,
`FanID` INT NULL ,
PRIMARY KEY (`ProductID`) ,
INDEX `EnvelopeID` (`EnvelopeID` ASC) ,
INDEX `BasketID` (`BasketID` ASC) ,
INDEX `BurnerID` (`BurnerID` ASC) ,
INDEX `FuelCylinderID` (`FuelCylinderID` ASC) ,
INDEX `AccessoriesID` (`AccessoriesID` ASC) ,
INDEX `FanID` (`FanID` ASC) ,
CONSTRAINT `EnvelopeID`
FOREIGN KEY (`EnvelopeID` )
REFERENCES `san10117028r`.`Envelope` (`EnvelopeID` )
ON DELETE CASCADE
ON UPDATE CASCADE,
CONSTRAINT `BasketID`
FOREIGN KEY (`BasketID` )
REFERENCES `san10117028r`.`Basket` (`BasketID` )
ON DELETE CASCADE
ON UPDATE CASCADE,
CONSTRAINT `BurnerID`
FOREIGN KEY (`BurnerID` )
REFERENCES `san10117028r`.`Burner` (`BurnerID` )
ON DELETE CASCADE
ON UPDATE CASCADE,
CONSTRAINT `FuelCylinderID`
FOREIGN KEY (`FuelCylinderID` )
REFERENCES `san10117028r`.`FuelCylinder` (`FuelCylinderID` )
ON DELETE CASCADE
ON UPDATE CASCADE,
CONSTRAINT `AccessoriesID`
FOREIGN KEY (`AccessoriesID` )
REFERENCES `san10117028r`.`Accessories` (`AccessoriesID` )
ON DELETE CASCADE
ON UPDATE CASCADE,
CONSTRAINT `FanID`
FOREIGN KEY (`FanID` )
REFERENCES `san10117028r`.`Fans` (`FanID` )
ON DELETE CASCADE
ON UPDATE CASCADE)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `san10117028r`.`QuoteSummery`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `san10117028r`.`QuoteSummery` (
`QuoteID` INT NOT NULL ,
`ClientID` INT NOT NULL ,
`BalloonName` VARCHAR(45) NULL ,
`Country` VARCHAR(45) NULL ,
`EnquiredDate` VARCHAR(45) NULL ,
`QuoteStatus` VARCHAR(45) NULL ,
`Deadline` VARCHAR(45) NULL ,
`StaffID` INT NOT NULL ,
`LastEdited` VARCHAR(45) NULL ,
PRIMARY KEY (`QuoteID`) ,
INDEX `ClientID` (`ClientID` ASC) ,
INDEX `StaffID` (`StaffID` ASC) ,
CONSTRAINT `ClientID`
FOREIGN KEY (`ClientID` )
REFERENCES `san10117028r`.`ClientDetails` (`ClientID` )
ON DELETE CASCADE
ON UPDATE CASCADE,
CONSTRAINT `StaffID`
FOREIGN KEY (`StaffID` )
REFERENCES `san10117028r`.`Staff` (`StaffID` )
ON DELETE CASCADE
ON UPDATE CASCADE)
ENGINE = InnoDB;
There are the table statements for the two tables i referenced.