Annulleret

Reindexing of magento products not working

We have upgraded our database from 1.3.2.4 to 1.4.2.0 and now everything is working fine , the only thing that not working is reindexing of category products due to which no products are shown on frontend , when i click on reindex it shows There was a problem with reindexing process. Please bid only if you have resolved this issue before .

when i run reindexall in SSH i got the below error

Category 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 (` namec_namenew/catalog_category_product_index`, CONSTRAINT `FK_CATALOG_CATEGORY_PRODUCT_INDEX_PRODUCT_ENTITY` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`))' in /chroot/home/namec/name.com/html/test/lib/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /chroot/home/namec/name.com/html/test/lib/Zend/Db/Statement/Pdo.php(228 ): PDOStatement->execute(Array)
#1 /chroot/home/namec/name.com/html/test/lib/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#2 /chroot/home/namec/name.com/html/test/lib/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#3 /chroot/home/namec/name.com/html/test/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO cat...', Array)
#4 /chroot/home/namec/name.com/html/test/lib/Varien/Db/Adapter/Pdo/Mysql.php(333): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO cat...', Array)
#5 /chroot/home/namec/name.com/html/test/app/code/core/Mage/Index/Model/Mysql4/Abstract.php(159): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO cat...')
#6 /chroot/home/namec/name.com/html/test/app/code/core/Mage/Index/Model/Mysql4/Abstract.php(134): Mage_Index_Model_Mysql4_Abstract->insertFromSelect('SELE CT * FROM c...', 'catalog_categor...', Array, false)
#7 /chroot/home/namec/name.com/html/test/app/code/core/Mage/Index/Model/Mysql4/Abstract.php(88): Mage_Index_Model_Mysql4_Abstract->insertFromTable('catalo g_categor...', 'catalog_categor...', false)
#8 /chroot/home/namec/name.com/html/test/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Category/Indexer/Product.php(598): Mage_Index_Model_Mysql4_A bstract->syncData()
#9 /chroot/home/namec/name.com/html/test/app/code/core/Mage/Index/Model/Indexer/Abstract.php(125): Mage_Catalog_Model_Resource_Eav_Mysql4_Category_Indexer _Product->reindexAll()
#10 /chroot/home/namec/name.com/html/test/app/code/core/Mage/Index/Model/Process.php(139): Mage_Index_Model_Indexer_Abstract->reindexAll()
#11 /chroot/home/namec/name.com/html/test/app/code/core/Mage/Index/Model/Process.php(167): Mage_Index_Model_Process->reindexAll()
#12 /chroot/home/namec/name.com/html/test/shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()
#13 /chroot/home/namec/name.com/html/test/shell/indexer.php(198): Mage_Shell_Compiler->run()
#14 {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 (`namec_namenew/catalog_category_product_index`, CONSTRAINT `FK_CATALOG_CATEGORY_PRODUCT_INDEX_PRODUCT_ENTITY` FOREIGN KEY (`product_id` ) REFERENCES `catalog_product_entity` (`entity_id`))' in /chroot/home/namec/name.com/html/test/lib/Zend/Db/Statement/Pdo.php:234
Stack trace:
#0 /chroot/home/namec/name.com/html/test/lib/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#1 /chroot/home/namec/name.com/html/test/lib/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#2 /chroot/home/namec/name.com/html/test/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO cat...', Array)
#3 /chroot/home/namec/name.com/html/test/lib/Varien/Db/Adapter/Pdo/Mysql.php(333): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO cat...', Array)
#4 /chroot/home/namec/name.com/html/test/app/code/core/Mage/Index/Model/Mysql4/Abstract.php(159): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO cat...')
#5 /chroot/home/namec/name.com/html/test/app/code/core/Mage/Index/Model/Mysql4/Abstract

Færdigheder: eHandel, Magento, MySQL, PHP

Se mere: magento reindex working, problem reindexing process, magento problem reindexing process, reindex working magento, magento reindexing working, problem reindexing process category products, reindex magento working, magento problem reindexing, category products problem reindexing process, magento reindex products, magento reindexing, category products magento reindex, problem reindexing category products magento, magento reindexing problem, problem reindexing process magento, magento category products reindexing, category products reindexing working, reindexing problem magento, no working, fine products, reindexing magento working, category products problem reindexing process magento, magento reindex process working, reindexing category products, magento products working

Om arbejdsgiveren:
( 4 bedømmelser ) New Delhi, India

Projekt-ID: #968066

10 freelancere byder i gennemsnit $107 for dette job

vigentocommerce

I can solved [url removed, login to view]

$45 USD in 0 dage
(198 bedømmelser)
8.2
vniteam

i can help you

$100 USD in 3 dage
(149 bedømmelser)
6.8
magentoecommerce

check yr pmb

$100 USD på 1 dag
(15 bedømmelser)
5.2
ubedarab

Hi, I will do, please check PMB.

$95 USD in 2 dage
(34 bedømmelser)
5.2
skorpland

I am experienced enough to solve all [url removed, login to view] my magento reviews. n check pm thanks

$150 USD in 2 dage
(17 bedømmelser)
4.7
Forci

Check PM, thanks!

$50 USD på 1 dag
(7 bedømmelser)
3.7
spiderphp

Hi, let me help you.

$60 USD på 1 dag
(5 bedømmelser)
3.0
team2extreme

I have already solved this problem for some customers. Do you use SSH?

$100 USD på 1 dag
(0 bedømmelser)
0.0
davebhavesh

hello shashank20062 .. i like to do this work for u.. please see PM.

$140 USD in 2 dage
(0 bedømmelser)
0.0
ambaecommerce

Hi visit us on [url removed, login to view] i have solved this issue before after reindexing no product can be seen in front

$229 USD in 0 dage
(0 bedømmelser)
0.0