SQL issue

[dvdmierden]

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]

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.