How to configure and adapt Aimeos based shops as developer
Forum rules: Always add your Aimeos and PHP version as well as your environment (Linux/Mac/Win)
#2984 by jfr
12 Jul 2016, 09:25
Running the extension managers update script i receive the following error. How can i fix that constraint issue?

Code: Select allMigrate suppliercode in mshop_product                                 
Executing statement "INSERT INTO "mshop_product_list" ("parentid", "siteid", "typeid", "domain", "refid", "config", "status", "ctime", "mtime", "editor")
       SELECT p."id", p."siteid", (SELECT t."id" FROM "mshop_product_list_type" t WHERE t."siteid" = p."siteid" AND t."domain" = 'supplier' AND t."code" = 'default'), 'supplier', s."id", '[]', 1, NOW(), NOW(), 'setup:ProductMigrateSupplier'
       FROM "mshop_supplier" s JOIN "mshop_product" p ON p."suppliercode" = s."code"" failed: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails ("INSTANCENAME"."mshop_product_list", CONSTRAINT "fk_msproli_typeid" FOREIGN KEY ("typeid") REFERENCES "mshop_product_list_type" ("id") ON DELETE CASCADE ON UPDATE CASCADE)
#3184 by jfr
08 Aug 2016, 15:20
The update now went through smoothly. Thanks a lot!

One small issue is left: the new backend dashboard throws "Error Price can not be added. Currency ID "" of price item and currently used currency ID "EUR" does not match."
#3186 by aimeos
09 Aug 2016, 11:24
jfr wrote:One small issue is left: the new backend dashboard throws "Error Price can not be added. Currency ID "" of price item and currently used currency ID "EUR" does not match."


Seems like there's no locale record (site/language/currency) available