• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Fixed  Invalid bind-variable name when Rebuilding Search Index

Clean install of Beta 5
Imported vB3.8.x forum ok, then when using the Rebuild Search Index it gets through a few thousand posts (approx 6,500) and I get the error as depicted below:

Server Error

Invalid bind-variable name ':o'

   1. Zend_Db_Statement->_parseParameters() in Zend/Db/Statement.php at line 114
   2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
   3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
   4. Zend_Db_Adapter_Abstract->query() in XenForo/Search/SourceHandler/MySqlFt.php at line 117
   5. XenForo_Search_SourceHandler_MySqlFt->_pushToIndex() in XenForo/Search/SourceHandler/MySqlFt.php at line 65
   6. XenForo_Search_SourceHandler_MySqlFt->insertIntoIndex() in XenForo/Search/Indexer.php at line 44
   7. XenForo_Search_Indexer->insertIntoIndex() in XenForo/Search/DataHandler/Post.php at line 47
   8. XenForo_Search_DataHandler_Post->_insertIntoIndex() in XenForo/Search/DataHandler/Abstract.php at line 227
   9. XenForo_Search_DataHandler_Abstract->insertIntoIndex() in XenForo/Search/DataHandler/Post.php at line 119
  10. XenForo_Search_DataHandler_Post->quickIndex() in XenForo/Search/DataHandler/Post.php at line 89
  11. XenForo_Search_DataHandler_Post->rebuildIndex() in XenForo/CacheRebuilder/SearchIndex.php at line 83
  12. XenForo_CacheRebuilder_SearchIndex->rebuild() in XenForo/ControllerHelper/CacheRebuild.php at line 26
  13. XenForo_ControllerHelper_CacheRebuild->rebuildCache() in XenForo/ControllerAdmin/Tools.php at line 63
  14. XenForo_ControllerAdmin_Tools->actionCacheRebuild() in XenForo/FrontController.php at line 310
  15. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
  16. XenForo_FrontController->run() in /var/www/clients/client1/web1/web/XenForo/upload/admin.php at line 13
Any help or advice would be appreciated, thanks.


XenForo developer
Staff member
This is fixed for the next release. The workaround is actually within Zend Framework.


Well-known member
I don't suppose there's any way we could get a patch for this one? It's pretty difficult to find stuff in 1.4million posts without a search ;)