Bug 382615 - amarock jamendo playlist empty after refresh
Summary: amarock jamendo playlist empty after refresh
Status: RESOLVED WORKSFORME
Alias: None
Product: amarok
Classification: Applications
Component: Services/Jamendo (show other bugs)
Version: 2.8-git
Platform: Other Linux
: NOR normal
Target Milestone: 2.9
Assignee: Amarok Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-07-23 10:19 UTC by p92
Modified: 2022-12-06 05:21 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:


Attachments
empty jamendo collection (60.85 KB, image/png)
2017-07-23 10:19 UTC, p92
Details
jamendo download success (15.46 KB, image/png)
2017-07-23 10:19 UTC, p92
Details

Note You need to log in before you can comment on or make changes to this bug.
Description p92 2017-07-23 10:19:13 UTC
Created attachment 106792 [details]
empty jamendo collection

go to home -> internet -> jamendo
click on refresh
the refresh of jamendo database starts, then a popup says it has fetched xxxxx songs etc
but nothing appears in jamendo collection (see screenshot)
Comment 1 p92 2017-07-23 10:19:43 UTC
Created attachment 106793 [details]
jamendo download success
Comment 2 p92 2017-07-23 10:20:21 UTC
trace of download : some SQL errors can explain the problem

amarok: JamendoService: start downloading xml file 
amarok: SCRIPT "Good Morning" :  "-> Gui.setStatus" 
amarok: SCRIPT "Good Morning" :  "<- Gui.setStatus" 
amarok: JamendoService: xml file download complete 
amarok: JamendoService: create xml parser 
amarok: BEGIN: JamendoXmlParser::JamendoXmlParser(const QString&) 
amarok: END__: JamendoXmlParser::JamendoXmlParser(const QString&) [Took: 0s] 
amarok: Destroy Jamendo database  
amarok: Creating jamendo_tracks:  "CREATE TABLE jamendo_tracks (id INTEGER PRIMARY KEY AUTO_INCREMENT,name VARCHAR(255),track_number INTEGER,length INTEGER,preview_url VARCHAR(1000),album_id INTEGER,artist_id INTEGER ) ENGINE = MyISAM;" 
amarok: Creating jamendo_albums:  "CREATE TABLE jamendo_albums (id INTEGER PRIMARY KEY AUTO_INCREMENT,name VARCHAR(255),description VARCHAR(1000),popularity FLOAT, cover_url VARCHAR(1000),launch_year Integer, genre VARCHAR(1000),artist_id INTEGER, mp3_torrent_url VARCHAR(1000),ogg_torrent_url VARCHAR(1000) ) ENGINE = MyISAM;" 
amarok: Creating jamendo_artists:  "CREATE TABLE jamendo_artists (id INTEGER PRIMARY KEY AUTO_INCREMENT,name VARCHAR(255),description VARCHAR(255),country VARCHAR(255),photo_url VARCHAR(255),jamendo_url VARCHAR(255),home_url VARCHAR(255)) ENGINE = MyISAM;" 
amarok: Creating jamendo_genres:  "CREATE TABLE jamendo_genre (id INTEGER PRIMARY KEY AUTO_INCREMENT,name VARCHAR(255),album_id INTEGER) ENGINE = MyISAM;" 
amarok: [ERROR__] [MySqlStorage] "MySQLe query failed! (1406) Data too long for column 'name' at row 1 on INSERT INTO jamendo_tracks ( id, name, track_number, length, album_id, artist_id, preview_url ) VALUES ( 1059672, 'Los enanitos cantarines de plastilina. Los enanitos cantan mientras: se duchan / van al bosque / descansan / caminan / se cansan / cortan leña / se cansan / descansan / se bañan en el Arroyo Gris / uno se ahoga / lo rescatan / uno de ellos charla con los pececillos / sacan a su compañero del Arroyo Gris / discuten sobre el PH sanguíneo tras una hiperventilación / estornudan y se suenan / se han quedado dormidos en el bosque / Finale. (fantasía para cuatro voces, retrete, lavabo, ducha, bidet, cassette, tres sintetizadores y secuenciador)', 6, 627000, 124992, 434805, 'http://api.jamendo.com/get2/stream/track/redirect/?id=1059672&streamencoding=mp32' );" 
amarok: [ERROR__] [MySqlStorage] "MySQLe query failed! (1406) Data too long for column 'name' at row 1 on INSERT INTO jamendo_tracks ( id, name, track_number, length, album_id, artist_id, preview_url ) VALUES ( 1101412, '<font><font><font><font><font><font><font><font></font></font></font><font><font><font></font></font></font></font></font></font></font><font><font><font><font><font><font><font><font><font></font></font></font></font></font><font><font><font><font><font></font></font></font></font></font></font></font></font></font><font><font><font><font><font><font><font><font><font> тебя</font></font></font></font></font></font></font></font></font></font>', 4, 157000, 131446, 441651, 'http://api.jamendo.com/get2/stream/track/redirect/?id=1101412&streamencoding=mp32' );" 
amarok: [ERROR__] [MySqlStorage] "MySQLe query failed! (1406) Data too long for column 'name' at row 1 on INSERT INTO jamendo_tracks ( id, name, track_number, length, album_id, artist_id, preview_url ) VALUES ( 825416, '<font><font><font><font><font><font><font><font><font><font><font><font><font><font><font><font><font><font><font><font><font><font><font><font><font><font><font><font><font><font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font>Спаси от прздности</font></font></font>', 2, 302000, 96518, 362400, 'http://api.jamendo.com/get2/stream/track/redirect/?id=825416&streamencoding=mp32' );" 
amarok: SCRIPT "Good Morning" :  "-> Gui.setStatus" 
amarok: SCRIPT "Good Morning" :  "<- Gui.setStatus" 
amarok: [ERROR__] [MySqlStorage] "MySQLe query failed! (1146) Table 'mysql.proc' doesn't exist on delete from jamendo_genre where name IN ( SELECT name from jamendo_genre GROUP BY jamendo_genre.name HAVING COUNT ( jamendo_genre.name ) < 10 );" 
amarok: JamendoXmlParser: total number of artists:  31983 
amarok: JamendoXmlParser: total number of albums:  26313 
amarok: JamendoXmlParser: total number of tracks:  454587 
amarok: JamendoService: done parsing 
amarok: BEGIN: virtual JamendoXmlParser::~JamendoXmlParser() 
amarok: END__: virtual JamendoXmlParser::~JamendoXmlParser() [Took: 0s] 
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_genre WHERE 1  GROUP BY jamendo_genre.name;" 
amarok: BEGIN: LongMessageWidget::LongMessageWidget(QWidget*, const QString&, Amarok::Logger::MessageType) 
amarok: END__: LongMessageWidget::LongMessageWidget(QWidget*, const QString&, Amarok::Logger::MessageType) [Took: 0.004s] 
amarok: BEGIN: virtual PopupWidget::~PopupWidget() 
amarok: END__: virtual PopupWidget::~PopupWidget() [Took: 0s]
Comment 3 p92 2017-07-23 10:22:45 UTC
seems the select to display the collection is buggy


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_genre WHERE 1  GROUP BY jamendo_genre.name;" 



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_genre WHERE 1  GROUP BY jamendo_genre.name;"
Comment 4 Myriam Schweingruber 2017-07-24 07:53:16 UTC
Are you really using current git? Because that Jamendo database bug was fixed in git ages ago, not in 2.8.0
Comment 5 p92 2017-07-24 11:39:56 UTC
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;"
Comment 6 p92 2017-07-24 15:36:30 UTC
after purging all old amarok packages from my system and recompiling git amarok I still have this problem with jamendo.

