I want to work on a ticket that has long annoyed me. https://bugs.kde.org/show_bug.cgi?id=188074
I ran into a couple of difficulties with getting my test environment set up. First question. I have a separate user account "kde" set up for amarok development. I am on kubuntu and I use pulse audio. When I try to start the git master build of amarok as user "kde" (instead of my regular user) I get this at startup, and the main window never appears: Failed to create secure directory (/run/user/1000/pulse): Permission denied How do i resolve that? Second, I have my regular user running amarok with an external mysql database. The database it uses is "amarok3". I wanted to use a copy of that database instead of the same one. So I did "rsync /var/lib/mysql/amarok3/ /var/lib/mysql/amarok/" as root. The two directories are identical. I thought I'd test the new db by just telling my regular version of amarok to use that db. settings - configure amarok - database - database - change "amarok3" to "amarok" I would expect to be able to exit and start amarok and see the same playlists and collection. Alas, that is not the case. Instead I get a lot of errors like this on startup: The amarok database reported the following errors: GREPME MySQL-server query failed! (1054) Unknown column 'version' in 'field list' on SELECT version FROM admin WHERE component = 'DB_VERSION'; GREPME MySQL-server query failed! (1054) Unknown column 'version' in 'field list' on SELECT version FROM admin WHERE component = 'DB_VERSION'; GREPME MySQL-server query failed! (1054) Unknown column 'version' in 'field list' on SELECT version FROM admin WHERE component = 'DB_VERSION'; GREPME MySQL-server query failed! (1050) Table 'admin' already exists on CREATE TABLE admin (component VARCHAR(255), version INTEGER) COLLATE = utf8_bin ENGINE = MyISAM; GREPME MySQL-server query failed! (1050) Table 'devices' already exists on CREATE TABLE devices (id INTEGER PRIMARY KEY AUTO_INCREMENT,type VARCHAR(255),label VARCHAR(255),lastmountpoint VARCHAR(255),uuid VARCHAR(255),servername VARCHAR(80),sharename VARCHAR(240)) COLLATE = utf8_bin ENGINE = MyISAM; GREPME MySQL-server query failed! (1061) Duplicate key name 'devices_type' on CREATE INDEX devices_type ON devices( type ); GREPME MySQL-server query failed! (1061) Duplicate key name 'devices_uuid' on CREATE UNIQUE INDEX devices_uuid ON devices( uuid ); GREPME MySQL-server query failed! (1061) Duplicate key name 'devices_rshare' on CREATE INDEX devices_rshare ON devices( servername, sharename ); GREPME MySQL-server query failed! (1050) Table 'urls' already exists on CREATE TABLE urls (id INTEGER PRIMARY KEY AUTO_INCREMENT,deviceid INTEGER,rpath VARCHAR(324) NOT NULL,directory INTEGER,uniqueid VARCHAR(128) UNIQUE) COLLATE = utf8_bin ENGINE = MyISAM; My collection is empty, and i can't find any of my database playlists either. What did I do wrong? How does one copy an existing external amarok mysql database and use that instead of the original?
_______________________________________________ Amarok-devel mailing list Amarok-devel@kde.org https://mail.kde.org/mailman/listinfo/amarok-devel
