A few problems

[ghost]

First, after the installation, i'll reindex the catalog. Then i get erros on the homepage, i can't open in the admin the category page or edit a product. What's wrong?

[ghost]

This is the error:

Mage registry key "_singleton/Netzarbeiter_GroupsCatalog2_Model_Observer" already exists

Trace:
#0 /home/nagelprod/domains/test.nagelproducten-limburg.nl/public_html/app/Mage.php(222): Mage::throwException('Mage registry k...')
#1 /home/nagelprod/domains/test.nagelproducten-limburg.nl/public_html/app/Mage.php(476): Mage::register('_singleton/Netz...', false)
#2 /home/nagelprod/domains/test.nagelproducten-limburg.nl/public_html/includes/src/__default.php(21023): Mage::getSingleton('Netzarbeiter_Gr...')
#3 /home/nagelprod/domains/test.nagelproducten-limburg.nl/public_html/app/Mage.php(447): Mage_Core_Model_App->dispatchEvent('catalog_categor...', Array)
#4 /home/nagelprod/domains/test.nagelproducten-limburg.nl/public_html/includes/src/__default.php(5620): Mage::dispatchEvent('catalog_categor...', Array)
#5 /home/nagelprod/domains/test.nagelproducten-limburg.nl/public_html/includes/src/__default.php(5579): Mage_Core_Model_Abstract->_afterLoad()
#6 /home/nagelprod/domains/test.nagelproducten-limburg.nl/public_html/app/design/frontend/base/MagicNails/template/page/home.phtml(51): Mage_Core_Model_Abstract->load('4')
#7 /home/nagelprod/domains/test.nagelproducten-limburg.nl/public_html/includes/src/__default.php(3223): include('/home/nagelprod...')
#8 /home/nagelprod/domains/test.nagelproducten-limburg.nl/public_html/includes/src/__default.php(3254): Mage_Core_Block_Template->fetchView('frontend/base/M...')
#9 /home/nagelprod/domains/test.nagelproducten-limburg.nl/public_html/includes/src/__default.php(3268): Mage_Core_Block_Template->renderView()
#10 /home/nagelprod/domains/test.nagelproducten-limburg.nl/public_html/includes/src/__default.php(2518): Mage_Core_Block_Template->_toHtml()
#11 /home/nagelprod/domains/test.nagelproducten-limburg.nl/public_html/includes/src/__default.php(27393): Mage_Core_Block_Abstract->toHtml()
#12 /home/nagelprod/domains/test.nagelproducten-limburg.nl/public_html/includes/src/__default.php(13553): Mage_Core_Model_Layout->getOutput()
#13 /home/nagelprod/domains/test.nagelproducten-limburg.nl/public_html/includes/src/__default.php(10913): Mage_Core_Controller_Varien_Action->renderLayout()
#14 /home/nagelprod/domains/test.nagelproducten-limburg.nl/public_html/includes/src/__default.php(10828): Mage_Cms_Helper_Page->_renderPage(Object(Mage_Cms_IndexController), 'home')
#15 /home/nagelprod/domains/test.nagelproducten-limburg.nl/public_html/app/code/core/Mage/Cms/controllers/IndexController.php(45): Mage_Cms_Helper_Page->renderPage(Object(Mage_Cms_IndexController), 'home')
#16 /home/nagelprod/domains/test.nagelproducten-limburg.nl/public_html/includes/src/__default.php(13582): Mage_Cms_IndexController->indexAction()
#17 /home/nagelprod/domains/test.nagelproducten-limburg.nl/public_html/includes/src/__default.php(17927): Mage_Core_Controller_Varien_Action->dispatch('index')
#18 /home/nagelprod/domains/test.nagelproducten-limburg.nl/public_html/includes/src/__default.php(17484): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#19 /home/nagelprod/domains/test.nagelproducten-limburg.nl/public_html/includes/src/__default.php(20061): Mage_Core_Controller_Varien_Front->dispatch()
#20 /home/nagelprod/domains/test.nagelproducten-limburg.nl/public_html/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#21 /home/nagelprod/domains/test.nagelproducten-limburg.nl/public_html/index.php(87): Mage::run('', 'store')
#22 {main}

[Vinai]

This error happens to some people after the module installation. So far I haven't been able to reproduce it. The solution is to remove all cookies for your site from your browser.

The error doesn't seem to occur again after that.

[ghost]

