| ||||||||||
Shopping cart software Solutions for online shops and malls | ||||||||||
|
X-Cart Home | FAQ | Forum rules | Calendar | Mark Forums Read | User manuals | Login |
SQLSTATE[23000]: Integrity constraint violation: 1217 | |||
|
|
Thread Tools | Search this Thread |
#1
|
|||||||
|
|||||||
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` __________________ |
|||||||
#2
|
|||||||
|
|||||||
Re: SQLSTATE[23000]: Integrity constraint violation: 1217
tried soft reset and hard reset but no luck recovering
|
|||||||
#3
|
|||||||||
|
|||||||||
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. |
|||||||||
#4
|
|||||||
|
|||||||
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.. |
|||||||
#5
|
|||||||
|
|||||||
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. |
|||||||
#6
|
|||||||
|
|||||||
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. |
|||||||
|
Thread Tools | Search this Thread |
|
|
|
|||
X-Cart forums © 2001-2020
|