Unable to use/modify/remove a song

tcawrse

I've been having trouble with this one song. Seems to be an isolated issue I think it's because there is a broken link with an audio file I had attached to it. I was going to try and remove it and simply re-add it but I'm unable to remove it with this error. Any help is appreciated.

PaulRowell

I've seen this before, but I'm sure I just edited the song and removed the audio link. What version are you using?

tcawrse

I'm using version 3.1.5
I've tried editing the song but I get the error same box only difference between the errors in the log of which way I attempted to access the song. My current work around is just to re-add the song and adjust the title with an asterisks or something simple to distinguish the two. It's nothing I can't work around but it would be nice to find a fix.

PaulRowell

tcawrse If you send me your songs database and the song title of the song with the missing audio, I will delete the song for you.

Alternatively if you are comfortable using Sql and don't mind installing an SQL editor, I can give you instructions on how to delete the offending song...

tcawrse

I have some experience with SQL but it's been some years. But if your patient enough I'd love to give it a shot (just to see if I still know my way around the language.

PaulRowell

OK you will need something like DB Browser for SQLite ( https://sqlitebrowser.org/).

Once installed you need to open the songs database file. (Use the Tools -> Open Data Folder... menu option in OpenLP) The songs db is in the sub folder songs and named "songs.sqlite".

First you need to find the id of the song with the broken audio link in the songs table.

Then you need to find the record that corresponds to this broken audio link in the media_files table.

By deleting this record I'm hoping that will then allow you to edit the original song within OpenLP.

I'm not sure what version of OpenLP you are using but in 3.1.7 broken audio links are handled better although the message "Usupported File" is a bit confusing.