• 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

#1
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:

Code:
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

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

whyweprotest

Well-known member
#4
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 ;)