Mythmusic smartplaylist doesn't actually select any songs. Error in Query

[rbonafied@…]

Mythmusic smart playlist selecting does not work. No songs are actually selected.

The frontend kicked out this error:

2006-09-17 10:18:31.470 DB Error (Load songlist from query): Query was: SELECT song_id FROM music_songs 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_genres ON music_songs.genre_id=music_genres.genre_id LEFT JOIN music_artists AS music_comp_artists ON music_albums.artist_id=music_comp_artists.artist_id WHERE genre = 'Rock' ORDER BY artist_name, album_name, track

Driver error was [2/1052]:

QMYSQL3: Unable to execute query

Database error was: Column 'artist_name' in order clause is ambiguous

[rbonafied@…]

Sorry about the (partial) dup. I editted the playbackbox.cpp to eliminate the order by error. However, I still have the problem where the smart playlist doesn't actually reflect in the music selected.

In other words, mythmusic behaves as if I didn't select any music from smart playlist. I've confirmed the original query error is gone.

Let me know if I should open this as a separate ticket. For now I'll re-open this one.

[anonymous]

Replying to rbonafied@gmail.com:

Sorry about the (partial) dup. I editted the playbackbox.cpp to eliminate the order by error. However, I still have the problem where the smart playlist doesn't actually reflect in the music selected.

In other words, mythmusic behaves as if I didn't select any music from smart playlist. I've confirmed the original query error is gone.

Let me know if I should open this as a separate ticket. For now I'll re-open this one.

*This can be closed. It was user/pilot error that caused the empty list after I made my patch.*