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

URGENT SQLSTATE[2003] ERROR WHEN ADDING/EDITING CATEGORIES IN 1.1.x
 
sherrie
Moderator
 
Avatar
Total Posts:  1655
Joined:  2007-12-14
Waterloo, ON
 

Would SOMEONE from Varien PLEASE address this issue. It is NOT resolved and very CRUCIAL.

Whenever I try to add/modify categories I am getting the following error:

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

And I know others are having even more serious issues like products being randomly deleted.

Please see these forum posts:
http://www.magentocommerce.com/boards/viewthread/13206 (Don’t be fooled by the title, it’s not fixed.)
http://www.magentocommerce.com/boards/viewthread/15302

And these bug reports:
http://www.magentocommerce.com/bug-tracking/issue?issue=3120
http://www.magentocommerce.com/bug-tracking/issue/?issue=2848

 
Magento Community Magento Community
Magento Community
Magento Community
 
redpen
Sr. Member
 
Total Posts:  254
Joined:  2008-01-23
 

Thanks for doing this, let’s hope we get a response this time.

I can confirm that whatever the issue is, it’s corrupting my live database and deleting products, which then causes the SQLSTATE[2003] error on the category admin pages, preventing further changes.  Just today (and this is like the 5th or 6th time it’s done it) Magento randomly deleted an entire category’s worth of products from the site. 

Utterly baffling, and would really appreciate some help ASAP because, as I said, this is happening on a live, trading Magento store.  If someone from the team wants to PM me I’ll give you access to the store back end and the PHPMyAdmin URL etc.

 
Magento Community Magento Community
Magento Community
Magento Community
 
redpen
Sr. Member
 
Total Posts:  254
Joined:  2008-01-23
 

Still no response.  We’re not able to make any changes to our products now in case this happens again, would appreciate a reply from Varien.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Flopy69
Sr. Member
 
Avatar
Total Posts:  124
Joined:  2008-06-04
Lyon
 

i have the same error :

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`mag_catalog_category_product_index`, CONSTRAINT `FK_CATALOG_CATEGORY_PRODUCT_INDEX_PRODUCT_ENTITY` FOREIGN KEY (`product_id`) REFERENCES `mag_catalog_product_entity` (`entity_id`) ON)

and

Item (Mage_Catalog_Model_Product) with the same id “123” already exist

i need a fix urgently !!!

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

Well I no longer have this issue in 1.1.5 - now the page just gets stuck with the spinning wheel. Haha ... the new category thing fixed this issue but created a new one, apparently.  Bleh.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Flopy69
Sr. Member
 
Avatar
Total Posts:  124
Joined:  2008-06-04
Lyon
 

i have still tihs bug.... anyone find a fix ?

 
Magento Community Magento Community
Magento Community
Magento Community
 
redpen
Sr. Member
 
Total Posts:  254
Joined:  2008-01-23
 
Flopy69 - 01 October 2008 11:10 PM

i have still tihs bug.... anyone find a fix ?

Nope.  No fix, no word from Varien.

Basically, we just lose 10 or so products every week, and have to manually add them back in again.

 
Magento Community Magento Community
Magento Community
Magento Community
 
redpen
Sr. Member
 
Total Posts:  254
Joined:  2008-01-23
 

Just lost another 2 products.  Same bug.

 
Magento Community Magento Community
Magento Community
Magento Community
 
lisali
Enthusiast
 
Avatar
Total Posts:  889
Joined:  2008-04-28
London, UK
 

1.1.6 - same bug. VARIEN, WHERE ART THOU?

 
Magento Community Magento Community
Magento Community
Magento Community
 
redpen
Sr. Member
 
Total Posts:  254
Joined:  2008-01-23
 

Over the weekend we had 140 products from one category suddenly appear in another, had to manually edit them out using PHPMyAdmin, presumably same bug.

 
Magento Community Magento Community
Magento Community
Magento Community
 
lisali
Enthusiast
 
Avatar
Total Posts:  889
Joined:  2008-04-28
London, UK
 

Any update on this?
Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
Flopy69
Sr. Member
 
Avatar
Total Posts:  124
Joined:  2008-06-04
Lyon
 

I identified error.

When install magento 1.1.6 -> no error

When install magento 1.1.x -> upgrade 1.1.6 -> error

If you install 1.1.6 then import database -> error

it’s a problem with one or many data in database… but which one ???

i don’t have a solution at this moment.... i need some help.

 
Magento Community Magento Community
Magento Community
Magento Community
 
lisali
Enthusiast
 
Avatar
Total Posts:  889
Joined:  2008-04-28
London, UK
 

Any updates?

Please comment on those Bug reports that Sherrie and Gabrusch posted:

http://www.magentocommerce.com/bug-tracking/issue?issue=3120
http://www.magentocommerce.com/bug-tracking/issue/?issue=2848

PS: I am on a FRESH 1.1.6 install, FRESH database, NO imports. Same error.

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

Did anyone ever find a fix for this issue?

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