Symfony Cannot Execute Doctrine Schema Update

Question

I am having an issue running doctrine:schema:update --force because of a forgeign key constraint issue.

 [Doctrine\DBAL\DBALException] An exception occurred while executing 'ALTER TABLE Product ADD CONSTRAINT FK_1CF73D312ADD6D8C FOREIGN KEY (supplier_id) REFERENCES Supplier (id) ON DELETE SET NULL':                                                                                                                   

 SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`wic_dev`.`#sql-5c0 a_1a12`, CONSTRAINT `FK_1CF73D312ADD6D8C` FOREIGN KEY (`supplier_id`) REFERENCES `Supplier` (`id`) ON DELETE SET NULL)                        

 [PDOException] SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`wic_dev`.`#sql-5c0 a_1a12`, CONSTRAINT `FK_1CF73D312ADD6D8C` FOREIGN KEY (`supplier_id`) REFERENCES `Supplier` (`id`) ON DELETE SET NULL)

I have two tables that are creating this error: Products and Suppliers.

Products can have 1 supplier and suppliers can have many products.

Here is how I have my entities set up:

Product Entity:

 /**
 * @ORM\ManyToOne(targetEntity="WIC\SupplierBundle\Entity\Supplier", inversedBy="products", fetch="EAGER")
 * @ORM\JoinColumn(name="supplier_id", referencedColumnName="id", nullable=true, onDelete="SET NULL")
 * @Common\Versioned
 * @Assert\NotBlank(message="Supplier Cannot Be Blank")
 */
protected $supplier;

Supplier Entity

 /**
 * @ORM\OneToMany(targetEntity="WIC\ProductBundle\Entity\Product", mappedBy="supplier", cascade={"all"})
 */
protected $products;

I currently have data in each table. I know some products are missing a supplier and suppliers are missing products.

What am I doing wrong and how can I fix this issue? I need to run this schema update so that my other tables will get updated as well.

Thanks so much for your help!

Everytime I get a problem with the constraints I just delete the whole table wich is in the database and let Doctrine generate it again. That's mostly the way I get it fixed. But since there is data in the table you could try to make a backup of it first, that delete the table, let Doctrine generate the new table en pass in the data — Robin Hermans
– Robin Hermans, Commented Dec 19, 2013 at 19:16

LargeTuna · Accepted Answer · 2013-12-19 19:50:21Z

5

Here is how I fixed the issue. In my products table I was storing values as "0" if the supplier wasnt found. Because it was a manytoone and onetomany relationship between the two tables, it was having a conflict because supplier_id is never 0, 0 does not match any id in the suppliers table. I had to update the products table to set any value for 0 to NULL, this made the schema update work.

answered Dec 19, 2013 at 19:50

LargeTuna

2,8448 gold badges50 silver badges97 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mick · Accepted Answer · 2014-05-06 11:18:20Z

0

In most cases, it's a simple autoloading problem

In most cases, simply make sure you have a use statement for the entity you're trying to create a relationship with. This happens often when the 2 entities are not in the same bundle and therefore need to autoload them. For the error to disappear, simply do this:

In your product entity, don't forget:

use WIC\SupplierBundle\Entity\Supplier;

answered May 6, 2014 at 11:18

Mick

32.2k17 gold badges114 silver badges132 bronze badges

Collectives™ on Stack Overflow

Symfony Cannot Execute Doctrine Schema Update

2 Answers 2

Comments

In most cases, it's a simple autoloading problem

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

In most cases, it's a simple autoloading problem

Comments

Your Answer

Sign up or log in

Post as a guest

Related