Vinai Kopp

Hi @aarti6495 , this is not the right place to ask for Magento upgrade help. Please use the [magento stack exchange](http://magento.stackexchange.com/) site or the [official Magento forums](http://community.magento.com/).

Can you please prefix the `SELECT` with `EXPLAIN` and post the resulting query plan? ``` sql EXPLAIN SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at... ```

That is a great idea! Thanks for the suggestion. I wish I had a week or so to really bring this module back up to speed again, I have neglected...

Hi, thanks for your report. I currently don't have the time to look into the issue. Very sorry I can't give a more supportive answer. Maybe someone else will be...

Thanks for your detailed report. Did you try reindexing the groupscatalog tables? Does that cause something to be logged into the var/log/exception.log file?

Can you post the result of the following SQL queries please? ``` sql SELECT group_id, COUNT(*) FROM groupscatalog_category_idx group by group_id; ``` and ``` sql SELECT * FROM core_config_data WHERE...

Thanks. Your configuration looks fine. I looks like you have some specific visibility settings for the customer group 2. It seems that you have limited access only for that one...

Could you please also post a screenshot of the backend interface for a generally accessable category and for the category that is hidden? Thanks.

I'm sorry to say that I have no time to contribute to my open source projects until next year due to the current work load. You will either have to...

Thank you. If you find a solution, it would be great if you would post it here. Others would appreciate it a lot I'm sure.