Error after aimeos update to 2019.10.* ,aimeos setup db error
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!
Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
-
- Posts: 86
- Joined: 12 Jan 2019, 15:17
Error after aimeos update to 2019.10.* ,aimeos setup db error
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
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
Re: Error after aimeos update to 2019.10.* ,aimeos setup db error
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.
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, give us a star
If you like Aimeos, give us a star