Word Count Search 1.4.3

Xon · Mar 31, 2017

It just means the word-count search will not be accurate

HappyWorld · Mar 31, 2017

Xon said:
It just means the word-count search will not be accurate

On install, i got this error :

Code:

An exception occurred: Call to undefined method SV_OptimizedListQueries_XenForo_Model_Search::getWordCountThreshold() in /home/XXXXXX/public_html/library/SV/WordCountSearch/Deferred/WordCountMigration.php on line 27

    SV_WordCountSearch_Deferred_WordCountMigration->execute() in XenForo/Model/Deferred.php at line 295
    XenForo_Model_Deferred->runDeferred() in XenForo/Model/Deferred.php at line 429
    XenForo_Model_Deferred->_runInternal() in XenForo/Model/Deferred.php at line 374
    XenForo_Model_Deferred->run() in XenForo/ViewRenderer/Abstract.php at line 352
    XenForo_ViewRenderer_Abstract::hasManualDeferredToRun() in XenForo/ViewRenderer/HtmlAdmin.php at line 50
    XenForo_ViewRenderer_HtmlAdmin->renderRedirect() in XenForo/FrontController.php at line 617
    XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
    XenForo_FrontController->run() in /home/XXXXXX/public_html/admin.php at line 13

When uninstalling, i see 1 manual rebuild process which can't finish.

Code:

Server Error

Mysqli prepare error: Table 'XXXXXX_xffinal.xf_post_words' doesn't exist

    Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
    Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
    Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
    Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 734
    Zend_Db_Adapter_Abstract->fetchAll() in SV/WordCountSearch/Deferred/WordCountMigration.php at line 18
    SV_WordCountSearch_Deferred_WordCountMigration->execute() in XenForo/Model/Deferred.php at line 295
    XenForo_Model_Deferred->runDeferred() in XenForo/Model/Deferred.php at line 429
    XenForo_Model_Deferred->_runInternal() in XenForo/Model/Deferred.php at line 374
    XenForo_Model_Deferred->run() in XenForo/ControllerAdmin/Tools.php at line 159
    XenForo_ControllerAdmin_Tools->actionRunDeferred() in XenForo/FrontController.php at line 351
    XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    XenForo_FrontController->run() in /home/XXXXXX/public_html/admin.php at line 13

How to clear the manual rebuild process?

Is it safe to just empty the "xf_deferred" table?

Xon · Apr 1, 2017

semprot said:

On install, i got this error :

Code:

An exception occurred: Call to undefined method SV_OptimizedListQueries_XenForo_Model_Search::getWordCountThreshold() in /home/XXXXXX/public_html/library/SV/WordCountSearch/Deferred/WordCountMigration.php on line 27

    SV_WordCountSearch_Deferred_WordCountMigration->execute() in XenForo/Model/Deferred.php at line 295
    XenForo_Model_Deferred->runDeferred() in XenForo/Model/Deferred.php at line 429
    XenForo_Model_Deferred->_runInternal() in XenForo/Model/Deferred.php at line 374
    XenForo_Model_Deferred->run() in XenForo/ViewRenderer/Abstract.php at line 352
    XenForo_ViewRenderer_Abstract::hasManualDeferredToRun() in XenForo/ViewRenderer/HtmlAdmin.php at line 50
    XenForo_ViewRenderer_HtmlAdmin->renderRedirect() in XenForo/FrontController.php at line 617
    XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
    XenForo_FrontController->run() in /home/XXXXXX/public_html/admin.php at line 13

That shouldn't happen. It means the add-on installer ran but the add-on itself wasn't installed.

When uninstalling, i see 1 manual rebuild process which can't finish.

Code:

Server Error

Mysqli prepare error: Table 'XXXXXX_xffinal.xf_post_words' doesn't exist

    Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
    Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
    Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
    Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 734
    Zend_Db_Adapter_Abstract->fetchAll() in SV/WordCountSearch/Deferred/WordCountMigration.php at line 18
    SV_WordCountSearch_Deferred_WordCountMigration->execute() in XenForo/Model/Deferred.php at line 295
    XenForo_Model_Deferred->runDeferred() in XenForo/Model/Deferred.php at line 429
    XenForo_Model_Deferred->_runInternal() in XenForo/Model/Deferred.php at line 374
    XenForo_Model_Deferred->run() in XenForo/ControllerAdmin/Tools.php at line 159
    XenForo_ControllerAdmin_Tools->actionRunDeferred() in XenForo/FrontController.php at line 351
    XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    XenForo_FrontController->run() in /home/XXXXXX/public_html/admin.php at line 13

How to clear the manual rebuild process?

Is it safe to just empty the "xf_deferred" table?