Thanks for your reply! Now i've installed it, but there are no categories showing. I'm trying to REINDEX the data, but magento gave me this as an error: There was a problem with reindexing process. And if i want to add or edit an product or category i don't see a field where i can check the usergroups who can see the product or category (the whole formular is missing ?).

[Vinai]

If an indexer fails, you get an error message in the file var/log/exception.log.

Please try to rerun the indexer and then post the according message and stack trace here. Thanks.

[ghost]

Hi, Thanks for your reply. At this moment i wont recieve any error anymore, but the status keey saying indexing requered

[Vinai]

If you can run the indexer successfully, the status should change to green.

[ghost]

Yeah, but that isn't maybe i've disabled the error logging. Do you know where i can enable that?

[Vinai]

Check under

System > Configuration > Developer > Log Settings

[ghost]

It was disabled, but still no errors.

[ghost]

I've found the error by running it in a shell:

GroupsCatalog Products index process unknown error:
exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.value' in 'field list'' in /home/nagelprod/domains/domain.com/public_html/lib/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /home/nagelprod/domains/domain.com/public_html/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /home/nagelprod/domains/domain.com/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#2 /home/nagelprod/domains/domain.com/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#3 /home/nagelprod/domains/domain.com/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#4 /home/nagelprod/domains/domain.com/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `e`.`ent...', Array)
#5 /home/nagelprod/domains/domain.com/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `e`.`ent...', Array)
#6 /home/nagelprod/domains/domain.com/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php(211): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select))
#7 /home/nagelprod/domains/domain.com/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php(174): Netzarbeiter_GroupsCatalog2_Model_Resource_Indexer_Abstract->_reindexEntity()
#8 /home/nagelprod/domains/domain.com/public_html/app/code/core/Mage/Index/Model/Indexer/Abstract.php(143): Netzarbeiter_GroupsCatalog2_Model_Resource_Indexer_Abstract->reindexAll()
#9 /home/nagelprod/domains/domain.com/public_html/app/code/core/Mage/Index/Model/Process.php(209): Mage_Index_Model_Indexer_Abstract->reindexAll()
#10 /home/nagelprod/domains/domain.com/public_html/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll()
#11 /home/nagelprod/domains/domain.com/public_html/shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()
#12 /home/nagelprod/domains/domain.com/public_html/shell/indexer.php(198): Mage_Shell_Compiler->run()
#13 {main}

Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.value' in 'field list'' in /home/nagelprod/domains/domain.com/public_html/lib/Zend/Db/Statement/Pdo.php:234
Stack trace:
#0 /home/nagelprod/domains/domain.com/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/nagelprod/domains/domain.com/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/nagelprod/domains/domain.com/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /home/nagelprod/domains/domain.com/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `e`.`ent...', Array)
#4 /home/nagelprod/domains/domain.com/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `e`.`ent...', Array)
#5 /home/nagelprod/domains/domain.com/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php(211): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select))
#6 /home/nagelprod/domains/domain.com/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php(174): Netzarbeiter_GroupsCatalog2_Model_Resource_Indexer_Abstract->_reindexEntity()
#7 /home/nagelprod/domains/domain.com/public_html/app/code/core/Mage/Index/Model/Indexer/Abstract.php(143): Netzarbeiter_GroupsCatalog2_Model_Resource_Indexer_Abstract->reindexAll()
#8 /home/nagelprod/domains/domain.com/public_html/app/code/core/Mage/Index/Model/Process.php(209): Mage_Index_Model_Indexer_Abstract->reindexAll()
#9 /home/nagelprod/domains/domain.com/public_html/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll()
#10 /home/nagelprod/domains/domain.com/public_html/shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()
#11 /home/nagelprod/domains/domain.com/public_html/shell/indexer.php(198): Mage_Shell_Compiler->run()
#12 {main}
GroupsCatalog Categories index process unknown error:
exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.value' in 'field list'' in /home/nagelprod/domains/domain.com/public_html/lib/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /home/nagelprod/domains/domain.com/public_html/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /home/nagelprod/domains/domain.com/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#2 /home/nagelprod/domains/domain.com/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#3 /home/nagelprod/domains/domain.com/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#4 /home/nagelprod/domains/domain.com/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `e`.`ent...', Array)
#5 /home/nagelprod/domains/domain.com/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `e`.`ent...', Array)
#6 /home/nagelprod/domains/domain.com/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php(211): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select))
#7 /home/nagelprod/domains/domain.com/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php(174): Netzarbeiter_GroupsCatalog2_Model_Resource_Indexer_Abstract->_reindexEntity()
#8 /home/nagelprod/domains/domain.com/public_html/app/code/core/Mage/Index/Model/Indexer/Abstract.php(143): Netzarbeiter_GroupsCatalog2_Model_Resource_Indexer_Abstract->reindexAll()
#9 /home/nagelprod/domains/domain.com/public_html/app/code/core/Mage/Index/Model/Process.php(209): Mage_Index_Model_Indexer_Abstract->reindexAll()
#10 /home/nagelprod/domains/domain.com/public_html/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll()
#11 /home/nagelprod/domains/domain.com/public_html/shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()
#12 /home/nagelprod/domains/domain.com/public_html/shell/indexer.php(198): Mage_Shell_Compiler->run()
#13 {main}

Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.value' in 'field list'' in /home/nagelprod/domains/domain.com/public_html/lib/Zend/Db/Statement/Pdo.php:234
Stack trace:
#0 /home/nagelprod/domains/domain.com/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/nagelprod/domains/domain.com/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/nagelprod/domains/domain.com/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /home/nagelprod/domains/domain.com/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `e`.`ent...', Array)
#4 /home/nagelprod/domains/domain.com/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `e`.`ent...', Array)
#5 /home/nagelprod/domains/domain.com/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php(211): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select))
#6 /home/nagelprod/domains/domain.com/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php(174): Netzarbeiter_GroupsCatalog2_Model_Resource_Indexer_Abstract->_reindexEntity()
#7 /home/nagelprod/domains/domain.com/public_html/app/code/core/Mage/Index/Model/Indexer/Abstract.php(143): Netzarbeiter_GroupsCatalog2_Model_Resource_Indexer_Abstract->reindexAll()
#8 /home/nagelprod/domains/domain.com/public_html/app/code/core/Mage/Index/Model/Process.php(209): Mage_Index_Model_Indexer_Abstract->reindexAll()
#9 /home/nagelprod/domains/domain.com/public_html/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll()
#10 /home/nagelprod/domains/domain.com/public_html/shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()
#11 /home/nagelprod/domains/domain.com/public_html/shell/indexer.php(198): Mage_Shell_Compiler->run()
#12 {main}

