openlp-core team mailing list archive
-
openlp-core team
-
Mailing list archive
-
Message #31933
[Bug 1689131] Re: Store media_file with relative path
phill is busy with a change that will fix this bug.
** Changed in: openlp
Assignee: (unassigned) => Phill (phill-ridout)
--
You received this bug notification because you are a member of OpenLP
Core, which is subscribed to OpenLP.
https://bugs.launchpad.net/bugs/1689131
Title:
Store media_file with relative path
Status in OpenLP:
New
Bug description:
The path stored on table "media_files", in songs.sqlite is the full
path. Is there a way to change this to save the relative path
independent of OS (unix vs Windows), based on data path?
All my database is on Windows (with a lot of linked audios), I
installed OpenLP in a linux machine and just copy & paste the songs
and themes folders. But the linked audios don't play (because of the
'old' path). So, I had to update the instances of "media_files" with
SQL commands, like these:
UPDATE media_files SET file_name = REPLACE(file_name, '\', '/');
UPDATE media_files SET file_name = REPLACE(file_name, 'C:/Users/Alberto/AppData/Roaming/openlp/data/songs/audio', '/home/alberto/.local/openlp/songs/audio');
Old OpenLP machine: Windows 7
New OpenLP machine: Ubuntu 16.04
OpenLP version: 2.4.6 (both)
To manage notifications about this bug go to:
https://bugs.launchpad.net/openlp/+bug/1689131/+subscriptions
References