Your message dated Thu, 3 Sep 2009 19:53:35 +0300
with message-id <[email protected]>
and subject line Re: problem is due to db crash
has caused the Debian Bug report #367669,
regarding Song ratings lost and unsettable after libsqlite upgrade
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
367669: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=367669
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: amarok
Version: 1.4.5-4
Severity: important
I noticed a couple of days ago that suddenly Amarok had lost the ratings for a
bunch of songs in my collection. It seemed to lose them for a rather random
selection of songs, but only by a certain artist. On Friday, May 18th, I
upgraded libsqlite3-0 3.3.16-1 -> 3.3.17-1. I'm not completely sure, but I
think that's about when I noticed the problem, and I'm guessing it's somehow
causing it. It could also have begun when Amarok was upgraded from 1.4.5-3
to 1.4.5-4.
Not only are the ratings lost, but when I rate some songs and then restart
Amarok, the ratings I just set are lost again, even though the collection.db
file shows a modified time of when I quit Amarok. But the songs that still
have their ratings do not lose them when I restart Amarok.
Also, before I realized that the ratings were being lost on every restart, I
noticed that when I would click the 4th star in the rating column, Amarok
would set it to 3.5 stars only, no matter how many times I clicked the 4th
star. If I right-clicked and edited the Rating field, I could set it to "4",
and it would then show four stars. However, on some other songs, if I
clicked the 4th star, it would rate it four stars. ??? I cannot explain
this behavior; it's very strange.
I love Amarok, and I thank the devs for their great work, but I will admit
that this is not the first time I have lost my song ratings due to an Amarok
or dependency upgrade, and it's getting a little tiresome. Maybe Amarok
should ship its own statically-linked libsqlite so upgrades could be
conclusively tested to not lose any database info.
--- System information. ---
Architecture: i386
Kernel: Linux 2.6.18-4-k7
Debian Release: testing/unstable
900 testing ftp.us.debian.org
900 testing ftp.sunet.se
800 unstable ftp.us.debian.org
800 unstable ftp.sunet.se
500 stable security.debian.org
500 edgy-cafuego ubuntu.cafuego.net
500 edgy wine.budgetdedicated.com
1 experimental ftp.us.debian.org
--- Package information. ---
Depends (Version) | Installed
======================================-+-===============
amarok-engines | 1.4.5-4
OR amarok-engine |
ruby | 1.8.2-1
unzip | 5.52-9
kdelibs4c2a (>= 4:3.5.6-1) | 4:3.5.6.r1.dfsg.1-4
libart-2.0-2 (>= 2.3.18) | 2.3.19-3
libaudio2 | 1.8-4
libc6 (>= 2.5-5) | 2.5-7
libfontconfig1 (>= 2.4.0) | 2.4.2-1.2
libfreetype6 (>= 2.2) | 2.2.1-5
libgcc1 (>= 1:4.1.2) | 1:4.2-20070516-1
libgl1-mesa-glx | 6.5.1-0.6
OR libgl1 |
libglib2.0-0 (>= 2.12.9) | 2.12.12-1
libgpod1 | 0.4.2-0.1
libice6 (>= 1:1.0.0) | 1:1.0.3-2
libidn11 (>= 0.5.18) | 0.6.5-1
libifp4 | 1.0.0.2-3
libjpeg62 | 6b-13
libkarma0 | 0.0.6-2
libmtp5 | 0.1.5-1
libmysqlclient15off (>= 5.0.27-1) | 5.0.38-1
libnjb5 | 2.2.5-4.1
libpng12-0 (>= 1.2.13-4) | 1.2.15~beta5-1
libpq5 | 8.2.4-1
libqt3-mt (>= 3:3.3.7) | 3:3.3.7-4
libruby1.8 (>= 1.8.6) | 1.8.6-1
libsdl1.2debian (>= 1.2.10-1) | 1.2.11-8
libsm6 | 1:1.0.2-2
libsqlite3-0 (>= 3.3.16) | 3.3.17-1
libstdc++6 (>= 4.1.2) | 4.2-20070516-1
libtag1c2a (>= 1.4) | 1.4-4
libtagc0 (>= 1.4) | 1.4-4
libtunepimp3 (>= 0.4.2) | 0.4.2-4.1
libusb-0.1-4 (>= 2:0.1.12) | 2:0.1.12-6
libvisual-0.4-0 (>= 0.4.0) | 0.4.0-1.1
libx11-6 | 2:1.0.3-7
libxcursor1 (>> 1.1.2) | 1.1.7-4
libxext6 | 1:1.0.1-2
libxft2 (>> 2.1.1) | 2.1.12-2
libxi6 | 1:1.0.1-4
libxinerama1 | 1:1.0.1-4.1
libxrandr2 (>= 2:1.2.0) | 2:1.2.1-1
libxrender1 | 1:0.9.1-3
libxt6 | 1:1.0.5-2
zlib1g (>= 1:1.2.1) | 1:1.2.3-13
pgp6xjVc1mq1w.pgp
Description: PGP signature
--- End Message ---
--- Begin Message ---
Version: 2.1.1-1
Hello,
I'm pretty sure this bug is fixed in Amarok 2 since it is a complete rewrite.
What is more, Amarok 2 uses another database engine and does not support
SQLite.
--
Modestas Vainius <[email protected]>
signature.asc
Description: This is a digitally signed message part.
--- End Message ---