I hope you know what's wrong

[Vinai]

Okay, that is strange. The table that is aliased to a is the attribute value table, which is determined as follows:

$attribute = Mage::getSingleton('eav/config')->getAttribute(
    $this->_getEntityTypeCode(), 'groupscatalog2_groups'
);
$table = $attribute->getBackend()->getTable();

The attribute is created with a backend_type property value text, which means the backend table catalog_product_entity_text (or catalog_category_entity_text for categories) will be used to store the attribute values.

It seems something is non-standard on your installation to cause this exception.
Please provide the output of the query:

SELECT attribute_id, entity_type_code, backend_type, backend_table
    FROM eav_attribute AS ea
    INNER JOIN eav_entity_type AS eet ON ea.entity_type_id = eet.entity_type_id
    WHERE attribute_code = 'groupscatalog2_groups';

[ghost]

Mysql doesn't return any result, it says there are no results

[Vinai]

That means the setup scripts of the extension haven't run. Otherwise you would get the following output (with varying ID values):

+--------------+------------------+--------------+---------------+
| attribute_id | entity_type_code | backend_type | backend_table |
+--------------+------------------+--------------+---------------+
|         1085 | catalog_category | text         | NULL          |
|         1084 | catalog_product  | text         | NULL          |
+--------------+------------------+--------------+---------------+

What does the following query give you?

SELECT * FROM core_resource WHERE code = 'netzarbeiter_groupscatalog2_setup';

Expected result:

+-----------------------------------+---------+--------------+
| code                              | version | data_version |
+-----------------------------------+---------+--------------+
| netzarbeiter_groupscatalog2_setup | 0.2.9   | 0.2.9        |
+-----------------------------------+---------+--------------+

[ghost]

That gives the expected result:

+-----------------------------------+---------+--------------+
| code                              | version | data_version |
+-----------------------------------+---------+--------------+
| netzarbeiter_groupscatalog2_setup | 0.2.9   | 0.2.9        |
+-----------------------------------+---------+--------------+

how can i run the setup scripts?

[Vinai]

To rerun the setup scripts, execute

DELETE FROM core_resource WHERE code = 'netzarbeiter_groupscatalog2_setup';

Then clear the Magento configuration cache and reload any page.

[ghost]

Still the same problem, and still no results for

