Hi, after updating 7.2-trunk today i see the same error messages on startup but with swapped collations:
Code: -------------------- [08-08-16 11:34:38.8842] Plugins::TrackStat::Storage::refreshTracks (1196) Database error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' [08-08-16 11:34:40.0423] Plugins::TrackStat::Storage::refreshTracks (1334) Database error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' -------------------- I haven't noticed any schema related updates to the 7.2 branch and neither updated any plugins, so i'm wondering what triggered this. any clues? Nearly forgot: On the first startup i got this: Code: -------------------- [08-08-16 11:11:14.4470] Plugins::TrackStat::Storage::init (281) Converting track_statistics to correct charset=utf8 collate= [08-08-16 11:11:15.6425] Plugins::TrackStat::Storage::init (308) Converting track_history to correct charset=utf8 collate= [08-08-16 11:11:22.3475] Plugins::TrackStat::Storage::refreshTracks (1196) Database error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' [08-08-16 11:11:23.6682] Plugins::TrackStat::Storage::refreshTracks (1334) Database error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' [08-08-16 11:11:31.7595] Slim::Schema::Storage::throw_exception (70) Error: Error executing 'SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.n amesearch, contributor.musicbrainz_id FROM contributor_track me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ?, ? ) ) AND ( me.track = ? ) ) ) GROUP BY co ntributor.id ORDER BY role desc': Lost connection to MySQL server during query [08-08-16 11:11:31.7603] Slim::Schema::Storage::throw_exception (70) Backtrace: -------------------- ..any many more backtraces. Now I'll only see those two lines... OTOH this thread contains much informations i can try this weekend... thanks! kind regards, Markus +-------------------------------------------------------------------+ |Filename: log.txt | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=5646| +-------------------------------------------------------------------+ -- schiegl ------------------------------------------------------------------------ schiegl's Profile: http://forums.slimdevices.com/member.php?userid=6654 View this thread: http://forums.slimdevices.com/showthread.php?t=28653 _______________________________________________ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins