This topic contains 6 replies, has 2 voices, and was last updated by 
- Posts
Hi There,
I hope you had a great weekend. I am really enjoying using up the Ajax Search Pro Plugin. I have hit a small glitch though. What I found is keyword logic AND is not giving expected/documented output in one case.As per documentation index table can’t search word inner parts, only beginnings and endings for example “rat” NOT match “karate”. Right? But in my case its searching inner parts & returning as a result. Please find attached screenshot.
How can I stop this?
Thanks
Hi!
Thank you very much for your kind words!
It is very hard to tell, but I assume that the matching might be happening for another word or the index table might be disabled.
I would suggest checking:
– If only the desired fields are indexed on the index table panel: https://i.imgur.com/qq1eIvn.png
If you change any of the options, then make sure to re-crate the index table as well.
– If the index table is indeed in use: https://i.imgur.com/L9DTFmR.png
– Also, that the exact matching is turned off: https://i.imgur.com/ww7dZY4.png
– ..and that there is no exact matching filter (it also applies even if search settings on the front-end are invisible): https://i.imgur.com/7mzpUKf.pngAny of these could cause this problem, make sure to check them, and let me know.
Best,
Ernest Marcinko
If you like my products, don't forget to rate them on codecanyon :)
Thanks for quick reply. Here is my reply to check list:
#1 – Yes only desired fields are indexed & I have regenerated index table too & checked for the results. But no luck.
#2 – Yes its indeed used.
#3 – Yes its turned off.
#4 – Yes, there is no exact matching filter.Do let me know if you need more details.
Is there any to check what DB query is getting fired?
I tried enabling ASP_DEBUG but not sure where to see debug data. Also when I enable it on front-end warning is received “Warning: Seems like you are using the Search feature (Chosen script) in search settings but the Chosen jQuery script is not loaded”
Also tried enabling Debug bar but no ASP query gets printed.
I figured out the problem ‘term_reverse’ for some of my products were causing the problem.
Is there any specific use of ‘term_reverse’?
Hi,
The term_reverse row in the database is used to store the reverse keyword. It is neccessary to maintain the index, as otherwise matching word ends would not be possible without a non-indexed query.
Best,
Ernest Marcinko
If you like my products, don't forget to rate them on codecanyon :)
Ok. Thanks. Appreciate your help.
You must be logged in to reply to this topic.