>Solution 1 (If you have access to the mysql db using a database tool) >===================================================================== >1. Take a backup of the TrackStat data unless you don't have a backup >2. Connect with a database tool and run: >alter table track_statistics convert to character set utf8 collate >utf8_unicode_ci; >alter table track_history convert to character set utf8 collate >utf8_unicode_ci; >3. Try again if TrackStat works > I tried this - got the same errors.
>Solution 2 (If you have access to the mysql db using a database tool >but solution 1 didn't work) >===================================================================== >1. Take a backup of the TrackStat data unless you don't have a backup >2. Connect with a database tool and run: >drop table track_statistics; >drop table track_history; >3. Restart slimserver >4. Restore the TrackStat backup >5. Try again if TrackStat works > I dropped the tables and restarted - I can still see errors at startup. The log contains: 2006-10-16 23:15:42.8736 TrackStat::Storage: Create database table 2006-10-16 23:15:42.8742 TrackStat::Storage: Executing SQL file P:\Music\SlimServer\trunk\server\Plugins\TrackStat\SQL\mysql\dbcreate.sql 2006-10-16 23:15:42.9211 TrackStat::Storage: Executing SQL statement: [CREATE TABLE track_statistics (url varchar(255) NOT NULL,musicbrainz_id varchar(40),playCount int(10) unsigned,added int(10) unsigned,lastPlayed int(10) unsigned,ratingint(10) unsigned) TYPE=InnoDB;] 2006-10-16 23:15:42.9365 TrackStat::Storage: Executing SQL statement: [CREATE TABLE track_history (id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE,url varchar(255) NOT NULL,musicbrainz_id varchar(40),played int(10) unsigned,rating int(10) unsigned) TYPE=InnoDB;] 2006-10-16 23:15:42.9409 TrackStat::Storage: Checking if track_history databasetable exists 2006-10-16 23:15:42.9448 TrackStat::Storage: Checking charsets on tables 2006-10-16 23:15:42.9540 TrackStat::Storage: Got tracks charset = utf8 and collate = utf8_unicode_ci 2006-10-16 23:15:42.9551 TrackStat::Storage: Got track_statistics charset = latin1 and collate = 2006-10-16 23:15:42.9553 TrackStat::Storage: Converting track_statistics to correct charset=utf8 collate=utf8_unicode_ci 2006-10-16 23:15:42.9820 TrackStat::Storage: Got track_history charset = latin1and collate = 2006-10-16 23:15:42.9822 TrackStat::Storage: Converting track_history to correct charset=utf8 collate=utf8_unicode_ci 2006-10-16 23:15:43.9912 TrackStat::Storage: Checking if indexes is needed for track_statistics 2006-10-16 23:15:43.9928 TrackStat::Storage: No urlIndex index found in track_statistics, creating index... 2006-10-16 23:15:43.0014 TrackStat::Storage: No musicbrainzIndex index found intrack_statistics, creating index... 2006-10-16 23:15:43.0115 TrackStat::Storage: Checking if indexes is needed for track_history 2006-10-16 23:15:43.0133 TrackStat::Storage: No urlIndex index found in track_history, creating index... 2006-10-16 23:15:43.0238 TrackStat::Storage: No musicbrainzIndex index found in track_history, creating index... 2006-10-16 23:15:43.0458 TrackStat::Storage: Checking if additional indexes are needed for tracks 2006-10-16 23:15:43.0781 TrackStat::Storage: Starting to analyze indexes 2006-10-16 23:15:43.1123 TrackStat::Storage: Finished analyzing indexes : It took 0.06658 seconds 2006-10-16 23:15:43.1126 TrackStat::Storage: Starting to update urls in statistic data based on musicbrainz ids 2006-10-16 23:15:43.1149 Database error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' Should there be something in the CREATE TABLE statements to force the correct character encodings? If I look at the table properties for the track_history table after it is created, it has charset=utf8, collation=utf8_unicode_ci. All char/varchar column properties seem to have the same charset and collation. I checked the albums and tracks tables, and they have the same settings. Phil _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/plugins
