Since upgrading to Amarok 1.4.1 beta1 (SUSE 10.0, XINE), I find that the "scores" part of the database isn't being updated when I play a track.  Not automatically, and not manually.  It's getting a little frustrating that the "never played" playlist keeps playing the same tracks!

I'm using the MySQL database option.

Now upgraded to 1.4.1, and I still have the same problem.

For example, I have an unplayed track.  I open the "edit track information" dialogue, and the score is blank.  I put a number in the blank box, save and close.

If I now open "edit track information" again, the score is still blank 

This means that all my 2,752 unplayed tracks are forever being shown as unplayed 

Perhaps I have the same problem.
I wrote a topic in the german part of this forum:

http://amarok.kde.org/forum/index.php/t ... 640.0.html

As an experiment, I switched to SQLite (in case it was a mySQL problem).  No difference - the scores are still not changing.

A further experiment... I tried using Ratings instead of Scores, and they behave slightly differently but are also broken.

I can set a Rating within the playlist window, either using Edit Track Information or directly clicking in the Rating column.  The Rating information displays correctly in the Rating column and the Statistics tab.

However, if I clear the playlist and then reload it, the Rating information has vanished.

(I hope my English is understandable.)

As I already wrote in my german article (http://amarok.kde.org/forum/index.php/t ... 640.0.html), there seems to be a missing field rating in the table statistics.
I added the field by hand (with datatype float). And now the problem seems repaired.
However I cannot guarantee that this method does not have unwanted side effects. I hope that someone can confirm that.

In understand what you mean, but unfortunately I know nothing about mySQL so I don't know how to do what you describe - unless you can spell it out for me?  I'm not sure that I want to learn mySQL just to get my favourite music player to work correctly 

Your English is fine, by the way - better than many native-speakers 

:)

It seems the cause of the problem are missing rights of the mySQL-user for the amarok-database.
The description in the HowTo changed in the last months. First the description says:

Code: Select all

GRANT select, insert, update, delete, create, drop, create temporary tables, index ON amarokdb.* TO amarok@localhost IDENTIFIED BY 'PASSWORD_CHANGE_ME';

(that's the way I created my database)
but now:

Code: Select all

GRANT ALL ON amarokdb.* TO ...

These are the commands that should work:

Code: Select all

$ mysql -u root -p
Enter password: xxxxxx

mysql> GRANT ALL ON amarokdb.* TO amarok@localhost;
mysql> QUIT

$ mysql -u amarok -p
Enter password: xxxxxx

mysql> USE amarokdb;
mysql> ALTER TABLE statistics ADD (rating INT DEFAULT 0, KEY(rating));
mysql> QUIT


(amarokdb is the name of the database, and amarok the name of the user)

Hooray!  That's fixed it... many thanks.

And how do you fix the problem with SQLite?

I'm an almost average desktop user and have no idea (nor want to) about putting MySQL to work... I have no scores and no ratings in sidebar, nor favourite tracks, nor a clickable box to disable statistics by album... Is there a remedy with SQLite?

I am having the same problem (scores are not being retained).  I am running Amarok 1.4.3 with KDE 3.4.2 in Mandriva 2006.  I am also using MySQL, and I tried to follow the instructions by Joachim, but in my bash shell, the command "mysql" is not found (or at least it's not in the path).  I tried searching for the binary but to no avail.  I checked what I have installed, and I only have libmysql.  Do I need anything else?  Or does anyone know where that "mysql" binary is located?

Much thanks,
Bryan

Sorry, but I don't use SQLite and I have currently no idea.

@bmccorm2:
I also use Mandriva 2006. And I find the command /usr/bin/mysql in the packet MySQL-client. (Current version: 4.1.12-4.8.20060mdk)
If you want to create a MySQL-Server on your machine, you need MySQL and MySQL-common too.