search

ProjectNami / projectnami

WordPress powered by Microsoft SQL Server
http://projectnami.org
Other
270 stars 137 forks source link

Seeking testers for PN Fulltext Search 1.1 #505

Open patrickebates opened 1 year ago

patrickebates commented 1 year ago

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.

Flying-Bas commented 1 year ago

Hi Patrick, I have executed the statement in the sql server and downloaded the plugin from your link. After some tests it all seems to work admit should. Don’t know if it matters, but my websites are in Dutch and the searching is in Dutch too. This all works now correct. Thanks!

patrickebates commented 1 year ago

Fantastic! Always happy to hear that languages other than English are working correctly.