Can't import product combinations on 8.1.2

[cricket-hockey]

Since upgrading to v8.1.2 I can't import product combinations using the csv import option on Prestashop.

I can import products no problem, but as soon as I try to then import the combinations, I get the following error pop up:

Errors occurred:

Technical error: Unexpected response returned by server. Import stopped.

In the console I can see the following error:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '25493-77869-42' for key 'id_product'

This never happened before on v1.7. I'm on php v8.1.

Any idea what the problem could be?

[cricket-hockey]

Thanks. That is the problem. id_product 25493 was there four times. Presumeably from each time I tried to do the import. So I deleted them all and tried the import again. But still it fails with the same message. When I look at the table now, 25493 is there once. The whole row looks to be complete so I am not sure why it is not then going on to process the next product?

[cricket-hockey]

I see the structure of ps_product_attribute on my new v8.1.2 database is different from the structure on v1.7.

v8 is missing the location and quantity fields. Do you think that is the problem? Should I add them?

[cricket-hockey]

I removed all the modules hooked to actionProductAdd - no difference.

I disabled the modules listed in the Product.php override - no difference.

It seems to add one row fine to ps_products_attributes and then stops. So I can add the combinations one at a time, but as I am trying to upload 300, it will take a very long time doing it that way.

Any other ideas?

Edited November 7, 2023 by cricket-hockey (see edit history)

[Vori]

8.1.1 desactiva España en localizacion. Lo activas y se vuelve a quitar solo.

[cricket-hockey]

8 hours ago, dnk.hack said:

Also, can you make the SQL dump from ps_product_attributes? 

I want to research bad fields! Sometimes a field can be NULL instead of an empty string or something like that! Or other tables must be repaired.
I have found this guide but never used it. Always try to fix it by myself!

 

Here is my table

ps_product_attribute.zip

[cricket-hockey]

UPDATE: I've just tried with a different importer (Store Commander) and it works! So I think the problem must lie with the default import in v8?

[cricket-hockey]

I've now bought this module to import products and it works fine: https://addons.prestashop.com/en/data-import-export/24523-easy-import-products-from-csv-excel-xml-json-txt.html

So must be a problem with the default import tool on v8.1?

[flencas]

On 11/8/2023 at 11:54 AM, cricket-hockey said:

I've now bought this module to import products and it works fine: https://addons.prestashop.com/en/data-import-export/24523-easy-import-products-from-csv-excel-xml-json-txt.html

So must be a problem with the default import tool on v8.1?

This module also does not import combinations on Presta 8.1.2.

Any ideas how to fix?

 

[cricket-hockey]

10 minutes ago, flencas said:

This module also does not import combinations on Presta 8.1.2.

Any ideas how to fix?

 

It works fine for me on 8.1.2. What is the error you are getting?

[flencas]

Exception: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '682-1-1' for key 'id_product' SK-A21

[cricket-hockey]

13 minutes ago, flencas said:

Exception: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '682-1-1' for key 'id_product' SK-A21

Sounds like that combination already exists in the database for that product. Can you select the option to overwrite it, if it already exists?

[flencas]

I'm trying to import multiple combinations for the same item, but the module only imports one. Option is set to update combination if exist.

[cricket-hockey]

21 minutes ago, flencas said:

I'm trying to import multiple combinations for the same item, but the module only imports one. Option is set to update combination if exist.

It work for me so there must be something wrong. I did have this happen to me once actually, but then tried again and it worked. Have you tried deleting the product completely and trying again?

[paxiko]

I had the same problem before upgrading to PS8, no matter what I wanted to import I always got the technical error, when I upgraded I had it too but since I was testing PS8 I deactivated most modules and found that I was able to import. You could give it a try, just deactivate non native modules.