16.4.3 Update Script SQL Error (mshop_product_list_type)

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)
Spam and unrelated posts will be removed immediately!
jfr
Posts: 9
Joined: 16 Sep 2015, 16:08

16.4.3 Update Script SQL Error (mshop_product_list_type)

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

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

Re: 16.4.3 Update Script SQL Error (mshop_product_list_type)

Post by aimeos » 12 Jul 2016, 16:05

From which version did you upgrade?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

jfr
Posts: 9
Joined: 16 Sep 2015, 16:08

Re: 16.4.3 Update Script SQL Error (mshop_product_list_type)

Post by jfr » 21 Jul 2016, 14:29

i think 2.4.2

jfr
Posts: 9
Joined: 16 Sep 2015, 16:08

Re: 16.4.3 Update Script SQL Error (mshop_product_list_type)

Post by jfr » 03 Aug 2016, 15:54

any idea where i should have a look into?

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

Re: 16.4.3 Update Script SQL Error (mshop_product_list_type)

Post by aimeos » 05 Aug 2016, 17:38

After the error occurs, is there an entry in your mshop_product_list_type table with
- domain: 'supplier'
- code: 'default'
- label: 'Standard'
- status: 1
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

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

Re: 16.4.3 Update Script SQL Error (mshop_product_list_type)

Post by aimeos » 06 Aug 2016, 12:12

Can you try this version and tell us if it works?
https://aimeos.org/fileadmin/download/a ... 1-pre2.zip
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

jfr
Posts: 9
Joined: 16 Sep 2015, 16:08

Re: 16.4.3 Update Script SQL Error (mshop_product_list_type)

Post by jfr » 08 Aug 2016, 14:39

thanks, on it - ill let you know shortly if it worked

jfr
Posts: 9
Joined: 16 Sep 2015, 16:08

Re: 16.4.3 Update Script SQL Error (mshop_product_list_type)

Post 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."

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

Re: 16.4.3 Update Script SQL Error (mshop_product_list_type)

Post 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
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Post Reply