Every thing was working fine but no products are showing after updating to Commerce Kickstart 7.x-2.6. I haven’t changed anything except update.

Comments

bojanz’s picture

bojanz commented

Not showing up where? The frontend or the backend?
Guessing it's the frontend, in which case you probably need to rebuild your Search API index.

(You also didn't mention which version you updated from. You provided no information that would allow someone to help you)

fhdrupal’s picture

fhdrupal commented

I updated from drupal 7.21 to 7.22, checked the website received the following errors for all the views and views disappeared.

“SQLSTATE[42S22]: Column not found: 1054 Unknown column 'value' in 'where clause'”

I ran the script update process, updated successfully, and same situation for all views. I regenerated my custom made views, and the error gone for that views. The only view that I can’t remake is ‘All Products Display view’ using search api. It doesn't give me delete option to remake it from the scratch. But I made the same type of view with different name, but I think search api is not working. Please help, appreciated.

fhdrupal’s picture

fhdrupal commented

After digging around, I found that the problem is with search api setting. Search for search_api settings and issues found this patch solved my problem.
Patch: http://drupal.org/files/search_api_db-unknown_column_value-1805640-9.patch

But I wonder this patch is there for a while why didn’t commerce kickstart project fixed it in new version. I found many people complaining about it.

Thanks for your response; you can mark this issue as fixed.

jsacksick’s picture

jsacksick commented
Status: Active » Fixed

You should try with the latest Commerce Kickstart version, this shouldn't happen anymore.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.