1. 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

Discussion in 'Resolved Bug Reports' started by Paul Butler, Jan 3, 2011.

  1. Paul Butler

    Paul Butler Member

    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.
  2. Mike

    Mike XenForo Developer Staff Member

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

    Paul Butler Member

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

    whyweprotest 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 ;)

Share This Page