When we try to rollback to a previous content version the following error occurs:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_cmsDocument_cmsTemplate". The conflict occurred in database "OA_Thinkeyegiene", table "dbo.cmsTemplate", column 'nodeId'. The statement has been terminated.
Does the node you are trying to roll back have a template associated with it? I think this is a bug that only manifests for item's without templates, or doc types with out templates.
Experienced precisely the same yesterday. On top of the Insert Statement error, all my files associated with the site were missing after I attempted to roll back a page associated with that site. All pages and the root node were gone (I have many sites running on one instance). Have not checked the DB yet, but they are not showing up in UI. I tried again with a test site. Same result.
@greengiant83: I have based my sites on a global properties docType without associating a template to it. This is my site container running metadata and such, under which all pages act as children. What is the bug you are referring to?
FYI - I ran into this issue also (error on rollback, only occurs on documents with no template assigned). I found this issue on Codeplex which reports it was fixed in latest changeset and should be included on 4.7.1.
I actually discoved in my case that our server was causing issues with Umbraco, especially with the developer section. Could not create our install packages, among other things. And could not rollback any pages. We tried everything to resolve, but ended up hosting on another server with same framework, which resolved the problem immediately. Still not certain why.
Rollback error in 4.5
When we try to rollback to a previous content version the following error occurs:
I have the same problem in both 4.6.1 and 4.7rc
Does the node you are trying to roll back have a template associated with it? I think this is a bug that only manifests for item's without templates, or doc types with out templates.
Hi all,
Experienced precisely the same yesterday. On top of the Insert Statement error, all my files associated with the site were missing after I attempted to roll back a page associated with that site. All pages and the root node were gone (I have many sites running on one instance). Have not checked the DB yet, but they are not showing up in UI. I tried again with a test site. Same result.
@greengiant83: I have based my sites on a global properties docType without associating a template to it. This is my site container running metadata and such, under which all pages act as children. What is the bug you are referring to?
FYI - I ran into this issue also (error on rollback, only occurs on documents with no template assigned). I found this issue on Codeplex which reports it was fixed in latest changeset and should be included on 4.7.1.
I actually discoved in my case that our server was causing issues with Umbraco, especially with the developer section. Could not create our install packages, among other things. And could not rollback any pages. We tried everything to resolve, but ended up hosting on another server with same framework, which resolved the problem immediately. Still not certain why.
is working on a reply...