projectnami icon indicating copy to clipboard operation
projectnami copied to clipboard

Seeking testers for PN Fulltext Search 1.1

Open patrickebates opened this issue 2 years ago • 2 comments

Need testing and feedback on upcoming release of PN Fulltext Search 1.1 as there are a couple of changes required to the SQL Server config.

https://projectnami.blob.core.windows.net/plugins/pn-fulltext-search-1-1.zip

Here's the changelog

  1. Removes a DB call for filtering noise words which has been failing under PHP 8.x for reasons still unknown.
  2. Modifies searching to include most plurals and suffixes of the terms (* operator).
  3. Modifies results by giving higher weight based on how close together the terms are in the text (NEAR operator).

Here's where the need for testers really comes in. In order to safely eliminate the call for filtering noise words, SQL Server config needs to be update to allow it to filter the noise words at search time. (Why this isn't the default, I have no idea...)

The following SQL statement needs to be executed on your server. If we get good feedback on these changes, steps will be taken to include this during plugin activation with the final release.

sp_configure 'show advanced options', 1;  
RECONFIGURE;  
GO  
sp_configure 'transform noise words', 1;  
RECONFIGURE;  
GO  

Good luck, and please report your findings by replying here.

patrickebates avatar Jan 28 '23 16:01 patrickebates