my libs :

pascal@minipc:~$ type amarok
amarok est haché (/home/pascal/kde/bin/amarok)
pascal@minipc:~$ ldd /home/pascal/kde/bin/amarok
        linux-vdso.so.1 =>  (0x00007ffce13aa000)
        libamaroklib.so.1 => /home/pascal/kde/lib/libamaroklib.so.1 (0x00007fb729e1a000)
        libX11.so.6 => /usr/lib/x86_64-linux-gnu/libX11.so.6 (0x00007fb729aa6000)
        libamarokcore.so.1 => /home/pascal/kde/lib/libamarokcore.so.1 (0x00007fb729814000)
        libkdeui.so.5 => /usr/lib/libkdeui.so.5 (0x00007fb72919d000)
        libkdecore.so.5 => /usr/lib/libkdecore.so.5 (0x00007fb728cbf000)
        libQtGui.so.4 => /usr/lib/x86_64-linux-gnu/libQtGui.so.4 (0x00007fb727fc8000)
        libQtCore.so.4 => /usr/lib/x86_64-linux-gnu/libQtCore.so.4 (0x00007fb727ad6000)
        libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007fb72774e000)
        libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007fb727387000)
        libkfile.so.4 => /usr/lib/libkfile.so.4 (0x00007fb7270dc000)
        libphonon.so.4 => /usr/lib/x86_64-linux-gnu/libphonon.so.4 (0x00007fb726e63000)
        libplasma.so.3 => /usr/lib/libplasma.so.3 (0x00007fb726942000)
        libktexteditor.so.4 => /usr/lib/libktexteditor.so.4 (0x00007fb726700000)
        libQtScript.so.4 => /usr/lib/x86_64-linux-gnu/libQtScript.so.4 (0x00007fb72623d000)
        libQtScriptTools.so.4 => /usr/lib/x86_64-linux-gnu/libQtScriptTools.so.4 (0x00007fb725f7b000)
        libQtSql.so.4 => /usr/lib/x86_64-linux-gnu/libQtSql.so.4 (0x00007fb725d3a000)
        libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007fb725b1c000)
        liblastfm.so.1 => /usr/lib/x86_64-linux-gnu/liblastfm.so.1 (0x00007fb72588c000)
        libofa.so.0 => /usr/lib/x86_64-linux-gnu/libofa.so.0 (0x00007fb725676000)
        libavformat.so.57 => /usr/lib/x86_64-linux-gnu/libavformat.so.57 (0x00007fb72523c000)
        libavcodec.so.57 => /usr/lib/x86_64-linux-gnu/libavcodec.so.57 (0x00007fb723c6a000)
        libavutil.so.55 => /usr/lib/x86_64-linux-gnu/libavutil.so.55 (0x00007fb7239e7000)
        libamarokpud.so.1 => /home/pascal/kde/lib/libamarokpud.so.1 (0x00007fb7237ca000)
        libamarokocsclient.so.4 => /home/pascal/kde/lib/libamarokocsclient.so.4 (0x00007fb72359a000)
        libamarok-transcoding.so.1 => /home/pascal/kde/lib/libamarok-transcoding.so.1 (0x00007fb72337f000)
        libknewstuff3.so.4 => /usr/lib/libknewstuff3.so.4 (0x00007fb723100000)
        libkcmutils.so.4 => /usr/lib/libkcmutils.so.4 (0x00007fb722ebe000)
        libthreadweaver.so.4 => /usr/lib/libthreadweaver.so.4 (0x00007fb722ca8000)
        libamarokshared.so.1 => /home/pascal/kde/lib/libamarokshared.so.1 (0x00007fb722a55000)
        libkio.so.5 => /usr/lib/libkio.so.5 (0x00007fb72258f000)
        libQtSvg.so.4 => /usr/lib/x86_64-linux-gnu/libQtSvg.so.4 (0x00007fb722336000)
        libsolid.so.4 => /usr/lib/libsolid.so.4 (0x00007fb72202f000)
        libQtDBus.so.4 => /usr/lib/x86_64-linux-gnu/libQtDBus.so.4 (0x00007fb721dac000)
        libQtNetwork.so.4 => /usr/lib/x86_64-linux-gnu/libQtNetwork.so.4 (0x00007fb721a57000)
        libQtXml.so.4 => /usr/lib/x86_64-linux-gnu/libQtXml.so.4 (0x00007fb721811000)
        libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007fb721506000)
        libxcb.so.1 => /usr/lib/x86_64-linux-gnu/libxcb.so.1 (0x00007fb7212e4000)
        libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007fb7210e0000)
        libSM.so.6 => /usr/lib/x86_64-linux-gnu/libSM.so.6 (0x00007fb720ed8000)
        libICE.so.6 => /usr/lib/x86_64-linux-gnu/libICE.so.6 (0x00007fb720cbe000)
        libattica.so.0.4 => /usr/lib/x86_64-linux-gnu/libattica.so.0.4 (0x00007fb7209ff000)
        libdbusmenu-qt.so.2 => /usr/lib/x86_64-linux-gnu/libdbusmenu-qt.so.2 (0x00007fb7207cb000)
        libXfixes.so.3 => /usr/lib/x86_64-linux-gnu/libXfixes.so.3 (0x00007fb7205c5000)
        libXrender.so.1 => /usr/lib/x86_64-linux-gnu/libXrender.so.1 (0x00007fb7203bb000)
        libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007fb72019f000)
        libbz2.so.1.0 => /lib/x86_64-linux-gnu/libbz2.so.1.0 (0x00007fb71ff8f000)
        liblzma.so.5 => /lib/x86_64-linux-gnu/liblzma.so.5 (0x00007fb71fd67000)
        libdlrestrictions.so.1 => /usr/lib/libdlrestrictions.so.1 (0x00007fb71fb62000)
        libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007fb71f94b000)
        libfontconfig.so.1 => /usr/lib/x86_64-linux-gnu/libfontconfig.so.1 (0x00007fb71f708000)
        libaudio.so.2 => /usr/lib/x86_64-linux-gnu/libaudio.so.2 (0x00007fb71f4ef000)
        libglib-2.0.so.0 => /lib/x86_64-linux-gnu/libglib-2.0.so.0 (0x00007fb71f1db000)
        libpng16.so.16 => /usr/lib/x86_64-linux-gnu/libpng16.so.16 (0x00007fb71efa7000)
        libfreetype.so.6 => /usr/lib/x86_64-linux-gnu/libfreetype.so.6 (0x00007fb71ecfa000)
        libgobject-2.0.so.0 => /usr/lib/x86_64-linux-gnu/libgobject-2.0.so.0 (0x00007fb71eaa7000)
        libXi.so.6 => /usr/lib/x86_64-linux-gnu/libXi.so.6 (0x00007fb71e897000)
        libXext.so.6 => /usr/lib/x86_64-linux-gnu/libXext.so.6 (0x00007fb71e685000)
        librt.so.1 => /lib/x86_64-linux-gnu/librt.so.1 (0x00007fb71e47d000)
        /lib64/ld-linux-x86-64.so.2 (0x000055ef11d8b000)
        libpulse.so.0 => /usr/lib/x86_64-linux-gnu/libpulse.so.0 (0x00007fb71e22b000)
        libpulse-mainloop-glib.so.0 => /usr/lib/x86_64-linux-gnu/libpulse-mainloop-glib.so.0 (0x00007fb71e026000)
        libQtWebKit.so.4 => /usr/lib/x86_64-linux-gnu/libQtWebKit.so.4 (0x00007fb71bb38000)
        libQtDeclarative.so.4 => /usr/lib/x86_64-linux-gnu/libQtDeclarative.so.4 (0x00007fb71b576000)
        libkdnssd.so.4 => /usr/lib/libkdnssd.so.4 (0x00007fb71b34c000)
        libkdewebkit.so.5 => /usr/lib/libkdewebkit.so.5 (0x00007fb71b127000)
        libqca.so.2 => /usr/lib/x86_64-linux-gnu/libqca.so.2 (0x00007fb71ae2e000)
        libQtOpenGL.so.4 => /usr/lib/x86_64-linux-gnu/libQtOpenGL.so.4 (0x00007fb71ab2c000)
        libkparts.so.4 => /usr/lib/libkparts.so.4 (0x00007fb71a8d5000)
        libfftw3.so.3 => /usr/lib/x86_64-linux-gnu/libfftw3.so.3 (0x00007fb71a4da000)
        libssh-gcrypt.so.4 => /usr/lib/x86_64-linux-gnu/libssh-gcrypt.so.4 (0x00007fb71a26c000)
        libopenmpt.so.0 => /usr/lib/x86_64-linux-gnu/libopenmpt.so.0 (0x00007fb719edd000)
        libgme.so.0 => /usr/lib/x86_64-linux-gnu/libgme.so.0 (0x00007fb719c90000)
        libbluray.so.2 => /usr/lib/x86_64-linux-gnu/libbluray.so.2 (0x00007fb719a44000)
        libgnutls.so.30 => /usr/lib/x86_64-linux-gnu/libgnutls.so.30 (0x00007fb7196e4000)
        libchromaprint.so.1 => /usr/lib/x86_64-linux-gnu/libchromaprint.so.1 (0x00007fb7194d0000)
        libswresample.so.2 => /usr/lib/x86_64-linux-gnu/libswresample.so.2 (0x00007fb7192b1000)
        libva.so.1 => /usr/lib/x86_64-linux-gnu/libva.so.1 (0x00007fb71908f000)
        libzvbi.so.0 => /usr/lib/x86_64-linux-gnu/libzvbi.so.0 (0x00007fb718e04000)
        libxvidcore.so.4 => /usr/lib/x86_64-linux-gnu/libxvidcore.so.4 (0x00007fb718af0000)
        libx265.so.110 => /usr/lib/x86_64-linux-gnu/libx265.so.110 (0x00007fb717e93000)
        libx264.so.148 => /usr/lib/x86_64-linux-gnu/libx264.so.148 (0x00007fb717af1000)
        libwebpmux.so.2 => /usr/lib/x86_64-linux-gnu/libwebpmux.so.2 (0x00007fb7178e7000)
        libwebp.so.6 => /usr/lib/x86_64-linux-gnu/libwebp.so.6 (0x00007fb717685000)
        libwavpack.so.1 => /usr/lib/x86_64-linux-gnu/libwavpack.so.1 (0x00007fb71745a000)
        libvpx.so.4 => /usr/lib/x86_64-linux-gnu/libvpx.so.4 (0x00007fb71701d000)
        libvorbisenc.so.2 => /usr/lib/x86_64-linux-gnu/libvorbisenc.so.2 (0x00007fb716d74000)
        libvorbis.so.0 => /usr/lib/x86_64-linux-gnu/libvorbis.so.0 (0x00007fb716b49000)
        libvo-amrwbenc.so.0 => /usr/lib/x86_64-linux-gnu/libvo-amrwbenc.so.0 (0x00007fb71692f000)
        libtwolame.so.0 => /usr/lib/x86_64-linux-gnu/libtwolame.so.0 (0x00007fb71670a000)
        libtheoraenc.so.1 => /usr/lib/x86_64-linux-gnu/libtheoraenc.so.1 (0x00007fb7164cb000)
        libtheoradec.so.1 => /usr/lib/x86_64-linux-gnu/libtheoradec.so.1 (0x00007fb7162ad000)
        libspeex.so.1 => /usr/lib/x86_64-linux-gnu/libspeex.so.1 (0x00007fb716094000)
        libsnappy.so.1 => /usr/lib/x86_64-linux-gnu/libsnappy.so.1 (0x00007fb715e8c000)
        libshine.so.3 => /usr/lib/x86_64-linux-gnu/libshine.so.3 (0x00007fb715c7f000)
        libopus.so.0 => /usr/lib/x86_64-linux-gnu/libopus.so.0 (0x00007fb715a33000)
        libopenjp2.so.7 => /usr/lib/x86_64-linux-gnu/libopenjp2.so.7 (0x00007fb7157f8000)
        libopencore-amrwb.so.0 => /usr/lib/x86_64-linux-gnu/libopencore-amrwb.so.0 (0x00007fb7155e4000)
        libopencore-amrnb.so.0 => /usr/lib/x86_64-linux-gnu/libopencore-amrnb.so.0 (0x00007fb7153b9000)
        libmp3lame.so.0 => /usr/lib/x86_64-linux-gnu/libmp3lame.so.0 (0x00007fb715144000)
        libgsm.so.1 => /usr/lib/x86_64-linux-gnu/libgsm.so.1 (0x00007fb714f36000)
        libcrystalhd.so.3 => /usr/lib/x86_64-linux-gnu/libcrystalhd.so.3 (0x00007fb714d19000)
        libvdpau.so.1 => /usr/lib/x86_64-linux-gnu/libvdpau.so.1 (0x00007fb714b15000)
        libva-drm.so.1 => /usr/lib/x86_64-linux-gnu/libva-drm.so.1 (0x00007fb714912000)
        libva-x11.so.1 => /usr/lib/x86_64-linux-gnu/libva-x11.so.1 (0x00007fb71470c000)
        libtag.so.1 => /usr/lib/x86_64-linux-gnu/libtag.so.1 (0x00007fb714433000)
        libtag-extras.so.1 => /usr/lib/libtag-extras.so.1 (0x00007fb714222000)
        libstreamanalyzer.so.0 => /usr/lib/libstreamanalyzer.so.0 (0x00007fb713fa5000)
        libacl.so.1 => /lib/x86_64-linux-gnu/libacl.so.1 (0x00007fb713d9d000)
        libattr.so.1 => /lib/x86_64-linux-gnu/libattr.so.1 (0x00007fb713b98000)
        libudev.so.1 => /lib/x86_64-linux-gnu/libudev.so.1 (0x00007fb713b77000)
        libdbus-1.so.3 => /lib/x86_64-linux-gnu/libdbus-1.so.3 (0x00007fb713929000)
        libXau.so.6 => /usr/lib/x86_64-linux-gnu/libXau.so.6 (0x00007fb713725000)
        libXdmcp.so.6 => /usr/lib/x86_64-linux-gnu/libXdmcp.so.6 (0x00007fb71351f000)
        libuuid.so.1 => /lib/x86_64-linux-gnu/libuuid.so.1 (0x00007fb71331a000)
        libexpat.so.1 => /lib/x86_64-linux-gnu/libexpat.so.1 (0x00007fb7130f0000)
        libXt.so.6 => /usr/lib/x86_64-linux-gnu/libXt.so.6 (0x00007fb712e85000)
        libpcre.so.3 => /lib/x86_64-linux-gnu/libpcre.so.3 (0x00007fb712c12000)
        libffi.so.6 => /usr/lib/x86_64-linux-gnu/libffi.so.6 (0x00007fb712a0a000)
        libpulsecommon-10.0.so => /usr/lib/x86_64-linux-gnu/pulseaudio/libpulsecommon-10.0.so (0x00007fb71278b000)
        libjpeg.so.8 => /usr/lib/x86_64-linux-gnu/libjpeg.so.8 (0x00007fb712521000)
        libxslt.so.1 => /usr/lib/x86_64-linux-gnu/libxslt.so.1 (0x00007fb7122e2000)
        libxml2.so.2 => /usr/lib/x86_64-linux-gnu/libxml2.so.2 (0x00007fb711f28000)
        libgstapp-1.0.so.0 => /usr/lib/x86_64-linux-gnu/libgstapp-1.0.so.0 (0x00007fb711d1a000)
        libgstpbutils-1.0.so.0 => /usr/lib/x86_64-linux-gnu/libgstpbutils-1.0.so.0 (0x00007fb711ae5000)
        libgstvideo-1.0.so.0 => /usr/lib/x86_64-linux-gnu/libgstvideo-1.0.so.0 (0x00007fb71185a000)
        libgstaudio-1.0.so.0 => /usr/lib/x86_64-linux-gnu/libgstaudio-1.0.so.0 (0x00007fb7115ef000)
        libgstbase-1.0.so.0 => /usr/lib/x86_64-linux-gnu/libgstbase-1.0.so.0 (0x00007fb711389000)
        libgstreamer-1.0.so.0 => /usr/lib/x86_64-linux-gnu/libgstreamer-1.0.so.0 (0x00007fb711057000)
        libsqlite3.so.0 => /usr/lib/x86_64-linux-gnu/libsqlite3.so.0 (0x00007fb710d50000)
        libGL.so.1 => /usr/lib/x86_64-linux-gnu/mesa/libGL.so.1 (0x00007fb710ade000)
        libQtXmlPatterns.so.4 => /usr/lib/x86_64-linux-gnu/libQtXmlPatterns.so.4 (0x00007fb710458000)
        libgcrypt.so.20 => /lib/x86_64-linux-gnu/libgcrypt.so.20 (0x00007fb710147000)
        libgssapi_krb5.so.2 => /usr/lib/x86_64-linux-gnu/libgssapi_krb5.so.2 (0x00007fb70fefd000)
        libmpg123.so.0 => /usr/lib/x86_64-linux-gnu/libmpg123.so.0 (0x00007fb70fc9f000)
        libvorbisfile.so.3 => /usr/lib/x86_64-linux-gnu/libvorbisfile.so.3 (0x00007fb70fa96000)
        libp11-kit.so.0 => /usr/lib/x86_64-linux-gnu/libp11-kit.so.0 (0x00007fb70f831000)
        libidn.so.11 => /lib/x86_64-linux-gnu/libidn.so.11 (0x00007fb70f5fe000)
        libtasn1.so.6 => /usr/lib/x86_64-linux-gnu/libtasn1.so.6 (0x00007fb70f3e9000)
        libnettle.so.6 => /usr/lib/x86_64-linux-gnu/libnettle.so.6 (0x00007fb70f1b3000)
        libgmp.so.10 => /usr/lib/x86_64-linux-gnu/libgmp.so.10 (0x00007fb70ef33000)
        libhogweed.so.4 => /usr/lib/x86_64-linux-gnu/libhogweed.so.4 (0x00007fb70ed00000)
        libsoxr.so.0 => /usr/lib/x86_64-linux-gnu/libsoxr.so.0 (0x00007fb70ea9e000)
        libnuma.so.1 => /usr/lib/x86_64-linux-gnu/libnuma.so.1 (0x00007fb70e893000)
        libogg.so.0 => /usr/lib/x86_64-linux-gnu/libogg.so.0 (0x00007fb70e688000)
        libcairo.so.2 => /usr/lib/x86_64-linux-gnu/libcairo.so.2 (0x00007fb70e374000)
        libdrm.so.2 => /usr/lib/x86_64-linux-gnu/libdrm.so.2 (0x00007fb70e163000)
        libstreams.so.0 => /usr/lib/libstreams.so.0 (0x00007fb70df2b000)
        libsystemd.so.0 => /lib/x86_64-linux-gnu/libsystemd.so.0 (0x00007fb70dea1000)
        libwrap.so.0 => /lib/x86_64-linux-gnu/libwrap.so.0 (0x00007fb70dc97000)
        libsndfile.so.1 => /usr/lib/x86_64-linux-gnu/libsndfile.so.1 (0x00007fb70da1f000)
        libasyncns.so.0 => /usr/lib/x86_64-linux-gnu/libasyncns.so.0 (0x00007fb70d819000)
        libicuuc.so.57 => /usr/lib/x86_64-linux-gnu/libicuuc.so.57 (0x00007fb70d471000)
        libgsttag-1.0.so.0 => /usr/lib/x86_64-linux-gnu/libgsttag-1.0.so.0 (0x00007fb70d234000)
        liborc-0.4.so.0 => /usr/lib/x86_64-linux-gnu/liborc-0.4.so.0 (0x00007fb70cfb6000)
        libgmodule-2.0.so.0 => /usr/lib/x86_64-linux-gnu/libgmodule-2.0.so.0 (0x00007fb70cdb2000)
        libxcb-dri3.so.0 => /usr/lib/x86_64-linux-gnu/libxcb-dri3.so.0 (0x00007fb70cbaf000)
        libxcb-present.so.0 => /usr/lib/x86_64-linux-gnu/libxcb-present.so.0 (0x00007fb70c9ac000)
        libxcb-sync.so.1 => /usr/lib/x86_64-linux-gnu/libxcb-sync.so.1 (0x00007fb70c7a3000)
        libxshmfence.so.1 => /usr/lib/x86_64-linux-gnu/libxshmfence.so.1 (0x00007fb70c5a0000)
        libglapi.so.0 => /usr/lib/x86_64-linux-gnu/libglapi.so.0 (0x00007fb70c371000)
        libXdamage.so.1 => /usr/lib/x86_64-linux-gnu/libXdamage.so.1 (0x00007fb70c16e000)
        libX11-xcb.so.1 => /usr/lib/x86_64-linux-gnu/libX11-xcb.so.1 (0x00007fb70bf6c000)
        libxcb-glx.so.0 => /usr/lib/x86_64-linux-gnu/libxcb-glx.so.0 (0x00007fb70bd53000)
        libxcb-dri2.so.0 => /usr/lib/x86_64-linux-gnu/libxcb-dri2.so.0 (0x00007fb70bb4c000)
        libXxf86vm.so.1 => /usr/lib/x86_64-linux-gnu/libXxf86vm.so.1 (0x00007fb70b946000)
        libgpg-error.so.0 => /lib/x86_64-linux-gnu/libgpg-error.so.0 (0x00007fb70b732000)
        libkrb5.so.3 => /usr/lib/x86_64-linux-gnu/libkrb5.so.3 (0x00007fb70b45d000)
        libk5crypto.so.3 => /usr/lib/x86_64-linux-gnu/libk5crypto.so.3 (0x00007fb70b22b000)
        libcom_err.so.2 => /lib/x86_64-linux-gnu/libcom_err.so.2 (0x00007fb70b027000)
        libkrb5support.so.0 => /usr/lib/x86_64-linux-gnu/libkrb5support.so.0 (0x00007fb70ae1a000)
        libgomp.so.1 => /usr/lib/x86_64-linux-gnu/libgomp.so.1 (0x00007fb70abec000)
        libpixman-1.so.0 => /usr/lib/x86_64-linux-gnu/libpixman-1.so.0 (0x00007fb70a946000)
        libxcb-shm.so.0 => /usr/lib/x86_64-linux-gnu/libxcb-shm.so.0 (0x00007fb70a742000)
        libxcb-render.so.0 => /usr/lib/x86_64-linux-gnu/libxcb-render.so.0 (0x00007fb70a538000)
        libselinux.so.1 => /lib/x86_64-linux-gnu/libselinux.so.1 (0x00007fb70a30e000)
        liblz4.so.1 => /usr/lib/x86_64-linux-gnu/liblz4.so.1 (0x00007fb70a0f6000)
        libnsl.so.1 => /lib/x86_64-linux-gnu/libnsl.so.1 (0x00007fb709edd000)
        libFLAC.so.8 => /usr/lib/x86_64-linux-gnu/libFLAC.so.8 (0x00007fb709c66000)
        libresolv.so.2 => /lib/x86_64-linux-gnu/libresolv.so.2 (0x00007fb709a4b000)
        libicudata.so.57 => /usr/lib/x86_64-linux-gnu/libicudata.so.57 (0x00007fb707fce000)
        libkeyutils.so.1 => /lib/x86_64-linux-gnu/libkeyutils.so.1 (0x00007fb707dc8000)
