Error after aimeos update to 2019.10.* ,aimeos setup db error

Help for integrating the Laravel package
Forum rules
Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
awaidqureshi
Posts: 86
Joined: 12 Jan 2019, 15:17

Error after aimeos update to 2019.10.* ,aimeos setup db error

Post by awaidqureshi » 10 Jan 2020, 13:27

I have upgraded my system from aimeos 2018.10.* to 2019.0.*

when i run aimeos:setup command there is an error
how can i solve this

Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails ("nordicforms_test"."#sql-50b_6086", CONSTRAINT "fk_mspropr_pid" FOREIGN KEY ("parentid") REFERENCES "mshop_product" ("id") ON DELETE CASCADE ON UPDATE CASCADE): ALTER TABLE mshop_product_property ADD CONSTRAINT fk_mspropr_pid FOREIGN KEY (parentid) REFERENCES mshop_product (id) ON UPDATE CASCADE ON DELETE CASCADE

User avatar
aimeos
Administrator
Posts: 7835
Joined: 01 Jan 1970, 00:00

Re: Error after aimeos update to 2019.10.* ,aimeos setup db error

Post by aimeos » 10 Jan 2020, 13:31

Did you have no foreign key constraint between mshop_product and mshop_product_property tables before?
Check, if there are records in mshop_product_property with a parentid value that isn't available in mshop_product any more.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Post Reply