SHARE
TWEET

Untitled

a guest Jul 16th, 2019 60 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. An error occurred
  2. An error occurred during execution; please try again later.
  3. Additional information:
  4. Zend\Db\Adapter\Exception\InvalidQueryException
  5. File:
  6. /home/zf3/htdocs/vendor/zendframework/zend-db/src/Adapter/Driver/Pdo/Statement.php:244
  7. Message:
  8. Statement could not be executed (42000 - 1064 - index proposal_sale_services: agent sphinx2:9306: remote query error: no enabled local indexes to search;
  9. index proposal_sale_services: agent sphinx3:9306: remote query error: no enabled local indexes to search)
  10. Stack trace:
  11. #0 /home/zf3/htdocs/vendor/ripaclub/sphinxsearch/library/AbstractComponent.php(86): Zend\Db\Adapter\Driver\Pdo\Statement->execute()
  12. #1 /home/zf3/htdocs/vendor/ripaclub/sphinxsearch/library/Search.php(75): SphinxSearch\AbstractComponent->executeSqlObject(Object(Search\Db\Sql\Select))
  13. #2 /home/zf3/htdocs/module/Search/src/Adapter/Paginator/Sphinx.php(131): SphinxSearch\Search->searchWith(Object(Search\Db\Sql\Select))
  14. #3 /home/zf3/htdocs/vendor/zendframework/zend-paginator/src/Paginator.php(882): Search\Adapter\Paginator\Sphinx->count()
  15. #4 /home/zf3/htdocs/vendor/zendframework/zend-paginator/src/Paginator.php(558): Zend\Paginator\Paginator->_calculatePageCount()
  16. #5 /home/zf3/htdocs/module/Search/src/Service/Provider/Sphinx/SphinxService.php(191): Zend\Paginator\Paginator->setItemCountPerPage(8)
  17. #6 /home/zf3/htdocs/module/Search/src/Service/MainPageAds/DefaultAdsDataProvider.php(460): Search\Service\Provider\Sphinx\SphinxService->getSearchResult(Object(Zend\Http\PhpEnvironment\Request), 'main-page-sale-...')
  18. #7 /home/zf3/htdocs/module/Search/src/Service/MainPageAds/DefaultAdsDataProvider.php(250): Search\Service\MainPageAds\DefaultAdsDataProvider->getAdsDataAndCount(Array, 'bWFpbi1wYWdlLWF...', Array)
  19. #8 /home/zf3/htdocs/module/Search/src/Service/MainPageAds/DefaultAdsDataProvider.php(428): Search\Service\MainPageAds\DefaultAdsDataProvider->getQueryThreeData()
  20. #9 /home/zf3/htdocs/module/Search/src/Service/MainPageAds/DefaultAdsDataProvider.php(114): Search\Service\MainPageAds\DefaultAdsDataProvider->getMainPageAdsData()
  21. #10 /home/zf3/htdocs/module/Search/src/View/Helper/MainPageAdsRenderer.php(69): Search\Service\MainPageAds\DefaultAdsDataProvider->getData()
  22. #11 /home/zf3/htdocs/module/Application/view/application/index/main-host-index.phtml(37): Search\View\Helper\MainPageAdsRenderer->render()
  23. #12 /home/zf3/htdocs/vendor/zendframework/zend-view/src/Renderer/PhpRenderer.php(506): include('/home/zf3/htdoc...')
  24. #13 /home/zf3/htdocs/vendor/zendframework/zend-view/src/Helper/Partial.php(61): Zend\View\Renderer\PhpRenderer->render(NULL, NULL)
  25. #14 [internal function]: Zend\View\Helper\Partial->__invoke('application/ind...', Array)
  26. #15 /home/zf3/htdocs/vendor/zendframework/zend-view/src/Renderer/PhpRenderer.php(397): call_user_func_array(Object(Zend\View\Helper\Partial), Array)
  27. #16 /home/zf3/htdocs/module/Application/src/View/Helper/MainPageHelper.php(101): Zend\View\Renderer\PhpRenderer->__call('partial', Array)
  28. #17 /home/zf3/htdocs/module/Application/view/application/index/index.phtml(6): Application\View\Helper\MainPageHelper->renderForMainHost()
  29. #18 /home/zf3/htdocs/vendor/zendframework/zend-view/src/Renderer/PhpRenderer.php(506): include('/home/zf3/htdoc...')
  30. #19 /home/zf3/htdocs/vendor/zendframework/zend-view/src/View.php(207): Zend\View\Renderer\PhpRenderer->render(NULL)
  31. #20 /home/zf3/htdocs/vendor/zendframework/zend-view/src/View.php(236): Zend\View\View->render(Object(Zend\View\Model\ViewModel))
  32. #21 /home/zf3/htdocs/vendor/zendframework/zend-view/src/View.php(200): Zend\View\View->renderChildren(Object(Zend\View\Model\ViewModel))
  33. #22 /home/zf3/htdocs/vendor/zendframework/zend-mvc/src/View/Http/DefaultRenderingStrategy.php(105): Zend\View\View->render(Object(Zend\View\Model\ViewModel))
  34. #23 /home/zf3/htdocs/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Zend\Mvc\View\Http\DefaultRenderingStrategy->render(Object(Zend\Mvc\MvcEvent))
  35. #24 /home/zf3/htdocs/vendor/zendframework/zend-eventmanager/src/EventManager.php(171): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent))
  36. #25 /home/zf3/htdocs/vendor/zendframework/zend-mvc/src/Application.php(367): Zend\EventManager\EventManager->triggerEvent(Object(Zend\Mvc\MvcEvent))
  37. #26 /home/zf3/htdocs/vendor/zendframework/zend-mvc/src/Application.php(348): Zend\Mvc\Application->completeRequest(Object(Zend\Mvc\MvcEvent))
  38. #27 /home/zf3/htdocs/public/index.php(59): Zend\Mvc\Application->run()
  39. #28 {main}
  40. Previous exceptions:
  41. PDOException
  42. File:
  43. /home/zf3/htdocs/vendor/zendframework/zend-db/src/Adapter/Driver/Pdo/Statement.php:239
  44. Message:
  45. SQLSTATE[42000]: Syntax error or access violation: 1064 index proposal_sale_services: agent sphinx2:9306: remote query error: no enabled local indexes to search;
  46. index proposal_sale_services: agent sphinx3:9306: remote query error: no enabled local indexes to search
  47. Stack trace:
  48. #0 /home/zf3/htdocs/vendor/zendframework/zend-db/src/Adapter/Driver/Pdo/Statement.php(239): PDOStatement->execute()
  49. #1 /home/zf3/htdocs/vendor/ripaclub/sphinxsearch/library/AbstractComponent.php(86): Zend\Db\Adapter\Driver\Pdo\Statement->execute()
  50. #2 /home/zf3/htdocs/vendor/ripaclub/sphinxsearch/library/Search.php(75): SphinxSearch\AbstractComponent->executeSqlObject(Object(Search\Db\Sql\Select))
  51. #3 /home/zf3/htdocs/module/Search/src/Adapter/Paginator/Sphinx.php(131): SphinxSearch\Search->searchWith(Object(Search\Db\Sql\Select))
  52. #4 /home/zf3/htdocs/vendor/zendframework/zend-paginator/src/Paginator.php(882): Search\Adapter\Paginator\Sphinx->count()
  53. #5 /home/zf3/htdocs/vendor/zendframework/zend-paginator/src/Paginator.php(558): Zend\Paginator\Paginator->_calculatePageCount()
  54. #6 /home/zf3/htdocs/module/Search/src/Service/Provider/Sphinx/SphinxService.php(191): Zend\Paginator\Paginator->setItemCountPerPage(8)
  55. #7 /home/zf3/htdocs/module/Search/src/Service/MainPageAds/DefaultAdsDataProvider.php(460): Search\Service\Provider\Sphinx\SphinxService->getSearchResult(Object(Zend\Http\PhpEnvironment\Request), 'main-page-sale-...')
  56. #8 /home/zf3/htdocs/module/Search/src/Service/MainPageAds/DefaultAdsDataProvider.php(250): Search\Service\MainPageAds\DefaultAdsDataProvider->getAdsDataAndCount(Array, 'bWFpbi1wYWdlLWF...', Array)
  57. #9 /home/zf3/htdocs/module/Search/src/Service/MainPageAds/DefaultAdsDataProvider.php(428): Search\Service\MainPageAds\DefaultAdsDataProvider->getQueryThreeData()
  58. #10 /home/zf3/htdocs/module/Search/src/Service/MainPageAds/DefaultAdsDataProvider.php(114): Search\Service\MainPageAds\DefaultAdsDataProvider->getMainPageAdsData()
  59. #11 /home/zf3/htdocs/module/Search/src/View/Helper/MainPageAdsRenderer.php(69): Search\Service\MainPageAds\DefaultAdsDataProvider->getData()
  60. #12 /home/zf3/htdocs/module/Application/view/application/index/main-host-index.phtml(37): Search\View\Helper\MainPageAdsRenderer->render()
  61. #13 /home/zf3/htdocs/vendor/zendframework/zend-view/src/Renderer/PhpRenderer.php(506): include('/home/zf3/htdoc...')
  62. #14 /home/zf3/htdocs/vendor/zendframework/zend-view/src/Helper/Partial.php(61): Zend\View\Renderer\PhpRenderer->render(NULL, NULL)
  63. #15 [internal function]: Zend\View\Helper\Partial->__invoke('application/ind...', Array)
  64. #16 /home/zf3/htdocs/vendor/zendframework/zend-view/src/Renderer/PhpRenderer.php(397): call_user_func_array(Object(Zend\View\Helper\Partial), Array)
  65. #17 /home/zf3/htdocs/module/Application/src/View/Helper/MainPageHelper.php(101): Zend\View\Renderer\PhpRenderer->__call('partial', Array)
  66. #18 /home/zf3/htdocs/module/Application/view/application/index/index.phtml(6): Application\View\Helper\MainPageHelper->renderForMainHost()
  67. #19 /home/zf3/htdocs/vendor/zendframework/zend-view/src/Renderer/PhpRenderer.php(506): include('/home/zf3/htdoc...')
  68. #20 /home/zf3/htdocs/vendor/zendframework/zend-view/src/View.php(207): Zend\View\Renderer\PhpRenderer->render(NULL)
  69. #21 /home/zf3/htdocs/vendor/zendframework/zend-view/src/View.php(236): Zend\View\View->render(Object(Zend\View\Model\ViewModel))
  70. #22 /home/zf3/htdocs/vendor/zendframework/zend-view/src/View.php(200): Zend\View\View->renderChildren(Object(Zend\View\Model\ViewModel))
  71. #23 /home/zf3/htdocs/vendor/zendframework/zend-mvc/src/View/Http/DefaultRenderingStrategy.php(105): Zend\View\View->render(Object(Zend\View\Model\ViewModel))
  72. #24 /home/zf3/htdocs/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Zend\Mvc\View\Http\DefaultRenderingStrategy->render(Object(Zend\Mvc\MvcEvent))
  73. #25 /home/zf3/htdocs/vendor/zendframework/zend-eventmanager/src/EventManager.php(171): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent))
  74. #26 /home/zf3/htdocs/vendor/zendframework/zend-mvc/src/Application.php(367): Zend\EventManager\EventManager->triggerEvent(Object(Zend\Mvc\MvcEvent))
  75. #27 /home/zf3/htdocs/vendor/zendframework/zend-mvc/src/Application.php(348): Zend\Mvc\Application->completeRequest(Object(Zend\Mvc\MvcEvent))
  76. #28 /home/zf3/htdocs/public/index.php(59): Zend\Mvc\Application->run()
  77. #29 {main}
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top