Closed

Resolve Issue of Magento Database Script for Product Entity & Attribute set

Hello,

I am looking for a magento expert who will be able to migrate my database script by resolving the database errors. Currently my database script giving following error.

ERROR 1005 (HY000) at line 1101132 in file: '[login to view URL]': Can't create table `jobakain_beyondbk`.`catalog_product_entity` (errno: 121 "Duplicate key on write or update")

ERROR 1452 (23000) at line 1101162 in file: '[login to view URL]': Cannot add or update a child row: a foreignkey constraint fails (`jobakain_beyondbk`.`#sql-32649f_567ecf`, CONSTRAINT `CAT_PRD_ENTT_INT_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE)

ERROR 1452 (23000) at line 1101206 in file: '[login to view URL]': Cannot add or update a child row: a foreignkey constraint fails (`jobakain_beyondbk`.`#sql-32649f_567ecf`, CONSTRAINT `CAT_PRD_ENTT_VCHR_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE)

ERROR 1452 (23000) at line 1101531 in file: '[login to view URL]': Cannot add or update a child row: a foreignkey constraint fails (`jobakain_beyondbk`.`#sql-32649f_567ecf`, CONSTRAINT `EAV_ATTR_GROUP_ATTR_SET_ID_EAV_ATTR_SET_ATTR_SET_ID` FOREIGN KEY (`attribute_set_id`) REFERENCES `eav_attribute_set` (`attribute_set_id`) )

ERROR 1452 (23000) at line 1101550 in file: '[login to view URL]': Cannot add or update a child row: a foreignkey constraint fails (`jobakain_beyondbk`.`#sql-32649f_567ecf`, CONSTRAINT `EAV_ATTR_OPT_SWATCH_OPT_ID_EAV_ATTR_OPT_OPT_ID` FOREIGN KEY (`option_id`) REFERENCES `eav_attribute_option` (`option_id`) ON DELETE CASCAD)

ERROR 1005 (HY000) at line 1101564 in file: '[login to view URL]': Can't create table `jobakain_beyondbk`.`eav_attribute_set` (errno: 121 "Duplicate key on write or update")

ERROR 1452 (23000) at line 1101577 in file: '[login to view URL]': Cannot add or update a child row: a foreignkey constraint fails (`jobakain_beyondbk`.`#sql-32649f_567ecf`, CONSTRAINT `EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON )

ERROR 1452 (23000) at line 1101584 in file: '[login to view URL]': Cannot add or update a child row: a foreignkey constraint fails (`jobakain_beyondbk`.`#sql-32649f_567ecf`, CONSTRAINT `EMAIL_CATALOG_PRODUCT_ID_CATALOG_PRODUCT_ENTITY_ENTITY_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON)

ERROR 1452 (23000) at line 1101614 in file: '[login to view URL]': Cannot add or update a child row: a foreignkey constraint fails (`jobakain_beyondbk`.`#sql-32649f_567ecf`, CONSTRAINT `MARKETPLACE_PRD_MAGEPRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`mageproduct_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELET)

Message and bid only if you are able to solve this!

Skills: Javascript, Magento, MySQL, PHP, SQL

See more: magento script product data import, magento database product images, magento product attribute set, magento delete attribute programmatically, magento 2 product attributes table, magento database product price, magento add manufacturer product attribute, magento change product attribute set, product name magento database, google redefines product type attribute magento, magento add product video attribute flash, magento database mysql field description product, magento database product option, magento display product custom attribute product listing, php product database script, php script product magento import, magento import complex product script, magento database downloadable product, magento database add product, shipping attribute magento database

About the Employer:
( 0 reviews ) bhavnagar, India

Project ID: #19046990

3 freelancers are bidding on average ₹6107 for this job

amolbhoyate

>>>>>Magento Certified Developer<<<<< Thank you for reading my proposal. I can work on all Magento tasks. I can resolve your all the issue . I have 10 years of experience in Magento. Magento certification link More

₹11111 INR in 1 day
(6 Reviews)
2.9
readymakers

I am confident I am the right candidate for this project as I have done many similar projects in the past. With years of experience in this field, I believe this project will be very easy for me.

₹5910 INR in 18 days
(2 Reviews)
2.5
ramkvenk1990

I have worked in magento projects and created complete e-commerce website with mysql database for storing products.

₹1300 INR in 1 day
(0 Reviews)
0.0