https://bugs.kde.org/show_bug.cgi?id=382615
--- Comment #5 from [email protected] --- unless the jamendo code is in a lib not covered by amarok git, yes i am using the git of amarok from last saturday. doing a query in the empty jamendo tab still gives this sql error in the trace amarok: BEGIN: void BrowserCategoryList::home() amarok: BEGIN: void BrowserCategoryList::childViewChanged() amarok: END__: void BrowserCategoryList::childViewChanged() [Took: 0.007s] amarok: END__: void BrowserCategoryList::home() [Took: 0.009s] amarok: BEGIN: void BrowserCategoryList::categoryActivated(const QModelIndex&) amarok: [BrowserCategoryList] Show service: "Jamendo.com" amarok: BEGIN: void BrowserCategoryList::setActiveCategory(BrowserCategory*) amarok: BEGIN: void BrowserCategoryList::childViewChanged() amarok: END__: void BrowserCategoryList::childViewChanged() [Took: 0.009s] amarok: END__: void BrowserCategoryList::setActiveCategory(BrowserCategory*) [Took: 0.012s] amarok: END__: void BrowserCategoryList::categoryActivated(const QModelIndex&) [Took: 0.012s] amarok: [ERROR__] [MySqlStorage] "MySQLe query failed! (1055) Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'amarok.jamendo_genre.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by on SELECT DISTINCT jamendo_genre.id, jamendo_genre.name FROM jamendo_tracks LEFT JOIN jamendo_albums ON jamendo_tracks.album_id = jamendo_albums.id LEFT JOIN jamendo_artists ON jamendo_albums.artist_id = jamendo_artists.id LEFT JOIN jamendo_genre ON jamendo_genre.album_id = jamendo_albums.id WHERE 1 AND ( 1 AND ( 0 OR ( 0 OR ( 0 OR jamendo_tracks.name LIKE '%abba%' COLLATE utf8_unicode_ci ESCAPE '/' OR jamendo_albums.name LIKE '%abba%' COLLATE utf8_unicode_ci ESCAPE '/' OR jamendo_artists.name LIKE '%abba%' COLLATE utf8_unicode_ci ESCAPE '/' OR jamendo_genre.name LIKE '%abba%' COLLATE utf8_unicode_ci ESCAPE '/' ))) ) GROUP BY jamendo_genre.name;" -- You are receiving this mail because: You are watching all bug changes.
