Reply to thread

This might be old, but for some that still go through this headache every-time they make changes to their drives, the DB edit route always proves easier for me.In my case i was changing my paths to a network share

to edit the TV Series DB, two tables must be edited

update local_episodes

set EpisodeFilename = replace(EpisodeFilename, 'D:\Series', '\\192.168.2.197\Series\Series')

update local_episodes

set volumelabel = replace(volumelabel, 'Series', '192.168.2.197\Series\Series')

//my old local folder drive was named series, this must also be changed to the  network folder, don't include the '\\'

update importpathes

set path = replace(path, 'D:\Series', '\\192.168.2.194\Series\Series')

you can run some selects on the following tables to verify that all has been changed

select * from

local_episodes

Select *

from importpathes

Make Changes to the Moving pictures Db

update local_media

set fullpath = replace(fullpath, '\\E:\Movies','\\192.168.2.197\Media\Movies\Various')

//This changes the file-names prefix, appending it with the new path

update import_path

set path = replace(path, 'E:\Movies','\\192.168.2.197\Media\Movies\Various')

update local_media

set volume_serial = ''

//My local was set to Movies, the name of my HardDrive, i removed this

Hope this helps someone that might have also struggled as i did