2008-03-19 19:00:34.770 MSqlQuery: UPDATE music_songs set rating = ? , numplays = ? , lastplay = ? where song_id = ? ;
2008-03-19 19:00:34.773 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 WHERE music_songs.song_id = ?;
2008-03-19 19:00:34.779 MSqlQuery: UPDATE music_songs set rating = ? , numplays = ? , lastplay = ? where song_id = ? ;
2008-03-19 19:00:34.782 MSqlQuery: UPDATE music_playlists SET playlist_songs = ?, playlist_name = ?, songcount = ?, length = ?, hostname = ? WHERE playlist_id = ? ;
2008-03-19 19:00:34.784 MSqlQuery: UPDATE music_playlists SET playlist_songs = ?, playlist_name = ?, songcount = ?, length = ?, hostname = ? WHERE playlist_id = ? ;
2008-03-19 19:00:34.785 MSqlQuery: SELECT * FROM settings WHERE value = ? AND hostname = ? ;
2008-03-19 19:00:34.786 MSqlQuery: UPDATE settings SET data = ? WHERE WHERE value = ? AND hostname = ? ;
2008-03-19 19:00:36.473 MSqlQuery: SELECT data FROM settings WHERE value = ? AND hostname = ? ;
2008-03-19 19:00:36.475 MSqlQuery: SELECT data FROM settings WHERE value = ? AND hostname = ? ;
2008-03-19 19:00:36.524 XMLParse::LoadTheme using /usr/local/share/mythtv/themes/metallurgy/music-ui.xml
2008-03-19 19:00:44.410 MSqlQuery: SELECT CONCAT_WS('/', music_directories.path, music_songs.filename) AS filename FROM music_songs LEFT JOIN music_directories ON music_songs.directory_id=music_directories.directory_id WHERE music_songs.song_id = ?
2008-03-19 19:00:44.410 DB Error (get filename):
Query was:
SELECT CONCAT_WS('/', music_directories.path, music_songs.filename) AS filename FROM music_songs LEFT JOIN music_directories ON music_songs.directory_id=music_directories.directory_id WHERE music_songs.song_id = ?
No error type from QSqlError? Strange...
2008-03-19 19:00:44.516 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 WHERE music_songs.song_id = ?;