Whoops, looks like something went wrong.

2/2 QueryException in Connection.php line 669: 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 'AND location= and `start_time` < ? and `end_time` > ?' at line 1 (SQL: select count(*) as aggregate from `booking` where id<> AND location= and `start_time` < 1710827712 and `end_time` > 1710827712)

  1. in Connection.php line 669
  2. at Connection->runQueryCallback('select count(*) as aggregate from `booking` where id<> AND location= and `start_time` < ? and `end_time` > ?', array('1710827712', '1710827712'), object(Closure)) in Connection.php line 629
  3. at Connection->run('select count(*) as aggregate from `booking` where id<> AND location= and `start_time` < ? and `end_time` > ?', array('1710827712', '1710827712'), object(Closure)) in Connection.php line 342
  4. at Connection->select('select count(*) as aggregate from `booking` where id<> AND location= and `start_time` < ? and `end_time` > ?', array('1710827712', '1710827712'), true) in Builder.php line 1461
  5. at Builder->runSelect() in Builder.php line 1447
  6. at Builder->get() in Builder.php line 1521
  7. at Builder->getCountForPagination() in Builder.php line 433
  8. at Builder->paginate('4') in HomeController.php line 4891
  9. at HomeController->wedding_booking_detailed('24')
  10. at call_user_func_array(array(object(HomeController), 'wedding_booking_detailed'), array('id' => '24')) in Controller.php line 80
  11. at Controller->callAction('wedding_booking_detailed', array('id' => '24')) in ControllerDispatcher.php line 146
  12. at ControllerDispatcher->call(object(HomeController), object(Route), 'wedding_booking_detailed') in ControllerDispatcher.php line 94
  13. at ControllerDispatcher->Illuminate\Routing\{closure}(object(Request))
  14. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
  15. at Pipeline->Illuminate\Routing\{closure}(object(Request))
  16. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 102
  17. at Pipeline->then(object(Closure)) in ControllerDispatcher.php line 96
  18. at ControllerDispatcher->callWithinStack(object(HomeController), object(Route), object(Request), 'wedding_booking_detailed') in ControllerDispatcher.php line 54
  19. at ControllerDispatcher->dispatch(object(Route), object(Request), 'App\Http\Controllers\HomeController', 'wedding_booking_detailed') in Route.php line 174
  20. at Route->runController(object(Request)) in Route.php line 140
  21. at Route->run(object(Request)) in Router.php line 759
  22. at Router->Illuminate\Routing\{closure}(object(Request))
  23. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
  24. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in CheckMerchantStatusMiddleware.php line 25
  25. at CheckMerchantStatusMiddleware->handle(object(Request), object(Closure))
  26. at call_user_func_array(array(object(CheckMerchantStatusMiddleware), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
  27. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  28. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  29. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in VerifyCsrfToken.php line 64
  30. at VerifyCsrfToken->handle(object(Request), object(Closure))
  31. at call_user_func_array(array(object(VerifyCsrfToken), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
  32. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  33. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  34. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in ShareErrorsFromSession.php line 49
  35. at ShareErrorsFromSession->handle(object(Request), object(Closure))
  36. at call_user_func_array(array(object(ShareErrorsFromSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
  37. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  38. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  39. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in StartSession.php line 62
  40. at StartSession->handle(object(Request), object(Closure))
  41. at call_user_func_array(array(object(StartSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
  42. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  43. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  44. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 37
  45. at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))
  46. at call_user_func_array(array(object(AddQueuedCookiesToResponse), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
  47. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  48. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  49. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in EncryptCookies.php line 59
  50. at EncryptCookies->handle(object(Request), object(Closure))
  51. at call_user_func_array(array(object(EncryptCookies), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
  52. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  53. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  54. at Pipeline->Illuminate\Routing\{closure}(object(Request))
  55. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 102
  56. at Pipeline->then(object(Closure)) in Router.php line 761
  57. at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 734
  58. at Router->dispatchToRoute(object(Request)) in Router.php line 710
  59. at Router->dispatch(object(Request)) in Kernel.php line 246
  60. at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))
  61. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
  62. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in CheckForMaintenanceMode.php line 44
  63. at CheckForMaintenanceMode->handle(object(Request), object(Closure))
  64. at call_user_func_array(array(object(CheckForMaintenanceMode), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
  65. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  66. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  67. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Request.php line 111
  68. at Request->handle(object(Request), object(Closure))
  69. at call_user_func_array(array(object(Request), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
  70. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  71. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  72. at Pipeline->Illuminate\Routing\{closure}(object(Request))
  73. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 102
  74. at Pipeline->then(object(Closure)) in Kernel.php line 132
  75. at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 99
  76. at Kernel->handle(object(Request)) in index.php line 52

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 'AND location= and `start_time` < ? and `end_time` > ?' at line 1

  1. in Connection.php line 333
  2. at PDO->prepare('select count(*) as aggregate from `booking` where id<> AND location= and `start_time` < ? and `end_time` > ?') in Connection.php line 333
  3. at Connection->Illuminate\Database\{closure}(object(MySqlConnection), 'select count(*) as aggregate from `booking` where id<> AND location= and `start_time` < ? and `end_time` > ?', array('1710827712', '1710827712')) in Connection.php line 662
  4. at Connection->runQueryCallback('select count(*) as aggregate from `booking` where id<> AND location= and `start_time` < ? and `end_time` > ?', array('1710827712', '1710827712'), object(Closure)) in Connection.php line 629
  5. at Connection->run('select count(*) as aggregate from `booking` where id<> AND location= and `start_time` < ? and `end_time` > ?', array('1710827712', '1710827712'), object(Closure)) in Connection.php line 342
  6. at Connection->select('select count(*) as aggregate from `booking` where id<> AND location= and `start_time` < ? and `end_time` > ?', array('1710827712', '1710827712'), true) in Builder.php line 1461
  7. at Builder->runSelect() in Builder.php line 1447
  8. at Builder->get() in Builder.php line 1521
  9. at Builder->getCountForPagination() in Builder.php line 433
  10. at Builder->paginate('4') in HomeController.php line 4891
  11. at HomeController->wedding_booking_detailed('24')
  12. at call_user_func_array(array(object(HomeController), 'wedding_booking_detailed'), array('id' => '24')) in Controller.php line 80
  13. at Controller->callAction('wedding_booking_detailed', array('id' => '24')) in ControllerDispatcher.php line 146
  14. at ControllerDispatcher->call(object(HomeController), object(Route), 'wedding_booking_detailed') in ControllerDispatcher.php line 94
  15. at ControllerDispatcher->Illuminate\Routing\{closure}(object(Request))
  16. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
  17. at Pipeline->Illuminate\Routing\{closure}(object(Request))
  18. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 102
  19. at Pipeline->then(object(Closure)) in ControllerDispatcher.php line 96
  20. at ControllerDispatcher->callWithinStack(object(HomeController), object(Route), object(Request), 'wedding_booking_detailed') in ControllerDispatcher.php line 54
  21. at ControllerDispatcher->dispatch(object(Route), object(Request), 'App\Http\Controllers\HomeController', 'wedding_booking_detailed') in Route.php line 174
  22. at Route->runController(object(Request)) in Route.php line 140
  23. at Route->run(object(Request)) in Router.php line 759
  24. at Router->Illuminate\Routing\{closure}(object(Request))
  25. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
  26. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in CheckMerchantStatusMiddleware.php line 25
  27. at CheckMerchantStatusMiddleware->handle(object(Request), object(Closure))
  28. at call_user_func_array(array(object(CheckMerchantStatusMiddleware), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
  29. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  30. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  31. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in VerifyCsrfToken.php line 64
  32. at VerifyCsrfToken->handle(object(Request), object(Closure))
  33. at call_user_func_array(array(object(VerifyCsrfToken), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
  34. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  35. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  36. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in ShareErrorsFromSession.php line 49
  37. at ShareErrorsFromSession->handle(object(Request), object(Closure))
  38. at call_user_func_array(array(object(ShareErrorsFromSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
  39. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  40. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  41. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in StartSession.php line 62
  42. at StartSession->handle(object(Request), object(Closure))
  43. at call_user_func_array(array(object(StartSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
  44. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  45. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  46. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 37
  47. at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))
  48. at call_user_func_array(array(object(AddQueuedCookiesToResponse), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
  49. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  50. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  51. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in EncryptCookies.php line 59
  52. at EncryptCookies->handle(object(Request), object(Closure))
  53. at call_user_func_array(array(object(EncryptCookies), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
  54. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  55. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  56. at Pipeline->Illuminate\Routing\{closure}(object(Request))
  57. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 102
  58. at Pipeline->then(object(Closure)) in Router.php line 761
  59. at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 734
  60. at Router->dispatchToRoute(object(Request)) in Router.php line 710
  61. at Router->dispatch(object(Request)) in Kernel.php line 246
  62. at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))
  63. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
  64. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in CheckForMaintenanceMode.php line 44
  65. at CheckForMaintenanceMode->handle(object(Request), object(Closure))
  66. at call_user_func_array(array(object(CheckForMaintenanceMode), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
  67. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  68. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  69. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Request.php line 111
  70. at Request->handle(object(Request), object(Closure))
  71. at call_user_func_array(array(object(Request), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
  72. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  73. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  74. at Pipeline->Illuminate\Routing\{closure}(object(Request))
  75. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 102
  76. at Pipeline->then(object(Closure)) in Kernel.php line 132
  77. at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 99
  78. at Kernel->handle(object(Request)) in index.php line 52