That's very interesting Joseph. I've got a support ticked logged with DNN for this issue but you've managed to progress further in resolving it.

Many physical folder names are mixed case so running a query to change the case of folders to all lower case or all upper case won't work because "images" or "IMAGES" won't match the spelling on the physical folder, "Images"

There are two ways to get the folders names in the Folders table to match the physical folder names.

The most dangerous is to run a delete query against the Folders table. This can wreck havoc and requires a recursive sync in the file manager and manually resetting the folder permissions in the file manager for each folder one at a time.

I finally settled on this process. You need to have direct DB access to do this.

Get the portal ID of your portal from the portals table. I use this first because you can tell by the Home Directory which row is the correct portal.

SELECT PortalID, HomeDirectory FROM Portals

Then run this query to get the folders list for your affected portal:

SELECT FolderID, FolderPath, PortalID from Folders WHERE PortalID = {your portal id} Order by FolderPath

This will give you a nice list to allow you to manually check the spelling of the folders in the folders table against the physical folders in your portals directory.

Next you will need to manually update the spelling of the folder names in the folders table to match the Case on your web server.

I did this by having my ftp client open, a window for my SQL server query showing the folder names list and a 3rd window with the Folders table open for edit access.

Seeing the folder id in this query let me navigate quickly to the correct row in the edit window and change the folder name . This is still a tedious process until the file manager recursive sync issue is fixed.

We have backend SQL database access so I was able to fix this by deleting all entries for the affected portal from the dbo.folders table, running a full recursive sync and re-applying the permissions. This has worked for a few days but I've just gone to edit a page on the portal and the problem has come back. Really frustrating!