Word Count Search 2.12.1

[Xon]

Xon updated Word Count Search with a new update entry:

2.10.2 - Bugfix update

• Fix upgrade and uninstall code paths had an unexpected dependency on Threadmarks addon being installed

Read the rest of this update entry...

 

[Xon]

Xon updated Word Count Search with a new update entry:

2.11.0 - Maintenance update

• If Threadmarks is installed, require at least v2.19.0+
• Support Threadmarks v2.19.0+

Read the rest of this update entry...

 

[Enes3078]

Does it requires XFES? I can't use this addon. I think it's XFES's fault but I want to ask it.

 

[Xon]

This add-on doesn't depend on XFES, it does require Search Improvements and StandardLibrary add-ons.

 

[Enes3078]

This add-on doesn't depend on XFES, it does require Search Improvements and StandardLibrary add-ons.

It's not working on my forum...

 

[Enes3078]

@Xon do you know anything about that?

 

[Xon]

It's not working on my forum...

View attachment 301793

Have you re-run the search indexer after installing the add-on?

 

[Enes3078]

Have you re-run the search indexer after installing the add-on?

I don't get it. Where to find Search Indexer?

 

[philmckrackon]

I don't get it. Where to find Search Indexer?

 

[Enes3078]

@Xon can you help me for this?

XF\Db\Exception: MySQL query error [126]: Index for table './te***/xf_search_index.MYI' is corrupt; try to repair it in src/XF/Db/AbstractStatement.php at line 230
XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 198
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 78
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 273
XF\Db\AbstractAdapter->insertBulk() in src/XF/Search/Source/MySqlFt.php at line 107
XF\Search\Source\MySqlFt->flushBulkIndexing() in src/XF/Search/Source/MySqlFt.php at line 91
XF\Search\Source\MySqlFt->index() in src/XF/Search/Search.php at line 42
XF\Search\Search->index() in src/addons/SV/SearchImprovements/XF/Search/SearchPatch.php at line 119
SV\SearchImprovements\XF\Search\SearchPatch->index() in src/XF/Search/Search.php at line 61
XF\Search\Search->indexEntities() in src/XF/Search/Search.php at line 87
XF\Search\Search->indexRange() in src/XF/Job/SearchRebuild.php at line 66
XF\Job\SearchRebuild->run() in src/XF/Job/Manager.php at line 260
XF\Job\Manager->runJobInternal() in src/XF/Job/Manager.php at line 202
XF\Job\Manager->runJobEntry() in src/XF/Job/Manager.php at line 86
XF\Job\Manager->runQueue() in src/XF/Admin/Controller/Tools.php at line 141
XF\Admin\Controller\Tools->actionRunJob() in src/XF/Mvc/Dispatcher.php at line 352
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
XF\App->run() in src/XF.php at line 524
XF::runApp() in admin.php at line 13

 

[Xon]

You should be able to safely run truncate table xf_search_index. This will truncate the table and discard the broken indexes & data.

Since you need to rebuild the search index, this is safe.

 

[Enes3078]

You should be able to safely run truncate table xf_search_index. This will truncate the table and discard the broken indexes & data.

Since you need to rebuild the search index, this is safe.

It's worked thanks but still your extension doesn't work.

 

[Enes3078]

@Xon actually it seems work but only upper bound works. You can check this out from attachments.

PS: It's same with order by date or order by word.

 

[Enes3078]

@Xon umm, helloo... Can you check this please?

 

[Xon]

I plan to look into this early next week. I normally do not use the the MySQL search support, so it will take setting up a new test environment

 

[Xon]

Xon updated Word Count Search with a new update entry:

2.12.0 - XenForo 2.3 support

• Require StandardLib v1.20.0+
• XF2.3 support
• php 8.4+ compatibility fixes
• Recommend adding pcre.jit=1 to php.ini

Read the rest of this update entry...

 

[Enes3078]

I plan to look into this early next week. I normally do not use the the MySQL search support, so it will take setting up a new test environment

Is this error fixed?

@Xon actually it seems work but only upper bound works. You can check this out from attachments.

PS: It's same with order by date or order by word.

View attachment 301901

View attachment 301902

 

[Xon]

Is this error fixed?

No, I should have a fix out within the next day or so.

 

[Xon]

Xon updated Word Count Search with a new update entry:

2.12.1 - Bugfix update

• MySQL full-text search search fixes, requires re-indexing the site
  • Fix for word-count range searches with a min/max value require Search Improvements v2.14.7+
  • Fix word-count wasn't pushed into the search index

Read the rest of this update entry...

 

[Xon]

Is this error fixed?

You will need to update Search Improvements and Word Count search, and then re-index your site.

The MySQL word-count sort and min/max features have been broken for years