API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 16th, 2019
100
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.81 KB | None | 0 0
raw download clone embed print report
  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}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!