[Zxurian]

I'm running Kodi via a shared MySQL DB. I recently moved all my media from old sources to a collective new source. and as part of that
1) I updated all paths within the database from smb://oldshare/oldfolder/... to smb://newshare/newfolder/...
2) i edited sources.xml to remove the old sources and add the new source as smb://newshare/newfolder/

For the most part, everything seems to have worked. All videos play, and when I updated it, it found some new video files I had placed there.

the problem is that when I run a Clean Library, it keeps listing the new smb://newshare/newfolder/ as an Unknown Source and prompting me to remove files from it (which will empty my library).

How can I get Clean Library to recognize this path as a valid source (even when Kodi continues to serve files from this source without issue) ?

[Karellen]

1) I updated all paths within the database from smb://oldshare/oldfolder/... to smb://newshare/newfolder/...

Which tables?

[Klojum]

the problem is that when I run a Clean Library, it keeps listing the new smb://newshare/newfolder/ as an Unknown Source

Then perhaps you missed a spot when hacking your database to the new paths?
Or maybe something went wrong all the same. Typos are made easily.

There is no database backup/dump from before you made the changes?

[Zxurian]

1) I updated all paths within the database from smb://oldshare/oldfolder/... to smb://newshare/newfolder/...

Which tables? 

txt:
path.strPath

movie.c22

episode.c18

art.url

tvshow.c16

files.strFilename

[Zxurian]

the problem is that when I run a Clean Library, it keeps listing the new smb://newshare/newfolder/ as an Unknown Source

Then perhaps you missed a spot when hacking your database to the new paths?
Or maybe something went wrong all the same. Typos are made easily.

There is no database backup/dump from before you made the changes? 

I do have a backup pre-upgrade, so I can always start-over. My DB upgrade script is the following if you think there could be a typo. I'm certainly not immune. My issue is that if Kodi itself is okay scanning the new paths & sources, then why does it reference the same path as unknown?

sql:
UPDATE path SET strPath = REPLACE(strPath,'smb://oldshare1/oldfolder1', 'smb://newshare/newfolder');

UPDATE path SET strPath = REPLACE(strPath,'smb://oldshare2/oldfolder2', 'smb://newshare/newfolder');

UPDATE movie SET c22 = REPLACE(c22,'smb://oldshare1/oldfolder1', 'smb://newshare/newfolder');

UPDATE movie SET c22 = REPLACE(c22,'smb://oldshare2/oldfolder2', 'smb://newshare/newfolder');

UPDATE episode SET c18 = REPLACE(c18,'smb://oldshare1/oldfolder1', 'smb://newshare/newfolder');

UPDATE episode SET c18 = REPLACE(c18,'smb://oldshare2/oldfolder2', 'smb://newshare/newfolder');

UPDATE art SET url = REPLACE(url,'smb://oldshare1/oldfolder1', 'smb://newshare/newfolder');

UPDATE art SET url = REPLACE(url,'smb://oldshare2/oldfolder2', 'smb://newshare/newfolder');

UPDATE tvshow SET c16 = REPLACE(c16,'smb://oldshare1/oldfolder1', 'smb://newshare/newfolder');

UPDATE tvshow SET c16 = REPLACE(c16,'smb://oldshare2/oldfolder2', 'smb://newshare/newfolder');

UPDATE files SET strFilename = REPLACE(strFilename,'smb://oldshare1/oldfolder1', 'smb://newshare/newfolder');

UPDATE files SET strFilename = REPLACE(strFilename,'smb://oldshare2/oldfolder2', 'smb://newshare/newfolder');