[announcement] MusicCabinet 0.7.22 released

[Aktarus]

Hello,

The scrobbling to LastFm seems to work well ... I can see my chart, library and wich song I listened last time I use music cabinet !!
My subsonic is installed in my C:\subsonic, but I can't find any musiccabinet.log file in this directory !!
Where is the log file ??

MERCI, ... and sorry for my poor english

[cakgok]

Hey,

I just upgraded from an earlier version and now i see Artist Radio, Top Tracks and Related Artist tabs on my mobile devices and they reaaly bother me. Is there a way i can remove those? I think i was at 0.7.8 before and they didn't exist.

Thanks for the great effort by the way:)

[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.

[Aktarus]

Hello,

Thank you Hakko for this new version. But I still have somme problem with LastFM features in the Home section.
The "STARRED" section's working well for me, but some problems with "TOP ARTISTS" and "RECOMMENDED" section..
Those two sections are empty but if I check at LastFM, I can see my charts for past days, week, months .. I can also see songs added by scrobbling.
But nothing in these two section !! I made a FULL RESCAN without success

Any idea ??

MERCI

[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!

[Aktarus]

Hello,

Here's my answer :

1 - Yes, It was working before, but I can't tell when it broke
2 - NOTHING at all in all section
4 - Results:
"AKTARUS_QC";-1;"2013-03-10 04:03:09.889"
"AKTARUS_QC";90;"2013-03-10 04:03:01.291"
"AKTARUS_QC";180;"2013-03-10 04:03:04.547"
"AKTARUS_QC";360;"2013-03-10 04:03:07.07"
5 - Results :
"Aktarus_qc";87;"Artistes Varies";0;90
6 - Results :
"AKTARUS_QC";"MUSE";-1
"AKTARUS_QC";"ARTISTES VARIES";-1
"AKTARUS_QC";"RUSH";-1
"AKTARUS_QC";"MAXÏMO PARK";-1
"AKTARUS_QC";"NO USE FOR A NAME";-1
"AKTARUS_QC";"NOFX";-1
"AKTARUS_QC";"PLACEBO";-1
"AKTARUS_QC";"COLDPLAY";-1
"AKTARUS_QC";"KAISER CHIEFS";-1
"AKTARUS_QC";"KASABIAN";-1
"AKTARUS_QC";"RADIOHEAD";-1
"AKTARUS_QC";"FRANZ FERDINAND";-1
"AKTARUS_QC";"LAGWAGON";-1
"AKTARUS_QC";"AVENGED SEVENFOLD";-1
"AKTARUS_QC";"BLOC PARTY";-1
"AKTARUS_QC";"BAD RELIGION";-1
"AKTARUS_QC";"KEANE";-1
"AKTARUS_QC";"BLUR";-1
"AKTARUS_QC";"TEN FOOT POLE";-1
"AKTARUS_QC";"EDITORS";-1
"AKTARUS_QC";"STEREOPHONICS";-1
"AKTARUS_QC";"PENNYWISE";-1
"AKTARUS_QC";"STRUNG OUT";-1
"AKTARUS_QC";"SNOW PATROL";-1
"AKTARUS_QC";"INTERPOL";-1
"AKTARUS_QC";"FACE TO FACE";-1
"AKTARUS_QC";"MILLENCOLIN";-1
"AKTARUS_QC";"OASIS";-1
"AKTARUS_QC";"TRAVIS";-1
"AKTARUS_QC";"THE KILLERS";-1
"AKTARUS_QC";"IRON MAIDEN";-1
"AKTARUS_QC";"THE COOPER TEMPLE CLAUSE";-1
"AKTARUS_QC";"DREAM THEATER";-1
"AKTARUS_QC";"FEEDER";-1
"AKTARUS_QC";"MANIC STREET PREACHERS";-1
"AKTARUS_QC";"GOOD RIDDANCE";-1
"AKTARUS_QC";"MXPX";-1
"AKTARUS_QC";"THE FRATELLIS";-1
"AKTARUS_QC";"WEEZER";-1
"AKTARUS_QC";"THE MARS VOLTA";-1
"AKTARUS_QC";"AYREON";-1
"AKTARUS_QC";"REEL BIG FISH";-1
"AKTARUS_QC";"JETHRO TULL";-1
"AKTARUS_QC";"THE BRAVERY";-1
"AKTARUS_QC";"30 SECONDS TO MARS";-1
"AKTARUS_QC";"HARMONIUM";-1
"AKTARUS_QC";"TOOL";-1
"AKTARUS_QC";"SATANIC SURFERS";-1
"AKTARUS_QC";"WE ARE SCIENTISTS";-1
"AKTARUS_QC";"GOLDFINGER";-1
"AKTARUS_QC";"ARTISTES VARIES";90
"AKTARUS_QC";"BAD RELIGION";90
"AKTARUS_QC";"AVENGED SEVENFOLD";90
"AKTARUS_QC";"LE BUTCHERETTES";90
"AKTARUS_QC";"TOOL";90
"AKTARUS_QC";"RUSH";90
"AKTARUS_QC";"EELS";90
"AKTARUS_QC";"IRON MAIDEN";90
"AKTARUS_QC";"DREAM THEATER";90
"AKTARUS_QC";"ASTRA";90
"AKTARUS_QC";"PINK FLOYD";90
"AKTARUS_QC";"ZECHS MARQUISE";90
"AKTARUS_QC";"MIGHTY MIDGETS";90
"AKTARUS_QC";"RESISTORS";90
"AKTARUS_QC";"TIME GRID";90
"AKTARUS_QC";"STRATOVARIUS";90
"AKTARUS_QC";"THE USED";90
"AKTARUS_QC";"BULLET FOR MY VALENTINE";90
"AKTARUS_QC";"RED";90
"AKTARUS_QC";"ANYWHERE";90
"AKTARUS_QC";"SELLFISH";90
"AKTARUS_QC";"FRIGHTENED RABBIT";90
"AKTARUS_QC";"DISPERSE";90
"AKTARUS_QC";"SWINGIN' UTTERS";90
"AKTARUS_QC";"GEARBOX";90
"AKTARUS_QC";"LANA LANE";90
"AKTARUS_QC";"NEAL MORSE";90
"AKTARUS_QC";"SILVERSTEIN";90
"AKTARUS_QC";"MUCKHOLE";90
"AKTARUS_QC";"LOCAL RESIDENT FAILURE";90
"AKTARUS_QC";"STRUGGLING FOR REASON";90
"AKTARUS_QC";"HERD OF INSTINCT";90
"AKTARUS_QC";"GENESIS";90
"AKTARUS_QC";"APOCALYPTICA";90
"AKTARUS_QC";"IRON BUTTERFLY";90
"AKTARUS_QC";"COHEED AND CAMBRIA";90
"AKTARUS_QC";"LIQUID TENSION EXPERIMENT";90
"AKTARUS_QC";"AYREON";90
"AKTARUS_QC";"PINK CREAM 69";90
"AKTARUS_QC";"MAGELLAN";90
"AKTARUS_QC";"THE DEFINITIVE MEASURE";90
"AKTARUS_QC";"PRISMA";90
"AKTARUS_QC";"RUBBERNECK";90
"AKTARUS_QC";"OMAR A. RODRIGUEZ-LOPEZ";90
"AKTARUS_QC";"PULLEY";90
"AKTARUS_QC";"311";90
"AKTARUS_QC";"FUNERAL FOR A FRIEND";90
"AKTARUS_QC";"BIFFY CLYRO";90
"AKTARUS_QC";"CIRCLE II CIRCLE";90
"AKTARUS_QC";"MANILLA ROAD";90
"AKTARUS_QC";"ARTISTES VARIES";180
"AKTARUS_QC";"AVENGED SEVENFOLD";180
"AKTARUS_QC";"MUSE";180
"AKTARUS_QC";"BAD RELIGION";180
"AKTARUS_QC";"RUSH";180
"AKTARUS_QC";"TOOL";180
"AKTARUS_QC";"LE BUTCHERETTES";180
"AKTARUS_QC";"DREAM THEATER";180
"AKTARUS_QC";"IRON MAIDEN";180
"AKTARUS_QC";"NOFX";180
"AKTARUS_QC";"EELS";180
"AKTARUS_QC";"ASTRA";180
"AKTARUS_QC";"PINK FLOYD";180
"AKTARUS_QC";"STEVE HACKETT";180
"AKTARUS_QC";"ZECHS MARQUISE";180
"AKTARUS_QC";"AYREON";180
"AKTARUS_QC";"ANYWHERE";180
"AKTARUS_QC";"DEVIN TOWNSEND PROJECT";180
"AKTARUS_QC";"MOON DUO";180
"AKTARUS_QC";"PRISMA";180
"AKTARUS_QC";"NO USE FOR A NAME";180
"AKTARUS_QC";"PULLEY";180
"AKTARUS_QC";"NEAL MORSE";180
"AKTARUS_QC";"MIGHTY MIDGETS";180
"AKTARUS_QC";"IRON BUTTERFLY";180
"AKTARUS_QC";"LANA LANE";180
"AKTARUS_QC";"RESISTORS";180
"AKTARUS_QC";"THE USED";180
"AKTARUS_QC";"MOSTLY AUTUMN";180
"AKTARUS_QC";"MAGELLAN";180
"AKTARUS_QC";"OMAR A. RODRIGUEZ-LOPEZ";180
"AKTARUS_QC";"BULLET FOR MY VALENTINE";180
"AKTARUS_QC";"LIQUID TENSION EXPERIMENT";180
"AKTARUS_QC";"TIME GRID";180
"AKTARUS_QC";"KING CRIMSON";180
"AKTARUS_QC";"APOCALYPTICA";180
"AKTARUS_QC";"STRATOVARIUS";180
"AKTARUS_QC";"TRANS-SIBERIAN ORCHESTRA";180
"AKTARUS_QC";"FACE TO FACE";180
"AKTARUS_QC";"LIQUID TRIO EXPERIMENT";180
"AKTARUS_QC";"YES";180
"AKTARUS_QC";"LAGWAGON";180
"AKTARUS_QC";"GHOST";180
"AKTARUS_QC";"GENESIS";180
"AKTARUS_QC";"JETHRO TULL";180
"AKTARUS_QC";"RED";180
"AKTARUS_QC";"JAMES LABRIE";180
"AKTARUS_QC";"SELLFISH";180
"AKTARUS_QC";"TONY SLY";180
"AKTARUS_QC";"TEN FOOT POLE";180
"AKTARUS_QC";"ARTISTES VARIES";360
"AKTARUS_QC";"RUSH";360
"AKTARUS_QC";"AVENGED SEVENFOLD";360
"AKTARUS_QC";"MUSE";360
"AKTARUS_QC";"BAD RELIGION";360
"AKTARUS_QC";"MAXÏMO PARK";360
"AKTARUS_QC";"IRON MAIDEN";360
"AKTARUS_QC";"PENNYWISE";360
"AKTARUS_QC";"NOFX";360
"AKTARUS_QC";"NO USE FOR A NAME";360
"AKTARUS_QC";"MILLENCOLIN";360
"AKTARUS_QC";"REEL BIG FISH";360
"AKTARUS_QC";"DREAM THEATER";360
"AKTARUS_QC";"TOOL";360
"AKTARUS_QC";"AYREON";360
"AKTARUS_QC";"FACE TO FACE";360
"AKTARUS_QC";"FIVE FINGER DEATH PUNCH";360
"AKTARUS_QC";"OMAR A. RODRIGUEZ-LOPEZ";360
"AKTARUS_QC";"PULLEY";360
"AKTARUS_QC";"LAGWAGON";360
"AKTARUS_QC";"LE BUTCHERETTES";360
"AKTARUS_QC";"THE BOUNCING SOULS";360
"AKTARUS_QC";"TONY SLY";360
"AKTARUS_QC";"STRUGGLING FOR REASON";360
"AKTARUS_QC";"PINK FLOYD";360
"AKTARUS_QC";"STRUNG OUT";360
"AKTARUS_QC";"ZECHS MARQUISE";360
"AKTARUS_QC";"GOOD RIDDANCE";360
"AKTARUS_QC";"LESS THAN JAKE";360
"AKTARUS_QC";"PRISMA";360
"AKTARUS_QC";"TEN FOOT POLE";360
"AKTARUS_QC";"ASTRA";360
"AKTARUS_QC";"EELS";360
"AKTARUS_QC";"METALLICA";360
"AKTARUS_QC";"SHINEDOWN";360
"AKTARUS_QC";"STEVE HACKETT";360
"AKTARUS_QC";"SECOND SHOT";360
"AKTARUS_QC";"MXPX";360
"AKTARUS_QC";"NIKSON";360
"AKTARUS_QC";"BILLY TALENT";360
"AKTARUS_QC";"SYMPHONY OF DISTRACTION";360
"AKTARUS_QC";"EPICA";360
"AKTARUS_QC";"ANYWHERE";360
"AKTARUS_QC";"DEBELI PRECJEDNIK";360
"AKTARUS_QC";"JOEY CAPE";360
"AKTARUS_QC";"SATANIC SURFERS";360
"AKTARUS_QC";"DOWN BY LAW";360
"AKTARUS_QC";"DEVIN TOWNSEND PROJECT";360
"AKTARUS_QC";"METRIC";360
"AKTARUS_QC";"VENEREA";360

Hope this will help you to help me

MERCI

[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!