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

[Presta_lover]

Hi,

I am working with local development and production site.

Prestashop: 1.7.6.1

I have more than 5.000 categories and subcategories (auto parts website).

My main duty now is to import (through native import tool) long product files.

To avoid errors in production, I do import first in local.

Problem is that suddenly, without no module installations, either code changes, etc.  import tool is throwing me this error:

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

If I look into dev tools, I see this:

Duplicate entry '2019117144-1' for key 'PRIMARY'<br /><br /><pre>INSERT INTO `pr_category_shop` (`id_category`, `id_shop`) VALUES ('2019117144', '1')</pre>

.csv file configuration:

|reference|name|category(id1,id2,id3,id4...)|imgage

I can't see where is the problem, and why now, after importing tons of products whitout problem at all...

Weird thing too, import stop, but it creates new categories! why creates news categories if products has assigned its own existing category?

thanks, hope you can help

 

[Presta_lover]

Hi,

thanks.

I can read duplicate entries too. But I don't know why is this behaviour when I have not duplicate entries.

I am trying to import PRODUCTS, not categories. So, I don't understand why is this behaviour...

I re install it, and now (untill now...) is working fine.

[aacaac]

Check if your cells (in .csv) is longer than allow maximum characters. In my case, features had strings too long. When I wrote features with small strings, CSV was imported fine.

[AlexLopatenco]

Got the same error just now. Prestashop 1.7.7.3, importing a .csv file

Quote

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

Solved by deleting some "unwanted symbols". For some reason, there is no list of these symbols anywhere, so I'll post it here:
 

Quote

/ \ $ & % < > * # ' " ` ~ ( ) [ ] { } | = 

AND "non breaking space". Hope this helps.

Edited August 31, 2021 by AlexLopatenco (see edit history)