version: 1.4-beta2
engine: xine

Hello!

I\'m using Suse9.3 and apt4rpm. If I remember correctly after the update to version 1.4-beta1 amarok performed an automatic conversion of my collection. I think it crashed once or twice until it finally ran through.
Since then the playcount and the rating system is broken. Basically everthing is working fine and the old values (ratings/playcount) are still displayed. They are just not updated any more. Nothing changed after the update to beta2.

Any idea how to fix this without having to reset all my old stats?

Thanks!

These are the files in the ~/.kde/share/apps/amarok directory.

[code:1]
drwxr-xr-x 5 matthias users 120 2005-08-10 19:58 albumcovers
-rw-r--r-- 1 matthias users 5,0K 2005-06-13 16:22 backtrace
-rw-r--r-- 1 matthias users 2,2M 2006-02-19 00:19 collection-backup.db
-rw-r--r-- 1 matthias users 2,1M 2006-03-13 19:39 collection.db
-rw------- 1 matthias users 512 2005-06-27 15:18 collection.db-1e3xtkph5ozjofxwdozg-journal
-rw-r--r-- 1 matthias users 3,0K 2006-03-12 21:41 collection_scan.files
-rw-r--r-- 1 matthias users 51 2006-03-12 21:41 collection_scan.log
-rw-r--r-- 1 matthias users 59K 2006-03-13 20:11 contextbrowser.html
drwx------ 2 matthias users 768 2006-03-13 19:47 covershadow-cache
-rw-r--r-- 1 matthias users 49K 2006-03-12 23:39 current.xml
-rw-r--r-- 1 matthias users 3,5K 2006-02-19 23:32 equalizerpresets_save.xml
-rw-r--r-- 1 matthias users 144 2006-03-12 23:39 partybrowser_save.xml
-rw-r--r-- 1 matthias users 71 2005-06-28 22:35 playlistbrowser_save
-rw-r--r-- 1 matthias users 5,0K 2006-03-12 23:39 playlistbrowser_save.xml
-rw-r--r-- 1 matthias users 125 2006-03-12 23:39 podcastbrowser_save.xml
drwx------ 2 matthias users 48 2006-02-07 19:01 scripts-data
-rw-r--r-- 1 matthias users 205 2006-03-12 23:39 smartplaylistbrowser_save.xml
-rw-r--r-- 1 matthias users 0 2005-06-28 22:35 smartplaylists
-rw-r--r-- 1 matthias users 30K 2006-01-19 22:11 statusbar.log.0
-rw-r--r-- 1 matthias users 27K 2006-03-13 20:09 statusbar.log.1
-rw-r--r-- 1 matthias users 196 2006-03-12 23:39 streambrowser_save.xml
-rw-r--r-- 1 matthias users 125 2006-03-13 20:09 submit.xml
-rw-r--r-- 1 matthias users 89 2006-03-12 23:39 transferlist.xml
drwx------ 2 matthias users 672 2006-03-13 19:51 undo
-rw-r--r-- 1 matthias users 11K 2006-03-12 23:39 xine-config
[/code:1]

Post edited by: stingray, at: 2006/03/16 17:32

In all my greatness I found the solution:

In amaroK database, add to table \'statistics\' column \'rating\' of integer type.

Thanks for your reply. The \'rating\' column was indeed missing. I added the column \'rating\' with the SQLite Database Browser ( http://sqlitebrowser.sourceforge.net/ ). After that the database shows the following behavior:

- When starting a song which has the playcount 0 a new entry is generated and after that the playcount 1 is displayed correctly in Amarok.
- Starting this song or any song with playcount >= 1 creates an !extra! entry in the database with the correct new playcount. Amarok will nevertheless show the old database entry.

I\'ve created a backup of my collection, deleted it and let Amarok create a new one. It is now working, but the stats are obviously lost.