When importing a fairly large number of goods using magma, I suddenly came across a problem:
SQLSTATE[HY000]: General error: 1364 Field 'image' doesn't have a default value - ERROR ON RECORD #1
Of course, all the fields had all the values.
Then what is it? A Magmi glitch? Magento? Or is it Mysql at all?
I will not give the whole way of finding a solution, I will only describe the result. The Problem was... in me!
The next to the image field in the import file was the width field. In the admin panel width field is spelled out with an indication of the dimension - 2 mm, 3 mm, 4 mm.
And in the import file, of course, just 2, 3, 4.
As soon as the dimension was specified in the import file, everything started working again, like a Swiss watch!
Top comments (0)