Magento

I also posted one of these errors in the 1.1.7 upgrade problems, but now I have an extra one. I get 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_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE)

and the following after saving a page in CMS…

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`dpotter_esds/googleoptimizer_code`, CONSTRAINT `FK_GOOGLEOPTIMIZER_CODE_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE)

I’m suspecting that the database didn’t update correctly through the upgrade but am unsure what to do to fix this. Any help would be appreciated.

OK, so after a bit of searching I found the solution on a previous thread…

http://www.magentocommerce.com/boards/viewthread/13206/

The core_store table had to be of InnoDB type which I changed using MySQL Query browser, phew, glad that’s done.

Worked for me too! Many thanks!

Thank you to paste the solution..good to know your issue is resolved.

so you find the solution this is good and this is very good information for us it will be work for them who want this solution to upgrade magento1.1.8

thank you

________________________

Computer Registry Cleaner

I just had this too when deleting all the inventory, none of the fixes mentioned in this post or the one linked above resolved it, what was actually needed was a re index and switching the flat catalog to No in System > Config > Catalog > FrontEnd > Use Flat Catalog Category

Matt

thanks the problem happens once in a while, its hard to predict what causes this because by default it is set to InnoDB