macopedia / magmi-m2

Magmi GitHub, see branch magento2 for a version compatible with Magento 2
113 stars 53 forks source link

Column 'is_in_stock' cannot be null #64

Open serik303 opened 4 years ago

serik303 commented 4 years ago

// Provide a general summary of the issue in the Title above

Preconditions

// Provide a more detailed information about you Magento, Apache2/nginx, PHP & MySQL version // Provide example CSV file to help us reproduce your issue run php magmi-m2/magmi/integration/samples/sample2_configurables.php

Steps to reproduce

run php magmi-m2/magmi/integration/samples/sample2_configurables.php

Actual result

// Tell us what happens instead - screenshot, logs etc. error:SKU 00000 - 1:SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'is_in_stock' cannot be null - error:SKU 00000 - 2:SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'is_in_stock' cannot be null - ERROR ON RECORD #1 error:SKU 00001 - 3:SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'is_in_stock' cannot be null - error:SKU 00001 - 4:SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'is_in_stock' cannot be null - ERROR ON RECORD #2 error:SKU 00002 - 5:SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'is_in_stock' cannot be null - error:SKU 00002 - 6:SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'is_in_stock' cannot be null - ERROR ON RECORD #3

is there a way to import conigurable?

tmotyl commented 4 years ago

Hi This is most probably caused by the mysql being configured in the „strict mode”. To solve that you can either change mysql settins or send a pull requesst which makes magmi always send values for „is_in_stock”

Please also attach a minimal csv file which allows to reproduce the issue.

serik303 commented 4 years ago

thx, i give it a try next days

can u pls look this one too? https://github.com/macopedia/magmi-m2/issues/30