Page 1 of 1

16.4.3 Update Script SQL Error (mshop_product_list_type)

Posted: 12 Jul 2016, 09:25
by jfr
Running the extension managers update script i receive the following error. How can i fix that constraint issue?

Code: Select all

Migrate 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)

Re: 16.4.3 Update Script SQL Error (mshop_product_list_type)

Posted: 12 Jul 2016, 16:05
by aimeos
From which version did you upgrade?

Re: 16.4.3 Update Script SQL Error (mshop_product_list_type)

Posted: 21 Jul 2016, 14:29
by jfr
i think 2.4.2

Re: 16.4.3 Update Script SQL Error (mshop_product_list_type)

Posted: 03 Aug 2016, 15:54
by jfr
any idea where i should have a look into?

Re: 16.4.3 Update Script SQL Error (mshop_product_list_type)

Posted: 05 Aug 2016, 17:38
by aimeos
After the error occurs, is there an entry in your mshop_product_list_type table with
- domain: 'supplier'
- code: 'default'
- label: 'Standard'
- status: 1

Re: 16.4.3 Update Script SQL Error (mshop_product_list_type)

Posted: 06 Aug 2016, 12:12
by aimeos
Can you try this version and tell us if it works?
https://aimeos.org/fileadmin/download/a ... 1-pre2.zip

Re: 16.4.3 Update Script SQL Error (mshop_product_list_type)

Posted: 08 Aug 2016, 14:39
by jfr
thanks, on it - ill let you know shortly if it worked

Re: 16.4.3 Update Script SQL Error (mshop_product_list_type)

Posted: 08 Aug 2016, 15:20
by jfr
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."

Re: 16.4.3 Update Script SQL Error (mshop_product_list_type)

Posted: 09 Aug 2016, 11:24
by aimeos
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