SmartCJ Support Forum

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.

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 will try to test that tomorrow

Ok

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

Try to push your request straight to Sphinx in ssh

search --index ... your-request

do you get what you expect ?

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

Yes, 15 was due to list limits, this issue is fixed in update, thank you.

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

201305241601