category_ids column not found

[keyur-iksula]

I found an issue while reindexing the products flat data, when i wrote code in try catch block it shows me error in _getDocuments() function of resource/catalog/product/indexer/elasticgento.php file.

Can any one help me to find the solution?

[dng-dev]

Hi can you give me more information for this?

[keyur-iksula]

Hello Daniel ,

I have installed this extension to new fresh 1.9.1.0 magento. I have done the required configuration from backend (attached an image). When i tried to re-index "Product flat data" from indexing i found error that want allow me to reindex the data. To identify the error i wrote exception handing code in function _getDocuments($storeId, $parameters = array()) [ line no: 237] of model/resource/catalog/product/indexer/elasticgento.php file.

After writing exception handing it's shows me error "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.category_ids' in 'field list' " so i have changed code of that function. i have added following line of code to skip iteration of attribute code is 'category_ids'.

[appended on line no: 282 ]
if($attributeCode == "category_ids"){
continue;
}

After appending above code, i can able to do re-indexing of product flat data and i can see product flat data in elastic document by hitting url in browser.

But after indexing when i go to category page, there isn't any layered navigation visible. i confirmed that products are coming from elastic document but layered navigation is not visible.

After digging into code i found the attributes count for product collection is returning null, so layered navigation is not displaying in category page.

Thanks for your instance replay, it will really helpful if you resolve my issue.