On a Documenttype a property got deleted by mistake. I can see in the database that the property values are still on the nodes, but not being displayed in the backend, and of course not when published again.
Is there anyway to restore the property, and being able to see and use the data?
I'm afraid restoring is out of the question, as the id of the property (and referenced by your doc's property data) is gone from the db. Best guess is to create a new property (which will have a different id obviously) and then dive in the db and change the id for each of the nodes that have the old id referenced and change it to the new one)
BUT: Backup first so in case somthing goes wrong, you still have a backup of your current situation. Also backup umbraco.config from the App_data folder just in case!
Restore deleted property
Hi there
On a Documenttype a property got deleted by mistake.
I can see in the database that the property values are still on the nodes, but not being displayed in the backend, and of course not when published again.
Is there anyway to restore the property, and being able to see and use the data?
I'm afraid restoring is out of the question, as the id of the property (and referenced by your doc's property data) is gone from the db. Best guess is to create a new property (which will have a different id obviously) and then dive in the db and change the id for each of the nodes that have the old id referenced and change it to the new one)
BUT: Backup first so in case somthing goes wrong, you still have a backup of your current situation. Also backup umbraco.config from the App_data folder just in case!
Cheers,
/Dirk
Hi Dirk
Thanks for the tip, i'll try my best.
Could you guide my a bit regarding:
'and then dive in the db and change the id for each of the nodes that have the old id referenced and change it to the new one) '
After quite som battle with sql, i managed to save nearly all the data :-)
Thanks for your tip, it really helped.
is working on a reply...