by MosquitoLoco » Tue May 26, 2009 12:11 pm
ZvezdanD wrote:Which MM version exactly? Which version of MN script? You could turn on the "Allow editing of SQL queries", "...when expand field nodes" and "...for the Unknown node" in the Options dialog box, copy the SQL query which you get before the error message and post it here.
MM ver: 3.0.6.1190
Magic Nodes 2.4
As for the error msg:
Code: Select all
SELECT Count(*) AS StatField0 FROM Songs , ArtistsSongs AS AArtistsSongs, Artists AS SongArtists LEFT JOIN ArtistsSongs AS AArtistsSongs ON Songs.ID = AArtistsSongs.IDSong AND (AArtistsSongs.PersonType = 1 OR AArtistsSongs.PersonType IS NULL) LEFT JOIN Artists AS SongArtists ON AArtistsSongs.IDArtist = SongArtists.ID WHERE (Songs.ID IN (SELECT Songs.ID FROM Songs, ArtistsSongs, Artists WHERE Songs.ID = ArtistsSongs.IDSong AND (ArtistsSongs.PersonType = 1 OR ArtistsSongs.PersonType IS NULL) AND ArtistsSongs.IDArtist = Artists.ID AND Artists.Artist IN (SELECT Artists.Artist FROM Songs, ArtistsSongs, Artists WHERE Songs.ID = ArtistsSongs.IDSong AND (ArtistsSongs.PersonType = 1 OR ArtistsSongs.PersonType IS NULL) AND ArtistsSongs.IDArtist = Artists.ID GROUP BY Artists.Artist HAVING Count(*) >= 2 AND ',' || group_concat(Custom5) || ',' LIKE '%,new,%'))) AND Songs.ID = AArtistsSongs.IDSong AND AArtistsSongs.IDArtist = SongArtists.ID AND (AArtistsSongs.PersonType = 1 OR AArtistsSongs.PersonType IS NULL) AND NOT Songs.Custom5 <> ''
It happens when I try to expand the mask node, I get the Ambiguous column name error.
Thanks!
Mosquito
[quote="ZvezdanD"]Which MM version exactly? Which version of MN script? You could turn on the "Allow editing of SQL queries", "...when expand field nodes" and "...for the Unknown node" in the Options dialog box, copy the SQL query which you get before the error message and post it here.[/quote]
MM ver: 3.0.6.1190
Magic Nodes 2.4
As for the error msg:
[code]SELECT Count(*) AS StatField0 FROM Songs , ArtistsSongs AS AArtistsSongs, Artists AS SongArtists LEFT JOIN ArtistsSongs AS AArtistsSongs ON Songs.ID = AArtistsSongs.IDSong AND (AArtistsSongs.PersonType = 1 OR AArtistsSongs.PersonType IS NULL) LEFT JOIN Artists AS SongArtists ON AArtistsSongs.IDArtist = SongArtists.ID WHERE (Songs.ID IN (SELECT Songs.ID FROM Songs, ArtistsSongs, Artists WHERE Songs.ID = ArtistsSongs.IDSong AND (ArtistsSongs.PersonType = 1 OR ArtistsSongs.PersonType IS NULL) AND ArtistsSongs.IDArtist = Artists.ID AND Artists.Artist IN (SELECT Artists.Artist FROM Songs, ArtistsSongs, Artists WHERE Songs.ID = ArtistsSongs.IDSong AND (ArtistsSongs.PersonType = 1 OR ArtistsSongs.PersonType IS NULL) AND ArtistsSongs.IDArtist = Artists.ID GROUP BY Artists.Artist HAVING Count(*) >= 2 AND ',' || group_concat(Custom5) || ',' LIKE '%,new,%'))) AND Songs.ID = AArtistsSongs.IDSong AND AArtistsSongs.IDArtist = SongArtists.ID AND (AArtistsSongs.PersonType = 1 OR AArtistsSongs.PersonType IS NULL) AND NOT Songs.Custom5 <> ''[/code]
It happens when I try to expand the mask node, I get the Ambiguous column name error.
Thanks!
Mosquito