Hi,

I'm using amaroK CVS and since some days I'll get lot's of errors when playing songs:
[code:1]amarok: ERROR: [QStringList CollectionDB::query(const QString&, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: statistics
amarok: ERROR: on query: SELECT tags.title, tags.url, round( statistics.percentage + 0.4 ), artist.name, album.name FROM tags, artist, album,statistics WHERE artist.id = tags.artist AND album.id = tags.album AND statistics.url = tags.url ORDER BY statistics.percentage DESC LIMIT 0,10;[/code:1]

I already deleted collection.db without success. While doing that I recognized that the newly created db is much smaller than before (1.8MB < 30MB).
Score is always shown as "0".

Any ideas?

Many thanks in advance!

Andreas

close amarok, then edit your amarokrc, search for "Database Stats Version" and decrease the number next to it. now restart amarok, and your stats table is back again

regards,
muesli

close amarok, then edit your amarokrc, search for "Database Stats Version" and decrease the number next to it. now restart amarok, and your stats table is back again

regards,
muesli

Hi,

thanks, now it works again!

Regards,
Andreas