Anybody else notice the following output spew when starting Amarok?
I traced the introduction of the bug to the first few days of Sept.
2013.
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index url_tag already exists
amarok: [CollectionDB] [ERROR!] on query: CREATE UNIQUE INDEX
url_tag ON tags( url, deviceid );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index album_tag already exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX album_tag ON
tags( album );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index artist_tag already exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX artist_tag
ON tags( artist );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index composer_tag already exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX composer_tag
ON tags( composer );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index genre_tag already exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX genre_tag ON
tags( genre );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index year_tag already exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX year_tag ON
tags( year );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index sampler_tag already exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX sampler_tag
ON tags( sampler );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index images_album already exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX images_album
ON images( album );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index images_artist already exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX
images_artist ON images( artist );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index images_url already exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX images_url
ON images( path, deviceid );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index embed_url already exists
amarok: [CollectionDB] [ERROR!] on query: CREATE UNIQUE INDEX
embed_url ON embed( url, deviceid );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index embed_hash already exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX embed_hash
ON embed( hash );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index directories_dir already exists
amarok: [CollectionDB] [ERROR!] on query: CREATE UNIQUE INDEX
directories_dir ON directories( dir, deviceid );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index uniqueid_uniqueid already
exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX
uniqueid_uniqueid ON uniqueid( uniqueid );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index uniqueid_url already exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX uniqueid_url
ON uniqueid( url, deviceid );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index album_idx already exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX album_idx ON
album( name );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index artist_idx already exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX artist_idx
ON artist( name );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index composer_idx already exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX composer_idx
ON composer( name );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index genre_idx already exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX genre_idx ON
genre( name );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index year_idx already exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX year_idx ON
year( name );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index tags_artist_index already
exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX
tags_artist_index ON tags( artist );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index tags_album_index already
exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX
tags_album_index ON tags( album );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index tags_deviceid_index already
exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX
tags_deviceid_index ON tags( deviceid );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index tags_url_index already exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX
tags_url_index ON tags( url );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index embed_deviceid_index already
exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX
embed_deviceid_index ON embed( deviceid );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index embed_url_index already exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX
embed_url_index ON embed( url );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index related_artists_artist
already exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX
related_artists_artist ON related_artists( artist );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index lyrics_url already exists
amarok: [CollectionDB] [ERROR!] on query: CREATE UNIQUE INDEX
lyrics_url ON lyrics( url, deviceid );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index lyrics_uniqueid already exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX
lyrics_uniqueid ON lyrics( uniqueid );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index playlist_playlists already
exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX
playlist_playlists ON playlists( playlist );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index url_playlists already exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX
url_playlists ON playlists( url );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index labels_name already exists
amarok: [CollectionDB] [ERROR!] on query: CREATE UNIQUE INDEX
labels_name ON labels( name, type );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index tags_labels_uniqueid already
exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX
tags_labels_uniqueid ON tags_labels( uniqueid );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index tags_labels_url already exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX
tags_labels_url ON tags_labels( url, deviceid );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index tags_labels_labelid already
exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX
tags_labels_labelid ON tags_labels( labelid );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index url_stats already exists
amarok: [CollectionDB] [ERROR!] on query: CREATE UNIQUE INDEX
url_stats ON statistics( deviceid, url );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index percentage_stats already
exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX
percentage_stats ON statistics( percentage );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index rating_stats already exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX rating_stats
ON statistics( rating );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index playcounter_stats already
exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX
playcounter_stats ON statistics( playcounter );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index uniqueid_stats already exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX
uniqueid_stats ON statistics( uniqueid );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index url_podchannel already exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX
url_podchannel ON podcastchannels( url );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index url_podepisode already exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX
url_podepisode ON podcastepisodes( url );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index localurl_podepisode already
exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX
localurl_podepisode ON podcastepisodes( localurl );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] index url_podfolder already exists
amarok: [CollectionDB] [ERROR!] on query: CREATE INDEX
url_podfolder ON podcastfolders( id );
amarok: [CollectionDB] [ERROR!] [virtual TQStringList
SqliteConnection::query(const TQString&, bool)] sqlite3_compile
error:
amarok: [CollectionDB] [ERROR!] no such table: magnatune_albums
amarok: [CollectionDB] [ERROR!] on query: SELECT DISTINCT genre
FROM magnatune_albums ORDER BY genre;
Darrell