MantisBT - MediaMonkey (current)
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006140MediaMonkey (current)Playlist / Searchpublic2009-11-04 19:572009-11-06 18:14
ReporterOwyn 
PriorityurgentSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version3.1.2 
Target Version3.1.2Fixed in Version3.1.2 
Fixed in build1287
Summary0006140: Searchbar does not search Encoder and some others fields after Optimize DB action
DescriptionFTS search for data in Encoder does not work. Either no or erroneous results returned.

See http://www.mediamonkey.com/forum/viewtopic.php?f=6&t=44121 [^]
Steps To Reproduce
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-11-04 19:57OwynNew Issue
2009-11-05 10:11rustyNote Added: 0019570
2009-11-05 10:11rustyAssigned To => Ludek
2009-11-05 10:11rustyPrioritynone => urgent
2009-11-05 10:11rustyStatusnew => feedback
2009-11-05 10:11rustyTarget Version => 3.1.2
2009-11-05 10:20OwynNote Added: 0019571
2009-11-05 10:46OwynNote Added: 0019572
2009-11-05 14:13LudekNote Added: 0019574
2009-11-05 14:13LudekNote Edited: 0019574
2009-11-05 14:18LudekNote Edited: 0019574
2009-11-05 14:23rustyNote Added: 0019575
2009-11-05 14:26rustyNote Edited: 0019575
2009-11-05 14:27rustyNote Edited: 0019575
2009-11-05 14:46LudekFixed in build => 1286
2009-11-05 14:46LudekNote Added: 0019576
2009-11-05 14:46LudekStatusfeedback => resolved
2009-11-05 14:46LudekFixed in Version => 3.1.2
2009-11-05 14:46LudekResolutionopen => fixed
2009-11-05 14:48LudekNote Edited: 0019576
2009-11-05 14:48LudekNote Edited: 0019576
2009-11-05 16:15LudekNote Added: 0019580
2009-11-05 16:25OwynNote Added: 0019581
2009-11-05 18:58LudekNote Added: 0019587
2009-11-05 18:58LudekNote Edited: 0019587
2009-11-05 18:58LudekNote Edited: 0019587
2009-11-05 18:59LudekNote Edited: 0019587
2009-11-05 22:54OwynNote Added: 0019591
2009-11-05 22:58stephen_plattStatusresolved => closed
2009-11-06 13:17LudekNote Added: 0019606
2009-11-06 13:17LudekStatusclosed => feedback
2009-11-06 13:17LudekResolutionfixed => reopened
2009-11-06 13:18LudekSummarySearchbar does not search Encoder => Searchbar does not search Encoder, Original Artist, Original Title after Optimize DB action
2009-11-06 13:19LudekSummarySearchbar does not search Encoder, Original Artist, Original Title after Optimize DB action => Searchbar does not search Encoder and some others fields after Optimize DB action
2009-11-06 13:20LudekNote Edited: 0019606
2009-11-06 13:21LudekFixed in build1286 => 1287
2009-11-06 13:21LudekNote Added: 0019607
2009-11-06 13:21LudekStatusfeedback => resolved
2009-11-06 13:21LudekResolutionreopened => fixed
2009-11-06 17:04OwynNote Added: 0019614
2009-11-06 18:14stephen_plattStatusresolved => closed

Notes
(0019570)
rusty   
2009-11-05 10:11   
Ludek, can you please have a look at this? I cannot reproduce the problem, but i want to make sure that it's not a lurking/more generalized regression.
(0019571)
Owyn   
2009-11-05 10:20   
Don't know if it is relevant but I tested DB Maintenance recently (within the last month). If I remember correctly it rebuilds SongsText as part of the process.
(0019572)
Owyn   
2009-11-05 10:46   
Hmmm. http://www.mediamonkey.com/forum/viewtopic.php?f=6&t=37368#p227758 [^]

Also note reference to having optimized database.
(0019574)
Ludek   
2009-11-05 14:13   
(edited on: 2009-11-05 14:18)
Owyn, thanks!

You've done a great observation, it is really related to the DB Maintenance where is a bug in the rebuild process of the SongsText as you proposed.

It is not problem only for Encoder, but also for Publisher, Copyright, Original Lyricist.

It will be fixed in the next build, but the Maintain Library -> Optimize Database (Complete) will need to be performed again in order to fix it.
(0019575)
rusty   
2009-11-05 14:23   
(edited on: 2009-11-05 14:27)
You're right--on my machine (Win7), after an Optimize database (complete) operation, searches of the encoder field (using the Searchbar) no longer work. Strangely, though, performing an optimization doesn't consistently trigger this bug.

What is even weirder, is that searches using the 'Search > Basic > Any text Field' also stop working for the Encoder field (which doesn't match REIKA's experience)!!

Based on the link that you provided, I suspect the problem also occurs with other fields.
(0019576)
Ludek   
2009-11-05 14:46   
(edited on: 2009-11-05 14:48)
Fixed in build 1286.

i.e. performing
Maintain Library -> Optimize Database (Complete)
with build 1286 fixes the problem.
(0019580)
Ludek   
2009-11-05 16:15   
The bug was in the
Maintain Library -> Optimize Database (Complete)
process itself so for the users that used the 'Maintain Library -> Optimize Database (Complete)' in MM 3.1 the bug occurs and they need to perform again
'Maintain Library -> Optimize Database (Complete) '
to fix it.
(0019581)
Owyn   
2009-11-05 16:25   
Is there a way to test for re-Optimization required and alert the user?
(0019587)
Ludek   
2009-11-05 18:58   
(edited on: 2009-11-05 18:59)
Maybe via a small script that would compare this 2 SQL queries:

=> Query 1:

SELECT ID FROM Songs WHERE Songs.ID IN (SELECT rowid FROM SongsText WHERE SongsText MATCH ' encoder: MediaMonkey* ')

=> Query 2:

SELECT ID FROM Songs WHERE (Songs.Encoder like 'MediaMonkey%')

the results should be same.
(0019591)
Owyn   
2009-11-05 22:54   
Verified in 1286
(0019606)
Ludek   
2009-11-06 13:17   
(edited on: 2009-11-06 13:20)
Re-opened, because this issue still exists for 'Original Artists' and 'Original Title' fields:
http://www.mediamonkey.com/forum/viewtopic.php?f=6&t=37368&st=0&sk=t&sd=a&start=15 [^]
(0019607)
Ludek   
2009-11-06 13:21   
Fixed in build 1287.
(0019614)
Owyn   
2009-11-06 17:04   
Verified in 1287 for "orginalartist:elvis" (that failed in 1286).