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'.
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?
is working on a reply...