Opened 17 years ago
Closed 17 years ago
#3075 closed defect (worksforme)
Edit metadata screen will not save metadata to database if an edited field contains a quote ( ' ) character.
Reported by: | Owned by: | Isaac Richards | |
---|---|---|---|
Priority: | minor | Milestone: | unknown |
Component: | mythmusic | Version: | head |
Severity: | low | Keywords: | |
Cc: | Ticket locked: | no |
Description
When editing metadata information in my mp3 collection, and opting to save changes to the database and the mp3 tags, I found that if the title contained a single quote ( ' ) character ("I'm Alright", "It's Still Rock and Roll To Me", "It's a Heartache", etc), none of the changed information would be saved to the music_* tables in the database.
I suspect that special characters are not escaped in the string(s) prior to building the SQL UPDATE statement, and this is causing the update(s) to fail. No error message is displayed.
Note: See
TracTickets for help on using
tickets.
This seems to have been fixed during the file scanning improvments.
I did notice that the displayed track details both on screen and on the lcd aren't updated to reflect the new metadata but the database is updated.