Kodi Community Forum

Full Version: File name not properly escaped in music database cleanup
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi all,

I am new to this forum, so please correct me, if this is the wrong forum or if I should open a ticket on trac directly.

I think I have encountered an issue with improper escaped filenames: When I try to cleanup the music database the cleanup process will be aborted and the following error is logged in xbmc.log:

Code:
ERROR: SQL: Undefined MySQL error: Code (1267)
Query: select count(idPath) from songpaths where SUBSTR(strPath,1,44)='/repository/music/m4a/Israel Kamakawiwoʻole/'

I guess the problem is the apostroph in the artist's name. More precise it seems to be an "turned comma" (UTF8: 0xcabb) in this case. At least it is printed in the log file as such.

I am using xbmc nightly builds on Ubuntu. Current installed version: 3:12.9.12-git201401191726~0af940a-1~ppa1~saucy.
I did a short search on the forum and found same related threads, e.g.
Clean Music Library Failure, but found no indication that there is an open ticket.

Best regards,

Sven
please create a ticket and attach a full Debug Log.
component: music database
Thanks. Ticket is here: http://trac.xbmc.org/ticket/14883