Public feed #528841

Something

public text v1 · immutable
Raw Edit
·published 2007-06-01 18:16 UTC
rendered paste body
2007-06-02 04:15:08.027 MSqlQuery: SELECT COUNT(*) FROM music_songs;
2007-06-02 04:15:08.030 MSqlQuery: SELECT data FROM settings WHERE value = 'MusicLocation' AND hostname = 'arnold' ;
2007-06-02 04:15:08.032 MSqlQuery: SELECT data FROM settings WHERE value = 'Ignore_ID3' AND hostname = 'arnold' ;
2007-06-02 04:15:08.035 MSqlQuery: SELECT data FROM settings WHERE value = 'TreeLevels' AND hostname = 'arnold' ;
2007-06-02 04:15:08.037 MSqlQuery: SELECT data FROM settings WHERE value = 'MusicFormatNormalFileArtist' AND hostname = 'arnold' ;
2007-06-02 04:15:08.039 MSqlQuery: SELECT data FROM settings WHERE value = 'MusicFormatNormalFileArtist' AND hostname IS NULL;
2007-06-02 04:15:08.042 MSqlQuery: SELECT data FROM settings WHERE value = 'MusicFormatNormalFileTrack' AND hostname = 'arnold' ;
2007-06-02 04:15:08.044 MSqlQuery: SELECT data FROM settings WHERE value = 'MusicFormatNormalFileTrack' AND hostname IS NULL;
2007-06-02 04:15:08.047 MSqlQuery: SELECT data FROM settings WHERE value = 'MusicFormatNormalCDArtist' AND hostname = 'arnold' ;
2007-06-02 04:15:08.049 MSqlQuery: SELECT data FROM settings WHERE value = 'MusicFormatNormalCDArtist' AND hostname IS NULL;
2007-06-02 04:15:08.051 MSqlQuery: SELECT data FROM settings WHERE value = 'MusicFormatNormalCDTrack' AND hostname = 'arnold' ;
2007-06-02 04:15:08.054 MSqlQuery: SELECT data FROM settings WHERE value = 'MusicFormatNormalCDTrack' AND hostname IS NULL;
2007-06-02 04:15:08.056 MSqlQuery: SELECT data FROM settings WHERE value = 'MusicFormatCompilationFileArtist' AND hostname = 'arnold' ;2007-06-02 04:15:08.059 MSqlQuery: SELECT data FROM settings WHERE value = 'MusicFormatCompilationFileArtist' AND hostname IS NULL;
2007-06-02 04:15:08.061 MSqlQuery: SELECT data FROM settings WHERE value = 'MusicFormatCompilationFileTrack' AND hostname = 'arnold' ;
2007-06-02 04:15:08.063 MSqlQuery: SELECT data FROM settings WHERE value = 'MusicFormatCompilationFileTrack' AND hostname IS NULL;
2007-06-02 04:15:08.066 MSqlQuery: SELECT data FROM settings WHERE value = 'MusicFormatCompilationCDArtist' AND hostname = 'arnold' ;
2007-06-02 04:15:08.068 MSqlQuery: SELECT data FROM settings WHERE value = 'MusicFormatCompilationCDArtist' AND hostname IS NULL;
2007-06-02 04:15:08.070 MSqlQuery: SELECT data FROM settings WHERE value = 'MusicFormatCompilationCDTrack' AND hostname = 'arnold' ;
2007-06-02 04:15:08.073 MSqlQuery: SELECT data FROM settings WHERE value = 'MusicFormatCompilationCDTrack' AND hostname IS NULL;
2007-06-02 04:15:08.105 MSqlQuery: SELECT data FROM settings WHERE value = 'IntelliRatingWeight' AND hostname = 'arnold' ;
2007-06-02 04:15:08.131 MSqlQuery: SELECT data FROM settings WHERE value = 'IntelliPlayCountWeight' AND hostname = 'arnold' ;
2007-06-02 04:15:08.134 MSqlQuery: SELECT data FROM settings WHERE value = 'IntelliLastPlayWeight' AND hostname = 'arnold' ;
2007-06-02 04:15:08.136 MSqlQuery: SELECT data FROM settings WHERE value = 'IntelliRandomWeight' AND hostname = 'arnold' ;
2007-06-02 04:15:08.139 MSqlQuery: SELECT data FROM settings WHERE value = 'CDDevice' AND hostname = 'arnold' ;
2007-06-02 04:15:08.142 MSqlQuery: SELECT data FROM settings WHERE value = 'PlayBoxTransparency' AND hostname = 'arnold' ;
2007-06-02 04:15:08.147 XMLParse::LoadTheme using /usr/share/mythtv/themes/blue/music-ui.xml
2007-06-02 04:15:08.476 MSqlQuery: SELECT music_songs.song_id, music_artists.artist_name, music_comp_artists.artist_name AS compilation_artist, music_albums.album_name, music_songs.name, music_genres.genre, music_songs.year, music_songs.track, music_songs.length, CONCAT_WS('/', music_directories.path, music_songs.filename) AS filename, music_songs.rating, music_songs.numplays, music_songs.lastplay, music_albums.compilation, music_songs.format FROM music_songs LEFT JOIN music_directories ON music_songs.directory_id=music_directories.directory_id LEFT JOIN music_artists ON music_songs.artist_id=music_artists.artist_id LEFT JOIN music_albums ON music_songs.album_id=music_albums.album_id LEFT JOIN music_artists AS music_comp_artists ON music_albums.artist_id=music_comp_artists.artist_id LEFT JOIN music_genres ON music_songs.genre_id=music_genres.genre_id ORDER BY music_songs.song_id;
2007-06-02 04:15:08.650 MSqlQuery: SELECT data FROM settings WHERE value = 'MusicMenuFilters' AND hostname = 'arnold' ;
2007-06-02 04:15:08.653 MSqlQuery: SELECT data FROM settings WHERE value = 'MusicMenuFilters' AND hostname IS NULL;
2007-06-02 04:15:08.655 MSqlQuery: SELECT data FROM settings WHERE value = 'AutoPlayCD' AND hostname = 'arnold' ;
2007-06-02 04:15:08.658 MSqlQuery: SELECT data FROM settings WHERE value = 'ShowWholeTree' AND hostname = 'arnold' ;
2007-06-02 04:15:08.660 MSqlQuery: SELECT data FROM settings WHERE value = 'KeyboardAccelerators' AND hostname = 'arnold' ;
2007-06-02 04:15:08.662 MSqlQuery: SELECT data FROM settings WHERE value = 'MusicShowRatings' AND hostname = 'arnold' ;
2007-06-02 04:15:08.671 MSqlQuery: SELECT data FROM settings WHERE value = 'ListAsShuffled' AND hostname = 'arnold' ;
2007-06-02 04:15:08.673 MSqlQuery: SELECT data FROM settings WHERE value = 'VisualCycleOnSongChange' AND hostname = 'arnold' ;
2007-06-02 04:15:08.676 MSqlQuery: SELECT data FROM settings WHERE value = 'VisualAlbumArtOnSongChange' AND hostname = 'arnold' ;
2007-06-02 04:15:08.678 MSqlQuery: SELECT data FROM settings WHERE value = 'VisualRandomize' AND hostname = 'arnold' ;
2007-06-02 04:15:08.681 MSqlQuery: SELECT data FROM settings WHERE value = 'MythControlsVolume' AND hostname = 'arnold' ;
2007-06-02 04:15:08.687 MSqlQuery: SELECT data FROM settings WHERE value = 'PlayMode' AND hostname = 'arnold' ;
2007-06-02 04:15:08.695 MSqlQuery: SELECT data FROM settings WHERE value = 'ResumeMode' AND hostname = 'arnold' ;
2007-06-02 04:15:08.698 MSqlQuery: SELECT data FROM settings WHERE value = 'RepeatMode' AND hostname = 'arnold' ;
2007-06-02 04:15:08.705 MSqlQuery: SELECT data FROM settings WHERE value = 'VisualMode' AND hostname = 'arnold' ;
2007-06-02 04:15:08.713 MSqlQuery: SELECT data FROM settings WHERE value = 'VisualModeDelay' AND hostname = 'arnold' ;
2007-06-02 04:15:09.154 MSqlQuery: SELECT playlist_id, playlist_name, playlist_songs FROM music_playlists WHERE playlist_name = 'default_playlist_storage' AND (hostname = '' OR hostname = 'arnold');
2007-06-02 04:15:09.170 MSqlQuery: SELECT playlist_id, playlist_name, playlist_songs FROM music_playlists WHERE playlist_name = 'backup_playlist_storage' AND (hostname = '' OR hostname = 'arnold');
2007-06-02 04:15:09.172 MSqlQuery: SELECT playlist_id FROM music_playlists WHERE playlist_name != 'default_playlist_storage' AND playlist_name != 'backup_playlist_storage'  AND (hostname = '' OR hostname = 'arnold') ORDER BY playlist_id;
2007-06-02 04:15:09.180 MSqlQuery: SELECT data FROM settings WHERE value = 'LastMusicPlaylistPush' AND hostname = 'arnold' ;
2007-06-02 04:15:09.375 MSqlQuery: SELECT data FROM settings WHERE value = 'MusicAudioDevice' AND hostname = 'arnold' ;
2007-06-02 04:15:09.378 MSqlQuery: SELECT data FROM settings WHERE value = 'AudioOutputDevice' AND hostname = 'arnold' ;
2007-06-02 04:15:09.379 Opening ALSA audio device 'plughw:0,0'.
2007-06-02 04:15:09.391 MSqlQuery: SELECT data FROM settings WHERE value = 'MixerControl' AND hostname = 'arnold' ;
2007-06-02 04:15:09.393 MSqlQuery: SELECT data FROM settings WHERE value = 'MixerDevice' AND hostname = 'arnold' ;
2007-06-02 04:15:09.397 MSqlQuery: SELECT data FROM settings WHERE value = 'MasterMixerVolume' AND hostname = 'arnold' ;
2007-06-02 04:15:09.399 MSqlQuery: SELECT data FROM settings WHERE value = 'PCMMixerVolume' AND hostname = 'arnold' ;
2007-06-02 04:15:09.402 MSqlQuery: SELECT data FROM settings WHERE value = 'AggressiveSoundcardBuffer' AND hostname = 'arnold' ;
2007-06-02 04:15:09.657 MSqlQuery: SELECT albumart_id, CONCAT_WS('/', music_directories.path, music_albumart.filename), music_albumart.imagetype, music_albumart.embedded FROM music_albumart LEFT JOIN music_directories ON music_directories.directory_id=music_albumart.directory_id WHERE music_directories.path = 'Soundgarden/Badmotorfinger' OR song_id = 2103 ORDER BY music_albumart.imagetype;