CSV Import attribute INSERT INTO "mshop_product_list" Duplicate entry

[TGergo]

Hello!

I would like to run the CSV import multiple times.

I set the update to change the following attributes.

Code: Select all

'controller' => [
	'product' => [
                   'import' => [
                       'csv' => [
                           'processor' => [

			       // modify by update import
                               'attribute' => [
                                   'listtypes' => [
                                       'myattribute1',
                                       'myattribute2'
                                   ],
                               ],
				...

Then I get the following error:

Code: Select all

Unable to import product with code "2": SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '125124-attribute-default-65287-1.' for key 'mshop_product_list.unq_msproli_pid_dm_ty_rid_sid':
INSERT INTO "mshop_product_list" (
"parentid", "key", "type", "domain", "refid", "start", "end",
"config", "pos", "status", "mtime", "editor", "siteid", "ctime"
) VALUES (
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
)

I tried to find the cause of the error, but so far I have not succeeded.
I rewrote:
from:

Code: Select all

INSERT INTO "mshop_product_list"

to:

Code: Select all

INSERT IGNORE INTO "mshop_product_list"

But this is not a permanent solution.
Thanks if you have any ideas.

TGergo

PHP 8.1
"aimeos/aimeos-laravel": "^2022.10",
Windows + Homestead Vagrant Linux

[aimeos]

Does that also occur if you remove your "listtypes" configuration?

[TGergo]

No, if I take it out, it runs flawlessly.

[TGergo]

Other problem with this feature.

When I add an attribute to the array
for example: 'myattribute1'

the first value is: text1
I change the value in the csv file: text2

will add text2 but not delete text1

so I have two values:
myattribute1 : text1
myattribute1 : text2

but my csv file contains only one

[aimeos]

Your configuration is wrong and must be:

Code: Select all

	'controller' => [
		'jobs' => [
			'product' => [
				'import' => [
					'csv' => [
						'attribute' => [
							'listtypes' => ['myattribute1', 'myattribute2'],
						],
					],
				],
			],
		],
	],

[TGergo]

Thanks! That was the problem.

[TGergo]

Thanks! That was the problem.

Another problem
It worked on my local machine but not on the test server.
same error, did not delete the old attributes
the solution: change Redis queue worker numprocs=2 to numprocs=1

[TGergo]

Your configuration is wrong and must be:

Code: Select all

	'controller' => [
		'jobs' => [
			'product' => [
				'import' => [
					'csv' => [
						'attribute' => [
							'listtypes' => ['myattribute1', 'myattribute2'],
						],
					],
				],
			],
		],
	],

No, I think the documentation is also bad, this is the right one:

controller/common/product/import/csv/processor/attribute/listtypes

[aimeos]

At the moment, both are working:
https://github.com/aimeos/ai-controller ... hp#L72-L73

In 2024+, the "controller/common/..." setting will be removed.