Page 68 of 163

Re: Magic Nodes 2.4 w/ 170+ masks & real GUI (2009-02-20)[MM2+3]

Posted: Mon Apr 13, 2009 8:10 am
by ZvezdanD
Weatherman wrote:"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?

Re: Magic Nodes 2.4 w/ 170+ masks & real GUI (2009-02-20)[MM2+3]

Posted: Mon Apr 13, 2009 8:24 am
by Weatherman
Hi again.

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

Re: Magic Nodes 2.4 w/ 170+ masks & real GUI (2009-02-20)[MM2+3]

Posted: Mon Apr 13, 2009 8:28 am
by 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

Re: Magic Nodes 2.4 w/ 170+ masks & real GUI (2009-02-20)[MM2+3]

Posted: Mon Apr 13, 2009 8:37 am
by 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

Re: Magic Nodes 2.4 w/ 170+ masks & real GUI (2009-02-20)[MM2+3]

Posted: Mon Apr 13, 2009 8:50 am
by ZvezdanD
Well, it is not so old. I will try to install exactly that version to see if I could reproduce a problem.

Re: Magic Nodes 2.4 w/ 170+ masks & real GUI (2009-02-20)[MM2+3]

Posted: Mon Apr 13, 2009 10:08 am
by 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.

Re: Magic Nodes 2.4 w/ 170+ masks & real GUI (2009-02-20)[MM2+3]

Posted: Mon Apr 13, 2009 11:01 am
by 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

Re: Magic Nodes 2.4 w/ 170+ masks & real GUI (2009-02-20)[MM2+3]

Posted: Mon Apr 20, 2009 10:07 am
by 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

Re: Magic Nodes 2.4 w/ 170+ masks & real GUI (2009-02-20)[MM2+3]

Posted: Wed Apr 22, 2009 7:26 pm
by 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. :wink:

Nyn

Re: Magic Nodes 2.4 w/ 170+ masks & real GUI (2009-02-20)[MM2+3]

Posted: Thu Apr 23, 2009 1:43 am
by ZvezdanD
nynaevelan wrote: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>
nynaevelan wrote:Be gentle, you know I do not know anything about SQL. :wink:
:D 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.

Re: Magic Nodes 2.4 w/ 170+ masks & real GUI (2009-02-20)[MM2+3]

Posted: Thu Apr 23, 2009 5:07 pm
by nynaevelan
ZvezdanD wrote:
nynaevelan wrote: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.
ZvezdanD wrote:
nynaevelan wrote:Be gentle, you know I do not know anything about SQL. :wink:
:D 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.
:lol: 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. :wink:

Nyn

Re: Magic Nodes 2.4 w/ 170+ masks & real GUI (2009-02-20)[MM2+3]

Posted: Thu Apr 30, 2009 5:55 am
by 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 ? :roll:

Re: Magic Nodes 2.4 w/ 170+ masks & real GUI (2009-02-20)[MM2+3]

Posted: Thu Apr 30, 2009 10:20 am
by 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?

Re: Magic Nodes 2.4 w/ 170+ masks & real GUI (2009-02-20)[MM2+3]

Posted: Thu Apr 30, 2009 10:32 am
by ZvezdanD
Big Isch wrote: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).

Re: Magic Nodes 2.4 w/ 170+ masks & real GUI (2009-02-20)[MM2+3]

Posted: Thu Apr 30, 2009 10:35 am
by ZvezdanD
aprzybylo wrote: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?