Comment 5 for bug 1580604

Revision history for this message
Philip Muškovac (yofel) wrote :

Some quick debugging shows a bunch of DB issues at least:

amarok: [ERROR__] [MySqlStorage] "GREPME MySQLe query failed! (1406) Data too long for column 'description' at row 1 on INSERT INTO magnatune_albums ( name, year, artist_id, album_code, cover_url, description ) VALUES ( 'Ill Be Here Awake', 2004, 682, 'yoria-here', 'http://he3.magnatune.com/music/Arthur%20Yoria/Ill%20Be%20Here%20Awake/cover_200.jpg', 'Ten playfully wicked, exceptionally well-crafted songs make up Arthur Yoria\'s full length debut, <i>I\'ll Be Here Awake</i>. Yoria says it\'s a straight-forward rock album that was written from the point of view of a \"nasty, egotistical fictional character\" that he vicariously lives through from time to time. However, Yoria\'s natural warmth makes this character charming in the way that cads can be when they\'re also talented, funny, and smart. It\'s a testament to Yoria\'s talent, in fact, that the general lack of typical indie rock neurosis comes off as refreshing rather that callous. Yoria is soulful, but mostly at peace with his preference for independence and fun. To wit, \"Call Me\" beautifully nuanced insight into the mind of the chronically unavailable male, and \"P.S.A.\" may be the most beguiling little ditty about masturbation ever written. \"Sevilla\" describes a seething jealousy in the most lilting possible tones, and \"At Least You\'ve Been Told\" is a cagey rock number that rails against stagnant situations. \"Here To Stay\" is the highlight of the entire album though?it\'s a patiently delivered, doggedly inspiring pop shanty. Yoria\'s evil twin be prone to fleeing the scene?but he\'s also always reminding us that at least in an archetypal sense, he\'s not going anywhere.' );"
(many times)

amarok: [ERROR__] [MySqlStorage] "GREPME MySQLe query failed! (1055) Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'amarok.magnatune_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 magnatune_genre.id, magnatune_genre.name FROM magnatune_genre WHERE 1 GROUP BY magnatune_genre.name;"
(once at the end)