search

akeneo / pim-community-dev

[Community Development Repository] The open source Product Information Management (PIM)
http://www.akeneo.com
Other
954 stars 514 forks source link

SQL error while importing products #5954

Closed malteSchultz closed 7 years ago

malteSchultz commented 7 years ago

When importing a CSV-file with products via the "Akeneo CSV Connector" sometimes Akeneo returns the following error message: bildschirmfoto 2017-03-20 um 14 28 39

The same import profile with other import data produces no problems. The CSV-files imported don't contain the number 1264 and the message seems to be the same in several instances of the error.

arnolanglade commented 7 years ago

Hi @malteSchultz-redteclab ,

You want to import 4250201202413, what did you configure as min and max for that attribute?

malteSchultz commented 7 years ago

The min and max values were not set. But since the attribute should have been a text to begin with, we fixed the problem this way. But the error message could give some clue about this.

mickaelandrieu commented 7 years ago

Hello @malteSchultz-redteclab,

can you please provide your PIM information? (You can export a txt file from System > System informations)

Also, would you mind to test using an updated version of Akeneo: we need a reproducible test case to fix the issue.

Thanks for your help :)

mickaelandrieu commented 7 years ago

Hello @malteSchultz-redteclab,

we close the issue right now, if you still have a question or an issue about Products import feel free to open a new issue.

Thank you for your understanding