Comment 7 p92 2017-07-24 15:38:39 UTC
I followed your article http://blogs.fsfe.org/myriam/2009/09/26/compiling-amarok-from-git-locally-full-summary/ to compile, install and run.
Comment 8 p92 2017-07-24 16:12:33 UTC
mysql --version
mysql  Ver 14.14 Distrib 5.7.19, for Linux (x86_64) using  EditLine wrapper


note for git users on plasma desktop : the myenv.sh should be put at 
./.config/plasma-workspace/env/myenv.sh  not in ./.kde/env/myenv.sh
Comment 9 Myriam Schweingruber 2017-07-25 21:35:13 UTC
Thanks for the info, I need to update my blog...
Comment 10 Justin Zobel 2022-11-06 09:25:39 UTC
Thank you for reporting this issue in KDE software. As it has been a while since this issue was reported, can we please ask you to see if you can reproduce the issue with a recent software version?

If you can reproduce the issue, please change the status to "REPORTED" when replying. Thank you!
Comment 11 Bug Janitor Service 2022-11-21 05:14:42 UTC
Dear Bug Submitter,

This bug has been in NEEDSINFO status with no change for at least
15 days. Please provide the requested information as soon as
possible and set the bug status as REPORTED. Due to regular bug
tracker maintenance, if the bug is still in NEEDSINFO status with
no change in 30 days the bug will be closed as RESOLVED > WORKSFORME
due to lack of needed information.

For more information about our bug triaging procedures please read the
wiki located here:
https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging

If you have already provided the requested information, please
mark the bug as REPORTED so that the KDE team knows that the bug is
ready to be confirmed.

Thank you for helping us make KDE software even better for everyone!
Comment 12 Bug Janitor Service 2022-12-06 05:21:25 UTC
This bug has been in NEEDSINFO status with no change for at least
30 days. The bug is now closed as RESOLVED > WORKSFORME
due to lack of needed information.

For more information about our bug triaging procedures please read the
wiki located here:
https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging

Thank you for helping us make KDE software even better for everyone!