Fixed Invalid bind-variable name when Rebuilding Search Index

[Paul Butler]

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.

 

[Mike]

This is fixed for the next release. The workaround is actually within Zend Framework.

 

[Paul Butler]

Thanks Mike, any idea when the next release is available?

 

[whyweprotest]

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