SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entity_id' in where clause is ambiguous

Vinai / groupscatalog2

Magento extension to enable you to hide categories and products from customers depending on their customer group. This is a Magento 1.6 and newer compatible version of the Netzarbeiter Customer Groups Catalog extension.

139 stars 60 forks source link

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entity_id' in where clause is ambiguous #34

Closed AlexanderHuyghebaert closed 11 years ago

AlexanderHuyghebaert commented 11 years ago

Getting this error after installation of Groups Catalog 2.

If extension is set to false, problem is gone.

If extension is set tot true and catalog_category_flat is Off, everything is also ok.

AlexanderHuyghebaert commented 11 years ago

Is there already an update about this? Really hard problem. Filtering on price doesn't work at all! Slow magento site after this

Vinai commented 11 years ago

Should be fixed by commit https://github.com/Vinai/groupscatalog2/commit/49a834174981a91713dcd919ec19f0f237a7d14f Please reopen issue if persists after update. WIll upload an updated package to MC in a few days, for now please upgrade from this github repository.