Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

SQL Error when Adding New Categories in 1.1.3
 
sherrie
Moderator
 
Avatar
Total Posts:  1655
Joined:  2007-12-14
Waterloo, ON
 

I am getting the following error in 1.1.3 when trying to add new categories:

SQLSTATE[23000]Integrity constraint violation1216 Cannot add or update a child rowa foreign key constraint fails

Any ideas?

 
Magento Community Magento Community
Magento Community
Magento Community
 
sherrie
Moderator
 
Avatar
Total Posts:  1655
Joined:  2007-12-14
Waterloo, ON
 

This also happens when trying to rename any existing categories or changing whether or not they are active.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Nick Burne
Jr. Member
 
Total Posts:  1
Joined:  2008-12-22
 

Hi, having the same problem.

Can anyone help?

Thanks

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