En cours

Magento Database Repair

We have a live website running Magento 1.5.0.1. 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.

Regards,

David

Compétences : Magento

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é à :

AStonetech

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

60 $ USD en 1 jour
(165 Commentaires)
7.0

6 freelance ont fait une offre moyenne de 113 $ pour ce travail

magentoecommerce

check your pmb

100 $ USD en 3 jours
(14 Commentaires)
5.2
stels88

I think I can hep you with this issue.

200 $ USD en 3 jours
(15 Commentaires)
4.7
ruimaxwell

Hi. Please check Pm. Thanks

80 $ USD en 1 jour
(5 Commentaires)
3.4
valleysoftware

See PMB for discussion.

90 $ USD en 1 jour
(1 Commentaire)
2.6
ndgarg

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""

150 $ USD en 25 jours
(0 Commentaires)
0.0
bobnz

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.

150 $ USD en 0 jours
(0 Commentaires)
0.0