Version: (using KDE KDE 3.4.2) Installed from: Compiled From Sources Compiler: gcc 4.0.3 OS: Linux I backed up my postgresql amarok database via pg_dump. I installed amarok 1.4.2 and encountered the database problems others are experiencing. I removed 1.4.2 and reinstalled 1.4.1. I dropped the database and created a new one giving all privileges to the user that amarok logs in with. I imported the saved 1.4.1 database back into the new db. I browse the data in the Statistics table and see that there are some 3k records. I close my postgresql session. I fire up amarok and play a track that according to the Statistics table i have played 20 times. Amarok tells me it has never been played before. I stop the track and close amarok. Looking at the table i see that it now has a playcount of 1. While i see why Amarok would write out the playcount and playdate info on exiting, why is Amarok not reading in the Statistics table of a new database?
Also, note i have seen the same behavior with mysql. I am running postgresql 8.1.4 Thanks all
I had the same problem and managed to get all my statistics back by doing update statistics set deviceid='-1' where deviceid!='-1'; After restoring the amarok database. I don't know why this works and I don't know what the deviceid column is used for. But perhaps a developer reading this can explain?
Can't find the duplicate, but we know of this problem. CLosing.