I have 700k+ videos in database, it is getting hard to search for specific things and as an example, imagine, that I want to find galleries only with bra in their descriptions. So i enter "bra" and search results give me lots of junk like brazillian, debra, braces, celebration, etc.
I would like to request a feature, to give us a way to search List Thumbs with a help of expressions like we have in Filter Keywords, so I would enter ^bra$ into search field and would get correct results. There could be some checkbox so if it's ticked, expressions could be used in seearch.
List Thumbs search
Re: List Thumbs search
It's a bit hard to create exactly as described above as mysql doesn't have the same query syntax
I've added sphinx options for filter in "list thumbs" , check sphinx docs for full sphinx syntax.
I've added sphinx options for filter in "list thumbs" , check sphinx docs for full sphinx syntax.
Don't forget to run script update
Re: List Thumbs search
Seems like sphinx search doesn't work.
If I enter ^vietnam it gives results with just "vietnam", no vietnamese.
If i use operator OR (hello | world) or operator NOT (hello -world) it lists all galleries in database.
I was trying many variants of the syntax from:
http://sphinxsearch.com/docs/current.ht ... ded-syntax
If I enter ^vietnam it gives results with just "vietnam", no vietnamese.
If i use operator OR (hello | world) or operator NOT (hello -world) it lists all galleries in database.
I was trying many variants of the syntax from:
http://sphinxsearch.com/docs/current.ht ... ded-syntax
Re: List Thumbs search
Try to push your request straight to Sphinx in ssh
search --index ... your-request
do you get what you expect ?
search --index ... your-request
do you get what you expect ?
Don't forget to run script update
Re: List Thumbs search
I am trying searching sphinx index on SSH now.
Search for vietnam in SSH lists "53 documents, 66 hits"
Search for vietnam in SCJ list thumbs via sphinx finds 15 videos
Search for vietnam in SCJ list thumbs via simple search finds 81 videos
Search for "asian|japan|vietnam" in SSH lists:
1. 'asian': 80017 documents, 132659 hits
2. 'japan': 19508 documents, 20334 hits
3. 'vietnam': 53 documents, 66 hits
Search for "asian|japan|vietnam" in SCJ list thumbs via sphinx finds 10 videos
Search for "asian -japan" in SSH lists:
1. 'asian': 80017 documents, 132659 hits
2. 'japan': 19508 documents, 20334 hits
Search for asian -japan or "asian -japan" in SCJ list thumbs via sphinx finds 15 videos
Search for vietnam in SSH lists "53 documents, 66 hits"
Search for vietnam in SCJ list thumbs via sphinx finds 15 videos
Search for vietnam in SCJ list thumbs via simple search finds 81 videos
Search for "asian|japan|vietnam" in SSH lists:
1. 'asian': 80017 documents, 132659 hits
2. 'japan': 19508 documents, 20334 hits
3. 'vietnam': 53 documents, 66 hits
Search for "asian|japan|vietnam" in SCJ list thumbs via sphinx finds 10 videos
Search for "asian -japan" in SSH lists:
1. 'asian': 80017 documents, 132659 hits
2. 'japan': 19508 documents, 20334 hits
Search for asian -japan or "asian -japan" in SCJ list thumbs via sphinx finds 15 videos
Re: List Thumbs search
Yes, 15 was due to list limits, this issue is fixed in update, thank you.
Don't forget to run script update
Re: List Thumbs search
OK.
Which build number has got this fix? I have updated the script today, so don't know if it already has the fix or not
Which build number has got this fix? I have updated the script today, so don't know if it already has the fix or not