Magento Database Repair

We have a live website running Magento We recently added a a configurable product and noticed that the "Product Prices" - "index product prices" under index management was stuck on processing. We deleted the product and we now notice that whenever we alter any product attribute the following message is displayed in the Magento backend in a red bar at the top:

"SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`pr0gr3ss_magento/catalog_product_index_tier_price`, CONSTRAINT `FK_CATALOG_PRODUCT_INDEX_TIER_PRICE_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELE)"

We need help to repair the database of our live Magento installation. The website still works and we are processing orders still, but we need to resolve this small bug. Experience in database repairs and backup for a live environment is necessary to bid on this contract. We are looking to reward this contract and have an expert resolve this ASAP.

Please let us know if there are any questions and we can provide full database/ backend access to the best bidder.



Compétences : Magento

en voir plus : magento product prices index processing, access database expert, magento integrity constraint violation catalog_product_index_tier_price, constraint `fk_catalog_product_index_tier_price_entity` foreign key, magento database repair, magento repair index, update magento website, repair website, magento help, magento database, magento 18, backup database, magento add product attribute, magento product management, 1452, expert website bug, integrity constraint violation 1452 add update add, added database, magento 1452, magento bug product, add foreign key constraint, add update child row foreign, magento add update child row foreign key, integrity constraint violation 23000, access orders management database

Concernant l'employeur :
( 9 commentaires ) Seattle, United States

Nº du projet : #1035302

Décerné à:


Hello David, Please have a look at PMB for more detail.

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(165 Commentaires)

6 freelance font une offre moyenne de $113 pour ce travail


check your pmb

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(14 Commentaires)

I think I can hep you with this issue.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(15 Commentaires)

Hi. Please check Pm. Thanks

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(5 Commentaires)

See PMB for discussion.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)

Ready to start right way. Hope to achieve next positive feedback from you !!! Please check you inbox. ""Always willing to walk extra miles to achieve Excellence""

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 25 jours
(0 Commentaires)

This would be an issue with the other connected products. I've worked with Magento for over 4 years. I can have this done for you in 2 hours.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(0 Commentaires)