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

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'p.family_variant' #182

Open
lucasmilin opened this issue Apr 5, 2018 · 2 comments

Comments

@lucasmilin
Copy link

Hi,
I am currently trying PimGento2 and when I run a family variant by Magento 2 interface I receive the following message:

[20:49:32] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'p.family_variant' in 'on clause', query was: UPDATE pimgento_variant AS p LEFT JOIN tmp_pimgento_entities_variant_family AS f ON p.family_variant = f.code SET p.axis = f._axis

Configuration:
Magento 2.2.3
Akeneo 2.2
Pimgento 100.3.2

What's wrong?

Thanks!

@nicobatty
Copy link

I had the same issue and I think it is because you need to import the product models before the family variants. Don't ask me why!

@lucasmilin
Copy link
Author

lucasmilin commented Apr 6, 2018

Actually, I skipped the product model import with PimGento because CSV product model export with Akeneo's sample did not work. I am going to fix this error first and afterwards I'll try your flow.
Thanks!

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