Thank you,
you are right, this is a regression introduced in RC2, the searching for 'Any text field' in the advanced section is really broken and freezes MM (the SQL is not creating right). Will be fixed in RC3.

FROM Songs WHERE (((Songs.SongTitle like '%BG%' OR Songs.Album like '%BG%' OR Songs.Artist like '%BG%' OR exists (select null from Albums where Albums.Id=Songs.IdAlbum and Albums.Comment like '%BG%') OR exists (select null from Artists, ArtistsSongs where ArtistsSongs.IDSong=Songs.ID and ArtistsSongs.IDArtist=Artists.ID and Artists.Comment like '%BG%') OR Songs.Author like '%BG%' OR Songs.Custom1 like '%BG%' OR Songs.Custom2 like '%BG%' OR Songs.Custom3 like '%BG%' OR Songs.Custom4 like '%BG%' OR Songs.Custom5 like '%BG%' OR (Songs.SongPath like '%BG%') OR Songs.Copyright like '%BG%' OR Songs.Publisher like '%BG%' OR Songs.Encoder like '%BG%' OR Songs.Lyricist like '%BG%' OR Songs.Conductor like '%BG%' OR Songs.InvolvedPeople like '%BG%' OR Songs.OrigTitle like '%BG%' OR Songs.OrigArtist like '%BG%' OR Songs.OrigLyricist like '%BG%' OR Songs.GroupDesc like '%BG%' OR Songs.SubTitle like '%BG%' OR Songs.ISRC like '%BG%' OR Songs.MediaType like '%BG%' OR Songs.Tempo like '%BG%' OR Songs.Mood like '%BG%' OR Songs.Quality like '%BG%' OR Songs.Occasion like '%BG%' OR Songs.Lyrics like '%BG%' OR Songs.Comment like '%BG%' OR Songs.Genre like '%BG%'  )AND( Songs.SongTitle like '%Bulletwound%' OR Songs.Album like '%Bulletwound%' OR Songs.Artist like '%Bulletwound%' OR exists (select null from Albums where Albums.Id=Songs.IdAlbum and Albums.Comment like '%Bulletwound%') OR exists (select null from Artists, ArtistsSongs where ArtistsSongs.IDSong=Songs.ID and ArtistsSongs.IDArtist=Artists.ID and Artists.Comment like '%Bulletwound%') OR Songs.Author like '%Bulletwound%' OR Songs.Custom1 like '%Bulletwound%' OR Songs.Custom2 like '%Bulletwound%' OR Songs.Custom3 like '%Bulletwound%' OR Songs.Custom4 like '%Bulletwound%' OR Songs.Custom5 like '%Bulletwound%' OR (Songs.SongPath like '%Bulletwound%') OR Songs.Copyright like '%Bulletwound%' OR Songs.Publisher like '%Bulletwound%' OR Songs.Encoder like '%Bulletwound%' OR Songs.Lyricist like '%Bulletwound%' OR Songs.Conductor like '%Bulletwound%' OR Songs.InvolvedPeople like '%Bulletwound%' OR Songs.OrigTitle like '%Bulletwound%' OR Songs.OrigArtist like '%Bulletwound%' OR Songs.OrigLyricist like '%Bulletwound%' OR Songs.GroupDesc like '%Bulletwound%' OR Songs.SubTitle like '%Bulletwound%' OR Songs.ISRC like '%Bulletwound%' OR Songs.MediaType like '%Bulletwound%' OR Songs.Tempo like '%Bulletwound%' OR Songs.Mood like '%Bulletwound%' OR Songs.Quality like '%Bulletwound%' OR Songs.Occasion like '%Bulletwound%' OR Songs.Lyrics like '%Bulletwound%' OR Songs.Comment like '%Bulletwound%' OR Songs.Genre like '%Bulletwound%' )))

