You are here:  » WP search results different to PT search results


WP search results different to PT search results

Submitted by jamie on Thu, 2017-01-05 12:20 in

Hi David,

One last question!

In my wordpress installation, when I try to search a product it returns no results. When I go to "http://example.com/pt/" and search for the same product it does return the product.

The only change to the code I made was the previous widget correction you kindly gave me.

Any idea how to fix this please?

Thank you for your amazing support with this product!

Cheers,
Jamie

Submitted by support on Thu, 2017-01-05 12:38

Hello Jamie,

That's strange - could you check that the External settings match the /pt/ installation - from /wp-admin/ > Settings > PriceTapestry.org, scroll down to the External section and check that $config_useFullText is set to TRUE - if still no joy if you could let me know the query that is not returning results in WordPress i'll check it out further wtih you...

Cheers,
David.
--
PriceTapestry.com

Submitted by jamie on Thu, 2017-01-05 12:57

Hi David,

Yep, $config_useFullText is set to TRUE

To give you an example, a test search query of "Scott" will return no results. Strangely, if a delete characters until I get to "Sco" this will successfully return the product result.

Meanwhile, in the /pt/ site a search of "Scott" will return the product.

Thanks
Jamie

Submitted by support on Thu, 2017-01-05 14:34

Hello Jamie,

That does indicate that it is something FULLTEXT related - could it be that your /pt/ installation has $config_useFullText set to FALSE at line 6 of config.advanced.php?

The FULLTEXT index is only used if a) all keywords in the query are greater than 3 characters in length, which is the default ft_min_word_len for MySQL, b) not a stopword.

However, MySQL FULLTEXT indexing also has rules regarding word frequency, so if starting a niche site and for example, the first feed was of Scott products only, with Scott appearing in every product name it would not initially be included in the FULLTEXT index.

If you set the plugin External setting to FALSE for $config_useFullText you should then obtain results for "Scott" or "Sco" - if you're still not sure of course let me know and I'll check it out further with you...

Cheers,
David.
--
PriceTapestry.com

Submitted by jamie on Thu, 2017-01-05 14:40

Perfect, works great now, thanks very much for your help again.