Whoops, looks like something went wrong.

2/2 QueryException in Connection.php line 770: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'offset 0' at line 1 (SQL: select * from `vacancys` order by `published` desc offset 0)

  1. in Connection.php line 770
  2. at Connection->runQueryCallback('select * from `vacancys` order by `published` desc offset 0', array(), object(Closure)) in Connection.php line 726
  3. at Connection->run('select * from `vacancys` order by `published` desc offset 0', array(), object(Closure)) in Connection.php line 351
  4. at Connection->select('select * from `vacancys` order by `published` desc offset 0', array(), true) in Builder.php line 1648
  5. at Builder->runSelect() in Builder.php line 1634
  6. at Builder->get(array('*')) in Builder.php line 638
  7. at Builder->getModels(array('*')) in Builder.php line 327
  8. at Builder->get() in Sphinx.php line 162
  9. at Sphinx::getVacancies(array('region' => '35', 'exclude_ids' => array('6915233', '6918649', '7525155', '7200815')), '-5', '0') in VacancyController.php line 170
  10. at VacancyController->getVacanciesData(object(Region), object(Region), null) in VacancyController.php line 275
  11. at VacancyController->vacancylist(array())
  12. at call_user_func_array(array(object(VacancyController), 'vacancylist'), array('path' => 'irkutskaya-oblast/irkutsk/farmatsevt')) in Controller.php line 55
  13. at Controller->callAction('vacancylist', array('path' => 'irkutskaya-oblast/irkutsk/farmatsevt')) in ControllerDispatcher.php line 44
  14. at ControllerDispatcher->dispatch(object(Route), object(VacancyController), 'vacancylist') in Route.php line 189
  15. at Route->runController() in Route.php line 144
  16. at Route->run(object(Request)) in Router.php line 653
  17. at Router->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 53
  18. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Cache.php line 21
  19. at Cache->handle(object(Request), object(Closure), '15') in Pipeline.php line 137
  20. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  21. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in ViewInit.php line 103
  22. at ViewInit->handle(object(Request), object(Closure)) in Pipeline.php line 137
  23. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  24. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in SubstituteBindings.php line 41
  25. at SubstituteBindings->handle(object(Request), object(Closure)) in Pipeline.php line 137
  26. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  27. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in VerifyCsrfToken.php line 65
  28. at VerifyCsrfToken->handle(object(Request), object(Closure)) in Pipeline.php line 137
  29. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  30. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in ShareErrorsFromSession.php line 49
  31. at ShareErrorsFromSession->handle(object(Request), object(Closure)) in Pipeline.php line 137
  32. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  33. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in StartSession.php line 64
  34. at StartSession->handle(object(Request), object(Closure)) in Pipeline.php line 137
  35. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  36. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 37
  37. at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) in Pipeline.php line 137
  38. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  39. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in EncryptCookies.php line 59
  40. at EncryptCookies->handle(object(Request), object(Closure)) in Pipeline.php line 137
  41. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  42. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 104
  43. at Pipeline->then(object(Closure)) in Router.php line 655
  44. at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 629
  45. at Router->dispatchToRoute(object(Request)) in Router.php line 607
  46. at Router->dispatch(object(Request)) in Kernel.php line 268
  47. at Kernel->Illuminate\Foundation\Http\{closure}(object(Request)) in Pipeline.php line 53
  48. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in CheckForMaintenanceMode.php line 46
  49. at CheckForMaintenanceMode->handle(object(Request), object(Closure)) in Pipeline.php line 137
  50. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  51. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 104
  52. at Pipeline->then(object(Closure)) in Kernel.php line 150
  53. at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 117
  54. at Kernel->handle(object(Request)) in index.php line 53
  55. at require_once('/var/www/joobix/data/www/joobis.ru/public/index.php') in index.php line 4

