#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
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks