Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
I'm wondering has anyone seen this error before? It's been logged a couple of times over the past few days. I'm not familiar with the Merchello table structure to know why this might occur. If anyone can give guidance that would be great.
The INSERT statement conflicted with the FOREIGN KEY constraint "FKmerchItemCacheItemmerchItemCache". The conflict occurred in database "xxxxxx", table "dbo.merchItemCache", column 'pk'.
I'm assuming this occurs in your application either in a basket or checkout process ...
You can think of the ItemCache as the container for a bunch of line items (ItemCacheLineItems). What must be happening is the ItemCache is getting removed in the database and something in your application is trying to insert a line item referencing the parent container that has been removed.
I'd need to know more about your application to figure out exactly what is going on - but one thought is if you are converting an anonymous customer to a known customer and not migrating their basket or something ... you might see a conflict like this ...
Thanks for the reply Rusty,
Will look into the anon customer migration angle.
is working on a reply...
Write your reply to:
Image will be uploaded when post is submitted