[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-bugs-dist
Subject:    [Bug 136599] New: amarok pretends that collection is empty but the
From:       Martin Steigerwald <Martin () Lichtvoll ! de>
Date:       2006-10-31 22:05:56
Message-ID: 20061031230554.136599.Martin () Lichtvoll ! de
[Download RAW message or body]

------- You are receiving this mail because: -------
You are on the CC list for the bug, or are watching someone who is.
         
http://bugs.kde.org/show_bug.cgi?id=136599         
           Summary: amarok pretends that collection is empty but the sqlite
                    database seems fine
           Product: amarok
           Version: unspecified
          Platform: Debian testing
        OS/Version: Linux
            Status: NEW
          Severity: normal
          Priority: NOR
         Component: general
        AssignedTo: amarok-bugs-dist kde org
        ReportedBy: Martin Lichtvoll de


Version:           1,.4.3 (using KDE KDE 3.5.5)
Installed from:    Debian testing/unstable Packages
OS:                Linux

I have been using Amarok since quite sometime without severe problems, but \
now Amarok 1.4.3 pretends that my collection is empty, even when the sqlite \
database file seems to be fine:

martin deepdance:share/apps/amarok> sqlite3 collection.db
SQLite version 3.3.8
Enter ".help" for instructions
sqlite> .tables
admin            devices          lyrics           related_artists
album            directories      playlists        statistics
amazon           embed            podcastchannels  tags
artist           genre            podcastepisodes  uniqueid
composer         images           podcastfolders   year
sqlite>

I queried some of the tables and they contain content that looks meaningful \
to me.

The collection tab shows an empty list. I told it to show the whole \
collection and did not give a filter. The playlist is still there and the \
music files as well.

The problem occured the first time yesterday as I just wanted to start \
Amarok to hear some music. The dynamic playlist is still there, but I keep \
getting errors that albums that are referred by it are not in the \
collection anymore.

The source directory for the collection is still available and readable by \
Amarok.

I am using Debian packages of Amarok and sqlite3:

deepdance:~> dpkg -l | egrep -i "(amarok|sqlite)"
ii  amarok                  1.4.3-1                 versatile and easy to \
use audio player for KDE ii  amarok-engines          1.4.3-1                \
output engines for the Amarok audio player ii  amarok-xine             \
1.4.3-1                 xine engine for the Amarok audio player ii  \
libdspam7-drv-sqlite3   3.6.8-4                 DSPAM is a scalable and \
statistical anti-spam filter ii  libsqlite0              2.8.17-1           \
SQLite shared library ii  libsqlite0-dev          2.8.17-1                \
SQLite development files ii  libsqlite3-0            3.3.8-1                \
SQLite 3 shared library ii  libsqlite3-dev          3.3.8-1                 \
SQLite 3 development files ii  python2.3-pysqlite2     2.2.2-1              \
python interface to SQLite 3 ii  sqlite3                 3.3.8-1            \
A command line interface for SQLite 3

I moved the old collection.db out of the way and let Amarok rebuild the \
database. After that the collection is not empty anymore and all seems \
fine. Still I would like Amarok to convince to use my existing data.

Tell me, when you need any other information. The bzip2 compressed \
collection.db is about 500 KB. I can send it to a Amarok developer via \
private mail. I do not like to attach it to this bug report tough.


[prev in list] [next in list] [prev in thread] [next in thread]