FROM Songs WHERE  Songs.ID IN (select ArtistsSongs.IDSong from ArtistsSongs, Artists where ArtistsSongs.IDArtist=Artists.ID  AND ArtistsSongs.PersonType = 1 and (((Songs.SongTitle like '%BG%' OR Songs.Album like '%BG%' OR Songs.Artist like '%BG%' OR exists (select null from Albums where Albums.Id=Songs.IdAlbum and Albums.Comment like '%BG%') OR exists (select null from Artists, ArtistsSongs where ArtistsSongs.IDSong=Songs.ID and ArtistsSongs.IDArtist=Artists.ID and Artists.Comment like '%BG%') OR Songs.Author like '%BG%' OR Songs.Custom1 like '%BG%' OR Songs.Custom2 like '%BG%' OR Songs.Custom3 like '%BG%' OR Songs.Custom4 like '%BG%' OR Songs.Custom5 like '%BG%' OR (Songs.SongPath like '%BG%') OR Songs.Copyright like '%BG%' OR Songs.Publisher like '%BG%' OR Songs.Encoder like '%BG%' OR Songs.Lyricist like '%BG%' OR Songs.Conductor like '%BG%' OR Songs.InvolvedPeople like '%BG%' OR Songs.OrigTitle like '%BG%' OR Songs.OrigArtist like '%BG%' OR Songs.OrigLyricist like '%BG%' OR Songs.GroupDesc like '%BG%' OR Songs.SubTitle like '%BG%' OR Songs.ISRC like '%BG%' OR Songs.MediaType like '%BG%' OR Songs.Tempo like '%BG%' OR Songs.Mood like '%BG%' OR Songs.Quality like '%BG%' OR Songs.Occasion like '%BG%' OR Songs.Lyrics like '%BG%' OR Songs.Comment like '%BG%' OR Songs.Genre like '%BG%'  )AND( Songs.SongTitle like '%Bulletwound%' OR Songs.Album like '%Bulletwound%' OR Songs.Artist like '%Bulletwound%' OR exists (select null from Albums where Albums.Id=Songs.IdAlbum and Albums.Comment like '%Bulletwound%') OR exists (select null from Artists, ArtistsSongs where ArtistsSongs.IDSong=Songs.ID and ArtistsSongs.IDArtist=Artists.ID and Artists.Comment like '%Bulletwound%') OR Songs.Author like '%Bulletwound%' OR Songs.Custom1 like '%Bulletwound%' OR Songs.Custom2 like '%Bulletwound%' OR Songs.Custom3 like '%Bulletwound%' OR Songs.Custom4 like '%Bulletwound%' OR Songs.Custom5 like '%Bulletwound%' OR (Songs.SongPath like '%Bulletwound%') OR Songs.Copyright like '%Bulletwound%' OR Songs.Publisher like '%Bulletwound%' OR Songs.Encoder like '%Bulletwound%' OR Songs.Lyricist like '%Bulletwound%' OR Songs.Conductor like '%Bulletwound%' OR Songs.InvolvedPeople like '%Bulletwound%' OR Songs.OrigTitle like '%Bulletwound%' OR Songs.OrigArtist like '%Bulletwound%' OR Songs.OrigLyricist like '%Bulletwound%' OR Songs.GroupDesc like '%Bulletwound%' OR Songs.SubTitle like '%Bulletwound%' OR Songs.ISRC like '%Bulletwound%' OR Songs.MediaType like '%Bulletwound%' OR Songs.Tempo like '%Bulletwound%' OR Songs.Mood like '%Bulletwound%' OR Songs.Quality like '%Bulletwound%' OR Songs.Occasion like '%Bulletwound%' OR Songs.Lyrics like '%Bulletwound%' OR Songs.Comment like '%Bulletwound%' OR Songs.Genre like '%Bulletwound%' ))))

Ok, finally was able to get DebugView to download. Started up MM3RC2 and went through the process of creating two different playlists. One used the Basic 'Any Text Field' of "BG Bulletwound" and was presented with all 57 tracks in the matter of a few seconds. On the second playlist, used the Advanced 'Any Text Field' method for "BG Bulletwound" and roughly 10 minutes later MM3 had only filled the main window with 18 of the 57 tracks before freezing for several minutes at which point I 'End Tasked' it.

I will include the log file from DebugView at the bottom, but the one thing I did notice is that the SQL statements were different for the two 'Any Text Field' playlists.

