FireFly Media Server › Firefly Media Server Forums › Firefly Media Server › General Discussion › Can I Update Database Information?
- This topic has 12 replies, 4 voices, and was last updated 15 years, 9 months ago by EVILRipper.
-
AuthorPosts
-
22/02/2009 at 3:55 AM #2735AnonymousInactive
Is it possible to update the song meta data in the database. For example can I change the genre of a song after it has already been indexed?
22/02/2009 at 5:26 AM #17975rsl360ParticipantShort answer? Yes. One way is with an add-on to firefox called sqlite manager. But is this really what you want to do? A full scan might wipe out the changes you have made, and deleting the database, (often done to solve problems), and doing a rescan certainly will. Maybe you really want to change the metadata in the music directly?
Robbie
22/02/2009 at 7:17 AM #17976stretchParticipantIf you’ve updated metadata in the music files and then want to update the db you need to run a full scan.
22/02/2009 at 2:11 PM #17977AnonymousInactive@rsl360 wrote:
Short answer? Yes. One way is with an add-on to firefox called sqlite manager. But is this really what you want to do? A full scan might wipe out the changes you have made, and deleting the database, (often done to solve problems), and doing a rescan certainly will. Maybe you really want to change the metadata in the music directly?
Robbie
This is what I originally wanted to do but I couldn’t figure out how to do it. I normally edit the the metadata for the music in my music player but I am not able to edit the files from the Firefly share. Any suggestions on how to do it?
22/02/2009 at 8:18 PM #17978stretchParticipantUse a tag editor and access the files directly or use your music player & access the files directly
12/03/2009 at 10:14 PM #17979AnonymousInactiveOK, I got a tag editor and updated a file. Then I went in and had Firefly scan the database but it doesn’t pick up the change. How can I make the database see the change?
13/03/2009 at 6:00 AM #17980rsl360Participant@Paul41 wrote:
OK, I got a tag editor and updated a file. Then I went in and had Firefly scan the database but it doesn’t pick up the change. How can I make the database see the change?
I’m not sure, but I think you may need to shut down firefly, delete the database and restart it. This will cause the database to be rebuild from scratch. I’m not sure if firefly read all the data on every scan. I think it might just look for new files, and/or maybe one that have been entirely deleted. On my computer, the database is located: /usr/local/var/cache/mt-daapd/songs3.db. It might not be in that exact path on your system, but it should be similar. Or just do a search for songs3.db. (or songs.db, if are using an earlier version.)
Robbie
13/03/2009 at 6:53 AM #17981stretchParticipantNo, you just need to do a “Full Scan”.
Scan = find & add new stuff
Full Scan = database rebuild13/03/2009 at 8:14 AM #17982EVILRipperParticipantEven more technical:
IIRC, a rescan looks at a file’s ctime. (Creation time) If this has not been modified, the file is ignored.
A Full rescan looks at a file’s mtime. (Modification time) So it only looks at the file if it was modified.Please do correct me if I’m wrong. 🙂
13/03/2009 at 9:37 AM #17983AnonymousInactiveI tried a full scan and deleting the database and the change still isn’t showing up, but when I view the id3 tag it is there. Any suggestions?
-
AuthorPosts
- The forum ‘General Discussion’ is closed to new topics and replies.