Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Alan Mac Kenna 147 posts 405 karma points MVP c-trib
    Mar 10, 2016 @ 12:09
    Alan Mac Kenna
    0

    INSERT statement conflicted with the FOREIGN KEY constraint FK_merchItemCacheItem_merchItemCache

    Hi all,

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

    • Umbraco Version 7.2.8
    • Merchello Version: 1.10.1

    Alan

  • Rusty Swayne 1655 posts 4993 karma points c-trib
    Mar 11, 2016 @ 18:11
    Rusty Swayne
    0

    Hey Simon,

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

  • Alan Mac Kenna 147 posts 405 karma points MVP c-trib
    Mar 13, 2016 @ 21:54
    Alan Mac Kenna
    0

    Thanks for the reply Rusty,

    Will look into the anon customer migration angle.

    Appreciate it.

Please Sign in or register to post replies

Write your reply to:

Draft