andyg;423371 Wrote: > > You may want to take a look at what I did for the tracks_persistent > table. In 7.3.3 it exports a JSON file of all the data and this is > imported back into SQLite the first time you run 7.4. > Is this only available in 7.3.3 and not in 7.4 trunk ?
The reason I'm asking is because I did as follows on my development machine and all my ratings were lost. 1. Used latest 7.4 trunk svn version and performed a rescan and ratings are shown in the web interface in Song Info page. 2. Shutdown the 7.4 trunk version 3. Checked out latest 7.4 noweb-sqlite branch and started it pointing to the same cache directory as used in step 1. The result is that I don't have any ratings and when I open the squeezecenter-persistent.db file with sqlite command line client it only have a single entry with rating>0 in the tracks_persistent table. The old MySQL database had 92 entries in tracks_persistenet with rating>0. The single file that has a rating in SQLite is a WMA file which I think might have the rating stored as a tag. Where is the JSON file supposed to be stored ? When is it stored ? I get a lot of strange DB migration and scanning errors when I start the noweb-sqlite branch the first time, so I suppose it could be related to those. The server.log is attached. I'll register a number of bug reports if you like me to, but I felt it was worth posting here first if the upgrade procedure I used isn't supported. I'm using svn on Ubuntu 8.04.1 JeOS running inside a virtualbox virtual machine. +-------------------------------------------------------------------+ |Filename: server.log | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=7416| +-------------------------------------------------------------------+ -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) 'My download page' (http://erland.isaksson.info/download) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher and Database Query plugins' (http://wiki.erland.isaksson.info/index.php/Category:SlimServer)) ------------------------------------------------------------------------ erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=63397 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