Basic 'Any Text Field':
[code]FROM Songs WHERE (((Songs.SongTitle like '%BG%' OR Songs.Album like '%BG%' OR Songs.Artist like '%BG%' OR exists (select null from Albums where Albums.Id=Songs.IdAlbum and Albums.Comment like '%BG%') OR exists (select null from Artists, ArtistsSongs where ArtistsSongs.IDSong=Songs.ID and ArtistsSongs.IDArtist=Artists.ID and Artists.Comment like '%BG%') OR Songs.Author like '%BG%' OR Songs.Custom1 like '%BG%' OR Songs.Custom2 like '%BG%' OR Songs.Custom3 like '%BG%' OR Songs.Custom4 like '%BG%' OR Songs.Custom5 like '%BG%' OR (Songs.SongPath like '%BG%') OR Songs.Copyright like '%BG%' OR Songs.Publisher like '%BG%' OR Songs.Encoder like '%BG%' OR Songs.Lyricist like '%BG%' OR Songs.Conductor like '%BG%' OR Songs.InvolvedPeople like '%BG%' OR Songs.OrigTitle like '%BG%' OR Songs.OrigArtist like '%BG%' OR Songs.OrigLyricist like '%BG%' OR Songs.GroupDesc like '%BG%' OR Songs.SubTitle like '%BG%' OR Songs.ISRC like '%BG%' OR Songs.MediaType like '%BG%' OR Songs.Tempo like '%BG%' OR Songs.Mood like '%BG%' OR Songs.Quality like '%BG%' OR Songs.Occasion like '%BG%' OR Songs.Lyrics like '%BG%' OR Songs.Comment like '%BG%' OR Songs.Genre like '%BG%' )AND( Songs.SongTitle like '%Bulletwound%' OR Songs.Album like '%Bulletwound%' OR Songs.Artist like '%Bulletwound%' OR exists (select null from Albums where Albums.Id=Songs.IdAlbum and Albums.Comment like '%Bulletwound%') OR exists (select null from Artists, ArtistsSongs where ArtistsSongs.IDSong=Songs.ID and ArtistsSongs.IDArtist=Artists.ID and Artists.Comment like '%Bulletwound%') OR Songs.Author like '%Bulletwound%' OR Songs.Custom1 like '%Bulletwound%' OR Songs.Custom2 like '%Bulletwound%' OR Songs.Custom3 like '%Bulletwound%' OR Songs.Custom4 like '%Bulletwound%' OR Songs.Custom5 like '%Bulletwound%' OR (Songs.SongPath like '%Bulletwound%') OR Songs.Copyright like '%Bulletwound%' OR Songs.Publisher like '%Bulletwound%' OR Songs.Encoder like '%Bulletwound%' OR Songs.Lyricist like '%Bulletwound%' OR Songs.Conductor like '%Bulletwound%' OR Songs.InvolvedPeople like '%Bulletwound%' OR Songs.OrigTitle like '%Bulletwound%' OR Songs.OrigArtist like '%Bulletwound%' OR Songs.OrigLyricist like '%Bulletwound%' OR Songs.GroupDesc like '%Bulletwound%' OR Songs.SubTitle like '%Bulletwound%' OR Songs.ISRC like '%Bulletwound%' OR Songs.MediaType like '%Bulletwound%' OR Songs.Tempo like '%Bulletwound%' OR Songs.Mood like '%Bulletwound%' OR Songs.Quality like '%Bulletwound%' OR Songs.Occasion like '%Bulletwound%' OR Songs.Lyrics like '%Bulletwound%' OR Songs.Comment like '%Bulletwound%' OR Songs.Genre like '%Bulletwound%' )))[/code]

