This forum has been archived. All content is frozen. Please use KDE Discuss instead.

sqlite collection.db - nothing inserted into devices

Tags: None
(comma "," separated)
boelter
Registered Member
Posts
2
Karma
0
Hello,

I am attempting to move my old collection to a new installation. I was following instructions here:

http://amarok.kde.org/forum/index.php/topic,14756.msg20763.html#msg20763

but there doesn't seem to be anything inserted into the "devices" table in my new collection.db file, it just goes on to create various indexes. Is this normal? Is there something that I can do that will trigger amarok to add to the devices table? Or perhaps it is resulting from my environment. I am running amarok 1.4.9.1 in KDE4 via the OpenSuSE 11.0 BETA.

Thank you.

Code: Select all
...
CREATE TABLE podcastfolders (id INTEGER PRIMARY KEY , name VARCHAR(255),parent INTEGER, isOpen BOOL );
CREATE TABLE statistics (url VARCHAR(1024),deviceid INTEGER,createdate INTEGER,accessdate INTEGER,percentage FLOAT,rating INTEGER DEFAULT 0,playcounter INTEGER,uniqueid VARCHAR(32) UNIQUE,deleted BOOL DEFAULT 0,PRIMARY KEY(url, deviceid) );
CREATE TABLE devices (id INTEGER PRIMARY KEY ,type VARCHAR(255),label VARCHAR(255),lastmountpoint VARCHAR(255),uuid VARCHAR(255),servername VARCHAR(255),sharename VARCHAR(255));
CREATE INDEX album_idx ON album( name );
CREATE INDEX artist_idx ON artist( name );
CREATE INDEX composer_idx ON composer( name );
...
boelter
Registered Member
Posts
2
Karma
0
I can now confirm that this is a consequence of running in KDE4. Using the same collection in KDE3 worked immediately.


Bookmarks



Who is online

Registered users: Bing [Bot], Google [Bot], kde-naveen, Sogou [Bot]