3.1 problems with linked audio

CalvaryCastlebar

Hi,

Have migrated from 2.4.6 to 3.1.2 and am having big problems with songs that had linked audio files. When I click on the song in the library I get this error popup:

Traceback (most recent call last):
File "openlp\core\lib\mediamanageritem.py", line 513, in on_selection_change
File "openlp\core\lib\mediamanageritem.py", line 528, in on_preview_click
File "openlp\core\lib\mediamanageritem.py", line 661, in build_service_item
File "openlp\plugins\songs\lib\mediaitem.py", line 638, in generate_slide_data
File "openlp\core\ui\media\mediacontroller.py", line 390, in media_length
File "pathlib.py", line 1044, in open
OSError: [Errno 22] Invalid argument: '{"parts": ["C:\", "Users", "steph", "OneDrive", "CCC", "music", "openlp", "songs", "audio", "17", "Amazing_Grace(My_Chains_Are_Gone)-_I_Listening_Demo_Eb.mp3"], "json_meta": {"class": "Path", "version": 1}}'

Perhaps something to do with the double backslash in the path?

I can do nothing with these files - error if I try to edit, add to service, or even delete!

CalvaryCastlebar

NB in the actual error message there are two backslashes after "c:"

CalvaryCastlebar

Hi,

Somehow the data in the songs database had become corrupted. As below, lots of extra backslash escape characters had been added (and also an extra " at beginning and end. I cleaned up the data in a database editor manually and all is OK now. Not sure how it happened.

"{\"parts\": [\"C:\\\", \"Users\", \"steph\", \"OneDrive\", \"CCC\", \"music\", \"openlp\", \"songs\", \"audio\", \"348\", \"Who_You_Say_I_Am_Listening_Demo_G.mp3\"], \"json_meta\": {\"class\": \"Path\", \"version\": 1}}"