SELECT attribute_id, entity_type_code, backend_type, backend_table
    FROM eav_attribute AS ea
    INNER JOIN eav_entity_type AS eet ON ea.entity_type_id = eet.entity_type_id
    WHERE attribute_code = 'groupscatalog2_groups';

[ghost]

Sorry, i forgot to clear the cache. It worked. Thanks again!

[Vinai]

EDIT: Just read your response after I composed this post, ignore the following please :)

To summarize (just to make sure I've got the right idea), all of the following statements are true:

• You installed the extension
• You cleared the cache
• You re-ran the Magento compiler
• Then you ran the DELETE query, cleared the cache and reloaded any page
• There is no record in the eav_attribute table with attribute_code = 'groupscatalog2_groups'

One last diagnostic question: do the tables groupscatalog_product_idx and groupscatalog_category_idx exist?

[gsgansi]

Hi, i can't open in the admin the category page or edit a product. What's wrong? and i had already tried below given steps:-

a) Deleted "groupscatalog_product_idx" and "groupscatalog_category_idx" also b) DELETE FROM core_resource WHERE code = 'netzarbeiter_groupscatalog2_setup';

error message in the file "var/log/exception.log" given below

++++++++++++++++++++++++++++++++++++
2013-07-23T07:00:48+00:00 ERR (3): 
exception 'Mage_Eav_Exception' with message 'Source model "groupscatalog/config_source_customergroups_product" not found for attribute "groupscatalog_hide_group"' in /var/www/vhosts/softalgo.ca/httpdocs/products/magento/app/Mage.php:549
Stack trace:
#0 /var/www/vhosts/softalgo.ca/httpdocs/products/magento/app/code/core/Mage/Eav/Model/Entity/Attribute/Abstract.php(387): Mage::exception('Mage_Eav', 'Source model "g...')
#1 /var/www/vhosts/softalgo.ca/httpdocs/products/magento/app/code/core/Mage/Catalog/Model/Resource/Product/Flat/Indexer.php(255): Mage_Eav_Model_Entity_Attribute_Abstract->getSource()
#2 /var/www/vhosts/softalgo.ca/httpdocs/products/magento/app/code/core/Mage/Catalog/Model/Resource/Product/Flat/Indexer.php(424): Mage_Catalog_Model_Resource_Product_Flat_Indexer->getAttributes()
#3 /var/www/vhosts/softalgo.ca/httpdocs/products/magento/app/code/core/Mage/Catalog/Model/Resource/Product/Flat/Indexer.php(625): Mage_Catalog_Model_Resource_Product_Flat_Indexer->getFlatColumns()
#4 /var/www/vhosts/softalgo.ca/httpdocs/products/magento/app/code/core/Mage/Catalog/Model/Resource/Product/Flat/Indexer.php(1390): Mage_Catalog_Model_Resource_Product_Flat_Indexer->prepareFlatTable(1)
#5 /var/www/vhosts/softalgo.ca/httpdocs/products/magento/app/code/core/Mage/Catalog/Model/Product/Flat/Indexer.php(296): Mage_Catalog_Model_Resource_Product_Flat_Indexer->reindexAll()
#6 /var/www/vhosts/softalgo.ca/httpdocs/products/magento/app/code/core/Mage/Catalog/Model/Product/Indexer/Flat.php(336): Mage_Catalog_Model_Product_Flat_Indexer->reindexAll()
#7 /var/www/vhosts/softalgo.ca/httpdocs/products/magento/app/code/core/Mage/Index/Model/Process.php(207): Mage_Catalog_Model_Product_Indexer_Flat->reindexAll()
#8 /var/www/vhosts/softalgo.ca/httpdocs/products/magento/app/code/core/Mage/Index/Model/Process.php(253): Mage_Index_Model_Process->reindexAll()
#9 /var/www/vhosts/softalgo.ca/httpdocs/products/magento/app/code/core/Mage/Index/controllers/Adminhtml/ProcessController.php(178): Mage_Index_Model_Process->reindexEverything()
#10 /var/www/vhosts/softalgo.ca/httpdocs/products/magento/app/code/core/Mage/Core/Controller/Varien/Action.php(420): Mage_Index_Adminhtml_ProcessController->massReindexAction()
#11 /var/www/vhosts/softalgo.ca/httpdocs/products/magento/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('massReindex')
#12 /var/www/vhosts/softalgo.ca/httpdocs/products/magento/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#13 /var/www/vhosts/softalgo.ca/httpdocs/products/magento/app/code/core/Mage/Core/Model/App.php(349): Mage_Core_Controller_Varien_Front->dispatch()
#14 /var/www/vhosts/softalgo.ca/httpdocs/products/magento/app/Mage.php(640): Mage_Core_Model_App->run(Array)
#15 /var/www/vhosts/softalgo.ca/httpdocs/products/magento/index.php(80): Mage::run('', 'store')
#16 {main}
2013-07-23T07:08:55+00:00 ERR (3): 
exception 'Mage_Eav_Exception' with message 'Source model "groupscatalog/config_source_customergroups_product" not found for attribute "groupscatalog_hide_group"' in /var/www/vhosts/softalgo.ca/httpdocs/products/magento/app/Mage.php:549
Stack trace:
#0 /var/www/vhosts/softalgo.ca/httpdocs/products/magento/app/code/core/Mage/Eav/Model/Entity/Attribute/Abstract.php(387): Mage::exception('Mage_Eav', 'Source model "g...')
#1 /var/www/vhosts/softalgo.ca/httpdocs/products/magento/app/code/core/Mage/Catalog/Model/Resource/Product/Flat/Indexer.php(255): Mage_Eav_Model_Entity_Attribute_Abstract->getSource()
#2 /var/www/vhosts/softalgo.ca/httpdocs/products/magento/app/code/core/Mage/Catalog/Model/Resource/Product/Flat/Indexer.php(424): Mage_Catalog_Model_Resource_Product_Flat_Indexer->getAttributes()
#3 /var/www/vhosts/softalgo.ca/httpdocs/products/magento/app/code/core/Mage/Catalog/Model/Resource/Product/Flat/Indexer.php(625): Mage_Catalog_Model_Resource_Product_Flat_Indexer->getFlatColumns()
#4 /var/www/vhosts/softalgo.ca/httpdocs/products/magento/app/code/core/Mage/Catalog/Model/Resource/Product/Flat/Indexer.php(1390): Mage_Catalog_Model_Resource_Product_Flat_Indexer->prepareFlatTable(1)
#5 /var/www/vhosts/softalgo.ca/httpdocs/products/magento/app/code/core/Mage/Catalog/Model/Product/Flat/Indexer.php(296): Mage_Catalog_Model_Resource_Product_Flat_Indexer->reindexAll()
#6 /var/www/vhosts/softalgo.ca/httpdocs/products/magento/app/code/core/Mage/Catalog/Model/Product/Indexer/Flat.php(336): Mage_Catalog_Model_Product_Flat_Indexer->reindexAll()
#7 /var/www/vhosts/softalgo.ca/httpdocs/products/magento/app/code/core/Mage/Index/Model/Process.php(207): Mage_Catalog_Model_Product_Indexer_Flat->reindexAll()
#8 /var/www/vhosts/softalgo.ca/httpdocs/products/magento/app/code/core/Mage/Index/Model/Process.php(253): Mage_Index_Model_Process->reindexAll()
#9 /var/www/vhosts/softalgo.ca/httpdocs/products/magento/app/code/core/Mage/Index/controllers/Adminhtml/ProcessController.php(178): Mage_Index_Model_Process->reindexEverything()
#10 /var/www/vhosts/softalgo.ca/httpdocs/products/magento/app/code/core/Mage/Core/Controller/Varien/Action.php(420): Mage_Index_Adminhtml_ProcessController->massReindexAction()
#11 /var/www/vhosts/softalgo.ca/httpdocs/products/magento/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('massReindex')
#12 /var/www/vhosts/softalgo.ca/httpdocs/products/magento/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#13 /var/www/vhosts/softalgo.ca/httpdocs/products/magento/app/code/core/Mage/Core/Model/App.php(349): Mage_Core_Controller_Varien_Front->dispatch()
#14 /var/www/vhosts/softalgo.ca/httpdocs/products/magento/app/Mage.php(640): Mage_Core_Model_App->run(Array)
#15 /var/www/vhosts/softalgo.ca/httpdocs/products/magento/index.php(80): Mage::run('', 'store')
#16 {main}
++++++++++++++++++++++++++++++++++++

[Vinai]

This is a broken relict of an installation of the old "GroupsCatalog" module, not the "GroupsCatalog2" module. To cleanly uninstall the old module, remove the files and directories app/etc/modules/Netzarbeiter_GroupsCatalog.xml and app/code/community/Netzarbeiter/GroupsCatalog (if they still exist). Then run the SQL query:

DELETE FROM eav_attribute WHERE attribute_code = 'groupscatalog_hide_group';
DELETE FROM core_resource WHERE code = 'groupscatalog_setup';