I am running an ecommerce set up with Commerce as the main module. Recently added a few fields to my products and am now finding that if I filter by said fields, some results will not be filtered correctly. We're talking in the region of 5,000+ products in total with probably 2,500+ display nodes.

What I've done so far:

Upgraded SQL to 5.6
Upgraded Easy Apache from 3 to 4
Stripped down views to the basics (just filtering by the field that I've noticed the issue on) and no improvement

Relationships don't seem to cause the issue. I'm running Editable Views, but running a view that doesn't utilise that module is still producing the same results. I'm pretty sure the only changes I've made between the views working correctly and the buggy results is the added fields (which I've created using the gui and applied values to using feed importer). I can't remember any module updates that might have been applied in the same time frame.

Happy to provide any further details to get this issue sorted. The project is live, but since I'm using facets to display the front end, it appears to only be affecting my custom admin views. Still, the sooner I get it corrected, the better.

Editing to add: Just tried out the dev version of Views with no improvement. Also tried manually saving an affected product in case the import did something strange with the save. No improvement there either.

Second edit: On further testing, I've found that the view will produce correct results if only 1 filter is applied. As soon as a second filter is applied, it loses its mind and can't handle it for whatever reason. I've tested with 3 different versions of views installed, .15 .16 and dev, and all produce the same results. Note: With one filter, it seems to make it maybe half way through the results before failing. Perhaps an sql limitation?

Comments

sjvellenga created an issue. See original summary.

sjvellenga’s picture

Issue summary: View changes
sjvellenga’s picture

Issue summary: View changes
sjvellenga’s picture

Issue summary: View changes