Magento Forum

   
[Solved] SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails…
 
Dunc
Member
 
Avatar
Total Posts:  56
Joined:  2008-08-05
 

Well I think everything else is working after the upgrade, had to run CHMOD again on this one though. The problem I am now getting is with this new feature for Google Base, I’m getting the following error when trying to “Add to Google Base"…

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`dpotter_esds/googlebase_items`, CONSTRAINT `GOOGLEBASE_ITEMS_PRODUCT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE)

Any help would be appreciated.

Thanks
Duncan

 
Magento Community Magento Community
Magento Community
Magento Community
 
Dunc
Member
 
Avatar
Total Posts:  56
Joined:  2008-08-05
 

I’m suspecting this problem is because my hosting company changed the name of my database when there were problems with it, this means it’s not the same as the initial install and I expect the update is not making the changes to the database it requires. I have asked them to change it back to it’s original name.

 
Magento Community Magento Community
Magento Community
Magento Community
 
hero
Member
 
Total Posts:  33
Joined:  2008-10-21
 

or change the dbase name in your config data.
search for config on your ftp server and change the dbname.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Dunc
Member
 
Avatar
Total Posts:  56
Joined:  2008-08-05
 

I’m not sure where the config file might be, I don;t have the option to search for files. Also, not so sure now that it’s to do with the filename chane of the database as everything else seems to be working fine.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Dunc
Member
 
Avatar
Total Posts:  56
Joined:  2008-08-05
 

Duplicate

 
Magento Community Magento Community
Magento Community
Magento Community
 
purplemine
Sr. Member
 
Total Posts:  143
Joined:  2008-05-20
London
 

I am also getting this error when trying to edit existing products, I can no longer edit any existing products in the admin.

This is a serious errror, fix would be very much appreciated.

Thanks,

John

 
Magento Community Magento Community
Magento Community
Magento Community
 
Dunc
Member
 
Avatar
Total Posts:  56
Joined:  2008-08-05
 

Thankfully, this is now solved…

http://www.magentocommerce.com/boards/viewthread/24394/#t80542

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top