>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). > I tried running the SQL to change collation, and still got the issue reported (twice). After pressing the "delete unused statistic" button and seeing the error log lines, the web UI seems to hang - would it actually work and complete the purge anyway (left it half an hour and then killed it but maybe I should be patient?).
I hunted around for other tables that had differing collations, and updated those (track_history and another table I think), but still got the issue reported twice. I notice that all of the text columns in the track table have utf8_unicode_ci collation - is that the problem? I don't use the bundled MySQL instance - I use my own MySQL instance. I have a script that I use to create the database: -- http://wiki.slimdevices.com/index.cgi?MySQL drop database squeezecenter; create database squeezecenter character set utf8; grant all on squeezecenter.* to <username> identified by '<password>'; flush privileges; I haven't needed to recreate my DB in some time - perhaps I should trash it and start again? >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. > Okay, I checked again and I do have valid data all three tables (track_history, track_statistics, track_persistent). I'm not sure why there are three tables with data in - I assume one of either track_statistics or track_persistent isn't needed any more? Phil _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/plugins
