Bug 12121 - Ratings lost when upgrading 7.5 -> 7.6
: Ratings lost when upgrading 7.5 -> 7.6
Status: CLOSED WORKSFORME
Product: Logitech Media Server
Classification: Unclassified
Component: Scanner
: 7.4.0
: PC Other
: P2 normal with 1 vote (vote)
: 7.6.0
Assigned To: Erland Isaksson
http://forums.slimdevices.com/showthr...
: SQLite
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2009-05-20 21:22 UTC by Erland Isaksson
Modified: 2011-08-14 21:08 UTC (History)
3 users (show)

See Also:
Category: ---


Attachments
scanner.log (301.27 KB, text/x-log)
2009-05-20 21:22 UTC, Erland Isaksson
Details
server.log (10.93 KB, text/x-log)
2009-05-20 21:23 UTC, Erland Isaksson
Details
tracks_persistent.json before the upgrade (17.34 KB, application/octet-stream)
2009-05-20 21:23 UTC, Erland Isaksson
Details
squeezecenter-persistent.db (80.00 KB, application/octet-stream)
2009-05-20 21:24 UTC, Erland Isaksson
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Erland Isaksson 2009-05-20 21:22:36 UTC
Created attachment 5244 [details]
scanner.log

My ratings were lost when I upgraded to the noweb-sqlite branch.

See the following thread for detailed discussion and investigation together with Andy:
http://forums.slimdevices.com/showthread.php?t=63397

To sum it up:
1. The installation I had before I upgraded created a tracks_persistent.json file which contains the old ratings
2. When upgrading it first scans the library and the relevant tracks are found and scanned correctly, it then reads the tracks_persistent.json file
3. The read ratings aren't stored in the tracks_persistent table of the squeezecenter-persistent.db file for some reason

The result is that after the upgrade I have 1 rated track while I in the tracks_persistent.json and also before the upgrade had 92 rated tracks.

I tried added some debug messages in the code with the result described in this thread:
http://forums.slimdevices.com/showpost.php?p=424815&postcount=9

I'm not sure if it's related (I think it isn't) but I start SqueezeCenter with the script mentioned in this post:
http://forums.slimdevices.com/showpost.php?p=424759&postcount=3
(The start arguments points to directories that contains the latest contents from the SqueezeCenter instance before the upgrade)
Comment 1 Erland Isaksson 2009-05-20 21:23:08 UTC
Created attachment 5245 [details]
server.log
Comment 2 Erland Isaksson 2009-05-20 21:23:40 UTC
Created attachment 5246 [details]
tracks_persistent.json before the upgrade
Comment 3 Erland Isaksson 2009-05-20 21:24:40 UTC
Created attachment 5247 [details]
squeezecenter-persistent.db
Comment 4 Erland Isaksson 2009-05-20 21:41:29 UTC
I should probably have mentioned that the log files and other files attached is from svn version 26700
Comment 5 Andy Grundman 2011-01-12 12:08:33 UTC
SQLite bugs need to go back to 7.6 target.
Comment 6 Andy Grundman 2011-01-12 12:15:03 UTC
We need to test this with 7.5.3 -> 7.6.
Comment 7 Mickey Gee 2011-05-26 09:20:07 UTC
Hey Erland, can you retry on latest?
Comment 8 Erland Isaksson 2011-05-29 22:14:17 UTC
I've tried this with latest 7.6 onebrowser and as far as I can see it now works correctly, I upgraded from 7.5.4.

So I think it's safe to close this bug report.
Comment 9 Jim McAtee 2011-08-14 16:57:21 UTC
Erland, please close this bug if it's been fixed.