https://bugs.kde.org/show_bug.cgi?id=382615
--- Comment #2 from p...@free.fr --- 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] -- You are receiving this mail because: You are watching all bug changes.
