Re: [Banshee-List] update music library

[Yves Alter <altery ethz ch>]

The Banshee SQLite DB is stored in ~/.config/banshee-1/banshee.db.
You'd have to execute a query on it, that replaces the URI of the
offending tracks. The URI column is stored in the 'CoreTracks' table.
The tool 'sqlitebrowser' allows you to inspect the contents of the DB
graphically. But without SQL experience it's probably hard to create a
query that suits your needs and you might want to consider changing
the values manually, if there are only a few tracks which are affected
of this problem. And make a backup of the DB file before you mess
around with it :)




2009/1/30 Paul Lange <palango gmx de>:
> Am Freitag, den 30.01.2009, 18:28 +0100 schrieb Bertrand Lorentz:
>> On Fri, 2009-01-30 at 12:20 -0500, Andrew Conkling wrote:
>> >
>> > 2009/1/30 Chow Loong Jin <hyperair gmail com>
>> >
>> >         On Fri, 2009-01-30 at 13:41 -0300, Paul Lange wrote:
>> >         > ps. I already tried to do a "library rescan" but it imports
>> >         many songs
>> >         > again (I think because I updated their metadata before there
>> >         was an
>> >         > option to write metadata into files.). So I'd like to do it
>> >         on an other
>> >         > way, if possible.
>> >
>> >         I've no idea why that happens, but to solve it, Tools->Rescan
>> >         Music
>> >
>> >          Library.
>> >
>> > I think Paul tried that, if I understand him right.
>> >
>> > Paul, what may have happened was that Banshee read some of the tracks
>> > as being in "the Library", i.e. your base folder under which all music
>> > resides. It also keeps track of "imported" music outside of that too,
>> > but wouldn't change the location if your library changed.* So I wonder
>> > if Banshee got confused and isn't treating everything as being part of
>> > the Library for some reason.
>> >
>> > Either way, probably your best bet would be to rescan the library, let
>> > it import what it will and then use the Location column (add it by
>> > right-clicking on the column headers in the track list) to find the
>> > tracks that don't have the right path. You could even create a smart
>> > playlist to look just for that path and remove them all that way. Of
>> > course, that'd reset things like the play count or the ratings, but I
>> > can't think of a better solution offhand.
>>
>> Ah, the awesome Andrew was faster than me ;)
>>
>> Another way would be to manually modify the content of the database. I'd
>> only recommend it if you know a bit of SQL and feel confortable with it
>
> I'm not comfortable with SQL at all.
> Like what would a command to replace all occurrences
> of /media/DATA/daten/Music to /media/Daten/Music?
>
> Paul
>
> _______________________________________________
> banshee-list mailing list
> banshee-list gnome org
> http://mail.gnome.org/mailman/listinfo/banshee-list
>
>