Opened 14 years ago

Closed 14 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: briand <turbo@…> Owned by: Isaac Richards
Priority: minor Milestone: unknown
Component: mythmusic Version: head
Severity: low Keywords:
Cc: Ticket locked: no


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.

Change History (1)

comment:1 Changed 14 years ago by paulh

Resolution: worksforme
Status: newclosed

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.

Note: See TracTickets for help on using tickets.