I'll push a 1.1.4 update which fixes the deferred tasks. Just update the files and they will then correctly stop.

Xon · Apr 1, 2017

Xon updated Enhanced Search Improvements - Word Count with a new update entry:

1.1.4 - Bugfix update

Stop deferred tasks it the add-on is disabled or not installed properly

Read the rest of this update entry...

HappyWorld · Apr 1, 2017

Xon said:
That shouldn't happen. It means the add-on installer ran but the add-on itself wasn't installed.

I'll push a 1.1.4 update which fixes the deferred tasks. Just update the files and they will then correctly stop.

It seems first error happened because i have not installed this add on https://xenforo.com/community/resources/enhanced-search-improvements.4762/
Now i have installed it, deferred errors have gone too

Xon · Jun 15, 2017

Xon updated Enhanced Search Improvements - Word Count with a new update entry:

1.1.7 - Compatibility Update

Support threadmark categories

Read the rest of this update entry...

Xon · Jul 7, 2017

Xon updated Word Count Search with a new update entry:

1.2.0 - Feature Update

Support sorting by word-count when searching (descending only).

Forum Options - sort/filter by word-count.

Read the rest of this update entry...

Alpha1 · Jul 19, 2017

Please add word count search to batch update threads.

Xon · Aug 2, 2017

Xon updated Word Count Search with a new update entry:

1.2.1 - Bugfix update

Do not break indexing of moderator copied posts, or reporting what posts where copied to create a new thread

Improve error reporting during add-on installing & enforce dependencies.

php 5.4 or newer,

XenFor 1.3.0 or newer

XFES is required

Enhanced Search Improvements 1.2.0 or newer

Read the rest of this update entry...

Xon · Aug 12, 2017

Xon updated Word Count Search with a new update entry:

1.3.0 - Feature Update

Improve integration with Threadmarks, reducing queries needed on new/edited posts to update word counts.

For Threadmarks 1.6.5, support reporting per category word-count totals instead of just the first threadmark type.

Read the rest of this update entry...

Xon · Aug 12, 2017

Xon updated Word Count Search with a new update entry:

1.3.1 - Bugfix release

Correctly trigger migration code for updating thread's with per-threadmark category wordcount totals

Read the rest of this update entry...

Xon · Aug 14, 2017

Xon updated Word Count Search with a new update entry:

1.3.2 - Maintenance update

Improve robustness of when a post's wordcount is populated, and any threadmark cache data is updated.

Only rebuild thread wordcount & threadmark wordcount cache data once on a post insert/update.

Support older versions of the threadmark add-on better.

Reduce threshold before the wordcount is stored (100 -> 20)

Read the rest of this update entry...

Xon · Sep 16, 2017

Xon updated Word Count Search with a new update entry:

1.4.0 - Compatibility update

This add-on now requires php 5.4+

Support for Mulit-Prefix 1.7.x's ability to include multiple prefix's as AND'ed forum filters

Improved support for Aggregating Forums v1.2.x

Reduces query complexity when dealing with

Populate threadmarks +1.5.x categories with word-counts on install.

Read the rest of this update entry...

Xon · Jan 12, 2018

Xon updated Word Count Search with a new update entry:

1.4.2 - Maintenance update

Elasticsearch v6 support is supplied by Search Improvements

Prevent word-counts being unexpectedly applied to posts/thread which should not have a word count during bulk-inserts.

May require rebuilding threads search index, post search index is should be unaffected by extra processing that is done.

Tweak rounding to avoid showing "1000" words instead of "1k" words (and...

Read the rest of this update entry...

HappyWorld · Jan 12, 2018

May require rebuilding threads search index, post search index is should be unaffected by extra processing that is done.

Do you mean i must rebuild thread search index?

What about post search index?

Xon · Jan 13, 2018

semprot said:
Do you mean i must rebuild thread search index?

What about post search index?

Some threads may have incorrect word counts associated with them in the search index. Under rebuilding cache, just doing threads is enough to fix it.

Posts are ok.

Xon · May 9, 2018

Xon updated Word Count Search with a new update entry:

1.4.3 - Bugfix update

Fix error when Threadmarks add-on is installed but disabled

Read the rest of this update entry...

Word Count Search 1.4.3

Xon

Well-known member

HappyWorld

Well-known member

Xon

Well-known member

Xon

Well-known member

HappyWorld

Well-known member

Xon

Well-known member

Xon

Well-known member

Alpha1

Well-known member

Xon

Well-known member

Xon

Well-known member

Xon

Well-known member

Xon

Well-known member

Xon

Well-known member

Xon

Well-known member

HappyWorld

Well-known member

Xon

Well-known member

Xon

Well-known member

Similar threads

We value your privacy