List Thumbs search

SpyCam
Posts: 736
Joined: Fri Oct 26, 2012 9:52 am

List Thumbs search

Post by SpyCam »

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.
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: List Thumbs search

Post by admin »

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.
Don't forget to run script update
SpyCam
Posts: 736
Joined: Fri Oct 26, 2012 9:52 am

Re: List Thumbs search

Post by SpyCam »

I will try to test that tomorrow
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: List Thumbs search

Post by admin »

Ok
Don't forget to run script update
SpyCam
Posts: 736
Joined: Fri Oct 26, 2012 9:52 am

Re: List Thumbs search

Post by SpyCam »

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
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: List Thumbs search

Post by admin »

Try to push your request straight to Sphinx in ssh

search --index ... your-request

do you get what you expect ?
Don't forget to run script update
SpyCam
Posts: 736
Joined: Fri Oct 26, 2012 9:52 am

Re: List Thumbs search

Post by SpyCam »

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
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: List Thumbs search

Post by admin »

Yes, 15 was due to list limits, this issue is fixed in update, thank you.
Don't forget to run script update
SpyCam
Posts: 736
Joined: Fri Oct 26, 2012 9:52 am

Re: List Thumbs search

Post by SpyCam »

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
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: List Thumbs search

Post by admin »

201305241601
Don't forget to run script update
Post Reply