Fix MySQL Magento 1452 error

In my Magento store, whenever I attempt to add a new product I run into this error:

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

I injected products in .csv form into the database, via myPhpAdmin and everything worked perfectly--except now I cannot add any new products to the store.

There are various articles online that detail fixes for this problem, but none pertaining to my exact table with problems.

If possible, I would like to get instructions on how to fix this problem--with support on the side in case I run into any issues. Unless of course you feel the fix is easy enough to do for the $$$ offered.


Skills: Magento, MySQL, SQL, System Admin

See more: mysql 1452 fix, this error, problem with error, how to fix my, how do i fix my, get my fix, fix support, error fixes, magento mysql 1452, fix 1452 error mysql, mysql 1452 error, violation, update mysql, system-admin-fix, mysql error, magento support, magento database, fix or now, fix magento issues, fix form

About the Employer:
( 4 reviews ) Glendale, United States

Project ID: #1013693

Awarded to:


can help you. tnx.

$30 USD in 0 days
(435 Reviews)

6 freelancers are bidding on average $45 for this job


I can help you.

$30 USD in 1 day
(28 Reviews)

STOP !!! STOP LOOKING AT ANYMORE BIDS !!! Dear,your search really ends here. Get your bugs fixed right and as it is you are expecting. check our private message then decide yourself. Thanks

$49 USD in 3 days
(13 Reviews)

hi please check pmb for details.

$30 USD in 1 day
(6 Reviews)

Hello please check your inbox

$100 USD in 3 days
(8 Reviews)

Please check PMB

$30 USD in 0 days
(0 Reviews)

Hi, I have 4+ exp. Believe in quality output In programming and do several project related to your project and I can easy do this job plaese check my pmb and be a part of my services forever and I have also good clie More

$30 USD in 0 days
(0 Reviews)