Philip Meyer;343196 Wrote: > >Thanks, it will be fixed in next release.[color=blue] > I found another problem though. I tried to purge old statistic data > but got the following (line occurs twice in log): > > [08:47:52.4149] Plugins::TrackStat::Storage::refreshTracks (1231) > Database error: Illegal mix of collations (utf8_general_ci,IMPLICIT) > and (utf8_unicode_ci,IMPLICIT) for operation '=' > http://bugs.slimdevices.com/show_bug.cgi?id=9423
The solution is to either run the SQL mentioned in the bug report or to completely delete the MySQL database by deleting the Cache/MySQL directory (assuming you are using the bundled MySQL instance and haven't connected SqueezeCenter towards your own MySQL database). Philip Meyer;343202 Wrote: > Hmmm, thought I'd try clearing all statistics and then restoring them. > > However, after I hit "Remove All Data", I waited a couple of minutes > and then checked library statistics - I still had trackstat statistics. > I didn't see anything in the log (no errors or success message). > > Perhaps my library statistics menu is looking at the wrong table? I'm not sure how well the "Remove All Data" works in 7.2 because SqueezeCenter is able to remember statistics after rescans in 7.2 (and 7.1 I think), so even if you clear the TrackStat data it will use the persistent data in SqueezeCenter after next refresh operation. I need to check exactly how much I implemented regarding this, I had some idea to remove the SqueezeCenter data from TrackStat but I'm not sure if I ever implemented that. I'll check this when I get back home from work tonight. Philip Meyer;343205 Wrote: > My track_history table is empty - all stats are in track_statistics > table. > > I can see old (invalid url's) and new (fixed url's) stats rows in that > table. > > Is that correct - track_history is a redundant table? > track_history should contain data if you have restored a backup, but I think it might be handled in some other function in Storage.pm. The restore is handled in Backup/File.pm, so if you look in that you can probably find the corresponding function to saveTrack that writes to the history. track_statistics: Contains current statistic information track_history: Contains historical statistic information, basically a history of each time a track was played. track_history is used for some of the "... recently played" statistics items shown in TrackStat interface. -- 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 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=52937 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/plugins
