DEV Community

Sa
Sa

Posted on

Magmi "1364 Field doesn't have a default value" error - Just be careful

When importing a fairly large number of goods using magma, I suddenly came across a problem:

Image description

SQLSTATE[HY000]: General error: 1364 Field 'image' doesn't have a default value - ERROR ON RECORD #1
Enter fullscreen mode Exit fullscreen mode

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)