mirror of
https://github.com/advplyr/audiobookshelf.git
synced 2026-05-30 23:40:40 +02:00
[Bug]: Duplicate file paths and manual track adjustment required after library migration #2106
Assignees
adam (Adam Melkus)
Clear assignees
adam (Adam Melkus)
No Assignees
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: starred/audiobookshelf#2106
Reference in New Issue
Block a user
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @kyleviloria on GitHub (Jul 13, 2024).
What happened?
This is likely a personal issue where I didn't do something correctly in order to successfully migrate my libraries, but it may be helpful to others. Happens in Firefox and Chrome.
Issue
I moved libraries to a new drive and aim to retain library/user progress/statistics. I stopped ABS (with backups downloaded), copied files to new drive (G:/) from old (C:/), updated absdatabase to change all (known) file/library paths (e.g.,
pathandlibraryFilesinlibraryItemstable,pathin libraryFolders table), restarted ABS, and rescanned libraries (successfully).I can listen to books as normal in 2 of 4 libraries with statistics retained, and cannot listen to books w/o a workaround in the other 2 libraries (which happen to be the 2 that I have listened to books from in the last 6 months).
As a workaround I can use ‘Manage Tracks’ in web UI to move the new file path G:/ into ‘Track 1’ position, and it plays successfully but the trace of the old file location C:/ is still detected. I'd have to do this manually for each book I want to listen to, and ABS is doubling the book size/length by identifying the (deleted) old file path as an additional track.
Logs
Playing book with old file location detected
Swapping 'tracks' via
Manage Tracksand then playingWhat did you expect to happen?
Retain library statistics and play books as normal
Steps to reproduce the issue
PlayManage Tracks, switch tracks 1 (old file path) and 2 (new file path), selectSave TracklistPlayAudiobookshelf version
v2.11.0
How are you running audiobookshelf?
Windows Tray App
What OS is your Audiobookshelf server hosted from?
Windows
If the issue is being seen in the UI, what browsers are you seeing the problem on?
Firefox and Chrome
Logs
@nichwall commented on GitHub (Jul 13, 2024):
Can you try doing a filter on the libraryItems table to make sure that
C:doesn't show up anywhere in the database? The paths should all be in those tables you already identified (except forpodcastsandpodcastEpisodesif applicable).You can use something like https://sqlitebrowser.org/ to filter on all columns in a table. It also supports find-and-replace for strings (the find and replace will be less useful with duplicate database entries because of additional information in
libraryFilescolumn, but filtering will help you find the ones that still need to be edited).Make sure your server is not running before you start editing the database (and make a backup in case you accidentally edit something wrong during cleanup)
@kyleviloria commented on GitHub (Jul 13, 2024):
Confirmed
C:doesn't show up in the database with DB Browser for SQLite (which I used to do the path replacements too via find-and-replace). Filtered libraryItems via theFilter in any columnsearch field in theBrowse Datatab.@advplyr commented on GitHub (Jul 14, 2024):
If I'm understanding this correctly the only way it could happen is if the paths in the
audioFilescolumn of thebookstable was not updated.This column is a JSON column that is an array of AudioFile objects. I'm not sure if you can search inside JSON objects in DB Browser. That may be why you are not finding it.
@nichwall commented on GitHub (Jul 14, 2024):
DB Browser does search through the entire string. Not sure if it's something being cached in the Windows Tray app?
@advplyr commented on GitHub (Jul 14, 2024):
I'm not aware of any caching. The data in the tracks list comes specifically from the
audioFilescolumn of thebookstable.I saw they mentioned updating the
libraryFilescolumn but not the other tables@nichwall commented on GitHub (Jul 14, 2024):
Oh, thanks. I misread your message.
@kyleviloria commented on GitHub (Jul 14, 2024):
This was the issue; simple fix! I'd only replaced the paths in the
libraryItemstable, not in thebookstable. 😑Using DB Browser's
Replace text in cellsfunction, I was able to replace any instance ofC:/...with the new paths, and all books play as expected.Thank you both for your help!