Advanced 'Any Text Field':
[code]FROM Songs WHERE Songs.ID IN (select ArtistsSongs.IDSong from ArtistsSongs, Artists where ArtistsSongs.IDArtist=Artists.ID AND ArtistsSongs.PersonType = 1 and (((Songs.SongTitle like '%BG%' OR Songs.Album like '%BG%' OR Songs.Artist like '%BG%' OR exists (select null from Albums where Albums.Id=Songs.IdAlbum and Albums.Comment like '%BG%') OR exists (select null from Artists, ArtistsSongs where ArtistsSongs.IDSong=Songs.ID and ArtistsSongs.IDArtist=Artists.ID and Artists.Comment like '%BG%') OR Songs.Author like '%BG%' OR Songs.Custom1 like '%BG%' OR Songs.Custom2 like '%BG%' OR Songs.Custom3 like '%BG%' OR Songs.Custom4 like '%BG%' OR Songs.Custom5 like '%BG%' OR (Songs.SongPath like '%BG%') OR Songs.Copyright like '%BG%' OR Songs.Publisher like '%BG%' OR Songs.Encoder like '%BG%' OR Songs.Lyricist like '%BG%' OR Songs.Conductor like '%BG%' OR Songs.InvolvedPeople like '%BG%' OR Songs.OrigTitle like '%BG%' OR Songs.OrigArtist like '%BG%' OR Songs.OrigLyricist like '%BG%' OR Songs.GroupDesc like '%BG%' OR Songs.SubTitle like '%BG%' OR Songs.ISRC like '%BG%' OR Songs.MediaType like '%BG%' OR Songs.Tempo like '%BG%' OR Songs.Mood like '%BG%' OR Songs.Quality like '%BG%' OR Songs.Occasion like '%BG%' OR Songs.Lyrics like '%BG%' OR Songs.Comment like '%BG%' OR Songs.Genre like '%BG%' )AND( Songs.SongTitle like '%Bulletwound%' OR Songs.Album like '%Bulletwound%' OR Songs.Artist like '%Bulletwound%' OR exists (select null from Albums where Albums.Id=Songs.IdAlbum and Albums.Comment like '%Bulletwound%') OR exists (select null from Artists, ArtistsSongs where ArtistsSongs.IDSong=Songs.ID and ArtistsSongs.IDArtist=Artists.ID and Artists.Comment like '%Bulletwound%') OR Songs.Author like '%Bulletwound%' OR Songs.Custom1 like '%Bulletwound%' OR Songs.Custom2 like '%Bulletwound%' OR Songs.Custom3 like '%Bulletwound%' OR Songs.Custom4 like '%Bulletwound%' OR Songs.Custom5 like '%Bulletwound%' OR (Songs.SongPath like '%Bulletwound%') OR Songs.Copyright like '%Bulletwound%' OR Songs.Publisher like '%Bulletwound%' OR Songs.Encoder like '%Bulletwound%' OR Songs.Lyricist like '%Bulletwound%' OR Songs.Conductor like '%Bulletwound%' OR Songs.InvolvedPeople like '%Bulletwound%' OR Songs.OrigTitle like '%Bulletwound%' OR Songs.OrigArtist like '%Bulletwound%' OR Songs.OrigLyricist like '%Bulletwound%' OR Songs.GroupDesc like '%Bulletwound%' OR Songs.SubTitle like '%Bulletwound%' OR Songs.ISRC like '%Bulletwound%' OR Songs.MediaType like '%Bulletwound%' OR Songs.Tempo like '%Bulletwound%' OR Songs.Mood like '%Bulletwound%' OR Songs.Quality like '%Bulletwound%' OR Songs.Occasion like '%Bulletwound%' OR Songs.Lyrics like '%Bulletwound%' OR Songs.Comment like '%Bulletwound%' OR Songs.Genre like '%Bulletwound%' ))))[/code]

The Advanced version is a little longer then the Basic, aswell as structured differently. I can't really tell other differences because I'm not exactly an SQL Master, but those two things stood out. Could this be part of the problem? Or maybe they're different for a reason and nothing out of the ordinary. *Shrugs*

Log File:
http://h1.ripway.com/MizeryMade/AnyTextFieldIssue.log

Can't get MM3 to produce a log itself, and I can't get the site for DBView or whatever that program is to let me download, so don't know what I can do.

Anyway, it is acting a little different this evening then it was this morning. The 'Any Text Field' under the 'Basic' tab acts perfectly fine now, could of swore it was also acting up this morning but I might have been mistaken. The 'Any Text Field' in 'Advanced' makes MM3 throw a fit though.

Using the Basic option allows the playlist to generate it's list almost immediately after clicking the playlist/node. However, the Advanced version will freeze MM3 for a bit, then finally start to fill the main view with the matching tracks... about 1 track added a minute. All during this, MM3 is eating up 80+ CPU.

I'll keep trying to get the debug though. :\

[b]EDIT:[/b] It might not do you as much good as a Debug Log from me, but maybe I could send you my database which already has a playlist that is effected by this, maybe then you could try loading that database into your copy of MM3RC2 and see if you get the same result when trying to open that playlist. Just a thought. *Shrugs*

Works great for me...

Mizery_made,

Can you send me a debug log? I can't reproduce this.

Anyone else seeing this problem?

-Rusty

The 'Any Text Field' for Search & AutoPlaylist appears broken. With a search, it results in, well, no results. In AutoPlaylist however, it results in a nice & frosty MM3 (Frozen).