Re: [trinity-devel] Amarok: [CollectionDB] [ERROR!] spew upon startup

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;