London Dev Meetup Rescheduled! Due to unavoidable reasons, the event has been moved to 21st May. Speakers remain the same—any changes will be communicated. Seats are limited—register here to secure your spot!
AI OnAI Off
London Dev Meetup Rescheduled! Due to unavoidable reasons, the event has been moved to 21st May. Speakers remain the same—any changes will be communicated. Seats are limited—register here to secure your spot!
Hey,
We have a customer that has implemented unique coupon codes for optimizely.
Inspiration for implementation: https://www.david-tec.com/2017/10/unique-vouchercoupon-codes-in-episerver-commerce-using-episerver-campaign/
Were we have experenced that we are getting an error from the SQL Server, if a customer is attempting to remove an added coupon.
SQL error message: "The DELETE statement conflicted with the REFERENCE constraint \"FK_PromotionInformationShipment_PromotionInformationId\". The conflict occurred in database \"CBB.EpiServerCommerceDB\", table \"dbo.PromotionInformationShipment\", column 'PromotionInformationId'.\r\nThe statement has been terminated."
If i drop the foreign key and add it again with "ON DELETE CASCADE", it all works for me locally.
Is it an error that this table, doesn't already have cascade delete ?
Versions:
EPiServer.CMS: 11.20.13
EPiServer.Commerce: 13.37.00