Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2+]

[ZvezdanD]

"Error executing SQL "Select Count(*) As Count_ Unknown FROM Songs WHERE (Songs.lyrics = ") AND Songs.Id = Memos.Idsongs AND Memos.MemoType = 20000)
": No such column: Memos.MemoType (1, 1)

This SQL query is a strange combination of the code for MM2 and MM3. Which versions of MediaMonkey and Magic Nodes are you using?

[Weatherman]

Hi again.

I am using MM3 version 3.1.0.1209 (Gold Lifetime) and Magic Nodes 2.4
Jim

[Bex]

I'm not sure it will help in this case but you're using a very old beta of MM 3.1. Download the latest (currently 1235) from the last post here:
http://www.mediamonkey.com/forum/viewto ... =6&t=34522

[Weatherman]

Thanks for your help. I will try this. I didn't realise my version was so old...I was hanging on till the next release.
I'm very grateful for your help.
Jim

[ZvezdanD]

Well, it is not so old. I will try to install exactly that version to see if I could reproduce a problem.

[ZvezdanD]

Just tried and as I supposed this old MM version works as it should. Only thing which comes to my mind is that you have old Pablos's version of the script (with the 1.3 version number in the filename) together in same Auto folder as the new version of the script.

[Weatherman]

I just upgraded to latest version of MM. I removed all magic nodes reference files and reinstalled magic nodes (I had exported my favourite nodes).

It all works perfectly.

Many thanks. Much appreciated.
happy easter.
Jim

[raybeau528]

ZvezdadD,

I have many Audiobooks (in MP3) and wrote this Magic Nodes mask to display just the Audiobooks by Album name. Makes it easy to find/select a book and its chapters.

Code: Select all

AudioBooks|Icon:Top level|Filter:<Genre> = "AudioBook"\<Genre|Statistic:Count(Album)>\<Album|Statistic:Count(All)>\<Artist>

Thanks for this great tool!

Ray

[nynaevelan]

It's your favorite SQL PITA again, I want to make a Magic Node that lists the name of playlists for playlists which are in the DeviceTracks table and have the IDDevice of 67 but I am having trouble. This is what I came up with but it isn't working. Can you help me?

Code: Select all

<Group|Name:Played>\<Group|Name:Playlist Info>\X-Fi Playlist Sync List|Icon:Top level|SQL filter: Songs.ID IN (SELECT IDTrack FROM DeviceTracks) AND IDDevice = 67\<Artist>\<Title>\<Playlist|Unknown:No>

Be gentle, you know I do not know anything about SQL.

Nyn

[ZvezdanD]

I want to make a Magic Node that lists the name of playlists for playlists which are in the DeviceTracks table and have the IDDevice of 67

I don't understand that "playlists" part and I am not sure if this will work, but you could try:

Code: Select all

<Group|Name:Played>\<Group|Name:Playlist Info>\X-Fi Playlist Sync List|Icon:Top level|SQL filter: Songs.ID IN (SELECT IDTrack FROM DeviceTracks WHERE IDDevice = 67)\<Artist>\<Title>\<Playlist|Unknown:No>

Be gentle, you know I do not know anything about SQL.

Why are you telling this? Is there somebody who haven't been gentle to you? By the way, I do not agree that you don't know anything about SQL. You are much better than many.

[nynaevelan]

I want to make a Magic Node that lists the name of playlists for playlists which are in the DeviceTracks table and have the IDDevice of 67

I don't understand that "playlists" part and I am not sure if this will work, but you could try:

Code: Select all

<Group|Name:Played>\<Group|Name:Playlist Info>\X-Fi Playlist Sync List|Icon:Top level|SQL filter: Songs.ID IN (SELECT IDTrack FROM DeviceTracks WHERE IDDevice = 67)\<Artist>\<Title>\<Playlist|Unknown:No>

Thanks, the SQL works the way I want I just have to tweak it to list the actual playlist names, but I've been a little busy with something else so will test it in the next day or two.

Be gentle, you know I do not know anything about SQL.

Why are you telling this? Is there somebody who haven't been gentle to you? By the way, I do not agree that you don't know anything about SQL. You are much better than many.

If I am better than some than it is through no skill of mine, it is due to the assistance of you SQL experts, especially you, Bex and SBondi. Half the time I do not understand what I am looking at but I "think" I am pretty good at explaining what it is I want. I just hope I do not nag you all too much because without you my MM would be very plain and unorganized.

Nyn

[Big Isch]

Hi,
by using the simple Node:

Code: Select all

My Artist\<Artist|Statistic:Count(Items)>\<Album|Statistic:Count(Tracks)>

In MM 3.0.3.1148, the nodes dispalyed show e.g. "(12 Albums)" and "(144 tracks)",
but with MM 3.0.7.1191 nodes show "(12 Albums)" and "(144)" without "tracks".

Anyone any idea ?

[aprzybylo]

Hello,
I have the problem with ratings. I created magic node where I display albums based on total of songs ratings. If I rate all songs then the total is correct. Also if I use bomb the total is correct (bomb being counter as 0). However if I leave one tract without rating my album disappears from the list (not sure if it is completely out or just no rating is counted as some negetive number and album is much lower in the list). Any idea how could I correct this without using "bomb" as 0 rating?

[ZvezdanD]

In MM 3.0.3.1148, the nodes dispalyed show e.g. "(12 Albums)" and "(144 tracks)",
but with MM 3.0.7.1191 nodes show "(12 Albums)" and "(144)" without "tracks".

This should not happen, especially should not have anything related to the version of MM. I just have installed mentioned MM version and everything is fine. You haven't mentioned which version of the script you are using, but I don't remember that any version had such behavior.

By the way, if you are using MM3 and MN 1.8 or up, it is better (faster) to use Count(Album) than Count(Items).

[ZvezdanD]

if I leave one tract without rating my album disappears from the list

Have you tried to turn off the option Tools / Options / Magic Nodes Settings / Display sorting/statistic results only if all values are defined?