16.4.3 Update Script SQL Error (mshop_product_list_type)
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!
Always add your Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
16.4.3 Update Script SQL Error (mshop_product_list_type)
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)
From which version did you upgrade?
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
Re: 16.4.3 Update Script SQL Error (mshop_product_list_type)
any idea where i should have a look into?
Re: 16.4.3 Update Script SQL Error (mshop_product_list_type)
After the error occurs, is there an entry in your mshop_product_list_type table with
- domain: 'supplier'
- code: 'default'
- label: 'Standard'
- status: 1
- domain: 'supplier'
- code: 'default'
- label: 'Standard'
- status: 1
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
Re: 16.4.3 Update Script SQL Error (mshop_product_list_type)
Can you try this version and tell us if it works?
https://aimeos.org/fileadmin/download/a ... 1-pre2.zip
https://aimeos.org/fileadmin/download/a ... 1-pre2.zip
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
Re: 16.4.3 Update Script SQL Error (mshop_product_list_type)
thanks, on it - ill let you know shortly if it worked
Re: 16.4.3 Update Script SQL Error (mshop_product_list_type)
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."
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)
Seems like there's no locale record (site/language/currency) availablejfr 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."
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