Missing Folders in Umbraco Tree

Posted on August 30, 2019 in umbraco

On this very site, which originally started as a v7 site and has slowly been upgraded to the latest 8.1 release, something weird started happening. Some media folders stopped showing in the media tree left), although they would still show in the media panel (right).

So: the media folders still existed, but they just did not show in trees.

I am pretty sure it worked with 8.0, and stopped working with 8.1. Which is strange, as the original issue seems to target the 7-to-8 upgrade. Anyways. I just wanted to share the cause, and the fix.

The cause is missing rows in the umbracoMediaVersion table for these folders. The fix consists in inserting these missing rows again.

This is exactly what the following SQL does:

insert into umbracoMediaVersion (id, path)
select VersionId, NULL
from (

    select n.id NodeId, n.Text Name, ct.alias Alias, cv.id VersionId, mv.id MvId, mv.path MvPath
    from umbracoNode n
    join umbracoContent c on n.id=c.nodeId
    join cmsContentType ct on c.contentTypeId=ct.nodeId
    join umbracoContentVersion cv on n.id=cv.nodeId
    left outer join umbracoMediaVersion mv on cv.id=mv.id
    where n.nodeObjectType='B796F64C-1F99-4FFB-B886-4BF4BC011A9C'

    and ct.alias='Folder' -- only folders
    and mv.id is null -- that dont have the required row
) x

Note that you may want to run the inner query first, just to verify that your database is indeed missing these rows.