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

16 Feb 2014

On Fri, 07 Feb 2014 20:39:29 -0600 "Darrell Anderson" 
&lt;darrella(a)hushmail.com&gt; wrote:
...
 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; 

Nobody else sees these error messages?

Darrell