Subsonic Forum

Release notes: viewtopic.php?f=4&t=9777&p=48714#p48714

This thread is for discussing the release.

@hakko: Installed 0.7.14 this morning... I really like the new genre changes you made. Especially the ability to edit the Last.FM genre tags. Everything appears to work OK, except that I am still not getting artist biography and the new genre tags for a LOT of artists (the new genre tags only show up if there is an artist biography)... I am fairly certain that I am getting a few more artist biographies than I did using version 0.7.13, but not that many.

Did you have artist biographies for these artists before? Did the biographies just disappear one day or did artists stop getting biographies after reinstalling?

This is how I would debug it (using artist Nirvana as an example). It's whole lot of SQL, sorry. Could you run it for an artist that lack biography, even though you have a couple of albums?

Show biography info + whether artist is eligible for artist radio (returns a "t" for true or an "f" for false)
This should hopefully return a biography, and letter "t" since most artists are expected to have at least some top tracks (unless you only have a single rare track or so by the artist).

Code: Select all

select a.artist_name_capitalization, ai.largeimageurl, ai.biosummary, exists(select 1 from library.artisttoptrackplaycount where artist_id = a.id) from music.artist a left outer join music.artistinfo ai on ai.artist_id = a.id where a.artist_name = upper('Nirvana');

When was information fetched from last.fm last time for this artist? (this could be future dates or infinity, if previous updates failed badly and further updates were quarantined or if you've manually edited the artist biography)

Code: Select all

select c.description, h.invocation_time from library.webservice_history h inner join library.webservice_calltype c on h.calltype_id = c.id inner join music.artist a on h.artist_id = a.id where a.artist_name = upper('Nirvana');

What top tracks have last.fm given us for this artist?

Code: Select all

select track_name_capitalization from music.artisttoptrack att inner join music.track t on att.track_id = t.id inner join music.artist a on att.artist_id = a.id where a.artist_name = upper('Nirvana') order by rank;

Do they match anything we have locally?

Code: Select all

select track_name_capitalization from library.artisttoptrackplaycount attpc inner join music.artist a on attpc.artist_id = a.id inner join library.track lt on attpc.track_id = lt.id inner join music.track mt on lt.track_id = mt.id where a.artist_name = upper('Nirvana') order by rank;

Are any artists waiting to have their biography updated? (this is the sql code that's being run right now, but it could actually be optimized. oops!)
This would normally return no hits, unless you just wiped out your whole database and haven't scanned it.

Code: Select all

select artist_name_capitalization from music.artist where id in (select distinct mt.artist_id from library.track lt inner join music.track mt on lt.track_id = mt.id where not exists (select 1 from library.webservice_history where artist_id = mt.artist_id and calltype_id = 5) order by mt.artist_id limit 3000);

Which artists will have their biographies updated next?
This should give a pretty long list (3% of all your artists). After doing a full scan, it should give a new list of names.

Code: Select all

select a.artist_name_capitalization from (select artist_id, ntile(30) over (order by invocation_time) from library.webservice_history where calltype_id = 5 and artist_id in (select artist_id from library.artist)) ntile inner join music.artist a on ntile.artist_id = a.id and ntile.ntile = 1 order by artist_id limit 1000;

I found a small bug with the effect that if you edited a lot of artist tags at the same time, not all of the updates would be posted to last.fm (but all of them would still get stored locally, so nothing lost). I've updated the installation package to 0.7.14b to solve this.

I have installed subsonic with the Debian/Ubuntu installer and now I am trying to install MusicCabinet. The problem is that I get this:
http://pastebin.com/bT1Qaww3
log: http://paste.ubuntu.com/1370185/

I don't really know what to do...

How exactly did you install it?

The error log says that you're running jetty-6.1.x, but version 0.7.14 comes with jetty 8. It looks like a mismatch of different files from different installations.

Thanks, problem solved.

Wow, best music app ever! Thanks!

Thank you!

Thank you for this!
After using Subsonic for several years this was exactly what i missed!

thanks!