search

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 59 forks source link

SQL issue #147

Open dvdmierden opened 7 years ago

dvdmierden commented 7 years ago

I've installed, uninstalled & reinstalled the extension.

Now when enabling the extension & trying to reindex the Groupscatalog Categories index, I see the following SQL error in the exception log:

Exception message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.value' in 'field list', query was: SELECT `e`.`entity_id`, `a`.`value` AS `group_ids`, `a`.`store_id` FROM `catalog_category_entity` AS `e`
 LEFT JOIN `catalog_category_entity` AS `a` ON e.entity_id=a.entity_id AND a.attribute_id = '' ORDER BY `e`.`entity_id` ASC, `a`.`store_id` ASC

Because of this issue, all categories are hidden in the frontend.

Turns out, the catalog_category_entity table is searched, but that indeed doesn't have a 'value' column. I believe it should look in catalog_category_entity_int , but I'm not sure how to resolve this.

Any thoughts?

renttek commented 7 years ago

Hey,

which Magento version are you using? And is there a PHP Stacktrace printed when the error occurs? I'll try to reproduce this later when I'm home.