Copied to clipboard

Flag this post as spam?

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


  • Duc Tran 20 posts 41 karma points
    May 21, 2013 @ 10:49
    Duc Tran
    0

    Missing FKs in DB of an upgraded 4.7.2

    I'm running a site which has gone from 4.0 to 4.5 to 4.7.2

    Somwhere along the way the FKs have dropped off (although I am not sure whether they were present in the old builds to start with). I am comparing the Fks in a fresh 4.7.2 site that hasn't undergone any upgrades

    A couple of questions:

    1. Is this a cause of concern and what possible impacts to the site? I did notice some trash items wouldn't delete but a recycle bin package fixed that.

    2. I tried to restore the foreign keys via SQL which seems successful until I get these errors in cmsContentVersion and cmsPreviewXml tables.

    The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_cmsContentVersion_cmsContent". The conflict occurred in database "bldtec_live", table "dbo.cmsContent", column 'nodeId'.

    Any idea what causes this?

     

Please Sign in or register to post replies

Write your reply to:

Draft