[announcement] MusicCabinet 0.7.22 released

[hakko]

Those were introduced in 0.7.11: http://dilerium.se/musiccabinet/#versionHistory. I think of them as features so to remove them, you'd have to alter the code a bit. You'd need to play around with RESTController.java which is the monstrous class where all the app logic happens.

I think I'm on to the loved/starred tracks bug and the top tracks/recommended import and the log file won't help actually, it's a pure logic thing. But thanks anyway!

[wikke]

thanks for checking into it hakko
it's a wonderful feature nevertheless

I can also report that, when they appear or are renewed after a nightly DB rescan, there are many duplicates.
Seems like all versions of a loved track are matched.

[hakko]

I've spent some time with the import during this weekend and put up a new version: viewtopic.php?f=4&t=9777&p=53923#p53923

Hopefully this will make the import more reliable. Also, when importing loved tracks from last.fm that aren't starred in your library, only one track (the one from the album with the earliest release date) is starred now, instead of starring all tracks. Hopefully that'll work out better if you have multiple copies of the same track on "Best of" compilations etc.

Feel free to continue the discussion in this thread, it doesn't seem worth it to create a new one since I haven't really introduced any new features.

[wikke]

Hakko,

My issue seems to be solved. Thanks.

There are about 800ish tracks synced right now. I have to check why the other tracks weren't synced, but I'm guessing due to my own bad tagging.

[hakko]

OK let's debug the missing "Top artists" issue.

1. Has it ever contained any artists?

2. Are "Three months", "Six months", "Twelve months" AND "Overall" empty? No artists in any of them?

3. Time for some SQL exploration. Fire up the program pgAdmin III (comes with your PostgreSQL install). Connect to your server in the object browser (left column) and expand so that you can see your musiccabinet database. Mark it and press the "SQL" icon to run some queries.

4. Has top artists been fetched?

Code: Select all

select lastfm_user, page, invocation_time from library.webservice_history h inner join music.lastfmuser u on h.lastfmuser_id = u.id where h.calltype_id = 7 order by u.id, h.page;

5. Has anything been put into the import table?

Code: Select all

select * from music.usertopartist_import limit 1;

6. Any traces of your artists in the actual table?

Code: Select all

select lastfm_user, artist_name, days from music.usertopartist t inner join music.lastfmuser u on t.lastfmuser_id = u.id inner join music.artist a on t.artist_id = a.id order by u.id, days, rank;

Thanks!

[hakko]

So far, so good! It looks like artists have been successfully imported.

1. Do we also have artist info (artist images)?

Code: Select all

select lastfm_user, artist_name, days from music.artistinfo ai inner join music.artist a on ai.artist_id = a.id inner join music.usertopartist uta on uta.artist_id = a.id inner join music.lastfmuser u on uta.lastfmuser_id = u.id where uta.days = -1 order by u.id, rank limit 1;

2. Do we also have local tracks for the matching artists?

Code: Select all

select lastfm_user, artist_name, days from music.artistinfo ai inner join music.artist a on ai.artist_id = a.id inner join music.usertopartist uta on uta.artist_id = a.id inner join music.lastfmuser u on uta.lastfmuser_id = u.id where uta.days = -1 and exists (select 1 from library.track lt inner join music.track mt on lt.track_id = mt.id where mt.artist_id = a.id) order by u.id, rank limit 1;

3. Are you logged in as a user which is configured to scrobble songs to last.fm as "AKTARUS_QC"? You can check this by turning your browser to (localhost:4040)/db.view and run:

Code: Select all

select username, last_fm_username from user_settings

[PoGo]

Hello Hakko,

I'm experiencing the same problem.
"Top Artists" and "Recommended" were fully populated before.
As Aktarus, I can't well when it brokes.

Here are the results of the SQL requests you asked to perform :
https://wtf.roflcopter.fr/paste/?97b87217fe6fb5da#cstqvuElx3bZ/EjSX/PbkV2E2poNpHJc/PNQLABRzXc=

Cheers.

[hakko]

Thanks for the detailed output! Everything is looking dandy but it might be a stupid bug of mine. In the personal settings, there's a setting called "Default home statistics" which can be either "Show activity for all users" or "Show only my activity".

I'm pretty sure that if you set it to "Show activity for all users", top artists and recommended artists will no longer be shown for your user but instead (wrongly) fetched for all users, which will give no output. I'll fix this in the next release.

Thanks again for your help with ruling out the last.fm import as the error source!

[DivBy0]

Hakko
I just want to take a moment and I sure everyone feels the same, to thank you for all you've done. This is a really great piece of software and is currently an invaluable part of my everyday life.

Thanks man!



750 artists
1,844 albums
20,624 songs
1042.05 GB (~ 1,589 hours)

[PoGo]

I'm pretty sure that if you set it to "Show activity for all users", top artists and recommended artists will no longer be shown for your user but instead (wrongly) fetched for all users, which will give no output.

Yes, switching back this option to "Show only my activity" solved this problem, thank you !

[hakko]

Hakko
I just want to take a moment and I sure everyone feels the same, to thank you for all you've done. This is a really great piece of software and is currently an invaluable part of my everyday life.

Thanks man!

This made my day, thanks a lot!