English > Support

Typing/Clicking to search for Tags yields different results

<< < (3/3)

mgpw4me@yahoo.com:

--- Quote from: Pensare on November 17, 2010, 03:13:47 am ---Is there a way to query the database directly?  Maybe my database has "unprintable" characters in it.

--- End quote ---

Nice catch big guy.

I can't imagine how those characters got there, but it looks like all you have to do now is do a search / replace on those characters then use the IMPORT function to replace the data.  Be sure to backup your database.

** NOTE ** Windows may not show the characters as being different, but dollars to donuts it will copy / paste into the replace dialog properly.

It's probably best to reset your imdb plug-in preferences to OVERWRITE your TAGS and try getting the data again.  If you still have the same problem there could be issues with the plug-in.

Pensare:

--- Quote from: rick.ca on November 18, 2010, 03:45:42 am ---You still haven't explained what the problem is. How many of your movies actually have the "Based on Play" tag? 8 or 50? Is 12 Angry Men one of the 8 or one of the 42? Are you suggesting a manual search for "Based on Play" will not find 12 Angry Men because the value is actually "Based On Play"? If so, what about the 8 that are found? Do they found because they do not have special characters in the value? Is my assumption the 8 are a subset of the 50 even true? Or is one search finding 50 records where the values include special characters and the other finds 8 different records where the values do not include special characters? Or vice versa?

--- End quote ---
S1. You still haven't explained what the problem is.
R1. I apologize for not being clear.  The problem is, apparently, that my database has characters that appear to be spaces but are not. 

Q1. How many of your movies actually have the "Based on Play" tag? 8 or 50?
A1. To the best of my knowledge, 58.

Q2. Is 12 Angry Men one of the 8 or one of the 42?
A2. One of the 50.

Q3. Are you suggesting a manual search for "Based on Play" will not find 12 Angry Men because the value is actually "Based On Play"?
A3. Yes
 
Q4. If so, what about the 8 that are found? Do they found because they do not have special characters in the value?
A4. That is my belief.  The string "Based on Play" contains space characters which are not in the tags of "12 Angry Men".

Q5. Is my assumption the 8 are a subset of the 50 even true?
A5. No. (Once again, sorry about not being clear).

Q6. Or is one search finding 50 records where the values include special characters and the other finds 8 different records where the values do not include special characters?
A6. Clicking the link of a record with special characters will match other records with the same sequence of characters (50 in my case) while typing in the Search box (or clicking the tag of a record without special characters) will also match the records with the same sequence of characters (8 in my case).

Pensare:

--- Quote ---It's probably best to reset your imdb plug-in preferences to OVERWRITE your TAGS and try getting the data again.

--- End quote ---
I tried mgpw4me's suggestion and the non-printable characters are gone.  Thanks.

Now, comes the process of re-importing most of my database.  :-\

rick.ca:

--- Quote ---A1...6
--- End quote ---

That's much better, thanks. ;)

Hopefully, downloading the data again will fix everything. I suppose it would be pointless to try to narrow down the cause—especially with the number of plugin updates that have been required in the recent past. If anyone else is affected, doing the same thing is probably the only practical fix. After updating, please to the same export to verify all is well. If it's not, we'll need to distract nostra from 1.0.0.1 development. :-\

Navigation

[0] Message Index

[*] Previous page