1/2 PDOException in Connection.php line 333: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'offset 0' at line 1

  1. in Connection.php line 333
  2. at PDO->prepare('select * from `vacancys` order by `published` desc offset 0') in Connection.php line 333
  3. at Connection->Illuminate\Database\{closure}(object(MySqlConnection), 'select * from `vacancys` order by `published` desc offset 0', array()) in Connection.php line 763
  4. at Connection->runQueryCallback('select * from `vacancys` order by `published` desc offset 0', array(), object(Closure)) in Connection.php line 726
  5. at Connection->run('select * from `vacancys` order by `published` desc offset 0', array(), object(Closure)) in Connection.php line 351
  6. at Connection->select('select * from `vacancys` order by `published` desc offset 0', array(), true) in Builder.php line 1648
  7. at Builder->runSelect() in Builder.php line 1634
  8. at Builder->get(array('*')) in Builder.php line 638
  9. at Builder->getModels(array('*')) in Builder.php line 327
  10. at Builder->get() in Sphinx.php line 162
  11. at Sphinx::getVacancies(array('region' => '35', 'exclude_ids' => array('6915233', '6918649', '7525155', '7200815')), '-5', '0') in VacancyController.php line 170
  12. at VacancyController->getVacanciesData(object(Region), object(Region), null) in VacancyController.php line 275
  13. at VacancyController->vacancylist(array())
  14. at call_user_func_array(array(object(VacancyController), 'vacancylist'), array('path' => 'irkutskaya-oblast/irkutsk/farmatsevt')) in Controller.php line 55
  15. at Controller->callAction('vacancylist', array('path' => 'irkutskaya-oblast/irkutsk/farmatsevt')) in ControllerDispatcher.php line 44
  16. at ControllerDispatcher->dispatch(object(Route), object(VacancyController), 'vacancylist') in Route.php line 189
  17. at Route->runController() in Route.php line 144
  18. at Route->run(object(Request)) in Router.php line 653
  19. at Router->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 53
  20. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Cache.php line 21
  21. at Cache->handle(object(Request), object(Closure), '15') in Pipeline.php line 137
  22. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  23. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in ViewInit.php line 103
  24. at ViewInit->handle(object(Request), object(Closure)) in Pipeline.php line 137
  25. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  26. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in SubstituteBindings.php line 41
  27. at SubstituteBindings->handle(object(Request), object(Closure)) in Pipeline.php line 137
  28. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  29. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in VerifyCsrfToken.php line 65
  30. at VerifyCsrfToken->handle(object(Request), object(Closure)) in Pipeline.php line 137
  31. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  32. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in ShareErrorsFromSession.php line 49
  33. at ShareErrorsFromSession->handle(object(Request), object(Closure)) in Pipeline.php line 137
  34. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  35. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in StartSession.php line 64
  36. at StartSession->handle(object(Request), object(Closure)) in Pipeline.php line 137
  37. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  38. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 37
  39. at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) in Pipeline.php line 137
  40. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  41. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in EncryptCookies.php line 59
  42. at EncryptCookies->handle(object(Request), object(Closure)) in Pipeline.php line 137
  43. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  44. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 104
  45. at Pipeline->then(object(Closure)) in Router.php line 655
  46. at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 629
  47. at Router->dispatchToRoute(object(Request)) in Router.php line 607
  48. at Router->dispatch(object(Request)) in Kernel.php line 268
  49. at Kernel->Illuminate\Foundation\Http\{closure}(object(Request)) in Pipeline.php line 53
  50. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in CheckForMaintenanceMode.php line 46
  51. at CheckForMaintenanceMode->handle(object(Request), object(Closure)) in Pipeline.php line 137
  52. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  53. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 104
  54. at Pipeline->then(object(Closure)) in Kernel.php line 150
  55. at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 117
  56. at Kernel->handle(object(Request)) in index.php line 53
  57. at require_once('/var/www/joobix/data/www/joobis.ru/public/index.php') in index.php line 4