Unknown column 'e.category_ids' in field list.

Hi,
After reindexing, we are getting an error when updating product details and status. 
Following error is coming in admin  site Magento 2.0.7
exception ‘PDOException’ with message ‘SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘e.category_ids’ in ‘field list”
Please help me on this.
Thanking you
Nilesh Gire

6 answers

Profile photo of An Nguyen Staff 8540.00 $tone October 4, 2016
Public

Hi Nilesh, 
I wonder if you’re using our Product List extension here -- https://www.ubertheme.com/magento-extensions/product-list? 
If that is the case, this extension is available for Magento 1 only. 
Regards,
An Nguyen

#1
Profile photo of Nilesh Gire 50.00 $tone October 4, 2016
Public

Hi Nguyen,
we are not using any product-list extension, we are using Amasty Extension for product feed and for that we setup one cron for every minute  ‘php  /bin/magento  cron:run’ 
Thanking you

#2
Profile photo of An Nguyen Staff 8540.00 $tone October 5, 2016
Public

Hi Nilesh, 
I wonder if you do use Amasty extension in combination with any of our product? Our forum is aimed at the issues related to our themes and extensions only. 
Meanwhile, as mentioned in my previous reply, in case you use any of our product, please make sure you check the version info accordingly. 
All our M2 extensions: https://www.ubertheme.com/magento-extensions-2-x/
M2 themes: 

Regards,
An Nguyen
 
 

#3
Profile photo of Nilesh Gire 50.00 $tone October 5, 2016
Public

Hi Nguyen,
But in local machine, it is working fine with the same extension in Magento 2.0.7 and we also did reindex.
Why in production it is not working but in local machine it’s work.
Please help me on.
 
Thanking you,
Nilesh Gire

#4
Profile photo of Nilesh Gire 50.00 $tone October 5, 2016
Public

Hi Nguyen,

We used Uber theme data migration tools (Which is free) for a migrating database of Magento 1.9 to Magento 2.0.
When we did the migration all products were not showing on a category page. So we toggled the status of all products from enable to disable and then enable again which solved this problem.
We also installed an Amasty extension for product feed creation for that we set Cron.
After that, Magento was showing we need to re-index so we did that then after that is shows the following when we try to save anything in the admin site. Although it does save properly but the user gets the error page.
exception ‘PDOException’ with message ‘SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘e.category_ids’ in ‘field list”
Any help you can give will be appreciated.

Thanking you,
Nilesh Gire

#5
Profile photo of An Nguyen Staff 8540.00 $tone October 6, 2016
Public

Hi Nilesh, 
It seems you’re using our old instance distributed on Github? Such script was dated long ago, since Magento 2.0.0, so it potentially comes with unexpected issues, especially when you use with newer Magento version like Magento 2.0.6. 
It’s hard for us to provide you help under this circumstance, as we no longer maintain such old free version. 
Thanks for your understanding. 
PS. Please consider to move forward with our Pro version to get the latest updates, new feature enhancements as well as our technical support. 
Kind Regards,
An Nguyen

#6

Please login or Register to Submit Answer

Written By

Comments