{"id":3923,"date":"2008-09-28T10:29:31","date_gmt":"2008-09-28T14:29:31","guid":{"rendered":"http:\/\/scruss.com\/blog\/?p=3923"},"modified":"2026-06-12T21:36:33","modified_gmt":"2026-06-13T01:36:33","slug":"cleaning-up-your-firefly-media-server-database","status":"publish","type":"post","link":"https:\/\/scruss.com\/blog\/2008\/09\/28\/cleaning-up-your-firefly-media-server-database\/","title":{"rendered":"cleaning up your FireFly Media Server database"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">mp3 tagging is a minefield. Like all metadata, one has to balance obsession with detail against ease of acquisition.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Some <a href=\"http:\/\/fireflymediaserver.org\/\">Firefly<\/a> clients are pickier than other about tagging. Regrettably, some of the music I get from <a href=\"http:\/\/emusic.com\/\">emusic<\/a> has bad characters in the tags, which throws the players right off. Finding the problem files is the majority of the problem &#8211; here&#8217;s a method that at least helps:<br>\n<code>wget -O- http:\/\/host:port\/rsp\/db\/1 | perl -pwe 's,&lt;(?![\/\\?]),\\n&lt;,g;' &gt; firefly.xml<br>\nxmllint --noout firefly.xml<br>\n<\/code><br>\nYou&#8217;ll likely get a few lines like:<br>\n<code><br>\nfirefly.xml:463415: parser error : PCDATA invalid Char value 65535<br>\n&lt;title&gt;\u00ef\u00bf\u00bdSinging in the Bathtub&lt;\/title&gt;<br>\n<\/code><br>\nIn this case, the song title tag has some junk characters in it that you&#8217;ll need to fix. After cleaning up the tags and rebuilding the database, try this process again to see if you&#8217;ve caught all the errors.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>mp3 tagging is a minefield. Like all metadata, one has to balance obsession with detail against ease of acquisition. Some Firefly clients are pickier than other about tagging. Regrettably, some of the music I get from emusic has bad characters in the tags, which throws the players right off. Finding the problem files is the [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[7],"tags":[1332,1371,45],"class_list":["post-3923","post","type-post","status-publish","format-standard","hentry","category-computers-suck","tag-daap","tag-firefly","tag-mp3"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pQNZZ-11h","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/scruss.com\/blog\/wp-json\/wp\/v2\/posts\/3923","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/scruss.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/scruss.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/scruss.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/scruss.com\/blog\/wp-json\/wp\/v2\/comments?post=3923"}],"version-history":[{"count":3,"href":"https:\/\/scruss.com\/blog\/wp-json\/wp\/v2\/posts\/3923\/revisions"}],"predecessor-version":[{"id":18167,"href":"https:\/\/scruss.com\/blog\/wp-json\/wp\/v2\/posts\/3923\/revisions\/18167"}],"wp:attachment":[{"href":"https:\/\/scruss.com\/blog\/wp-json\/wp\/v2\/media?parent=3923"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/scruss.com\/blog\/wp-json\/wp\/v2\/categories?post=3923"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/scruss.com\/blog\/wp-json\/wp\/v2\/tags?post=3923"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}