Reindexing not working with plugin installed. about groupscatalog2 HOT 11 CLOSED

I tried to reindex via SSH and this is the error I got

Failed loading /usr/php/53/usr/lib64/php/modules/ZendGuardLoader.so: /usr/php/53/usr/lib64/php/modules/ZendGuardLoader.so: undefined symbol: gc_remove_zval_from_buffer

from groupscatalog2.

The error when trying to reindex via SSH is related to a PHP module that only works in conjunction with Zend Server. You need to disable that module for php-cli if you want to run scripts that way.

Regarding the error in your original post, please check var/log/exception.log for errors when trying to reindex, and paste the corresponding stacktrace here. Thanks.

from groupscatalog2.

I just tried something else in the ssh and got this

GroupsCatalog Products index process unknown error:
exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (nstcom_ssq1.groupscatalog_product_idx, CONSTRAINT FK_GROUPSCAT_PRD_IDX_CAT_ENTT_ID_CAT_PRD_ENTT_ENTT_ID FOREIGN KEY (catalog_entity_id) REFERENCES catalog_product_entity (entity_id)' in /home3/nstcom/public_html/lib/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /home3/nstcom/public_html/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /home3/nstcom/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#2 /home3/nstcom/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#3 /home3/nstcom/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#4 /home3/nstcom/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO gr...', Array) #5 /home3/nstcom/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTOgr...', Array)
#6 /home3/nstcom/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(1974): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `gr...', Array)
#7 /home3/nstcom/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(1947): Varien_Db_Adapter_Pdo_Mysql->insertArray('groupscatalog_p...', Array, Array)
#8 /home3/nstcom/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php(307): Varien_Db_Adapter_Pdo_Mysql->insertMultiple('groupscatalog_p...', Array)
#9 /home3/nstcom/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php(271): Netzarbeiter_GroupsCatalog2_Model_Resource_Indexer_Abstract->_insertIndexRecordsIfMinChunkSizeReached(Array, 1)
#10 /home3/nstcom/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php(208): Netzarbeiter_GroupsCatalog2_Model_Resource_Indexer_Abstract->_insertIndexRecords(Array)
#11 /home3/nstcom/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php(174): Netzarbeiter_GroupsCatalog2_Model_Resource_Indexer_Abstract->_reindexEntity()
#12 /home3/nstcom/public_html/app/code/core/Mage/Index/Model/Indexer/Abstract.php(143): Netzarbeiter_GroupsCatalog2_Model_Resource_Indexer_Abstract->reindexAll()
#13 /home3/nstcom/public_html/app/code/core/Mage/Index/Model/Process.php(209): Mage_Index_Model_Indexer_Abstract->reindexAll()
#14 /home3/nstcom/public_html/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll()
#15 /home3/nstcom/public_html/shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()
#16 /home3/nstcom/public_html/shell/indexer.php(198): Mage_Shell_Compiler->run()
#17 {main}

Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (nstcom_ssq1.groupscatalog_product_idx, CONSTRAINT FK_GROUPSCAT_PRD_IDX_CAT_ENTT_ID_CAT_PRD_ENTT_ENTT_ID FOREIGN KEY (catalog_entity_id) REFERENCES catalog_product_entity (entity_id)' in /home3/nstcom/public_html/lib/Zend/Db/Statement/Pdo.php:234
Stack trace:
#0 /home3/nstcom/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home3/nstcom/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home3/nstcom/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /home3/nstcom/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO gr...', Array) #4 /home3/nstcom/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTOgr...', Array)
#5 /home3/nstcom/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(1974): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `gr...', Array)
#6 /home3/nstcom/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(1947): Varien_Db_Adapter_Pdo_Mysql->insertArray('groupscatalog_p...', Array, Array)
#7 /home3/nstcom/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php(307): Varien_Db_Adapter_Pdo_Mysql->insertMultiple('groupscatalog_p...', Array)
#8 /home3/nstcom/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php(271): Netzarbeiter_GroupsCatalog2_Model_Resource_Indexer_Abstract->_insertIndexRecordsIfMinChunkSizeReached(Array, 1)
#9 /home3/nstcom/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php(208): Netzarbeiter_GroupsCatalog2_Model_Resource_Indexer_Abstract->_insertIndexRecords(Array)
#10 /home3/nstcom/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php(174): Netzarbeiter_GroupsCatalog2_Model_Resource_Indexer_Abstract->_reindexEntity()
#11 /home3/nstcom/public_html/app/code/core/Mage/Index/Model/Indexer/Abstract.php(143): Netzarbeiter_GroupsCatalog2_Model_Resource_Indexer_Abstract->reindexAll()
#12 /home3/nstcom/public_html/app/code/core/Mage/Index/Model/Process.php(209): Mage_Index_Model_Indexer_Abstract->reindexAll()
#13 /home3/nstcom/public_html/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll()
#14 /home3/nstcom/public_html/shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()
#15 /home3/nstcom/public_html/shell/indexer.php(198): Mage_Shell_Compiler->run()
#16 {main}

from groupscatalog2.

Log says the same thing pretty much

2013-05-03T15:27:38+00:00 DEBUG (7): Exception message: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (nstcom_ssq1.groupscatalog_product_idx, CONSTRAINT FK_GROUPSCAT_PRD_IDX_CAT_ENTT_ID_CAT_PRD_ENTT_ENTT_ID FOREIGN KEY (catalog_entity_id) REFERENCES catalog_product_entity (entity_id)
Trace: #0 /home3/nstcom/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home3/nstcom/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home3/nstcom/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /home3/nstcom/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO gr...', Array) #4 /home3/nstcom/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTOgr...', Array)
#5 /home3/nstcom/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(1974): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `gr...', Array)
#6 /home3/nstcom/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(1947): Varien_Db_Adapter_Pdo_Mysql->insertArray('groupscatalog_p...', Array, Array)
#7 /home3/nstcom/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php(307): Varien_Db_Adapter_Pdo_Mysql->insertMultiple('groupscatalog_p...', Array)
#8 /home3/nstcom/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php(271): Netzarbeiter_GroupsCatalog2_Model_Resource_Indexer_Abstract->_insertIndexRecordsIfMinChunkSizeReached(Array, 1)
#9 /home3/nstcom/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php(208): Netzarbeiter_GroupsCatalog2_Model_Resource_Indexer_Abstract->_insertIndexRecords(Array)
#10 /home3/nstcom/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php(174): Netzarbeiter_GroupsCatalog2_Model_Resource_Indexer_Abstract->_reindexEntity()
#11 /home3/nstcom/public_html/app/code/core/Mage/Index/Model/Indexer/Abstract.php(143): Netzarbeiter_GroupsCatalog2_Model_Resource_Indexer_Abstract->reindexAll()
#12 /home3/nstcom/public_html/app/code/core/Mage/Index/Model/Process.php(209): Mage_Index_Model_Indexer_Abstract->reindexAll()
#13 /home3/nstcom/public_html/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll()
#14 /home3/nstcom/public_html/app/code/core/Mage/Index/controllers/Adminhtml/ProcessController.php(124): Mage_Index_Model_Process->reindexEverything()
#15 /home3/nstcom/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(419): Mage_Index_Adminhtml_ProcessController->reindexProcessAction()
#16 /home3/nstcom/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('reindexProcess')
#17 /home3/nstcom/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#18 /home3/nstcom/public_html/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#19 /home3/nstcom/public_html/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#20 /home3/nstcom/public_html/index.php(87): Mage::run('', 'store')
#21 {main}

from groupscatalog2.

SSH reindexing has fixed GroupsCatalog Categories but GroupsCatalog Products is still throwing errors

from groupscatalog2.

The only way (I can come up with right now) the exception makes sense is if the products where deleted after the indexer process started, while it was still running. Could that be the case?

from groupscatalog2.

No. I don't have any products in my store right now...would that cause an issue?

To clarify, I have zero products and zero categories.

from groupscatalog2.

Oh, interesting. Never thought of that. I'll look into that over the weekend probably.

from groupscatalog2.

Adding a product fixed it. So it doesn't index right if you have no products

from groupscatalog2.

Thanks for the follow up, as I said, I never had thought of that fringe case :)
Will fix it anyways. Thanks!

from groupscatalog2.

No problem! Great plugin now that I got it working! :)

from groupscatalog2.