erland;145467 Wrote:
> I'm not sure if its stored to a file by default, but you should be able
> to open a command prompt window and run "slim.exe --logfile C:\log.txt"
> manually and then you will get the log in C:\log.txt
Ok, here is the log.
Started slimserver.
Opened the webpage
Opened trackstat
Selected - "top rated" - "top rated songs"
Next i switched to dynamic playlist and tried to play one of them "4-5
selected artist"
next i switched to sqlplaylist and choose to edit "4-5 selected artist"
and the pressed test (with rand())
Here is the output.
061011 22:51:51 InnoDB: Started; log sequence number 0 331678118
061011 22:51:51 [Note]
C:\PROGRA~1\SLIMSE~1\server\Bin\MSWIN3~1\mysqld.exe: ready for
connections.
Version: '5.0.22-community-nt' socket: '' port: 9092 MySQL Community
Edition (GPL)
2006-10-11 22:51:55.8281 TrackStat: initialising
2006-10-11 22:51:55.8285 TrackStat: Hook activated.
2006-10-11 22:51:55.8286 TrackStat::Storage: Checking if
track_statistics database table exists
2006-10-11 22:51:55.8306 TrackStat::Storage: Checking if track_history
database table exists
2006-10-11 22:51:55.8746 TrackStat::Storage: Checking charsets on
tables
2006-10-11 22:51:56.6562 TrackStat::Storage: Got tracks charset = utf8
2006-10-11 22:51:56.6571 TrackStat::Storage: Got track_statistics
charset = utf8
2006-10-11 22:51:56.7631 TrackStat::Storage: Got track_history charset
= utf8
2006-10-11 22:51:56.7634 TrackStat::Storage: Checking if indexes is
needed for track_statistics
2006-10-11 22:51:56.7689 TrackStat::Storage: Checking if indexes is
needed for track_history
2006-10-11 22:51:56.7972 TrackStat::Storage: Checking if additional
indexes are needed for tracks
2006-10-11 22:51:57.2969 TrackStat::Storage: Starting to analyze
indexes
2006-10-11 22:51:57.8281 TrackStat::Storage: Finished analyzing indexes
: It took 1.030966 seconds
2006-10-11 22:51:57.8283 TrackStat::Storage: Starting to update urls in
statistic data based on musicbrainz ids
2006-10-11 22:51:57.8297 Database error: Illegal mix of collations
(utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation
'='
2006-10-11 22:51:57.8299 TrackStat::Storage: Finished updating urls in
statistic data based on musicbrainz ids, updated 0 items : It took
0.001582 seconds
2006-10-11 22:51:57.8300 TrackStat::Storage: Starting to update
musicbrainz id's in statistic data based on urls
2006-10-11 22:51:57.8305 Database error: Illegal mix of collations
(utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation
'='
2006-10-11 22:51:57.8306 TrackStat::Storage: Finished updating
musicbrainz id's in statistic data based on urls, updated 0 items : It
took 0.000583 seconds
2006-10-11 22:51:57.8307 TrackStat::Storage: Starting to update ratings
in standard slimserver database based on urls
2006-10-11 22:51:57.8311 Database error: Illegal mix of collations
(utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation
'='
2006-10-11 22:51:57.8313 TrackStat::Storage: Finished updating ratings
in standard slimserver database based on urls, updated 0 items : It
took 0.000529 seconds
2006-10-11 22:51:57.8314 TrackStat::Storage: Starting to update added
times in statistic data based on urls
2006-10-11 22:51:57.8318 Database error: Illegal mix of collations
(utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation
'='
2006-10-11 22:51:57.8319 TrackStat::Storage: Finished updating added
times in statistic data based on urls, updated 0 items : It took
0.000529 seconds
2006-10-11 22:51:57.8320 TrackStat::Storage: Starting to add tracks
without added times in statistic data based on urls
2006-10-11 22:51:57.8329 Database error: Illegal mix of collations
(utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation
'='
2006-10-11 22:51:57.8331 TrackStat::Storage: Finished adding tracks
without added times in statistic data based on urls, added 0 items : It
took 0.00104 seconds
2006-10-11 22:51:57.8332 TrackStat::Storage: Starting to update ratings
in statistic data based on urls
2006-10-11 22:51:57.8336 Database error: Illegal mix of collations
(utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation
'='
2006-10-11 22:51:57.8337 TrackStat::Storage: Finished updating ratings
in statistic data based on urls, updated 0 items : It took 0.000551
seconds
2006-10-11 22:51:57.8338 TrackStat::Storage: Starting to update urls in
track_history based on musicbrainz ids
2006-10-11 22:51:57.8346 Database error: Illegal mix of collations
(utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation
'='
2006-10-11 22:51:57.8348 TrackStat::Storage: Finished updating urls in
track_history based on musicbrainz ids, updated 0 items : It took
0.000906 seconds
2006-10-11 22:51:57.8350 TrackStat::Storage: Starting to update
musicbrainz id's in track_history based on urls
2006-10-11 22:51:57.8354 Database error: Illegal mix of collations
(utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation
'='
2006-10-11 22:51:57.8355 TrackStat::Storage: Finished updating
musicbrainz id's in statistic data based on urls, updated 0 items : It
took 0.000547 seconds
2006-10-11 22:51:57.8356 TrackStat::Storage: Starting to add missing
entries to history table
2006-10-11 22:51:57.8365 Database error: Illegal mix of collations
(utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation
'='
2006-10-11 22:51:57.8366 TrackStat::Storage: Finished adding missing
entries to history table, adding 0 items : It took 0.001009 seconds
2006-10-11 22:51:57.8857 TrackStat: Added rating support for
TrackStat::Plugin
2006-10-11 22:51:57.8858 TrackStat: Added play count support for
TrackStat::Plugin
2006-10-11 22:51:57.8860 TrackStat: Checking if its time to do a
scheduled backup
2006-10-11 22:51:57.8861 TrackStat: Its 14940 seconds left until next
scheduled backup
2006-10-11 22:52:46.5586 TrackStat: Entering baseWebPage
2006-10-11 22:52:46.5588 TrackStat: Entering getTrackInfo
2006-10-11 22:52:46.5589 TrackStat: Creating new PlayerStatus for
1.1.1.2 (00:04:20:06:93:9a)
2006-10-11 22:52:46.5593 TrackStat: Exiting getTrackInfo
2006-10-11 22:52:46.5605 TrackStat: Get statistic context for level=1
2006-10-11 22:52:46.5607 TrackStat: Exiting baseWebPage
2006-10-11 22:53:01.8405 TrackStat: Entering baseWebPage
2006-10-11 22:53:01.8407 TrackStat: Entering getTrackInfo
2006-10-11 22:53:01.8410 TrackStat: Exiting getTrackInfo
2006-10-11 22:53:01.8425 TrackStat: Get statistic context for level=1
2006-10-11 22:53:01.8427 TrackStat: Get statistic context for level=2
2006-10-11 22:53:01.8429 TrackStat: Exiting baseWebPage
2006-10-11 22:53:07.3249 TrackStat: Entering baseWebPage
2006-10-11 22:53:07.3250 TrackStat: Entering getTrackInfo
2006-10-11 22:53:07.3252 TrackStat: Exiting getTrackInfo
2006-10-11 22:53:07.3262 TrackStat: Get statistic context for level=1
2006-10-11 22:53:07.3263 TrackStat: Get statistic context for level=2
2006-10-11 22:53:07.3265 TrackStat: Exiting baseWebPage
2006-10-11 22:53:07.3266 TrackStat: Calling webfunction for toprated
2006-10-11 22:53:07.3271 TrackStat::Statistics: Executing: select
tracks.id,track_statistics.playCount,track_statistics.added,track_statistics.lastPlayed,track_statistics.rating
from tracks left join track_statistics on tracks.url =
track_statistics.url where tracks.audio=1 order by
track_statistics.rating desc,track_statistics.playCount
desc,tracks.playCount desc,rand() limit 50;
2006-10-11 22:53:07.3278 Database error: Illegal mix of collations
(utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation
'='
2006-10-11 22:54:02.5003 SQLPlayList: Getting tracks for:
4-5%20selected%20aritst
2006-10-11 22:54:02.5004 SQLPlayList: Get playlist:
4-5%20selected%20aritst
2006-10-11 22:54:02.5012 SQLPlayList: Executing: select tracks.url from
tracks join contributor_track on tracks.id=contributor_track.track join
contributors on contributor_track.contributor=contributors.id join
track_statistics on tracks.url=track_statistics.url where
track_statistics.rating>=80 and tracks.audio=1 and contributors.name in
('Muse','The Music','Razorlight','Kasabian','Kashmir','Oasis','Franz
Ferdinand','Editors','Kaiser Chiefs','The
Killers','Keane','Coldplay','Athlete') order by random() limit 50;
2006-10-11 22:54:02.6669 Database error: Illegal mix of collations
(utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation
'='
2006-10-11 22:54:02.9660 TrackStat: Entering commandCallback65
2006-10-11 22:54:02.9662 TrackStat: Exiting commandCallback65
2006-10-11 22:54:20.3412 SQLPlayList: Searching for playlists in:
G:\playlist
2006-10-11 22:54:44.2727 SQLPlayList: Get playlist:
4-5%20selected%20aritst
2006-10-11 22:55:10.0127 SQLPlayList: Executing: select tracks.url from
tracks join contributor_track on tracks.id=contributor_track.track join
contributors on contributor_track.contributor=contributors.id join
track_statistics on tracks.url=track_statistics.url where
track_statistics.rating>=80 and tracks.audio=1 and contributors.name in
('Muse','The Music','Razorlight','Kasabian','Kashmir','Oasis','Franz
Ferdinand','Editors','Kaiser Chiefs','The
Killers','Keane','Coldplay','Athlete') order by rand() limit 50;
2006-10-11 22:55:10.0133 Database error: Illegal mix of collations
(utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation
'='
2006-10-11 22:55:55.8365 TrackStat: disabling
2006-10-11 22:55:55.8367 TrackStat: Hook deactivated.
061011 22:55:56 [Note]
C:\PROGRA~1\SLIMSE~1\server\Bin\MSWIN3~1\mysqld.exe: Normal shutdown
--
wiped
Squeezebox 3 - SS 6.5.1 - Core Duo T2500 - 2Gb ram - 25000 Songs - 1912
Albums (FLAC and MP3) - 324Gb Music Folder
------------------------------------------------------------------------
wiped's Profile: http://forums.slimdevices.com/member.php?userid=1542
View this thread: http://forums.slimdevices.com/showthread.php?t=20533
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/plugins
