Magento Database Repair

Completed Posted Apr 23, 2011 Paid on delivery
Completed Paid on delivery

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

Magento

Project ID: #1035302

About the project

6 proposals Remote project Active Apr 24, 2011

Awarded to:

AStonetech

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

$60 USD in 1 day
(165 Reviews)
7.0

6 freelancers are bidding on average $113 for this job

magentoecommerce

check your pmb

$100 USD in 3 days
(14 Reviews)
5.2
stels88

I think I can hep you with this issue.

$200 USD in 3 days
(15 Reviews)
4.7
ruimaxwell

Hi. Please check Pm. Thanks

$80 USD in 1 day
(5 Reviews)
3.4
valleysoftware

See PMB for discussion.

$90 USD in 1 day
(1 Review)
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 in 25 days
(0 Reviews)
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 in 0 days
(0 Reviews)
0.0