Additional Path changes needed when using Toolbarr DB Editor

[qsuicide]

Hello!

Recently did a full migration from Windows to Linux using Toolbarr, and discovered that I need additional database edits. The main function of Toolbarr updated the Root Folders without issue, and my Recycling Bin, but in discussion with Sonarr team members, it appears three additional tables need editing

EpisodeFiles
MetadataFiles
SubtitleFiles

in Each case, the RelativePath field contains /\s that need to be swapped if moving from windows to linux (or vise versa). If the changes are not made, you end up with sonarr scanning the shows, removing all the files, and re-adding them with proper paths

From

To

where the only difference is the \ to / in the Season folder part of the path.

I also had additional DB issues [some shows could not be scanned, causing errors and db corruption entries in the logs] that were resolved once i updated those three tables above as well as the Series table that Toolbarr did.

So perhaps another option/button can be added to toolbarr to 'clean up additional database tables when migrating from linux to windows' and vise versa, or something simple that can identify that the /'s in those tables dont match the root folders and thus need to be changed.. im not sure what the best approach here is.

There was also note from another use that this could/should be part of the Starr apps directly, which sounds like a lovely idea, but out of the scope of this particular request.

p.s. dont hate my paths and filenames.