amaroK assigns a score of 0 to anything that I play, there is no score if I haven\'t played it yet. I was running a CVS version and then upgraded to 1.2-beta1 when the website became available again.

Andrew

i didnt understand, yet. do the songs have a score after playing them? if so, then this is normal behaviour. a not yet played track doesnt have a score, technically.

regards,
muesli

The score field is empty if they haven\'t been played, but if they have been played then the score is always zero.

I experience the same issue.
No matter how many times a track is played, it still shows as \"Never played before\". The score is always 0, which is logical. Nothing ever shows up for \"Favorite Tracks\", which also follows. And for the sake of completeness, even though it\'s pretty much obvious, under smart playlists, nothing lists for favorites, most played, etc.

1.2-beta1 with internal sqlite, compiled from source on a somewhat updated Slackware 10 system. I built from CVS earlier today, same symptoms. I rebuilt the 1.2-beta1 with external MySQL, same symptoms still.

I don\'t have a clue what\'s missing or wrong on my side. The database thing was the only guess I had, so when that failed to resolve it, I was pretty much lost.

Any other information you\'d like, just let me know. Versions of dependencies or build tools is the only thing I could think of to provide at this point, but I\'m not going to spew that out unless it\'s actually usefull...

Very curious, at any rate.

Okay, I got this fixed, but I only have a conjecture as to what resolved it.

I tried mv\'ing some of the .kde/share/apps/amarok/* files, but same symptoms, so I logged in as a spare user, and it actually worked correctly there. I tried mv\'ing the .kde/share/config/amarokrc, but that left me with the same symptoms, so I mv\'ed the .kde/share/apps/amarok/ directory to amarok.old. When I loaded up amaroK right after that, it worked perfectly.

Curiously, I mv\'ed my the amarok.old/ directory back to amarok/ and amaroK continued to function correctly. The only thing I hadn\'t tampered with within that directory before mv\'ing it entirely was the albumcovers/ directory. Since it\'s working now, though, I can\'t test to see if just mv\'ing that would have resolved it.

At any rate, for those experiencing this issue, try mv\'ing that amarok/ directory, loading amarok, then mving it back. This doesn\'t really make too much sense to me, since moving the old files back over doesn\'t cause the symptom to reoccur, but nonetheless it seems to have resolved it.

ah, seems i know whats happening. dont be afraid this will be fixed before 1.2. (and it happens rarely, actually it should only happen for users who are updating)

close amarok, edit your amarokrc, decrease the value of \"Database Stats Version\" to 2. restart amarok, now.

regards,
muesli

im experiencing the same problem and i guess i know what the problem is.
amarok does not create the appropriate mysql table for the statistics:

amarok: MYSQL QUERY FAILED: Table \'amarok.statistics\' doesn\'t exist
amarok: FAILED QUERY: SELECT tags.title, tags.url, round( statistics.percentage + 0.4 ) FROM tags, statistics WHERE tags.artist = 484 AND statistics.url = tags.url ORDER BY statistics.percentage DESC LIMIT 0,5;

mysql> show tables;
+------------------+
| Tables_in_amarok |
+------------------+
| album |
| artist |
| directories |
| genre |
| images |
| related_artists |
| tags |
| year |
+------------------+
8 rows in set (0.00 sec)

yeah, right. after creating the table by hand with the information from collectiondb.cpp, CollectionDB::createStatsTable() the scores are calculated and displayed correctly.

Christian

That did the trick! Thanks a million!

Andrew

Had you already tried to do the \"decrease the value of \"Database Stats Version\" to 2\"?

well, this just happened to me as well with todays CVS
would someone have the structure of amarok.statistics at hand, and post a mysql dump here, please?
btw: the empty structure only, without contents, of course B)
btw2: my database version says \"3\". everything was installed nicely from scratch, but amarok.statistics is missing (speak: was not created)

hds wrote:

would someone have the structure of amarok.statistics at hand, and post a mysql dump here, please?

please its x-mas soon