strange database problem

Thu Mar 22 07:08:08 UTC 2007

I just noticed that I didn't send my reply to the mailing list, only to 
Sebastian directly.

There is a solution which is a lot simpler than what Seb wrote below:

Update to Amarok 1.4.5 (if you haven't already), make sure that your 
collection folders are set up correctly and start a full recsan of your 
collection (an incremental scan is not enough).

If an update to Amarok 1.4.5 is not possible, some additional work is 
required. Quit Amarok and connect to you database using

sqlite3 ~/.kde/share/apps/amarok/collection.db

and run the following command:

delete from tags;

Exit sqlite3 using

.quit

and start Amarok. After a full rescan of your collection and a restart of 
Amarok your statistics are back.

Max

On Wednesday 21 March 2007, Seb Ruiz wrote:
> Hi sebastian,
> Amarok stores statistics in the database with relative paths from the
> drive root. Since you moved the root (from sdb3 to sdb4 ), it's not
> going to work.
>
> You'll need to do some manual fixing of your database. Make sure you
> are not running Amarok, and make a backup of collection.db.
>
> In the 'devices' table, you will see a list of tables:
>
> seb at hammerhead:~/.kde/share/apps/amarok$ sqlite3 collection.db
> SQLite version 3.3.13
> Enter ".help" for instructions
> sqlite> select * from devices;
> 1|uuid||/|/org/freedesktop/Hal/devices/volume_uuid_aed7daa5_91f9_40c6_a859_
>dd2eaf5399c4|| sqlite>
>
> This shows that i have one device, with id 1 and hardware id
> volume_uuid_aed...... whatever
>
> You will have more than one, with at least one for the old device, and
> one for the new device.
>
> Once you have determined which is your new device, you will need to
> update all the rows in the rest of the database to match the new id.
>
> Important: I am assuming your old id is A and the new one is B.
> Replace them as relevant
>
> sqlite> UPDATE embed SET deviceid=B WHERE deviceid=A;
> sqlite> UPDATE images SET deviceid=B WHERE deviceid=A;
> sqlite> UPDATE labels SET deviceid=B WHERE deviceid=A;
> sqlite> UPDATE lyrics SET deviceid=B WHERE deviceid=A;
> sqlite> UPDATE playlists SET deviceid=B WHERE deviceid=A;
> sqlite> UPDATE statistics SET deviceid=B WHERE deviceid=A;
> sqlite> UPDATE tags SET deviceid=B WHERE deviceid=A;
> sqlite> UPDATE tags_labels SET deviceid=B WHERE deviceid=A;
> sqlite> UPDATE uniqueid SET deviceid=B WHERE deviceid=A;
>
> Now, restart Amarok and hope it works.
>
> On 22/03/07, Sebastian Leibnitz <sebastian.leibnitz at googlemail.com> wrote:
> > Hi all!
> >
> > I've got to admit, I am fairly new to the world of Linux and my problem
> > might therefore be less strange than I think.
> >
> > Basically, Amarok seems to have lost all information stored in the
> > database (score, playcount, everything...), although the file is still
> > where it was (and still seems to contain all data)
> > New changes are stored fine though.(that is, playcount is updated just
> > fine, but from scratch)
> >
> > what i did to cause the problem:
> >
> > I've recently moved my whole /home directory from one partition (formerly
> > sdb3, mounted as /home) to another (sdb4, now mounted as /home)
> >
> > sdb3 doesn't exist anymore (sdb=sdb1,sdb2,sdb4)
> >
> >
> > I copied the whole thing with
> > cp -r -p source dest
> >
> > Well, i did it piece by piece (because i couldnt move the whole thing at
> > once), resizing both partititons in between (enlarging sdb4, shrinking
> > sdb3)
> >
> > Everything worked find, except for the database in amarok problem. (that
> > is every other configuration, data just worked when i mounted sdb3 as
> > /home and rebooted)
> >
> > The database seems as if it were fresh(collection.db is 8MB large), new
> > things are added fine(and collection.db is modified when that happens).
> >
> > I then reinstated a backup of mine (i made a backup before messing with
> > my partitions).
> > So I restored /.kde/share/apps/amarok and /.kde/share/config/amarokrc to
> > their backup-state.
> >
> > It didnt help though, all it does is reset every new changes to the
> > database since the problem occured (logically), and i start with a
> > "fresh" database again.
> > I didnt get back my old scores/playcounts/etc, unfortunately.
> >
> >
> > some data from my amarokrc (sle=user)
> >
> > [Collection]
> > DatabaseEngine=0
> >
> > [Collection Browser]
> > Category1=2
> > Category2=1024
> > Category3=64
> > Database AFT Version=2
> > Database Devices Version=1
> > Database Persistent Tables Version=19
> > Database Podcast Tables Version=2
> > Database Stats Version=12
> > Database Version=35
> > FlatColumnWidths=133,131,0,131,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
> > ShowDivider=true
> > ViewMode=0
> >
> > [Collection Folders]
> > 8=./sle/music,./sle/music_temp,./sle/musictemp
> >
> >
> >
> >  conclusion
> >
> > I have none. Though i am hoping that somebody here needs only half a
> > minute to figure out what happened.
> >
> >
> > Sincerely (thanks in advance),
> > Sebastian.
> >
> > _______________________________________________
> > Amarok mailing list
> > Amarok at kde.org
> > https://mail.kde.org/mailman/listinfo/amarok
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://mail.kde.org/pipermail/amarok/attachments/20070322/873df79d/attachment.sig>