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`
__________________

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

tried soft reset and hard reset but no luck recovering

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?

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..

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.

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.