[2013-11-24 00:21:48] log.ERROR: exception 'Symfony\Component\HttpKernel\Exception\NotFoundHttpException' in Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php:1429 Stack trace: #0 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1050): Illuminate\Routing\Router->handleRoutingException(Object(Symfony\Component\Routing\Exception\ResourceNotFoundException)) #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1014): Illuminate\Routing\Router->findRoute(Object(Illuminate\Http\Request)) #2 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #3 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #4 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #5 {main} [] [] [2013-11-24 00:22:24] log.ERROR: exception 'Symfony\Component\HttpKernel\Exception\NotFoundHttpException' in Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php:1429 Stack trace: #0 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1050): Illuminate\Routing\Router->handleRoutingException(Object(Symfony\Component\Routing\Exception\ResourceNotFoundException)) #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1014): Illuminate\Routing\Router->findRoute(Object(Illuminate\Http\Request)) #2 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #3 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #4 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #5 {main} [] [] [2013-11-24 00:22:34] log.ERROR: exception 'Symfony\Component\HttpKernel\Exception\NotFoundHttpException' in Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php:1429 Stack trace: #0 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1050): Illuminate\Routing\Router->handleRoutingException(Object(Symfony\Component\Routing\Exception\ResourceNotFoundException)) #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1014): Illuminate\Routing\Router->findRoute(Object(Illuminate\Http\Request)) #2 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #3 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #4 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #5 {main} [] [] [2013-11-24 00:23:22] log.ERROR: exception 'Symfony\Component\HttpKernel\Exception\NotFoundHttpException' in Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php:1429 Stack trace: #0 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1050): Illuminate\Routing\Router->handleRoutingException(Object(Symfony\Component\Routing\Exception\ResourceNotFoundException)) #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1014): Illuminate\Routing\Router->findRoute(Object(Illuminate\Http\Request)) #2 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #3 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #4 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #5 {main} [] [] [2013-11-24 00:23:49] log.ERROR: exception 'Symfony\Component\HttpKernel\Exception\NotFoundHttpException' in Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php:1429 Stack trace: #0 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1050): Illuminate\Routing\Router->handleRoutingException(Object(Symfony\Component\Routing\Exception\ResourceNotFoundException)) #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1014): Illuminate\Routing\Router->findRoute(Object(Illuminate\Http\Request)) #2 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #3 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #4 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #5 {main} [] [] [2013-11-24 00:24:39] log.ERROR: exception 'Symfony\Component\HttpKernel\Exception\NotFoundHttpException' in Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php:1429 Stack trace: #0 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1050): Illuminate\Routing\Router->handleRoutingException(Object(Symfony\Component\Routing\Exception\ResourceNotFoundException)) #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1014): Illuminate\Routing\Router->findRoute(Object(Illuminate\Http\Request)) #2 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #3 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #4 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #5 {main} [] [] [2013-11-24 00:25:08] log.ERROR: exception 'Symfony\Component\HttpKernel\Exception\NotFoundHttpException' in Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php:1429 Stack trace: #0 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1050): Illuminate\Routing\Router->handleRoutingException(Object(Symfony\Component\Routing\Exception\ResourceNotFoundException)) #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1014): Illuminate\Routing\Router->findRoute(Object(Illuminate\Http\Request)) #2 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #3 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #4 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #5 {main} [] [] [2013-11-24 01:17:40] log.ERROR: exception 'Symfony\Component\HttpKernel\Exception\NotFoundHttpException' in Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php:1429 Stack trace: #0 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1050): Illuminate\Routing\Router->handleRoutingException(Object(Symfony\Component\Routing\Exception\ResourceNotFoundException)) #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1014): Illuminate\Routing\Router->findRoute(Object(Illuminate\Http\Request)) #2 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #3 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #4 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #5 {main} [] [] [2013-11-24 01:27:23] log.ERROR: exception 'Symfony\Component\HttpKernel\Exception\NotFoundHttpException' in Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php:1429 Stack trace: #0 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1050): Illuminate\Routing\Router->handleRoutingException(Object(Symfony\Component\Routing\Exception\ResourceNotFoundException)) #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1014): Illuminate\Routing\Router->findRoute(Object(Illuminate\Http\Request)) #2 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #3 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #4 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #5 {main} [] [] [2013-11-24 01:37:09] log.ERROR: exception 'Symfony\Component\HttpKernel\Exception\NotFoundHttpException' in Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php:1429 Stack trace: #0 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1050): Illuminate\Routing\Router->handleRoutingException(Object(Symfony\Component\Routing\Exception\ResourceNotFoundException)) #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1014): Illuminate\Routing\Router->findRoute(Object(Illuminate\Http\Request)) #2 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #3 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #4 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #5 {main} [] [] [2013-11-24 01:37:09] log.ERROR: exception 'Symfony\Component\HttpKernel\Exception\NotFoundHttpException' in Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php:1429 Stack trace: #0 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1050): Illuminate\Routing\Router->handleRoutingException(Object(Symfony\Component\Routing\Exception\ResourceNotFoundException)) #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1014): Illuminate\Routing\Router->findRoute(Object(Illuminate\Http\Request)) #2 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #3 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #4 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #5 {main} [] [] [2013-11-24 01:47:39] log.ERROR: exception 'Symfony\Component\HttpKernel\Exception\NotFoundHttpException' in Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php:1429 Stack trace: #0 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1050): Illuminate\Routing\Router->handleRoutingException(Object(Symfony\Component\Routing\Exception\ResourceNotFoundException)) #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1014): Illuminate\Routing\Router->findRoute(Object(Illuminate\Http\Request)) #2 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #3 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #4 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #5 {main} [] [] [2013-11-24 02:00:26] log.ERROR: exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'brokers.rental_id' in 'where clause'' in Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php:272 Stack trace: #0 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(272): PDO->prepare('select * from `...') #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(521): Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'select * from `...', Array) #2 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(277): Illuminate\Database\Connection->run('select * from `...', Array, Object(Closure)) #3 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(1028): Illuminate\Database\Connection->select('select * from `...', Array) #4 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(1018): Illuminate\Database\Query\Builder->runSelect() #5 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(1005): Illuminate\Database\Query\Builder->getFresh(Array) #6 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(441): Illuminate\Database\Query\Builder->get(Array) #7 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(132): Illuminate\Database\Eloquent\Builder->getModels(Array) #8 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(108): Illuminate\Database\Eloquent\Builder->get(Array) #9 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Relations\HasOne.php(14): Illuminate\Database\Eloquent\Builder->first() #10 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(2053): Illuminate\Database\Eloquent\Relations\HasOne->getResults() #11 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(2535): Illuminate\Database\Eloquent\Model->getAttribute('broker') #12 Z:\home\local\cr\app\storage\views\a85831431d093006cc180510563640fe(83): Illuminate\Database\Eloquent\Model->__get('broker') #13 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\Engines\PhpEngine.php(38): include('Z:\home\local\c...') #14 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\Engines\CompilerEngine.php(45): Illuminate\View\Engines\PhpEngine->evaluatePath('Z:\home\local\c...', Array) #15 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\View.php(100): Illuminate\View\Engines\CompilerEngine->get('Z:\home\local\c...', Array) #16 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\View.php(81): Illuminate\View\View->getContents() #17 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\View.php(116): Illuminate\View\View->render() #18 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\View.php(100): Illuminate\View\View->gatherData() #19 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\View.php(81): Illuminate\View\View->getContents() #20 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Http\Response.php(70): Illuminate\View\View->render() #21 Z:\home\local\cr\vendor\symfony\http-foundation\Symfony\Component\HttpFoundation\Response.php(141): Illuminate\Http\Response->setContent(Object(Illuminate\View\View)) #22 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1414): Symfony\Component\HttpFoundation\Response->__construct(Object(Illuminate\View\View)) #23 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(156): Illuminate\Routing\Router->prepare(Object(Illuminate\View\View), Object(Illuminate\Http\Request)) #24 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(126): Illuminate\Routing\Controllers\Controller->processResponse(Object(Illuminate\Routing\Router), 'getView', Object(Illuminate\View\View)) #25 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(985): Illuminate\Routing\Controllers\Controller->callAction(Object(Illuminate\Foundation\Application), Object(Illuminate\Routing\Router), 'getView', Array) #26 [internal function]: Illuminate\Routing\{closure}('flatiron', '38', 'sixth-avenue') #27 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(80): call_user_func_array(Object(Closure), Array) #28 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(47): Illuminate\Routing\Route->callCallable() #29 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1016): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) #30 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #31 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #32 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #33 {main} Next exception 'Exception' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'brokers.rental_id' in 'where clause' (SQL: select * from `brokers` where `brokers`.`rental_id` = ? limit 1) (Bindings: array ( 0 => 38, ))' in Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php:556 Stack trace: #0 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(529): Illuminate\Database\Connection->handleQueryException(Object(PDOException), 'select * from `...', Array) #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(277): Illuminate\Database\Connection->run('select * from `...', Array, Object(Closure)) #2 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(1028): Illuminate\Database\Connection->select('select * from `...', Array) #3 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(1018): Illuminate\Database\Query\Builder->runSelect() #4 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(1005): Illuminate\Database\Query\Builder->getFresh(Array) #5 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(441): Illuminate\Database\Query\Builder->get(Array) #6 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(132): Illuminate\Database\Eloquent\Builder->getModels(Array) #7 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(108): Illuminate\Database\Eloquent\Builder->get(Array) #8 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Relations\HasOne.php(14): Illuminate\Database\Eloquent\Builder->first() #9 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(2053): Illuminate\Database\Eloquent\Relations\HasOne->getResults() #10 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(2535): Illuminate\Database\Eloquent\Model->getAttribute('broker') #11 Z:\home\local\cr\app\storage\views\a85831431d093006cc180510563640fe(83): Illuminate\Database\Eloquent\Model->__get('broker') #12 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\Engines\PhpEngine.php(38): include('Z:\home\local\c...') #13 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\Engines\CompilerEngine.php(45): Illuminate\View\Engines\PhpEngine->evaluatePath('Z:\home\local\c...', Array) #14 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\View.php(100): Illuminate\View\Engines\CompilerEngine->get('Z:\home\local\c...', Array) #15 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\View.php(81): Illuminate\View\View->getContents() #16 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\View.php(116): Illuminate\View\View->render() #17 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\View.php(100): Illuminate\View\View->gatherData() #18 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\View.php(81): Illuminate\View\View->getContents() #19 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Http\Response.php(70): Illuminate\View\View->render() #20 Z:\home\local\cr\vendor\symfony\http-foundation\Symfony\Component\HttpFoundation\Response.php(141): Illuminate\Http\Response->setContent(Object(Illuminate\View\View)) #21 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1414): Symfony\Component\HttpFoundation\Response->__construct(Object(Illuminate\View\View)) #22 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(156): Illuminate\Routing\Router->prepare(Object(Illuminate\View\View), Object(Illuminate\Http\Request)) #23 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(126): Illuminate\Routing\Controllers\Controller->processResponse(Object(Illuminate\Routing\Router), 'getView', Object(Illuminate\View\View)) #24 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(985): Illuminate\Routing\Controllers\Controller->callAction(Object(Illuminate\Foundation\Application), Object(Illuminate\Routing\Router), 'getView', Array) #25 [internal function]: Illuminate\Routing\{closure}('flatiron', '38', 'sixth-avenue') #26 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(80): call_user_func_array(Object(Closure), Array) #27 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(47): Illuminate\Routing\Route->callCallable() #28 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1016): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) #29 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #30 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #31 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #32 {main} [] [] [2013-11-24 02:01:24] log.ERROR: exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'brokers.rental_id' in 'where clause'' in Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php:272 Stack trace: #0 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(272): PDO->prepare('select * from `...') #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(521): Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'select * from `...', Array) #2 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(277): Illuminate\Database\Connection->run('select * from `...', Array, Object(Closure)) #3 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(1028): Illuminate\Database\Connection->select('select * from `...', Array) #4 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(1018): Illuminate\Database\Query\Builder->runSelect() #5 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(1005): Illuminate\Database\Query\Builder->getFresh(Array) #6 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(441): Illuminate\Database\Query\Builder->get(Array) #7 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(132): Illuminate\Database\Eloquent\Builder->getModels(Array) #8 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(108): Illuminate\Database\Eloquent\Builder->get(Array) #9 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Relations\HasOne.php(14): Illuminate\Database\Eloquent\Builder->first() #10 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(2053): Illuminate\Database\Eloquent\Relations\HasOne->getResults() #11 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(2535): Illuminate\Database\Eloquent\Model->getAttribute('broker') #12 Z:\home\local\cr\app\storage\views\a85831431d093006cc180510563640fe(83): Illuminate\Database\Eloquent\Model->__get('broker') #13 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\Engines\PhpEngine.php(38): include('Z:\home\local\c...') #14 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\Engines\CompilerEngine.php(45): Illuminate\View\Engines\PhpEngine->evaluatePath('Z:\home\local\c...', Array) #15 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\View.php(100): Illuminate\View\Engines\CompilerEngine->get('Z:\home\local\c...', Array) #16 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\View.php(81): Illuminate\View\View->getContents() #17 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\View.php(116): Illuminate\View\View->render() #18 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\View.php(100): Illuminate\View\View->gatherData() #19 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\View.php(81): Illuminate\View\View->getContents() #20 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Http\Response.php(70): Illuminate\View\View->render() #21 Z:\home\local\cr\vendor\symfony\http-foundation\Symfony\Component\HttpFoundation\Response.php(141): Illuminate\Http\Response->setContent(Object(Illuminate\View\View)) #22 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1414): Symfony\Component\HttpFoundation\Response->__construct(Object(Illuminate\View\View)) #23 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(156): Illuminate\Routing\Router->prepare(Object(Illuminate\View\View), Object(Illuminate\Http\Request)) #24 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(126): Illuminate\Routing\Controllers\Controller->processResponse(Object(Illuminate\Routing\Router), 'getView', Object(Illuminate\View\View)) #25 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(985): Illuminate\Routing\Controllers\Controller->callAction(Object(Illuminate\Foundation\Application), Object(Illuminate\Routing\Router), 'getView', Array) #26 [internal function]: Illuminate\Routing\{closure}('flatiron', '38', 'sixth-avenue') #27 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(80): call_user_func_array(Object(Closure), Array) #28 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(47): Illuminate\Routing\Route->callCallable() #29 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1016): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) #30 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #31 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #32 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #33 {main} Next exception 'Exception' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'brokers.rental_id' in 'where clause' (SQL: select * from `brokers` where `brokers`.`rental_id` = ? limit 1) (Bindings: array ( 0 => 38, ))' in Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php:556 Stack trace: #0 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(529): Illuminate\Database\Connection->handleQueryException(Object(PDOException), 'select * from `...', Array) #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(277): Illuminate\Database\Connection->run('select * from `...', Array, Object(Closure)) #2 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(1028): Illuminate\Database\Connection->select('select * from `...', Array) #3 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(1018): Illuminate\Database\Query\Builder->runSelect() #4 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(1005): Illuminate\Database\Query\Builder->getFresh(Array) #5 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(441): Illuminate\Database\Query\Builder->get(Array) #6 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(132): Illuminate\Database\Eloquent\Builder->getModels(Array) #7 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(108): Illuminate\Database\Eloquent\Builder->get(Array) #8 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Relations\HasOne.php(14): Illuminate\Database\Eloquent\Builder->first() #9 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(2053): Illuminate\Database\Eloquent\Relations\HasOne->getResults() #10 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(2535): Illuminate\Database\Eloquent\Model->getAttribute('broker') #11 Z:\home\local\cr\app\storage\views\a85831431d093006cc180510563640fe(83): Illuminate\Database\Eloquent\Model->__get('broker') #12 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\Engines\PhpEngine.php(38): include('Z:\home\local\c...') #13 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\Engines\CompilerEngine.php(45): Illuminate\View\Engines\PhpEngine->evaluatePath('Z:\home\local\c...', Array) #14 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\View.php(100): Illuminate\View\Engines\CompilerEngine->get('Z:\home\local\c...', Array) #15 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\View.php(81): Illuminate\View\View->getContents() #16 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\View.php(116): Illuminate\View\View->render() #17 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\View.php(100): Illuminate\View\View->gatherData() #18 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\View.php(81): Illuminate\View\View->getContents() #19 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Http\Response.php(70): Illuminate\View\View->render() #20 Z:\home\local\cr\vendor\symfony\http-foundation\Symfony\Component\HttpFoundation\Response.php(141): Illuminate\Http\Response->setContent(Object(Illuminate\View\View)) #21 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1414): Symfony\Component\HttpFoundation\Response->__construct(Object(Illuminate\View\View)) #22 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(156): Illuminate\Routing\Router->prepare(Object(Illuminate\View\View), Object(Illuminate\Http\Request)) #23 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(126): Illuminate\Routing\Controllers\Controller->processResponse(Object(Illuminate\Routing\Router), 'getView', Object(Illuminate\View\View)) #24 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(985): Illuminate\Routing\Controllers\Controller->callAction(Object(Illuminate\Foundation\Application), Object(Illuminate\Routing\Router), 'getView', Array) #25 [internal function]: Illuminate\Routing\{closure}('flatiron', '38', 'sixth-avenue') #26 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(80): call_user_func_array(Object(Closure), Array) #27 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(47): Illuminate\Routing\Route->callCallable() #28 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1016): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) #29 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #30 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #31 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #32 {main} [] [] [2013-11-24 02:02:15] log.ERROR: exception 'BadMethodCallException' with message 'Call to undefined method Illuminate\Database\Query\Builder::brokerage()' in Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php:1658 Stack trace: #0 [internal function]: Illuminate\Database\Query\Builder->__call('brokerage', Array) #1 [internal function]: Illuminate\Database\Query\Builder->brokerage() #2 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(786): call_user_func_array(Array, Array) #3 [internal function]: Illuminate\Database\Eloquent\Builder->__call('brokerage', Array) #4 [internal function]: Illuminate\Database\Eloquent\Builder->brokerage() #5 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(2636): call_user_func_array(Array, Array) #6 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(526): Illuminate\Database\Eloquent\Model->__call('brokerage', Array) #7 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(526): Rental->brokerage() #8 [internal function]: Illuminate\Database\Eloquent\{closure}() #9 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Relations\Relation.php(159): call_user_func(Object(Closure)) #10 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(527): Illuminate\Database\Eloquent\Relations\Relation::noConstraints(Object(Closure)) #11 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(495): Illuminate\Database\Eloquent\Builder->getRelation('brokerage') #12 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(475): Illuminate\Database\Eloquent\Builder->loadRelation(Array, 'brokerage', Object(Closure)) #13 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(139): Illuminate\Database\Eloquent\Builder->eagerLoadRelations(Array) #14 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(108): Illuminate\Database\Eloquent\Builder->get(Array) #15 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(69): Illuminate\Database\Eloquent\Builder->first(Array) #16 Z:\home\local\cr\app\controllers\ApartmentsController.php(18): Illuminate\Database\Eloquent\Builder->find('38') #17 [internal function]: ApartmentsController->getView('flatiron', '38', 'sixth-avenue') #18 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(138): call_user_func_array(Array, Array) #19 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(115): Illuminate\Routing\Controllers\Controller->callMethod('getView', Array) #20 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(985): Illuminate\Routing\Controllers\Controller->callAction(Object(Illuminate\Foundation\Application), Object(Illuminate\Routing\Router), 'getView', Array) #21 [internal function]: Illuminate\Routing\{closure}('flatiron', '38', 'sixth-avenue') #22 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(80): call_user_func_array(Object(Closure), Array) #23 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(47): Illuminate\Routing\Route->callCallable() #24 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1016): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) #25 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #26 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #27 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #28 {main} [] [] [2013-11-24 02:14:40] log.ERROR: exception 'ErrorException' with message 'Undefined variable: event' in Z:\home\local\cr\app\storage\views\a85831431d093006cc180510563640fe:105 Stack trace: #0 Z:\home\local\cr\app\storage\views\a85831431d093006cc180510563640fe(105): Illuminate\Exception\Handler->handleError(8, 'Undefined varia...', 'Z:\home\local\c...', 105, Array) #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\Engines\PhpEngine.php(38): include('Z:\home\local\c...') #2 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\Engines\CompilerEngine.php(45): Illuminate\View\Engines\PhpEngine->evaluatePath('Z:\home\local\c...', Array) #3 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\View.php(100): Illuminate\View\Engines\CompilerEngine->get('Z:\home\local\c...', Array) #4 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\View.php(81): Illuminate\View\View->getContents() #5 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\View.php(116): Illuminate\View\View->render() #6 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\View.php(100): Illuminate\View\View->gatherData() #7 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\View.php(81): Illuminate\View\View->getContents() #8 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Http\Response.php(70): Illuminate\View\View->render() #9 Z:\home\local\cr\vendor\symfony\http-foundation\Symfony\Component\HttpFoundation\Response.php(141): Illuminate\Http\Response->setContent(Object(Illuminate\View\View)) #10 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1414): Symfony\Component\HttpFoundation\Response->__construct(Object(Illuminate\View\View)) #11 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(156): Illuminate\Routing\Router->prepare(Object(Illuminate\View\View), Object(Illuminate\Http\Request)) #12 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(126): Illuminate\Routing\Controllers\Controller->processResponse(Object(Illuminate\Routing\Router), 'getView', Object(Illuminate\View\View)) #13 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(985): Illuminate\Routing\Controllers\Controller->callAction(Object(Illuminate\Foundation\Application), Object(Illuminate\Routing\Router), 'getView', Array) #14 [internal function]: Illuminate\Routing\{closure}('bowery', '77', 'east-4th-street') #15 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(80): call_user_func_array(Object(Closure), Array) #16 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(47): Illuminate\Routing\Route->callCallable() #17 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1016): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) #18 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #19 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #20 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #21 {main} [] [] [2013-11-24 02:15:35] log.ERROR: exception 'ErrorException' with message 'Trying to get property of non-object' in Z:\home\local\cr\app\storage\views\a85831431d093006cc180510563640fe:49 Stack trace: #0 Z:\home\local\cr\app\storage\views\a85831431d093006cc180510563640fe(49): Illuminate\Exception\Handler->handleError(8, 'Trying to get p...', 'Z:\home\local\c...', 49, Array) #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\Engines\PhpEngine.php(38): include('Z:\home\local\c...') #2 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\Engines\CompilerEngine.php(45): Illuminate\View\Engines\PhpEngine->evaluatePath('Z:\home\local\c...', Array) #3 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\View.php(100): Illuminate\View\Engines\CompilerEngine->get('Z:\home\local\c...', Array) #4 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\View.php(81): Illuminate\View\View->getContents() #5 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\View.php(116): Illuminate\View\View->render() #6 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\View.php(100): Illuminate\View\View->gatherData() #7 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\View\View.php(81): Illuminate\View\View->getContents() #8 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Http\Response.php(70): Illuminate\View\View->render() #9 Z:\home\local\cr\vendor\symfony\http-foundation\Symfony\Component\HttpFoundation\Response.php(141): Illuminate\Http\Response->setContent(Object(Illuminate\View\View)) #10 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1414): Symfony\Component\HttpFoundation\Response->__construct(Object(Illuminate\View\View)) #11 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(156): Illuminate\Routing\Router->prepare(Object(Illuminate\View\View), Object(Illuminate\Http\Request)) #12 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(126): Illuminate\Routing\Controllers\Controller->processResponse(Object(Illuminate\Routing\Router), 'getView', Object(Illuminate\View\View)) #13 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(985): Illuminate\Routing\Controllers\Controller->callAction(Object(Illuminate\Foundation\Application), Object(Illuminate\Routing\Router), 'getView', Array) #14 [internal function]: Illuminate\Routing\{closure}('bowery', '77', 'east-4th-street') #15 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(80): call_user_func_array(Object(Closure), Array) #16 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(47): Illuminate\Routing\Route->callCallable() #17 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1016): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) #18 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #19 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #20 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #21 {main} [] [] [2013-11-24 02:25:29] log.INFO: Cauth - login attempt success. [] [] [2013-11-24 04:55:28] log.ERROR: exception 'PDOException' with message '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 'GROUP BY events.event_id ORDER BY distance, start_time LIMIT 0, 5' at line 11' in Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php:272 Stack trace: #0 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(272): PDO->prepare('SELECT places.p...') #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(521): Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'SELECT places.p...', Array) #2 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(277): Illuminate\Database\Connection->run('SELECT places.p...', Array, Object(Closure)) #3 [internal function]: Illuminate\Database\Connection->select('SELECT places.p...') #4 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\DatabaseManager.php(242): call_user_func_array(Array, Array) #5 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(206): Illuminate\Database\DatabaseManager->__call('select', Array) #6 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(206): Illuminate\Database\DatabaseManager->select('SELECT places.p...') #7 Z:\home\local\cr\app\models\EventModel.php(44): Illuminate\Support\Facades\Facade::__callStatic('select', Array) #8 Z:\home\local\cr\app\models\EventModel.php(44): Illuminate\Support\Facades\DB::select('SELECT places.p...') #9 Z:\home\local\cr\app\controllers\api\NeighborhoodsController.php(55): EventModel::getNearbyEvents(Array, 3) #10 [internal function]: Controllers\Api\NeighborhoodsController->postListings() #11 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(138): call_user_func_array(Array, Array) #12 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(115): Illuminate\Routing\Controllers\Controller->callMethod('postListings', Array) #13 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(985): Illuminate\Routing\Controllers\Controller->callAction(Object(Illuminate\Foundation\Application), Object(Illuminate\Routing\Router), 'postListings', Array) #14 [internal function]: Illuminate\Routing\{closure}() #15 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(80): call_user_func_array(Object(Closure), Array) #16 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(47): Illuminate\Routing\Route->callCallable() #17 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1016): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) #18 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #19 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #20 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #21 {main} Next exception 'Exception' with message '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 'GROUP BY events.event_id ORDER BY distance, start_time LIMIT 0, 5' at line 11 (SQL: SELECT places.place_id,places.name,places.address,places.locality as city, places.region as state, places.postcode as zipcode, places.phone, places.lat, places.lng, events.event_id,events.title, events.start_time, events.cover_image, events.price, ( 3959 * acos( cos( radians(40.7387574) ) * cos( radians( places.lat ) ) * cos( radians( places.lng ) - radians(-73.99161850000002) ) + sin( radians(40.7387574) ) * sin( radians( places.lat ) ) ) ) AS distance FROM events INNER JOIN places ON places.place_id=events.place_id LEFT JOIN events_to_categories ON events_to_categories.event_id=events.event_id INNER JOIN events_categories ON events_categories.category_id=events_to_categories.category_id WHERE events.is_active=1 AND events.place_id>0 AND DATE(events.start_time) >= '2013-11-24' AND events_categories.slug='' GROUP BY event_id HAVING distance < 3 GROUP BY events.event_id ORDER BY distance, start_time LIMIT 0, 500) (Bindings: array ( ))' in Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php:556 Stack trace: #0 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(529): Illuminate\Database\Connection->handleQueryException(Object(PDOException), 'SELECT places.p...', Array) #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(277): Illuminate\Database\Connection->run('SELECT places.p...', Array, Object(Closure)) #2 [internal function]: Illuminate\Database\Connection->select('SELECT places.p...') #3 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\DatabaseManager.php(242): call_user_func_array(Array, Array) #4 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(206): Illuminate\Database\DatabaseManager->__call('select', Array) #5 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(206): Illuminate\Database\DatabaseManager->select('SELECT places.p...') #6 Z:\home\local\cr\app\models\EventModel.php(44): Illuminate\Support\Facades\Facade::__callStatic('select', Array) #7 Z:\home\local\cr\app\models\EventModel.php(44): Illuminate\Support\Facades\DB::select('SELECT places.p...') #8 Z:\home\local\cr\app\controllers\api\NeighborhoodsController.php(55): EventModel::getNearbyEvents(Array, 3) #9 [internal function]: Controllers\Api\NeighborhoodsController->postListings() #10 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(138): call_user_func_array(Array, Array) #11 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(115): Illuminate\Routing\Controllers\Controller->callMethod('postListings', Array) #12 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(985): Illuminate\Routing\Controllers\Controller->callAction(Object(Illuminate\Foundation\Application), Object(Illuminate\Routing\Router), 'postListings', Array) #13 [internal function]: Illuminate\Routing\{closure}() #14 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(80): call_user_func_array(Object(Closure), Array) #15 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(47): Illuminate\Routing\Route->callCallable() #16 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1016): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) #17 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #18 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #19 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #20 {main} [] [] [2013-11-24 04:56:26] log.ERROR: exception 'PDOException' with message '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 'GROUP BY events.event_id ORDER BY distance, start_time LIMIT 0, 5' at line 11' in Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php:272 Stack trace: #0 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(272): PDO->prepare('SELECT places.p...') #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(521): Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'SELECT places.p...', Array) #2 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(277): Illuminate\Database\Connection->run('SELECT places.p...', Array, Object(Closure)) #3 [internal function]: Illuminate\Database\Connection->select('SELECT places.p...') #4 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\DatabaseManager.php(242): call_user_func_array(Array, Array) #5 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(206): Illuminate\Database\DatabaseManager->__call('select', Array) #6 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(206): Illuminate\Database\DatabaseManager->select('SELECT places.p...') #7 Z:\home\local\cr\app\models\EventModel.php(44): Illuminate\Support\Facades\Facade::__callStatic('select', Array) #8 Z:\home\local\cr\app\models\EventModel.php(44): Illuminate\Support\Facades\DB::select('SELECT places.p...') #9 Z:\home\local\cr\app\controllers\api\NeighborhoodsController.php(55): EventModel::getNearbyEvents(Array, 3) #10 [internal function]: Controllers\Api\NeighborhoodsController->postListings() #11 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(138): call_user_func_array(Array, Array) #12 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(115): Illuminate\Routing\Controllers\Controller->callMethod('postListings', Array) #13 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(985): Illuminate\Routing\Controllers\Controller->callAction(Object(Illuminate\Foundation\Application), Object(Illuminate\Routing\Router), 'postListings', Array) #14 [internal function]: Illuminate\Routing\{closure}() #15 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(80): call_user_func_array(Object(Closure), Array) #16 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(47): Illuminate\Routing\Route->callCallable() #17 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1016): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) #18 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #19 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #20 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #21 {main} Next exception 'Exception' with message '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 'GROUP BY events.event_id ORDER BY distance, start_time LIMIT 0, 5' at line 11 (SQL: SELECT places.place_id,places.name,places.address,places.locality as city, places.region as state, places.postcode as zipcode, places.phone, places.lat, places.lng, events.event_id,events.title, events.start_time, events.cover_image, events.price, ( 3959 * acos( cos( radians(40.7387574) ) * cos( radians( places.lat ) ) * cos( radians( places.lng ) - radians(-73.99161850000002) ) + sin( radians(40.7387574) ) * sin( radians( places.lat ) ) ) ) AS distance FROM events INNER JOIN places ON places.place_id=events.place_id LEFT JOIN events_to_categories ON events_to_categories.event_id=events.event_id INNER JOIN events_categories ON events_categories.category_id=events_to_categories.category_id WHERE events.is_active=1 AND events.place_id>0 AND DATE(events.start_time) >= '2013-11-24' AND events_categories.slug='' GROUP BY event_id HAVING distance < 3 GROUP BY events.event_id ORDER BY distance, start_time LIMIT 0, 500) (Bindings: array ( ))' in Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php:556 Stack trace: #0 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(529): Illuminate\Database\Connection->handleQueryException(Object(PDOException), 'SELECT places.p...', Array) #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(277): Illuminate\Database\Connection->run('SELECT places.p...', Array, Object(Closure)) #2 [internal function]: Illuminate\Database\Connection->select('SELECT places.p...') #3 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\DatabaseManager.php(242): call_user_func_array(Array, Array) #4 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(206): Illuminate\Database\DatabaseManager->__call('select', Array) #5 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(206): Illuminate\Database\DatabaseManager->select('SELECT places.p...') #6 Z:\home\local\cr\app\models\EventModel.php(44): Illuminate\Support\Facades\Facade::__callStatic('select', Array) #7 Z:\home\local\cr\app\models\EventModel.php(44): Illuminate\Support\Facades\DB::select('SELECT places.p...') #8 Z:\home\local\cr\app\controllers\api\NeighborhoodsController.php(55): EventModel::getNearbyEvents(Array, 3) #9 [internal function]: Controllers\Api\NeighborhoodsController->postListings() #10 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(138): call_user_func_array(Array, Array) #11 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(115): Illuminate\Routing\Controllers\Controller->callMethod('postListings', Array) #12 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(985): Illuminate\Routing\Controllers\Controller->callAction(Object(Illuminate\Foundation\Application), Object(Illuminate\Routing\Router), 'postListings', Array) #13 [internal function]: Illuminate\Routing\{closure}() #14 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(80): call_user_func_array(Object(Closure), Array) #15 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(47): Illuminate\Routing\Route->callCallable() #16 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1016): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) #17 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #18 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #19 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #20 {main} [] [] [2013-11-24 04:57:07] log.ERROR: exception 'PDOException' with message '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 'GROUP BY events.event_id ORDER BY distance, start_time LIMIT 0, 5' at line 11' in Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php:272 Stack trace: #0 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(272): PDO->prepare('SELECT places.p...') #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(521): Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'SELECT places.p...', Array) #2 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(277): Illuminate\Database\Connection->run('SELECT places.p...', Array, Object(Closure)) #3 [internal function]: Illuminate\Database\Connection->select('SELECT places.p...') #4 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\DatabaseManager.php(242): call_user_func_array(Array, Array) #5 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(206): Illuminate\Database\DatabaseManager->__call('select', Array) #6 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(206): Illuminate\Database\DatabaseManager->select('SELECT places.p...') #7 Z:\home\local\cr\app\models\EventModel.php(44): Illuminate\Support\Facades\Facade::__callStatic('select', Array) #8 Z:\home\local\cr\app\models\EventModel.php(44): Illuminate\Support\Facades\DB::select('SELECT places.p...') #9 Z:\home\local\cr\app\controllers\api\NeighborhoodsController.php(55): EventModel::getNearbyEvents(Array, 3) #10 [internal function]: Controllers\Api\NeighborhoodsController->postListings() #11 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(138): call_user_func_array(Array, Array) #12 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(115): Illuminate\Routing\Controllers\Controller->callMethod('postListings', Array) #13 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(985): Illuminate\Routing\Controllers\Controller->callAction(Object(Illuminate\Foundation\Application), Object(Illuminate\Routing\Router), 'postListings', Array) #14 [internal function]: Illuminate\Routing\{closure}() #15 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(80): call_user_func_array(Object(Closure), Array) #16 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(47): Illuminate\Routing\Route->callCallable() #17 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1016): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) #18 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #19 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #20 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #21 {main} Next exception 'Exception' with message '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 'GROUP BY events.event_id ORDER BY distance, start_time LIMIT 0, 5' at line 11 (SQL: SELECT places.place_id,places.name,places.address,places.locality as city, places.region as state, places.postcode as zipcode, places.phone, places.lat, places.lng, events.event_id,events.title, events.start_time, events.cover_image, events.price, ( 3959 * acos( cos( radians(40.7387574) ) * cos( radians( places.lat ) ) * cos( radians( places.lng ) - radians(-73.99161850000002) ) + sin( radians(40.7387574) ) * sin( radians( places.lat ) ) ) ) AS distance FROM events INNER JOIN places ON places.place_id=events.place_id LEFT JOIN events_to_categories ON events_to_categories.event_id=events.event_id INNER JOIN events_categories ON events_categories.category_id=events_to_categories.category_id WHERE events.is_active=1 AND events.place_id>0 AND DATE(events.start_time) >= '2013-11-24' AND events_categories.slug='' GROUP BY event_id HAVING distance < 3 GROUP BY events.event_id ORDER BY distance, start_time LIMIT 0, 500) (Bindings: array ( ))' in Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php:556 Stack trace: #0 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(529): Illuminate\Database\Connection->handleQueryException(Object(PDOException), 'SELECT places.p...', Array) #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(277): Illuminate\Database\Connection->run('SELECT places.p...', Array, Object(Closure)) #2 [internal function]: Illuminate\Database\Connection->select('SELECT places.p...') #3 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\DatabaseManager.php(242): call_user_func_array(Array, Array) #4 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(206): Illuminate\Database\DatabaseManager->__call('select', Array) #5 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(206): Illuminate\Database\DatabaseManager->select('SELECT places.p...') #6 Z:\home\local\cr\app\models\EventModel.php(44): Illuminate\Support\Facades\Facade::__callStatic('select', Array) #7 Z:\home\local\cr\app\models\EventModel.php(44): Illuminate\Support\Facades\DB::select('SELECT places.p...') #8 Z:\home\local\cr\app\controllers\api\NeighborhoodsController.php(55): EventModel::getNearbyEvents(Array, 3) #9 [internal function]: Controllers\Api\NeighborhoodsController->postListings() #10 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(138): call_user_func_array(Array, Array) #11 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(115): Illuminate\Routing\Controllers\Controller->callMethod('postListings', Array) #12 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(985): Illuminate\Routing\Controllers\Controller->callAction(Object(Illuminate\Foundation\Application), Object(Illuminate\Routing\Router), 'postListings', Array) #13 [internal function]: Illuminate\Routing\{closure}() #14 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(80): call_user_func_array(Object(Closure), Array) #15 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(47): Illuminate\Routing\Route->callCallable() #16 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1016): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) #17 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #18 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #19 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #20 {main} [] [] [2013-11-24 04:57:41] log.ERROR: exception 'PDOException' with message '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 'GROUP BY events.event_id ORDER BY distance, start_time LIMIT 0, 5' at line 11' in Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php:272 Stack trace: #0 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(272): PDO->prepare('SELECT places.p...') #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(521): Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'SELECT places.p...', Array) #2 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(277): Illuminate\Database\Connection->run('SELECT places.p...', Array, Object(Closure)) #3 [internal function]: Illuminate\Database\Connection->select('SELECT places.p...') #4 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\DatabaseManager.php(242): call_user_func_array(Array, Array) #5 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(206): Illuminate\Database\DatabaseManager->__call('select', Array) #6 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(206): Illuminate\Database\DatabaseManager->select('SELECT places.p...') #7 Z:\home\local\cr\app\models\EventModel.php(44): Illuminate\Support\Facades\Facade::__callStatic('select', Array) #8 Z:\home\local\cr\app\models\EventModel.php(44): Illuminate\Support\Facades\DB::select('SELECT places.p...') #9 Z:\home\local\cr\app\controllers\api\NeighborhoodsController.php(55): EventModel::getNearbyEvents(Array, 3) #10 [internal function]: Controllers\Api\NeighborhoodsController->postListings() #11 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(138): call_user_func_array(Array, Array) #12 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(115): Illuminate\Routing\Controllers\Controller->callMethod('postListings', Array) #13 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(985): Illuminate\Routing\Controllers\Controller->callAction(Object(Illuminate\Foundation\Application), Object(Illuminate\Routing\Router), 'postListings', Array) #14 [internal function]: Illuminate\Routing\{closure}() #15 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(80): call_user_func_array(Object(Closure), Array) #16 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(47): Illuminate\Routing\Route->callCallable() #17 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1016): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) #18 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #19 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #20 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #21 {main} Next exception 'Exception' with message '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 'GROUP BY events.event_id ORDER BY distance, start_time LIMIT 0, 5' at line 11 (SQL: SELECT places.place_id,places.name,places.address,places.locality as city, places.region as state, places.postcode as zipcode, places.phone, places.lat, places.lng, events.event_id,events.title, events.start_time, events.cover_image, events.price, ( 3959 * acos( cos( radians(40.7387574) ) * cos( radians( places.lat ) ) * cos( radians( places.lng ) - radians(-73.99161850000002) ) + sin( radians(40.7387574) ) * sin( radians( places.lat ) ) ) ) AS distance FROM events INNER JOIN places ON places.place_id=events.place_id LEFT JOIN events_to_categories ON events_to_categories.event_id=events.event_id INNER JOIN events_categories ON events_categories.category_id=events_to_categories.category_id WHERE events.is_active=1 AND events.place_id>0 AND DATE(events.start_time) >= '2013-11-24' AND events_categories.slug='' GROUP BY event_id HAVING distance < 3 GROUP BY events.event_id ORDER BY distance, start_time LIMIT 0, 500) (Bindings: array ( ))' in Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php:556 Stack trace: #0 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(529): Illuminate\Database\Connection->handleQueryException(Object(PDOException), 'SELECT places.p...', Array) #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(277): Illuminate\Database\Connection->run('SELECT places.p...', Array, Object(Closure)) #2 [internal function]: Illuminate\Database\Connection->select('SELECT places.p...') #3 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\DatabaseManager.php(242): call_user_func_array(Array, Array) #4 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(206): Illuminate\Database\DatabaseManager->__call('select', Array) #5 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(206): Illuminate\Database\DatabaseManager->select('SELECT places.p...') #6 Z:\home\local\cr\app\models\EventModel.php(44): Illuminate\Support\Facades\Facade::__callStatic('select', Array) #7 Z:\home\local\cr\app\models\EventModel.php(44): Illuminate\Support\Facades\DB::select('SELECT places.p...') #8 Z:\home\local\cr\app\controllers\api\NeighborhoodsController.php(55): EventModel::getNearbyEvents(Array, 3) #9 [internal function]: Controllers\Api\NeighborhoodsController->postListings() #10 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(138): call_user_func_array(Array, Array) #11 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(115): Illuminate\Routing\Controllers\Controller->callMethod('postListings', Array) #12 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(985): Illuminate\Routing\Controllers\Controller->callAction(Object(Illuminate\Foundation\Application), Object(Illuminate\Routing\Router), 'postListings', Array) #13 [internal function]: Illuminate\Routing\{closure}() #14 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(80): call_user_func_array(Object(Closure), Array) #15 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(47): Illuminate\Routing\Route->callCallable() #16 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1016): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) #17 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #18 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #19 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #20 {main} [] [] [2013-11-24 04:58:17] log.ERROR: exception 'PDOException' with message '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 'GROUP BY events.event_id ORDER BY distance, start_time LIMIT 0, 5' at line 11' in Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php:272 Stack trace: #0 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(272): PDO->prepare('SELECT places.p...') #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(521): Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'SELECT places.p...', Array) #2 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(277): Illuminate\Database\Connection->run('SELECT places.p...', Array, Object(Closure)) #3 [internal function]: Illuminate\Database\Connection->select('SELECT places.p...') #4 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\DatabaseManager.php(242): call_user_func_array(Array, Array) #5 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(206): Illuminate\Database\DatabaseManager->__call('select', Array) #6 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(206): Illuminate\Database\DatabaseManager->select('SELECT places.p...') #7 Z:\home\local\cr\app\models\EventModel.php(44): Illuminate\Support\Facades\Facade::__callStatic('select', Array) #8 Z:\home\local\cr\app\models\EventModel.php(44): Illuminate\Support\Facades\DB::select('SELECT places.p...') #9 Z:\home\local\cr\app\controllers\api\NeighborhoodsController.php(55): EventModel::getNearbyEvents(Array, 3) #10 [internal function]: Controllers\Api\NeighborhoodsController->postListings() #11 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(138): call_user_func_array(Array, Array) #12 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(115): Illuminate\Routing\Controllers\Controller->callMethod('postListings', Array) #13 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(985): Illuminate\Routing\Controllers\Controller->callAction(Object(Illuminate\Foundation\Application), Object(Illuminate\Routing\Router), 'postListings', Array) #14 [internal function]: Illuminate\Routing\{closure}() #15 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(80): call_user_func_array(Object(Closure), Array) #16 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(47): Illuminate\Routing\Route->callCallable() #17 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1016): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) #18 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #19 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #20 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #21 {main} Next exception 'Exception' with message '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 'GROUP BY events.event_id ORDER BY distance, start_time LIMIT 0, 5' at line 11 (SQL: SELECT places.place_id,places.name,places.address,places.locality as city, places.region as state, places.postcode as zipcode, places.phone, places.lat, places.lng, events.event_id,events.title, events.start_time, events.cover_image, events.price, ( 3959 * acos( cos( radians(40.7387574) ) * cos( radians( places.lat ) ) * cos( radians( places.lng ) - radians(-73.99161850000002) ) + sin( radians(40.7387574) ) * sin( radians( places.lat ) ) ) ) AS distance FROM events INNER JOIN places ON places.place_id=events.place_id LEFT JOIN events_to_categories ON events_to_categories.event_id=events.event_id INNER JOIN events_categories ON events_categories.category_id=events_to_categories.category_id WHERE events.is_active=1 AND events.place_id>0 AND DATE(events.start_time) >= '2013-11-24' AND events_categories.slug='' GROUP BY event_id HAVING distance < 3 GROUP BY events.event_id ORDER BY distance, start_time LIMIT 0, 500) (Bindings: array ( ))' in Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php:556 Stack trace: #0 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(529): Illuminate\Database\Connection->handleQueryException(Object(PDOException), 'SELECT places.p...', Array) #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(277): Illuminate\Database\Connection->run('SELECT places.p...', Array, Object(Closure)) #2 [internal function]: Illuminate\Database\Connection->select('SELECT places.p...') #3 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\DatabaseManager.php(242): call_user_func_array(Array, Array) #4 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(206): Illuminate\Database\DatabaseManager->__call('select', Array) #5 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(206): Illuminate\Database\DatabaseManager->select('SELECT places.p...') #6 Z:\home\local\cr\app\models\EventModel.php(44): Illuminate\Support\Facades\Facade::__callStatic('select', Array) #7 Z:\home\local\cr\app\models\EventModel.php(44): Illuminate\Support\Facades\DB::select('SELECT places.p...') #8 Z:\home\local\cr\app\controllers\api\NeighborhoodsController.php(55): EventModel::getNearbyEvents(Array, 3) #9 [internal function]: Controllers\Api\NeighborhoodsController->postListings() #10 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(138): call_user_func_array(Array, Array) #11 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(115): Illuminate\Routing\Controllers\Controller->callMethod('postListings', Array) #12 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(985): Illuminate\Routing\Controllers\Controller->callAction(Object(Illuminate\Foundation\Application), Object(Illuminate\Routing\Router), 'postListings', Array) #13 [internal function]: Illuminate\Routing\{closure}() #14 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(80): call_user_func_array(Object(Closure), Array) #15 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(47): Illuminate\Routing\Route->callCallable() #16 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1016): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) #17 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #18 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #19 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #20 {main} [] [] [2013-11-24 05:01:14] log.ERROR: exception 'PDOException' with message '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 'GROUP BY events.event_id ORDER BY distance, start_time LIMIT 0, 5' at line 11' in Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php:272 Stack trace: #0 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(272): PDO->prepare('SELECT places.p...') #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(521): Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'SELECT places.p...', Array) #2 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(277): Illuminate\Database\Connection->run('SELECT places.p...', Array, Object(Closure)) #3 [internal function]: Illuminate\Database\Connection->select('SELECT places.p...') #4 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\DatabaseManager.php(242): call_user_func_array(Array, Array) #5 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(206): Illuminate\Database\DatabaseManager->__call('select', Array) #6 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(206): Illuminate\Database\DatabaseManager->select('SELECT places.p...') #7 Z:\home\local\cr\app\models\EventModel.php(44): Illuminate\Support\Facades\Facade::__callStatic('select', Array) #8 Z:\home\local\cr\app\models\EventModel.php(44): Illuminate\Support\Facades\DB::select('SELECT places.p...') #9 Z:\home\local\cr\app\controllers\api\NeighborhoodsController.php(55): EventModel::getNearbyEvents(Array, 3) #10 [internal function]: Controllers\Api\NeighborhoodsController->postListings() #11 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(138): call_user_func_array(Array, Array) #12 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(115): Illuminate\Routing\Controllers\Controller->callMethod('postListings', Array) #13 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(985): Illuminate\Routing\Controllers\Controller->callAction(Object(Illuminate\Foundation\Application), Object(Illuminate\Routing\Router), 'postListings', Array) #14 [internal function]: Illuminate\Routing\{closure}() #15 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(80): call_user_func_array(Object(Closure), Array) #16 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(47): Illuminate\Routing\Route->callCallable() #17 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1016): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) #18 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #19 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #20 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #21 {main} Next exception 'Exception' with message '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 'GROUP BY events.event_id ORDER BY distance, start_time LIMIT 0, 5' at line 11 (SQL: SELECT places.place_id,places.name,places.address,places.locality as city, places.region as state, places.postcode as zipcode, places.phone, places.lat, places.lng, events.event_id,events.title, events.start_time, events.cover_image, events.price, ( 3959 * acos( cos( radians(40.7387574) ) * cos( radians( places.lat ) ) * cos( radians( places.lng ) - radians(-73.99161850000002) ) + sin( radians(40.7387574) ) * sin( radians( places.lat ) ) ) ) AS distance FROM events INNER JOIN places ON places.place_id=events.place_id LEFT JOIN events_to_categories ON events_to_categories.event_id=events.event_id INNER JOIN events_categories ON events_categories.category_id=events_to_categories.category_id WHERE events.is_active=1 AND events.place_id>0 AND DATE(events.start_time) >= '2013-11-24' AND events_categories.slug='' GROUP BY event_id HAVING distance < 3 GROUP BY events.event_id ORDER BY distance, start_time LIMIT 0, 500) (Bindings: array ( ))' in Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php:556 Stack trace: #0 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(529): Illuminate\Database\Connection->handleQueryException(Object(PDOException), 'SELECT places.p...', Array) #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(277): Illuminate\Database\Connection->run('SELECT places.p...', Array, Object(Closure)) #2 [internal function]: Illuminate\Database\Connection->select('SELECT places.p...') #3 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\DatabaseManager.php(242): call_user_func_array(Array, Array) #4 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(206): Illuminate\Database\DatabaseManager->__call('select', Array) #5 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(206): Illuminate\Database\DatabaseManager->select('SELECT places.p...') #6 Z:\home\local\cr\app\models\EventModel.php(44): Illuminate\Support\Facades\Facade::__callStatic('select', Array) #7 Z:\home\local\cr\app\models\EventModel.php(44): Illuminate\Support\Facades\DB::select('SELECT places.p...') #8 Z:\home\local\cr\app\controllers\api\NeighborhoodsController.php(55): EventModel::getNearbyEvents(Array, 3) #9 [internal function]: Controllers\Api\NeighborhoodsController->postListings() #10 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(138): call_user_func_array(Array, Array) #11 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(115): Illuminate\Routing\Controllers\Controller->callMethod('postListings', Array) #12 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(985): Illuminate\Routing\Controllers\Controller->callAction(Object(Illuminate\Foundation\Application), Object(Illuminate\Routing\Router), 'postListings', Array) #13 [internal function]: Illuminate\Routing\{closure}() #14 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(80): call_user_func_array(Object(Closure), Array) #15 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(47): Illuminate\Routing\Route->callCallable() #16 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1016): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) #17 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #18 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #19 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #20 {main} [] [] [2013-11-24 05:04:16] log.ERROR: exception 'PDOException' with message '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 'GROUP BY events.event_id ORDER BY distance, start_time LIMIT 0, 5' at line 11' in Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php:272 Stack trace: #0 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(272): PDO->prepare('SELECT places.p...') #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(521): Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'SELECT places.p...', Array) #2 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(277): Illuminate\Database\Connection->run('SELECT places.p...', Array, Object(Closure)) #3 [internal function]: Illuminate\Database\Connection->select('SELECT places.p...') #4 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\DatabaseManager.php(242): call_user_func_array(Array, Array) #5 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(206): Illuminate\Database\DatabaseManager->__call('select', Array) #6 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(206): Illuminate\Database\DatabaseManager->select('SELECT places.p...') #7 Z:\home\local\cr\app\models\EventModel.php(44): Illuminate\Support\Facades\Facade::__callStatic('select', Array) #8 Z:\home\local\cr\app\models\EventModel.php(44): Illuminate\Support\Facades\DB::select('SELECT places.p...') #9 Z:\home\local\cr\app\controllers\api\NeighborhoodsController.php(55): EventModel::getNearbyEvents(Array, 3) #10 [internal function]: Controllers\Api\NeighborhoodsController->postListings() #11 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(138): call_user_func_array(Array, Array) #12 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(115): Illuminate\Routing\Controllers\Controller->callMethod('postListings', Array) #13 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(985): Illuminate\Routing\Controllers\Controller->callAction(Object(Illuminate\Foundation\Application), Object(Illuminate\Routing\Router), 'postListings', Array) #14 [internal function]: Illuminate\Routing\{closure}() #15 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(80): call_user_func_array(Object(Closure), Array) #16 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(47): Illuminate\Routing\Route->callCallable() #17 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1016): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) #18 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #19 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #20 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #21 {main} Next exception 'Exception' with message '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 'GROUP BY events.event_id ORDER BY distance, start_time LIMIT 0, 5' at line 11 (SQL: SELECT places.place_id,places.name,places.address,places.locality as city, places.region as state, places.postcode as zipcode, places.phone, places.lat, places.lng, events.event_id,events.title, events.start_time, events.cover_image, events.price, ( 3959 * acos( cos( radians(40.7387574) ) * cos( radians( places.lat ) ) * cos( radians( places.lng ) - radians(-73.99161850000002) ) + sin( radians(40.7387574) ) * sin( radians( places.lat ) ) ) ) AS distance FROM events INNER JOIN places ON places.place_id=events.place_id LEFT JOIN events_to_categories ON events_to_categories.event_id=events.event_id INNER JOIN events_categories ON events_categories.category_id=events_to_categories.category_id WHERE events.is_active=1 AND events.place_id>0 AND DATE(events.start_time) >= '2013-11-24' AND events_categories.slug='' GROUP BY event_id HAVING distance < 3 GROUP BY events.event_id ORDER BY distance, start_time LIMIT 0, 500) (Bindings: array ( ))' in Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php:556 Stack trace: #0 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(529): Illuminate\Database\Connection->handleQueryException(Object(PDOException), 'SELECT places.p...', Array) #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(277): Illuminate\Database\Connection->run('SELECT places.p...', Array, Object(Closure)) #2 [internal function]: Illuminate\Database\Connection->select('SELECT places.p...') #3 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\DatabaseManager.php(242): call_user_func_array(Array, Array) #4 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(206): Illuminate\Database\DatabaseManager->__call('select', Array) #5 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(206): Illuminate\Database\DatabaseManager->select('SELECT places.p...') #6 Z:\home\local\cr\app\models\EventModel.php(44): Illuminate\Support\Facades\Facade::__callStatic('select', Array) #7 Z:\home\local\cr\app\models\EventModel.php(44): Illuminate\Support\Facades\DB::select('SELECT places.p...') #8 Z:\home\local\cr\app\controllers\api\NeighborhoodsController.php(55): EventModel::getNearbyEvents(Array, 3) #9 [internal function]: Controllers\Api\NeighborhoodsController->postListings() #10 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(138): call_user_func_array(Array, Array) #11 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(115): Illuminate\Routing\Controllers\Controller->callMethod('postListings', Array) #12 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(985): Illuminate\Routing\Controllers\Controller->callAction(Object(Illuminate\Foundation\Application), Object(Illuminate\Routing\Router), 'postListings', Array) #13 [internal function]: Illuminate\Routing\{closure}() #14 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(80): call_user_func_array(Object(Closure), Array) #15 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(47): Illuminate\Routing\Route->callCallable() #16 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1016): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) #17 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #18 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #19 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #20 {main} [] [] [2013-11-24 05:34:27] log.ERROR: exception 'PDOException' with message '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 'GROUP BY events.event_id ORDER BY distance, start_time LIMIT 0, 5' at line 11' in Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php:272 Stack trace: #0 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(272): PDO->prepare('SELECT places.p...') #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(521): Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'SELECT places.p...', Array) #2 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(277): Illuminate\Database\Connection->run('SELECT places.p...', Array, Object(Closure)) #3 [internal function]: Illuminate\Database\Connection->select('SELECT places.p...') #4 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\DatabaseManager.php(242): call_user_func_array(Array, Array) #5 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(206): Illuminate\Database\DatabaseManager->__call('select', Array) #6 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(206): Illuminate\Database\DatabaseManager->select('SELECT places.p...') #7 Z:\home\local\cr\app\models\EventModel.php(44): Illuminate\Support\Facades\Facade::__callStatic('select', Array) #8 Z:\home\local\cr\app\models\EventModel.php(44): Illuminate\Support\Facades\DB::select('SELECT places.p...') #9 Z:\home\local\cr\app\controllers\api\NeighborhoodsController.php(55): EventModel::getNearbyEvents(Array, 3) #10 [internal function]: Controllers\Api\NeighborhoodsController->postListings() #11 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(138): call_user_func_array(Array, Array) #12 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(115): Illuminate\Routing\Controllers\Controller->callMethod('postListings', Array) #13 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(985): Illuminate\Routing\Controllers\Controller->callAction(Object(Illuminate\Foundation\Application), Object(Illuminate\Routing\Router), 'postListings', Array) #14 [internal function]: Illuminate\Routing\{closure}() #15 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(80): call_user_func_array(Object(Closure), Array) #16 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(47): Illuminate\Routing\Route->callCallable() #17 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1016): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) #18 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #19 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #20 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #21 {main} Next exception 'Exception' with message '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 'GROUP BY events.event_id ORDER BY distance, start_time LIMIT 0, 5' at line 11 (SQL: SELECT places.place_id,places.name,places.address,places.locality as city, places.region as state, places.postcode as zipcode, places.phone, places.lat, places.lng, events.event_id,events.title, events.start_time, events.cover_image, events.price, ( 3959 * acos( cos( radians(40.7387574) ) * cos( radians( places.lat ) ) * cos( radians( places.lng ) - radians(-73.99161850000002) ) + sin( radians(40.7387574) ) * sin( radians( places.lat ) ) ) ) AS distance FROM events INNER JOIN places ON places.place_id=events.place_id LEFT JOIN events_to_categories ON events_to_categories.event_id=events.event_id INNER JOIN events_categories ON events_categories.category_id=events_to_categories.category_id WHERE events.is_active=1 AND events.place_id>0 AND DATE(events.start_time) >= '2013-11-24' AND events_categories.slug='' GROUP BY event_id HAVING distance < 3 GROUP BY events.event_id ORDER BY distance, start_time LIMIT 0, 500) (Bindings: array ( ))' in Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php:556 Stack trace: #0 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(529): Illuminate\Database\Connection->handleQueryException(Object(PDOException), 'SELECT places.p...', Array) #1 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\Connection.php(277): Illuminate\Database\Connection->run('SELECT places.p...', Array, Object(Closure)) #2 [internal function]: Illuminate\Database\Connection->select('SELECT places.p...') #3 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Database\DatabaseManager.php(242): call_user_func_array(Array, Array) #4 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(206): Illuminate\Database\DatabaseManager->__call('select', Array) #5 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(206): Illuminate\Database\DatabaseManager->select('SELECT places.p...') #6 Z:\home\local\cr\app\models\EventModel.php(44): Illuminate\Support\Facades\Facade::__callStatic('select', Array) #7 Z:\home\local\cr\app\models\EventModel.php(44): Illuminate\Support\Facades\DB::select('SELECT places.p...') #8 Z:\home\local\cr\app\controllers\api\NeighborhoodsController.php(55): EventModel::getNearbyEvents(Array, 3) #9 [internal function]: Controllers\Api\NeighborhoodsController->postListings() #10 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(138): call_user_func_array(Array, Array) #11 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Controllers\Controller.php(115): Illuminate\Routing\Controllers\Controller->callMethod('postListings', Array) #12 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(985): Illuminate\Routing\Controllers\Controller->callAction(Object(Illuminate\Foundation\Application), Object(Illuminate\Routing\Router), 'postListings', Array) #13 [internal function]: Illuminate\Routing\{closure}() #14 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(80): call_user_func_array(Object(Closure), Array) #15 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Route.php(47): Illuminate\Routing\Route->callCallable() #16 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1016): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) #17 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(574): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #18 Z:\home\local\cr\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(550): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #19 Z:\home\local\cr\public\index.php(49): Illuminate\Foundation\Application->run() #20 {main} [] []