Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Tim Hustler 10 posts 31 karma points
    Nov 25, 2010 @ 10:51
    Tim Hustler
    0

    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

  • Lee Kelleher 4026 posts 15836 karma points MVP 13x admin c-trib
    Nov 25, 2010 @ 18:18
    Lee Kelleher
    0

    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

  • Tim Hustler 10 posts 31 karma points
    Nov 25, 2010 @ 18:38
    Tim Hustler
    1

    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

Please Sign in or register to post replies

Write your reply to:

Draft