Opened 13 years ago

Closed 13 years ago

#2409 closed defect (invalid)

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

Reported by: rbonafied@… Owned by: Isaac Richards
Priority: minor Milestone: unknown
Component: mythmusic Version: 0.20
Severity: medium Keywords:
Cc: Ticket locked: no

Description

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

Change History (4)

comment:1 Changed 13 years ago by Isaac Richards

Resolution: duplicate
Status: newclosed

comment:2 in reply to:  1 ; Changed 13 years ago by rbonafied@…

Resolution: duplicate
Status: closedreopened

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.

comment:3 in reply to:  2 Changed 13 years ago by 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.*

comment:4 Changed 13 years ago by Isaac Richards

Resolution: invalid
Status: reopenedclosed
Note: See TracTickets for help on using tickets.