Umbraco-CMS: Media tree doesn't show folders in 7.15.0 any more for folders created before 7.8.0

Sure, there you go: 😊

This is a reasonably large problem for users. Perhaps HQ needs to highlight this issue on the 7.15.0 release page on Our ?

I feel that this is a serious issue that needs to be fixed in a patch update or hotfix as soon as possible.

A 7.15.1 release will have to wait a little longer.

If you need to fix it now, make sure to roll back to either 7.14.0, use the build output from the related PR.

Considering that there should be massive amount of sites out there that is affected by this issue, I would say that a releases hot fix would be preferable. Modifying the DB manually feels like the wrong fix. I would REALLY like that the 7.15.1 release got closed and shipped. That said, I would prefer to upgrade via Nuget.

In our case we updated 12 sites, after reading about the update before the warning came up. We obviously didn’t return to the releases-page after that.

So, I thought screw it. I’m going to remove the ‘parentId = -1’ in the first select query… And it fixes all my problems with the folders. Now all are showing 👍

As a workaround, we can populate the cmsMedia table with some SQL. Note, this is mostly untested, make backups and copy the output of this script to make sure you can revert the INSERT statement if needed later

DECLARE @i int
DECLARE @nodeId int
DECLARE @numrows int
DECLARE @versionId varchar(50)
DECLARE @rootNodes TABLE (
    idx smallint Primary Key IDENTITY(1,1)
    , NodeId int
)

INSERT @rootNodes
SELECT id FROM umbracoNode WHERE nodeObjectType = 'B796F64C-1F99-4FFB-B886-4BF4BC011A9C' AND id NOT IN (SELECT nodeId FROM cmsMedia)

SET @i = 1
SET @numrows = (SELECT COUNT(*) FROM @rootNodes)
IF @numrows > 0
    WHILE (@i <= (SELECT MAX(idx) FROM @rootNodes))
    BEGIN

        SET @nodeId = (SELECT NodeId FROM @rootNodes WHERE idx = @i)

        --Do something with Id here
        SET @versionId = (SELECT TOP 1 VersionId FROM cmsContentVersion WHERE ContentId = @nodeId ORDER BY VersionDate DESC)
		PRINT(@versionId)
		PRINT(@nodeId)
		INSERT INTO cmsMedia(nodeId, versionId) VALUES(@nodeId, @versionId)
		
        SET @i = @i + 1
    END

What does it do? It finds all nodes of type 'B796F64C-1F99-4FFB-B886-4BF4BC011A9C' (media types) that are not yet in the cmsMedia table.

It then loops through each of them and finds the newest version in the cmsContentVersion table. Then it inserts the nodeId and versionId in cmsMedia which will then ensure it ends up in the media tree again as it is part of the LEFT JOIN query again,

Did I tell you to make backups? And copy the output?

In the output you should see the result of the first SELECT (in my case 5 items, (5 rows affected)) and then for each item the versionId and the nodeId that are inserted into cmsMedia.

Ps. Make backups!

@MichaelNielsenDK Obviously this is being fixed ASAP.

Just to be difficult - running the SQL works fine, I can see the folders in the media table, all with mediaPath = null. I don’t though have a rendered tree in the backoffice. Folders show fine in the main pane, just nothing in the tree…

Site is 7.8.2 freshly updated to 7.15

EDIT - user error. Ignore me.

Understood. It’s stable. After Lee said it “half works” he fixed it, the script has been updated and I mentioned a few times that you should use it if you need to get up and running on 7.15.0 for now.

For future readers:

Workaround if you are already on 7.15.0 and need to fix your media tree right now

The complete SQL script that works great is in this comment, it has been updated after some tests came in and it is now complete: https://github.com/umbraco/Umbraco-CMS/issues/5848#issuecomment-510801892

@nul800sebastiaan Any news on the 7.15.1 release? Don’t want to hassle, but it’s been over two weeks now and this is a show-stopper bug in the only release that contains an important security fix. If it’s just changing one query to a LeftJoin then I would have expected a release much sooner. Are there other issues or some reason for the delay? Normally critical patches are release quickly. Or is there something political at work, with v8 taking all the priority?

Using the workaround in the SQL script is the correct thing to do for now until we have a 7.15.1 release ready soon.

Note that for security fixes we also listed workarounds for all older versions that can be used.

We ran the patch SQL (with the additional notes from Lee) and that fixed the issue for us on Umbraco Cloud.

Thanks @nul800sebastiaan and @YodasMyDad

Any idea when this will make it into 7.15.1 and when it will be released? Currently have a live site that no one can add new content on because cannot pick images for the content.

Hi @nul800sebastiaan It wasn’t clear how stable that script was given it says, “this is mostly untested” and someone had commented “it half works”. You can understand, even with backups, that it can be worrying running an SQL script like this (and if a client is actively populating a site, then restoring the DB from backup a week later if a problem arises isn’t really viable as they will lose all content added since that point).

@nul800sebastiaan @Shazwazza Whats the outlook for making a patch for this issue alone? Or at least close 7.15.1 as is? Our clients are upset. And the Security Advisory July 9th 2019 makes it somewhat official that we’ve done the correct thing upgrading.

We upgraded to v7.15.0 in part because of the security advisory issued by Umbraco on 9th July:

https://umbraco.com/blog/security-advisory-july-9th-2019/

Being able to select media in folders is critical functionality for editors.

I understand the focus in now on v8, but this isn’t a new feature request, this is a request to fix existing functionality that was broken in the last release.

Is there an expected release date for this fix so I can relay this to our clients?