We just moved to 7.6.4 from 7.5.14 and are experiencing problems with transfering content. Simply put, Deploy is not working. It issues an SQL error.
I have been trying to get to the bottom of this and it seems like there is a solution (at least it has worked on my localhost that was working from a previous restore).
For some weird reason there are a lot of entries in "umbracoRelation" table, and it looks like nodes that I had deleted and then restored from the Recycle Bin. They are in that table.
When I deleted the entries on my localhost, I could restore again and the SQL error was gone. I think Deploy things that "umbracoRelation" is empty so it tries to put in content and results in "Cannot insert duplicate key row in object" SQL error.
Has anyone done this on the Umbraco Cloud? The problem remains on our DEV and LIVE servers on Umbraco Cloud.
delete entries in table "umbracoRelation" and "Relate Parent Document On Delete" relation SQL problem
Hello everyone,
We just moved to 7.6.4 from 7.5.14 and are experiencing problems with transfering content. Simply put, Deploy is not working. It issues an SQL error.
I have been trying to get to the bottom of this and it seems like there is a solution (at least it has worked on my localhost that was working from a previous restore).
For some weird reason there are a lot of entries in "umbracoRelation" table, and it looks like nodes that I had deleted and then restored from the Recycle Bin. They are in that table.
When I deleted the entries on my localhost, I could restore again and the SQL error was gone. I think Deploy things that "umbracoRelation" is empty so it tries to put in content and results in "Cannot insert duplicate key row in object" SQL error.
Has anyone done this on the Umbraco Cloud? The problem remains on our DEV and LIVE servers on Umbraco Cloud.
Thank you, Genc
is working on a reply...