Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Column 'is_in_stock' cannot be null #64

Open
serik303 opened this issue Nov 30, 2019 · 2 comments
Open

Column 'is_in_stock' cannot be null #64

serik303 opened this issue Nov 30, 2019 · 2 comments

Comments

@serik303
Copy link

// 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
Copy link
Member

tmotyl commented Dec 1, 2019

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
Copy link
Author

serik303 commented Dec 4, 2019

thx, i give it a try next days

can u pls look this one too?
#30

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants