Can't reindex Product Prices: a foreign key constraint failsMagento 1.8 reindex allMagento error “Currency 'USD' not found”Fix error “There was a problem with reindexing process.” or “Cannot initialize the indexer process.”Index Management ProblemProduct Attributes could not be reindexedError installing security patches on CE 1.7.0.2Error report in var/report ,what does it mean? and is it serious problem? It keep create those error report and take 1.7 GB space alreadySite went down after last designer cleared cacheError in admin panel: MySQL server has gone awayHTTP Error 500 when trying access Admin System Configuration
Early 2000s movie about time travel, protagonist travels back to save girlfriend, then into multiple points in future
What was the point of separating stdout and stderr?
Should Catholics in a state of grace call themselves sinners?
Why doesn't SpaceX land boosters in Africa?
What are the children of two Muggle-borns called?
How useful would a hydroelectric power plant be in the post-apocalypse world?
Reusable spacecraft: why still have fairings detach, instead of open/close?
What does 5d4 x 10 gp mean?
German idiomatic equivalents of 能骗就骗 (if you can trick, then trick)
Why would Dementors torture a Death Eater if they are loyal to Voldemort?
Rear derailleur got caught in the spokes, what could be a root cause
Robots in a spaceship
Why will we fail creating a self sustaining off world colony?
Tricolour nonogram
"I am [the / an] owner of a bookstore"?
Where can I find my serialized Sitecore items?
Dynamic Sql Query - how to add an int to the code?
Correct use of the the idiom 'Гнать/Катить бочку'
Does it make sense to (partially) create a conlang that you don't intend to actually use in the story?
Why am I getting an electric shock from the water in my hot tub?
Meaning of the word "good" in context
What verb for taking advantage fits in "I don't want to ________ on the friendship"?
Russian equivalents of 能骗就骗 (if you can cheat, then cheat)
Is this house-rule removing the increased effect of cantrips at higher character levels balanced?
Can't reindex Product Prices: a foreign key constraint fails
Magento 1.8 reindex allMagento error “Currency 'USD' not found”Fix error “There was a problem with reindexing process.” or “Cannot initialize the indexer process.”Index Management ProblemProduct Attributes could not be reindexedError installing security patches on CE 1.7.0.2Error report in var/report ,what does it mean? and is it serious problem? It keep create those error report and take 1.7 GB space alreadySite went down after last designer cleared cacheError in admin panel: MySQL server has gone awayHTTP Error 500 when trying access Admin System Configuration
0
I receive an error when trying to reindex Product Prices: "Some problem with reindexing process."
Digging some more, I extracted this error message on exception.log:
2015-10-06T17:17:52+00:00 DEBUG (7): Exception message: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`db1192491-myDB3`.`catalog_product_index_tier_price`, CONSTRAINT `FK_CATALOG_PRODUCT_INDEX_TIER_PRICE_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) O)
Trace: #0 /is/htdocs/wp1192491_HPZFWNW898/www/lib/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#1 /is/htdocs/wp1192491_HPZFWNW898/www/lib/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#2 /is/htdocs/wp1192491_HPZFWNW898/www/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `ca...', Array)
#3 /is/htdocs/wp1192491_HPZFWNW898/www/lib/Varien/Db/Adapter/Pdo/Mysql.php(333): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `ca...', Array)
#4 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Price.php(412): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `ca...')
#5 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Price.php(353): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Indexer_Price->_prepareTierPriceIndex()
#6 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Index/Model/Indexer/Abstract.php(125): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Indexer_Price->reindexAll()
#7 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Index/Model/Process.php(139): Mage_Index_Model_Indexer_Abstract->reindexAll()
#8 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Index/Model/Process.php(167): Mage_Index_Model_Process->reindexAll()
#9 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Index/controllers/Adminhtml/ProcessController.php(124): Mage_Index_Model_Process->reindexEverything()
#10 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Index_Adminhtml_ProcessController->reindexProcessAction()
#11 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('reindexProcess')
#12 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Core/Controller/Varien/Front.php(177): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#13 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Core/Model/App.php(304): Mage_Core_Controller_Varien_Front->dispatch()
#14 /is/htdocs/wp1192491_HPZFWNW898/www/app/Mage.php(596): Mage_Core_Model_App->run(Array)
#15 /is/htdocs/wp1192491_HPZFWNW898/www/index.php(78): Mage::run('', 'store')
#16 main
I tried this solution on MySQL but didn't work (MySQL says no row was changed):
delete FROM `catalog_product_index_tier_price` where entity_id not in (select entity_id from catalog_product_entity);
Do you have some suggestions about what could I try?
Quite a lot of people have similar issues but couldn't find any of them related to the Product Price index and the tier prices in particular.
Thanks for any ideas,
EDIT: also tried removing the contents on var/locks directory, to no avail. I re-saved as well the products with tier prices, but it made no difference.
error mysql reindex tierprice foreign-key
edited May 23 '17 at 12:37
Community♦
1
asked Nov 2 '15 at 18:29
PeanutsPeanuts
2331 silver badge12 bronze badges
add a comment |
0
I receive an error when trying to reindex Product Prices: "Some problem with reindexing process."
Digging some more, I extracted this error message on exception.log:
2015-10-06T17:17:52+00:00 DEBUG (7): Exception message: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`db1192491-myDB3`.`catalog_product_index_tier_price`, CONSTRAINT `FK_CATALOG_PRODUCT_INDEX_TIER_PRICE_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) O)
Trace: #0 /is/htdocs/wp1192491_HPZFWNW898/www/lib/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#1 /is/htdocs/wp1192491_HPZFWNW898/www/lib/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#2 /is/htdocs/wp1192491_HPZFWNW898/www/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `ca...', Array)
#3 /is/htdocs/wp1192491_HPZFWNW898/www/lib/Varien/Db/Adapter/Pdo/Mysql.php(333): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `ca...', Array)
#4 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Price.php(412): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `ca...')
#5 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Price.php(353): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Indexer_Price->_prepareTierPriceIndex()
#6 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Index/Model/Indexer/Abstract.php(125): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Indexer_Price->reindexAll()
#7 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Index/Model/Process.php(139): Mage_Index_Model_Indexer_Abstract->reindexAll()
#8 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Index/Model/Process.php(167): Mage_Index_Model_Process->reindexAll()
#9 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Index/controllers/Adminhtml/ProcessController.php(124): Mage_Index_Model_Process->reindexEverything()
#10 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Index_Adminhtml_ProcessController->reindexProcessAction()
#11 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('reindexProcess')
#12 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Core/Controller/Varien/Front.php(177): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#13 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Core/Model/App.php(304): Mage_Core_Controller_Varien_Front->dispatch()
#14 /is/htdocs/wp1192491_HPZFWNW898/www/app/Mage.php(596): Mage_Core_Model_App->run(Array)
#15 /is/htdocs/wp1192491_HPZFWNW898/www/index.php(78): Mage::run('', 'store')
#16 main
I tried this solution on MySQL but didn't work (MySQL says no row was changed):
delete FROM `catalog_product_index_tier_price` where entity_id not in (select entity_id from catalog_product_entity);
Do you have some suggestions about what could I try?
Quite a lot of people have similar issues but couldn't find any of them related to the Product Price index and the tier prices in particular.
Thanks for any ideas,
EDIT: also tried removing the contents on var/locks directory, to no avail. I re-saved as well the products with tier prices, but it made no difference.
error mysql reindex tierprice foreign-key
edited May 23 '17 at 12:37
Community♦
1
asked Nov 2 '15 at 18:29
PeanutsPeanuts
2331 silver badge12 bronze badges
As a sidenote, in this SO thread they say that it's safe to truncate the Product Prices Index table, and then re-build it, without any consecuences. Do you think I could take that route? (stackoverflow.com/questions/22590843/…)
– Peanuts
Nov 2 '15 at 19:01
I found this link, with a script that may help but I'm not quite sure if it's safe: gist.github.com/cgdangelo/2175558 ALTER TABLEcatalog_product_index_tier_priceADD CONSTRAINTFK_CAT_PRD_IDX_TIER_PRICE_CSTR_GROUP_ID_CSTR_GROUP_CSTR_GROUP_IDFOREIGN KEY (customer_group_id) REFERENCEScustomer_group(customer_group_id) ON DELETE CASCADE ON UPDATE CASCADE;
– Peanuts
Nov 3 '15 at 19:56
add a comment |
0
0
0
I receive an error when trying to reindex Product Prices: "Some problem with reindexing process."
Digging some more, I extracted this error message on exception.log:
2015-10-06T17:17:52+00:00 DEBUG (7): Exception message: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`db1192491-myDB3`.`catalog_product_index_tier_price`, CONSTRAINT `FK_CATALOG_PRODUCT_INDEX_TIER_PRICE_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) O)
Trace: #0 /is/htdocs/wp1192491_HPZFWNW898/www/lib/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#1 /is/htdocs/wp1192491_HPZFWNW898/www/lib/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#2 /is/htdocs/wp1192491_HPZFWNW898/www/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `ca...', Array)
#3 /is/htdocs/wp1192491_HPZFWNW898/www/lib/Varien/Db/Adapter/Pdo/Mysql.php(333): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `ca...', Array)
#4 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Price.php(412): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `ca...')
#5 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Price.php(353): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Indexer_Price->_prepareTierPriceIndex()
#6 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Index/Model/Indexer/Abstract.php(125): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Indexer_Price->reindexAll()
#7 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Index/Model/Process.php(139): Mage_Index_Model_Indexer_Abstract->reindexAll()
#8 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Index/Model/Process.php(167): Mage_Index_Model_Process->reindexAll()
#9 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Index/controllers/Adminhtml/ProcessController.php(124): Mage_Index_Model_Process->reindexEverything()
#10 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Index_Adminhtml_ProcessController->reindexProcessAction()
#11 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('reindexProcess')
#12 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Core/Controller/Varien/Front.php(177): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#13 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Core/Model/App.php(304): Mage_Core_Controller_Varien_Front->dispatch()
#14 /is/htdocs/wp1192491_HPZFWNW898/www/app/Mage.php(596): Mage_Core_Model_App->run(Array)
#15 /is/htdocs/wp1192491_HPZFWNW898/www/index.php(78): Mage::run('', 'store')
#16 main
I tried this solution on MySQL but didn't work (MySQL says no row was changed):
delete FROM `catalog_product_index_tier_price` where entity_id not in (select entity_id from catalog_product_entity);
Do you have some suggestions about what could I try?
Quite a lot of people have similar issues but couldn't find any of them related to the Product Price index and the tier prices in particular.
Thanks for any ideas,
EDIT: also tried removing the contents on var/locks directory, to no avail. I re-saved as well the products with tier prices, but it made no difference.
error mysql reindex tierprice foreign-key
edited May 23 '17 at 12:37
Community♦
1
asked Nov 2 '15 at 18:29
PeanutsPeanuts
2331 silver badge12 bronze badges
I receive an error when trying to reindex Product Prices: "Some problem with reindexing process."
Digging some more, I extracted this error message on exception.log:
2015-10-06T17:17:52+00:00 DEBUG (7): Exception message: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`db1192491-myDB3`.`catalog_product_index_tier_price`, CONSTRAINT `FK_CATALOG_PRODUCT_INDEX_TIER_PRICE_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) O)
Trace: #0 /is/htdocs/wp1192491_HPZFWNW898/www/lib/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#1 /is/htdocs/wp1192491_HPZFWNW898/www/lib/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#2 /is/htdocs/wp1192491_HPZFWNW898/www/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `ca...', Array)
#3 /is/htdocs/wp1192491_HPZFWNW898/www/lib/Varien/Db/Adapter/Pdo/Mysql.php(333): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `ca...', Array)
#4 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Price.php(412): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `ca...')
#5 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Price.php(353): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Indexer_Price->_prepareTierPriceIndex()
#6 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Index/Model/Indexer/Abstract.php(125): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Indexer_Price->reindexAll()
#7 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Index/Model/Process.php(139): Mage_Index_Model_Indexer_Abstract->reindexAll()
#8 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Index/Model/Process.php(167): Mage_Index_Model_Process->reindexAll()
#9 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Index/controllers/Adminhtml/ProcessController.php(124): Mage_Index_Model_Process->reindexEverything()
#10 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Index_Adminhtml_ProcessController->reindexProcessAction()
#11 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('reindexProcess')
#12 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Core/Controller/Varien/Front.php(177): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#13 /is/htdocs/wp1192491_HPZFWNW898/www/app/code/core/Mage/Core/Model/App.php(304): Mage_Core_Controller_Varien_Front->dispatch()
#14 /is/htdocs/wp1192491_HPZFWNW898/www/app/Mage.php(596): Mage_Core_Model_App->run(Array)
#15 /is/htdocs/wp1192491_HPZFWNW898/www/index.php(78): Mage::run('', 'store')
#16 main
I tried this solution on MySQL but didn't work (MySQL says no row was changed):
delete FROM `catalog_product_index_tier_price` where entity_id not in (select entity_id from catalog_product_entity);
Do you have some suggestions about what could I try?
Quite a lot of people have similar issues but couldn't find any of them related to the Product Price index and the tier prices in particular.
Thanks for any ideas,
EDIT: also tried removing the contents on var/locks directory, to no avail. I re-saved as well the products with tier prices, but it made no difference.
error mysql reindex tierprice foreign-key
error mysql reindex tierprice foreign-key
edited May 23 '17 at 12:37
Community♦
1
asked Nov 2 '15 at 18:29
PeanutsPeanuts
2331 silver badge12 bronze badges
edited May 23 '17 at 12:37
Community♦
1
asked Nov 2 '15 at 18:29
PeanutsPeanuts
2331 silver badge12 bronze badges
edited May 23 '17 at 12:37
Community♦
1
edited May 23 '17 at 12:37
Community♦
1
edited May 23 '17 at 12:37
Community♦
1
1
asked Nov 2 '15 at 18:29
PeanutsPeanuts
2331 silver badge12 bronze badges
asked Nov 2 '15 at 18:29
PeanutsPeanuts
2331 silver badge12 bronze badges
asked Nov 2 '15 at 18:29
PeanutsPeanuts
2331 silver badge12 bronze badges
2331 silver badge12 bronze badges
As a sidenote, in this SO thread they say that it's safe to truncate the Product Prices Index table, and then re-build it, without any consecuences. Do you think I could take that route? (stackoverflow.com/questions/22590843/…)
– Peanuts
Nov 2 '15 at 19:01
I found this link, with a script that may help but I'm not quite sure if it's safe: gist.github.com/cgdangelo/2175558 ALTER TABLEcatalog_product_index_tier_priceADD CONSTRAINTFK_CAT_PRD_IDX_TIER_PRICE_CSTR_GROUP_ID_CSTR_GROUP_CSTR_GROUP_IDFOREIGN KEY (customer_group_id) REFERENCEScustomer_group(customer_group_id) ON DELETE CASCADE ON UPDATE CASCADE;
– Peanuts
Nov 3 '15 at 19:56
add a comment |
As a sidenote, in this SO thread they say that it's safe to truncate the Product Prices Index table, and then re-build it, without any consecuences. Do you think I could take that route? (stackoverflow.com/questions/22590843/…)
– Peanuts
Nov 2 '15 at 19:01
I found this link, with a script that may help but I'm not quite sure if it's safe: gist.github.com/cgdangelo/2175558 ALTER TABLEcatalog_product_index_tier_priceADD CONSTRAINTFK_CAT_PRD_IDX_TIER_PRICE_CSTR_GROUP_ID_CSTR_GROUP_CSTR_GROUP_IDFOREIGN KEY (customer_group_id) REFERENCEScustomer_group(customer_group_id) ON DELETE CASCADE ON UPDATE CASCADE;
– Peanuts
Nov 3 '15 at 19:56
As a sidenote, in this SO thread they say that it's safe to truncate the Product Prices Index table, and then re-build it, without any consecuences. Do you think I could take that route? (stackoverflow.com/questions/22590843/…)
– Peanuts
Nov 2 '15 at 19:01
As a sidenote, in this SO thread they say that it's safe to truncate the Product Prices Index table, and then re-build it, without any consecuences. Do you think I could take that route? (stackoverflow.com/questions/22590843/…)
– Peanuts
Nov 2 '15 at 19:01
I found this link, with a script that may help but I'm not quite sure if it's safe: gist.github.com/cgdangelo/2175558 ALTER TABLE
catalog_product_index_tier_price ADD CONSTRAINT FK_CAT_PRD_IDX_TIER_PRICE_CSTR_GROUP_ID_CSTR_GROUP_CSTR_GROUP_ID FOREIGN KEY (customer_group_id) REFERENCES customer_group (customer_group_id) ON DELETE CASCADE ON UPDATE CASCADE;– Peanuts
Nov 3 '15 at 19:56
I found this link, with a script that may help but I'm not quite sure if it's safe: gist.github.com/cgdangelo/2175558 ALTER TABLE
catalog_product_index_tier_price ADD CONSTRAINT FK_CAT_PRD_IDX_TIER_PRICE_CSTR_GROUP_ID_CSTR_GROUP_CSTR_GROUP_ID FOREIGN KEY (customer_group_id) REFERENCES customer_group (customer_group_id) ON DELETE CASCADE ON UPDATE CASCADE;– Peanuts
Nov 3 '15 at 19:56
add a comment |
1 Answer
1
active
oldest
votes
0
Try doing it programmatically. This way:
$indexCollection = Mage::getModel('index/process')->getCollection();
foreach ($indexCollection as $index)
$index->reindexAll();
answered Dec 24 '15 at 4:32
Akhil GuptaAkhil Gupta
1,6311 gold badge7 silver badges21 bronze badges
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f88607%2fcant-reindex-product-prices-a-foreign-key-constraint-fails%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
0
Try doing it programmatically. This way:
$indexCollection = Mage::getModel('index/process')->getCollection();
foreach ($indexCollection as $index)
$index->reindexAll();
answered Dec 24 '15 at 4:32
Akhil GuptaAkhil Gupta
1,6311 gold badge7 silver badges21 bronze badges
add a comment |
0
Try doing it programmatically. This way:
$indexCollection = Mage::getModel('index/process')->getCollection();
foreach ($indexCollection as $index)
$index->reindexAll();
answered Dec 24 '15 at 4:32
Akhil GuptaAkhil Gupta
1,6311 gold badge7 silver badges21 bronze badges
add a comment |
0
0
0
Try doing it programmatically. This way:
$indexCollection = Mage::getModel('index/process')->getCollection();
foreach ($indexCollection as $index)
$index->reindexAll();
answered Dec 24 '15 at 4:32
Akhil GuptaAkhil Gupta
1,6311 gold badge7 silver badges21 bronze badges
Try doing it programmatically. This way:
$indexCollection = Mage::getModel('index/process')->getCollection();
foreach ($indexCollection as $index)
$index->reindexAll();
answered Dec 24 '15 at 4:32
Akhil GuptaAkhil Gupta
1,6311 gold badge7 silver badges21 bronze badges
answered Dec 24 '15 at 4:32
Akhil GuptaAkhil Gupta
1,6311 gold badge7 silver badges21 bronze badges
answered Dec 24 '15 at 4:32
Akhil GuptaAkhil Gupta
1,6311 gold badge7 silver badges21 bronze badges
answered Dec 24 '15 at 4:32
Akhil GuptaAkhil Gupta
1,6311 gold badge7 silver badges21 bronze badges
1,6311 gold badge7 silver badges21 bronze badges
add a comment |
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f88607%2fcant-reindex-product-prices-a-foreign-key-constraint-fails%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
As a sidenote, in this SO thread they say that it's safe to truncate the Product Prices Index table, and then re-build it, without any consecuences. Do you think I could take that route? (stackoverflow.com/questions/22590843/…)
– Peanuts
Nov 2 '15 at 19:01
I found this link, with a script that may help but I'm not quite sure if it's safe: gist.github.com/cgdangelo/2175558 ALTER TABLE
catalog_product_index_tier_priceADD CONSTRAINTFK_CAT_PRD_IDX_TIER_PRICE_CSTR_GROUP_ID_CSTR_GROUP_CSTR_GROUP_IDFOREIGN KEY (customer_group_id) REFERENCEScustomer_group(customer_group_id) ON DELETE CASCADE ON UPDATE CASCADE;– Peanuts
Nov 3 '15 at 19:56