You are here:  » Empty search results - sql error


Empty search results - sql error

Submitted by magnaromagna on Sat, 2021-01-02 07:51 in

Hi,
on wordpress installation, if I perform search it show always empty results. If I try on /pt core installation, it shows the error:

[SELECT SQL_CALC_FOUND_ROWS id,COUNT(id) AS numMerchants,MIN(price) as minPrice, MATCH name,description AGAINST ('lenovo') AS relevance FROM `pt_products` WHERE MATCH name,description AGAINST ('lenovo') GROUP BY search_name ORDER BY relevance DESC LIMIT 0,15][Can't find FULLTEXT index matching the column list]

Can you help me?
Thanks!

Submitted by support on Sat, 2021-01-02 09:03

Hi,

Having enabled search description ($config_searchDescription in config.advanced.php and set it the plugin by the corresponding setting in wp-admin > Settings > PriceTapestry.org) you then need to run /pt/setup.php once to add the new FULLTEXT index to (name,description) - that should be all it is...

Cheers,
David.
--
PriceTapestry.com

Submitted by magnaromagna on Sat, 2021-01-02 09:21

Ok, done. Now working fine, thanks.