We took over administration of an existing Umbraco site (4.0.2.1 SqlServer .net2) and the content admin managed to delete a media node with a load of images in
Using SqlCompare, i was able to retieve the content, version and node records so that they now at least appear in the tree structure, but the nodws are not editable and error in the CMS
The nodes all have "Click to edit this item <nodename>" against each row in the media tree
Initially i thought that those three tables held all the data i needed but i'm missing something else it seems.
I read that the recycle bin is available for media in 4.5 but i really need to get this media working in 4 before i can proceed with an upgrade. Does anyone know if i can actually retireve this meda in a usable state or are they lost forever? the cached images are still in-place in the media folder but there are literally hundreds in there so retrieving them by hand is a long task that i would like to avoid :¬)
I'm guessing its a silly question to ask if you had a back-up? (or copy of the install from when you took it over?)
Deleting media nodes was always a fear before v4.5 - as you say the latest version does have the recycle bin!
OK, I've not helped so far... which database tables did you look at? umbracoNode, cmsPropertyData, cmsContentXml?
As far as I recall, the media (image) has been deleted - but you should be able to get the meta-data using your SqlCompare approach ... there should be a property called "umbracoFile" that will tell you the filepath of where the media/image used to be (that is, if you still have an archived copy?)
We took it over and this happened on day one so there wasn't a chance for me to get in and take a full backup. The incumbant agency didn;t have a resislant backup plan, more like the backup is overwritten every night and this was the case on this occasion. Items deleted on Monday >> Client Panics and tries to retrieve >> we are informed on Tuesday post backup overwrite. My only saving grace was that they had a dev setup on the same machine and, with this node being so old, most of the data was there thankfully. Still, would have been cool for him to put his hand up striaght away so i could have restored same day and not lost too much content
The original files are indeed gone. i only did umbracoNode, cmsPropertyData and cmsContentVersion, since this was only media i didn't think cmsContentXml was relevant. Should i look in that tables as well you think?
Looking in the old directories, the meta XML file is still in there and points to the cached/resized images. i was hoping this was still going to be able to find the images
Thanks for you pointers as well, clutching a straws a a little but it does give me ammunition for an upgrade and proper backup plan in light of these issues
Restored Media Error
Hi All
We took over administration of an existing Umbraco site (4.0.2.1 SqlServer .net2) and the content admin managed to delete a media node with a load of images in
Using SqlCompare, i was able to retieve the content, version and node records so that they now at least appear in the tree structure, but the nodws are not editable and error in the CMS
The nodes all have "Click to edit this item <nodename>" against each row in the media tree
Initially i thought that those three tables held all the data i needed but i'm missing something else it seems.
I read that the recycle bin is available for media in 4.5 but i really need to get this media working in 4 before i can proceed with an upgrade. Does anyone know if i can actually retireve this meda in a usable state or are they lost forever? the cached images are still in-place in the media folder but there are literally hundreds in there so retrieving them by hand is a long task that i would like to avoid :¬)
Any pointers would be much appreciated
Hi Tim,
I'm guessing its a silly question to ask if you had a back-up? (or copy of the install from when you took it over?)
Deleting media nodes was always a fear before v4.5 - as you say the latest version does have the recycle bin!
OK, I've not helped so far... which database tables did you look at? umbracoNode, cmsPropertyData, cmsContentXml?
As far as I recall, the media (image) has been deleted - but you should be able to get the meta-data using your SqlCompare approach ... there should be a property called "umbracoFile" that will tell you the filepath of where the media/image used to be (that is, if you still have an archived copy?)
Good luck.
Cheers, Lee
Hi Lee
Thanks for your reply
We took it over and this happened on day one so there wasn't a chance for me to get in and take a full backup. The incumbant agency didn;t have a resislant backup plan, more like the backup is overwritten every night and this was the case on this occasion. Items deleted on Monday >> Client Panics and tries to retrieve >> we are informed on Tuesday post backup overwrite. My only saving grace was that they had a dev setup on the same machine and, with this node being so old, most of the data was there thankfully. Still, would have been cool for him to put his hand up striaght away so i could have restored same day and not lost too much content
The original files are indeed gone. i only did umbracoNode, cmsPropertyData and cmsContentVersion, since this was only media i didn't think cmsContentXml was relevant. Should i look in that tables as well you think?
Looking in the old directories, the meta XML file is still in there and points to the cached/resized images. i was hoping this was still going to be able to find the images
Thanks for you pointers as well, clutching a straws a a little but it does give me ammunition for an upgrade and proper backup plan in light of these issues
cheers
Tim
is working on a reply...