[announcement] MusicCabinet 0.7.14 released

Artist radio, genre radio & related artists. A Subsonic server for music nerds.

Moderator: moderators

[announcement] MusicCabinet 0.7.14 released

Postby hakko » Sun Nov 11, 2012 9:18 pm

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

This thread is for discussing the release.
MusicCabinet developer
hakko
 
Posts: 1416
Joined: Tue Apr 17, 2012 7:05 pm
Location: Sweden

Re: [announcement] MusicCabinet 0.7.14 released

Postby precipitous » Mon Nov 12, 2012 5:53 pm

@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.
User avatar
precipitous
 
Posts: 91
Joined: Fri Aug 14, 2009 6:43 pm
Location: Santa Barbara CA USA

Re: [announcement] MusicCabinet 0.7.14 released

Postby hakko » Mon Nov 12, 2012 9:22 pm

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;
MusicCabinet developer
hakko
 
Posts: 1416
Joined: Tue Apr 17, 2012 7:05 pm
Location: Sweden

Re: [announcement] MusicCabinet 0.7.14 released

Postby hakko » Tue Nov 13, 2012 8:29 pm

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.
MusicCabinet developer
hakko
 
Posts: 1416
Joined: Tue Apr 17, 2012 7:05 pm
Location: Sweden

Re: [announcement] MusicCabinet 0.7.14 released

Postby obcd » Mon Nov 19, 2012 2:54 pm

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...
obcd
 
Posts: 40
Joined: Mon Nov 19, 2012 2:42 pm

Re: [announcement] MusicCabinet 0.7.14 released

Postby hakko » Mon Nov 19, 2012 4:34 pm

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.
MusicCabinet developer
hakko
 
Posts: 1416
Joined: Tue Apr 17, 2012 7:05 pm
Location: Sweden

Re: [announcement] MusicCabinet 0.7.14 released

Postby obcd » Mon Nov 19, 2012 5:39 pm

Thanks, problem solved.
obcd
 
Posts: 40
Joined: Mon Nov 19, 2012 2:42 pm

Re: [announcement] MusicCabinet 0.7.14 released

Postby obcd » Mon Nov 19, 2012 8:02 pm

Wow, best music app ever! Thanks!
obcd
 
Posts: 40
Joined: Mon Nov 19, 2012 2:42 pm

Re: [announcement] MusicCabinet 0.7.14 released

Postby hakko » Mon Nov 19, 2012 9:51 pm

Thank you!
MusicCabinet developer
hakko
 
Posts: 1416
Joined: Tue Apr 17, 2012 7:05 pm
Location: Sweden

Re: [announcement] MusicCabinet 0.7.14 released

Postby nicholasa » Thu Nov 22, 2012 7:32 am

Thank you for this!
After using Subsonic for several years this was exactly what i missed!
Lossless junkie!
Image
---
Subsonic running on Win Server 2012, 12TB ISCSI NAS.
nicholasa
 
Posts: 15
Joined: Mon Nov 22, 2010 9:51 am

Re: [announcement] MusicCabinet 0.7.14 released

Postby hakko » Thu Nov 22, 2012 9:06 am

thanks!
MusicCabinet developer
hakko
 
Posts: 1416
Joined: Tue Apr 17, 2012 7:05 pm
Location: Sweden


Return to MusicCabinet

Who is online

Users browsing this forum: No registered users and 4 guests