Product update via csv import fails in 2022.04

[columbo]

Hi,

after upgrading to Aimeos 2022.04 product updates using csv import fails:

Code: Select all

Unable to import product with code "238530": SQLSTATE[23505]: Unique violation: 7 FEHLER: doppelter Schlüsselwert verletzt Unique-Constraint »unq_msproli_pid_sid_dm_ty_rid«
DETAIL: Schlüssel »(parentid, siteid, domain, type, refid)=(37254, 1., catalog, default, 16)« existiert bereits.:
INSERT INTO "mshop_product_list" (
"parentid", "key", "type", "domain", "refid", "start", "end",
"config", "pos", "status", "mtime", "editor", "siteid", "ctime"
) VALUES (
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
)
["37254","catalog|default|16","default","catalog","16",null,null,"[]",0,1,"2022-05-16 23:30:52","aimeos:jobs","1.","2022-05-16 23:30:52"]

Products are already imported, but I have to update prices, texts etc.
The csv worked for Aimeos 2020, but now the update fails. I could not find any new settings for shop.php or any changes for the csv mapping.

Thanks!

[aimeos]

The problem should be fixed with this patch and it will be part of the next release:
https://github.com/aimeos/ai-controller ... c07ede72ec

In the meantime, you can add a configuration with the new values to your ./config/shop.php

[columbo]

perfect - its working with the added configuration
Thank you!