Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

SQLSTATE[23000]: Integrity constraint violation: 1217

 
Reply
   X-Cart forums > X-Cart 5 > Dev Questions (X-Cart 5)
 
Thread Tools Search this Thread
  #1  
Old 09-27-2014, 07:54 AM
 
xanadude xanadude is offline
 

eXpert
  
Join Date: Jun 2006
Posts: 247
 

Unhappy SQLSTATE[23000]: Integrity constraint violation: 1217

disabled egoods and file attachments.
removed file attachments module and the site auto recache


and now this
Deploying store [step 5 of 11], please wait...

Run the "Doctrine_Plugin_UpdateSchema" plugin...
Error
ERROR: "23000" (code N/A)

SQLSTATE[23000]: Integrity constraint violation: 1217 Cannot delete or update a parent row: a foreign key constraint fails SQL query: DROP TABLE IF EXISTS `xc_product_attachments`
__________________
__________________
Xanadude

http://wemakeanyshirt.com X5 with x-Cart Mobile in build
Reply With Quote
  #2  
Old 09-27-2014, 07:58 AM
 
xanadude xanadude is offline
 

eXpert
  
Join Date: Jun 2006
Posts: 247
 

Default Re: SQLSTATE[23000]: Integrity constraint violation: 1217

tried soft reset and hard reset but no luck recovering
__________________
Xanadude

http://wemakeanyshirt.com X5 with x-Cart Mobile in build
Reply With Quote
  #3  
Old 09-27-2014, 11:28 AM
  totaltec's Avatar 
totaltec totaltec is offline
 

X-Guru
  
Join Date: Jan 2007
Location: Louisville, KY USA
Posts: 5,823
 

Default Re: SQLSTATE[23000]: Integrity constraint violation: 1217

I have run into trouble like this before. Try re-enabling the modules, then make sure that no products actually use these modules, egoods and file attachments by removing any attachments or egoods. Then disable. Any luck?
__________________
Mike White - Now Accepting new clients and projects! Work with the best, get a US based development team for just $125 an hour. Call 1-502-773-6454, email mike at babymonkeystudios.com, or skype b8bym0nkey

XcartGuru
X-cart Tutorials | X-cart 5 Tutorials

Check out the responsive template for X-cart.
Reply With Quote
  #4  
Old 09-27-2014, 12:01 PM
 
xanadude xanadude is offline
 

eXpert
  
Join Date: Jun 2006
Posts: 247
 

Default Re: SQLSTATE[23000]: Integrity constraint violation: 1217

Hi Bud

Thanks I have ended up restoring from last nights backup all files and database so am back up and running.

Just getting so frustrated with the instability of x5

Thanks again..
__________________
Xanadude

http://wemakeanyshirt.com X5 with x-Cart Mobile in build
Reply With Quote
  #5  
Old 09-28-2014, 07:48 AM
 
xanadude xanadude is offline
 

eXpert
  
Join Date: Jun 2006
Posts: 247
 

Default Re: SQLSTATE[23000]: Integrity constraint violation: 1217

OK this is getting stupid

After restoring everything and getting up again unisender does not work properly so disabled it.. Site recache and


ERROR: "0" (code N/A)

A new entity was found through the relationship 'XLite\Model\Profile#membership' that was not configured to cascade persist operations for entity: XLite\Model\Membership@00000000569f621a000000006c2 9b942. To solve this issue: Either explicitly call EntityManager#persist() on this unknown entity or configure cascade persist this association in the mapping for example @ManyToOne(..,cascade={"persist"}). If you cannot find out which entity causes the problem implement 'XLite\Model\Membership#__toString()' to get a clue.
__________________
Xanadude

http://wemakeanyshirt.com X5 with x-Cart Mobile in build
Reply With Quote
  #6  
Old 09-29-2014, 06:18 AM
 
xanadude xanadude is offline
 

eXpert
  
Join Date: Jun 2006
Posts: 247
 

Default Re: SQLSTATE[23000]: Integrity constraint violation: 1217

OK I ended up again doing a full restore of the site. this is now passed as joke

How the hell can I remove the Unisend module without the site failing to recache..... its with the errors.
__________________
Xanadude

http://wemakeanyshirt.com X5 with x-Cart Mobile in build
Reply With Quote
Reply
   X-Cart forums > X-Cart 5 > Dev Questions (X-Cart 5)


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 02:46 AM.

   

 
X-Cart forums © 2001-2020