RC2: Any Text Field [F3974 RC3]

Beta Testing for Windows Products and plugins

Moderator: Gurus

Mizery_Made
Posts: 2283
Joined: Tue Aug 29, 2006 1:09 pm
Location: Kansas City, Missouri, United States

RC2: Any Text Field [F3974 RC3]

Post by Mizery_Made »

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).
rusty
Posts: 8393
Joined: Tue Apr 29, 2003 3:39 am
Location: Montreal, Canada

Search any text field problem

Post by rusty »

Mizery_made,

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

Anyone else seeing this problem?

-Rusty
Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Post by Bex »

Works great for me...
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts
Mizery_Made
Posts: 2283
Joined: Tue Aug 29, 2006 1:09 pm
Location: Kansas City, Missouri, United States

Post by Mizery_Made »

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. :\

EDIT: 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*
Mizery_Made
Posts: 2283
Joined: Tue Aug 29, 2006 1:09 pm
Location: Kansas City, Missouri, United States

Post by Mizery_Made »

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: Select all

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%' )))
Advanced 'Any Text Field':

Code: Select all

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%' ))))
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
Ludek
Posts: 4945
Joined: Fri Mar 09, 2007 9:00 am

Post by Ludek »

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.
Post Reply