Fix for duplicates after moving libraries to new disk

[LordSeitan]

Hi, I just experienced a situation where I had moved all of my media to a larger drive and everything was duplicated. There were ghost entries pointing to files at the old media path which I couldn't seem to remove anywhere from the UI and I didn't see any clear solutions in here.

What I ended up doing was to log into the database from the command line with Sqlite3 and deleted the "ghost" entries.

Assuming you're comfortable using the command line and Sqlite3, this is the procedure I used:

1. Stop the server and back up your database.

2. Search and confirm the results are pulling up the old entries you want to delete. (the % matches anything else after this point)

Code:

select * from TypedBaseItems where Path like '/mnt/OldMediaPath/%' limit 10;

3. Delete entries referencing old Library.

Code:

delete from TypedBaseItems where Path like '/mnt/OldMediaPath/%';

4. Give the server a reboot.

Hopefully this helps someone else stuck in a similar situation.