Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#84 Error due to special characters in file names

closed-fixed
None
5
2014-07-11
2011-09-02
Michael
No

Hi,
while preparing the playlists the following error occurs:

[2011/09/02 18:34:14] sql.c:88: error: prepare failed: near "s": syntax error
SELECT ID from DETAILS where PATH = '/export/Multimedia/Share/Musik/Ralfs Sammlungen/Favoriten/Little River Band - It's A Long Way There.mp3'
[2011/09/02 18:34:14] playlist.c:162: debug: 457: checking database for Little River Band - It's A Long Way There.mp3

Special characters like a single quote in the file name will need to be escaped in the sql. A single quote needs to be replaced by two single quotes, at least for Oracle, I have never used sqlite. I do not know which other characters might be affected.
Best regards,
Michael

Discussion

  • Justin Maggard
    Justin Maggard
    2011-09-04

    Thanks for catching that. It's fixed now in CVS.

     
  • Justin Maggard
    Justin Maggard
    2011-09-04

    • assigned_to: nobody --> jmaggard
    • status: open --> closed-fixed