Symfony Exception

PDOException QueryException

HTTP 500 Internal Server Error

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 ')' at line 1 (SQL: select * from `services` where 0 = 1 and `services`.`deleted_at` is null order by field(id,))

Exceptions 2

Illuminate\Database\ QueryException

  1.         // If an exception occurs when attempting to run a query, we'll format the error
  2.         // message to include the bindings with SQL, which will make this exception a
  3.         // lot more helpful to the developer instead of just the database's errors.
  4.         catch (Exception $e) {
  5.             throw new QueryException(
  6.                 $query$this->prepareBindings($bindings), $e
  7.             );
  8.         }
  9.     }
  1.         // Here we will run this query. If an exception occurs we'll determine if it was
  2.         // caused by a connection that has been lost. If that is the cause, we'll try
  3.         // to re-establish connection and re-run the query with a fresh connection.
  4.         try {
  5.             $result $this->runQueryCallback($query$bindings$callback);
  6.         } catch (QueryException $e) {
  7.             $result $this->handleQueryException(
  8.                 $e$query$bindings$callback
  9.             );
  10.         }
  1.             $this->bindValues($statement$this->prepareBindings($bindings));
  2.             $statement->execute();
  3.             return $statement->fetchAll();
  4.         });
  5.     }
  6.     /**
  7.      * Run a select statement against the database and returns a generator.
  8.      *
  1.      * @return array
  2.      */
  3.     protected function runSelect()
  4.     {
  5.         return $this->connection->select(
  6.             $this->toSql(), $this->getBindings(), ! $this->useWritePdo
  7.         );
  8.     }
  9.     /**
  10.      * Paginate the given query into a simple paginator.
  1.      * @return \Illuminate\Support\Collection
  2.      */
  3.     public function get($columns = ['*'])
  4.     {
  5.         return collect($this->onceWithColumns(Arr::wrap($columns), function () {
  6.             return $this->processor->processSelect($this$this->runSelect());
  7.         }));
  8.     }
  9.     /**
  10.      * Run the query as a "select" statement against the connection.
  1.         if (is_null($original)) {
  2.             $this->columns $columns;
  3.         }
  4.         $result $callback();
  5.         $this->columns $original;
  6.         return $result;
  7.     }
  1.      */
  2.     public function get($columns = ['*'])
  3.     {
  4.         return collect($this->onceWithColumns(Arr::wrap($columns), function () {
  5.             return $this->processor->processSelect($this$this->runSelect());
  6.         }));
  7.     }
  8.     /**
  9.      * Run the query as a "select" statement against the connection.
  10.      *
  1.      * @return \Illuminate\Database\Eloquent\Model[]|static[]
  2.      */
  3.     public function getModels($columns = ['*'])
  4.     {
  5.         return $this->model->hydrate(
  6.             $this->query->get($columns)->all()
  7.         )->all();
  8.     }
  9.     /**
  10.      * Eager load the relationships for the models.
  1.         $builder $this->applyScopes();
  2.         // If we actually found models we will also eager load any relationships that
  3.         // have been specified as needing to be eager loaded, which will solve the
  4.         // n+1 query issue for the developers to avoid running a lot of queries.
  5.         if (count($models $builder->getModels($columns)) > 0) {
  6.             $models $builder->eagerLoadRelations($models);
  7.         }
  8.         return $builder->getModel()->newCollection($models);
  9.     }
  1.             $navbar_res_array = [ $navbar_res->one_english$navbar_res->two_english$navbar_res->three_english$navbar_res->four_english$navbar_res->five_english$navbar_res->six_english$navbar_res->seven_english ];
  2.             $navbar_res_array array_unique($navbar_res_array);
  3.             if (($res_key array_search(13$navbar_res_array)) !== false) { unset($navbar_res_array[$res_key]); }
  4.             $res_service_lists Services::wherein('id'$navbar_res_array)->orderByRaw("field(id,".implode(',',$navbar_res_array).")")->get();
  5.             
  6.             return $res_service_lists;
  7.         }
  8.     }
  1.         }
  2.         // $education_nav = EducationCourses::where('site_frid', $site_frid)->get();
  3.                 $education_nav EducationCourses::whereDate('start_time''>='now())->where('site_frid'$site_frid)->orderBy('start_time''asc')->get();
  4.         $res_service_lists navigation_dropdown_res_english($site_frid);
  5.         $com_service_lists navigation_dropdown_com_english($site_frid);
  6.         $res_other_services_eng navigation_dropdown_res_other_english($site_frid$site_detail);
  7.         $com_other_services_eng navigation_dropdown_com_other_english($site_frid$site_detail);
  8.         $residential_custom_services OtherCustomServices::where('site_frid'$site_frid)->where('residential'true)->get();
  1.      * @param  array  $parameters
  2.      * @return \Symfony\Component\HttpFoundation\Response
  3.      */
  4.     public function callAction($method$parameters)
  5.     {
  6.         return $this->{$method}(...array_values($parameters));
  7.     }
  8.     /**
  9.      * Handle calls to missing methods on the controller.
  10.      *
  1.         $parameters $this->resolveClassMethodDependencies(
  2.             $route->parametersWithoutNulls(), $controller$method
  3.         );
  4.         if (method_exists($controller'callAction')) {
  5.             return $controller->callAction($method$parameters);
  6.         }
  7.         return $controller->{$method}(...array_values($parameters));
  8.     }
  1.      * @throws \Symfony\Component\HttpKernel\Exception\NotFoundHttpException
  2.      */
  3.     protected function runController()
  4.     {
  5.         return $this->controllerDispatcher()->dispatch(
  6.             $this$this->getController(), $this->getControllerMethod()
  7.         );
  8.     }
  9.     /**
  10.      * Get the controller instance for the route.
  1.     {
  2.         $this->container $this->container ?: new Container;
  3.         try {
  4.             if ($this->isControllerAction()) {
  5.                 return $this->runController();
  6.             }
  7.             return $this->runCallable();
  8.         } catch (HttpResponseException $e) {
  9.             return $e->getResponse();
  1.         return (new Pipeline($this->container))
  2.                         ->send($request)
  3.                         ->through($middleware)
  4.                         ->then(function ($request) use ($route) {
  5.                             return $this->prepareResponse(
  6.                                 $request$route->run()
  7.                             );
  8.                         });
  9.     }
  10.     /**
  1.      */
  2.     protected function prepareDestination(Closure $destination)
  3.     {
  4.         return function ($passable) use ($destination) {
  5.             try {
  6.                 return $destination($passable);
  7.             } catch (Throwable $e) {
  8.                 return $this->handleException($passable$e);
  9.             }
  10.         };
  11.     }
  1.             }
  2.             throw $exception;
  3.         }
  4.         return $next($request);
  5.     }
  6. }
  1.                         // since the object we're given was already a fully instantiated object.
  2.                         $parameters = [$passable$stack];
  3.                     }
  4.                     $carry method_exists($pipe$this->method)
  5.                                     ? $pipe->{$this->method}(...$parameters)
  6.                                     : $pipe(...$parameters);
  7.                     return $this->handleCarry($carry);
  8.                 } catch (Throwable $e) {
  9.                     return $this->handleException($passable$e);
  1.             $this->isReading($request) ||
  2.             $this->runningUnitTests() ||
  3.             $this->inExceptArray($request) ||
  4.             $this->tokensMatch($request)
  5.         ) {
  6.             return tap($next($request), function ($response) use ($request) {
  7.                 if ($this->shouldAddXsrfTokenCookie()) {
  8.                     $this->addCookieToResponse($request$response);
  9.                 }
  10.             });
  11.         }
  1.                         // since the object we're given was already a fully instantiated object.
  2.                         $parameters = [$passable$stack];
  3.                     }
  4.                     $carry method_exists($pipe$this->method)
  5.                                     ? $pipe->{$this->method}(...$parameters)
  6.                                     : $pipe(...$parameters);
  7.                     return $this->handleCarry($carry);
  8.                 } catch (Throwable $e) {
  9.                     return $this->handleException($passable$e);
  1.         // Putting the errors in the view for every view allows the developer to just
  2.         // assume that some errors are always available, which is convenient since
  3.         // they don't have to continually run checks for the presence of errors.
  4.         return $next($request);
  5.     }
  6. }
  1.                         // since the object we're given was already a fully instantiated object.
  2.                         $parameters = [$passable$stack];
  3.                     }
  4.                     $carry method_exists($pipe$this->method)
  5.                                     ? $pipe->{$this->method}(...$parameters)
  6.                                     : $pipe(...$parameters);
  7.                     return $this->handleCarry($carry);
  8.                 } catch (Throwable $e) {
  9.                     return $this->handleException($passable$e);
  1.             $this->startSession($request$session)
  2.         );
  3.         $this->collectGarbage($session);
  4.         $response $next($request);
  5.         $this->storeCurrentUrl($request$session);
  6.         $this->addCookieToResponse($response$session);
  1.         if ($this->manager->shouldBlock() ||
  2.             ($request->route() instanceof Route && $request->route()->locksFor())) {
  3.             return $this->handleRequestWhileBlocking($request$session$next);
  4.         }
  5.         return $this->handleStatefulRequest($request$session$next);
  6.     }
  7.     /**
  8.      * Handle the given request within session state.
  9.      *
  1.                         // since the object we're given was already a fully instantiated object.
  2.                         $parameters = [$passable$stack];
  3.                     }
  4.                     $carry method_exists($pipe$this->method)
  5.                                     ? $pipe->{$this->method}(...$parameters)
  6.                                     : $pipe(...$parameters);
  7.                     return $this->handleCarry($carry);
  8.                 } catch (Throwable $e) {
  9.                     return $this->handleException($passable$e);
  1.      * @param  \Closure  $next
  2.      * @return mixed
  3.      */
  4.     public function handle($requestClosure $next)
  5.     {
  6.         $response $next($request);
  7.         foreach ($this->cookies->getQueuedCookies() as $cookie) {
  8.             $response->headers->setCookie($cookie);
  9.         }
  1.                         // since the object we're given was already a fully instantiated object.
  2.                         $parameters = [$passable$stack];
  3.                     }
  4.                     $carry method_exists($pipe$this->method)
  5.                                     ? $pipe->{$this->method}(...$parameters)
  6.                                     : $pipe(...$parameters);
  7.                     return $this->handleCarry($carry);
  8.                 } catch (Throwable $e) {
  9.                     return $this->handleException($passable$e);
  1.      * @param  \Closure  $next
  2.      * @return \Symfony\Component\HttpFoundation\Response
  3.      */
  4.     public function handle($requestClosure $next)
  5.     {
  6.         return $this->encrypt($next($this->decrypt($request)));
  7.     }
  8.     /**
  9.      * Decrypt the cookies on the request.
  10.      *
  1.                         // since the object we're given was already a fully instantiated object.
  2.                         $parameters = [$passable$stack];
  3.                     }
  4.                     $carry method_exists($pipe$this->method)
  5.                                     ? $pipe->{$this->method}(...$parameters)
  6.                                     : $pipe(...$parameters);
  7.                     return $this->handleCarry($carry);
  8.                 } catch (Throwable $e) {
  9.                     return $this->handleException($passable$e);
  1.     {
  2.         $pipeline array_reduce(
  3.             array_reverse($this->pipes()), $this->carry(), $this->prepareDestination($destination)
  4.         );
  5.         return $pipeline($this->passable);
  6.     }
  7.     /**
  8.      * Run the pipeline and return the result.
  9.      *
  1.                         ->through($middleware)
  2.                         ->then(function ($request) use ($route) {
  3.                             return $this->prepareResponse(
  4.                                 $request$route->run()
  5.                             );
  6.                         });
  7.     }
  8.     /**
  9.      * Gather the middleware for the given route with resolved class names.
  10.      *
  1.         });
  2.         $this->events->dispatch(new RouteMatched($route$request));
  3.         return $this->prepareResponse($request,
  4.             $this->runRouteWithinStack($route$request)
  5.         );
  6.     }
  7.     /**
  8.      * Run the given route within a Stack "onion" instance.
  1.      * @param  \Illuminate\Http\Request  $request
  2.      * @return \Symfony\Component\HttpFoundation\Response
  3.      */
  4.     public function dispatchToRoute(Request $request)
  5.     {
  6.         return $this->runRoute($request$this->findRoute($request));
  7.     }
  8.     /**
  9.      * Find the route matching a given request.
  10.      *
  1.      */
  2.     public function dispatch(Request $request)
  3.     {
  4.         $this->currentRequest $request;
  5.         return $this->dispatchToRoute($request);
  6.     }
  7.     /**
  8.      * Dispatch the request to a route and return the response.
  9.      *
  1.     protected function dispatchToRouter()
  2.     {
  3.         return function ($request) {
  4.             $this->app->instance('request'$request);
  5.             return $this->router->dispatch($request);
  6.         };
  7.     }
  8.     /**
  9.      * Call the terminate method on any terminable middleware.
  1.      */
  2.     protected function prepareDestination(Closure $destination)
  3.     {
  4.         return function ($passable) use ($destination) {
  5.             try {
  6.                 return $destination($passable);
  7.             } catch (Throwable $e) {
  8.                 return $this->handleException($passable$e);
  9.             }
  10.         };
  11.     }
  1.      */
  2.     public function handle($requestClosure $next)
  3.     {
  4.         $this->clean($request);
  5.         return $next($request);
  6.     }
  7.     /**
  8.      * Clean the request's data.
  9.      *
  1.             if ($callback($request)) {
  2.                 return $next($request);
  3.             }
  4.         }
  5.         return parent::handle($request$next);
  6.     }
  7.     /**
  8.      * Transform the given value.
  9.      *
  1.                         // since the object we're given was already a fully instantiated object.
  2.                         $parameters = [$passable$stack];
  3.                     }
  4.                     $carry method_exists($pipe$this->method)
  5.                                     ? $pipe->{$this->method}(...$parameters)
  6.                                     : $pipe(...$parameters);
  7.                     return $this->handleCarry($carry);
  8.                 } catch (Throwable $e) {
  9.                     return $this->handleException($passable$e);
  1.      */
  2.     public function handle($requestClosure $next)
  3.     {
  4.         $this->clean($request);
  5.         return $next($request);
  6.     }
  7.     /**
  8.      * Clean the request's data.
  9.      *
  1.             if ($callback($request)) {
  2.                 return $next($request);
  3.             }
  4.         }
  5.         return parent::handle($request$next);
  6.     }
  7.     /**
  8.      * Transform the given value.
  9.      *
  1.                         // since the object we're given was already a fully instantiated object.
  2.                         $parameters = [$passable$stack];
  3.                     }
  4.                     $carry method_exists($pipe$this->method)
  5.                                     ? $pipe->{$this->method}(...$parameters)
  6.                                     : $pipe(...$parameters);
  7.                     return $this->handleCarry($carry);
  8.                 } catch (Throwable $e) {
  9.                     return $this->handleException($passable$e);
  1.         if ($max && $request->server('CONTENT_LENGTH') > $max) {
  2.             throw new PostTooLargeException;
  3.         }
  4.         return $next($request);
  5.     }
  6.     /**
  7.      * Determine the server 'post_max_size' as bytes.
  8.      *
  1.                         // since the object we're given was already a fully instantiated object.
  2.                         $parameters = [$passable$stack];
  3.                     }
  4.                     $carry method_exists($pipe$this->method)
  5.                                     ? $pipe->{$this->method}(...$parameters)
  6.                                     : $pipe(...$parameters);
  7.                     return $this->handleCarry($carry);
  8.                 } catch (Throwable $e) {
  9.                     return $this->handleException($passable$e);
  1.                 null,
  2.                 $this->getHeaders($data)
  3.             );
  4.         }
  5.         return $next($request);
  6.     }
  7.     /**
  8.      * Determine if the incoming request has a maintenance mode bypass cookie.
  9.      *
  1.                         // since the object we're given was already a fully instantiated object.
  2.                         $parameters = [$passable$stack];
  3.                     }
  4.                     $carry method_exists($pipe$this->method)
  5.                                     ? $pipe->{$this->method}(...$parameters)
  6.                                     : $pipe(...$parameters);
  7.                     return $this->handleCarry($carry);
  8.                 } catch (Throwable $e) {
  9.                     return $this->handleException($passable$e);
  1.      */
  2.     public function handle($requestClosure $next)
  3.     {
  4.         // Check if we're dealing with CORS and if we should handle it
  5.         if (! $this->shouldRun($request)) {
  6.             return $next($request);
  7.         }
  8.         // For Preflight, return the Preflight response
  9.         if ($this->cors->isPreflightRequest($request)) {
  10.             $response $this->cors->handlePreflightRequest($request);
  1.                         // since the object we're given was already a fully instantiated object.
  2.                         $parameters = [$passable$stack];
  3.                     }
  4.                     $carry method_exists($pipe$this->method)
  5.                                     ? $pipe->{$this->method}(...$parameters)
  6.                                     : $pipe(...$parameters);
  7.                     return $this->handleCarry($carry);
  8.                 } catch (Throwable $e) {
  9.                     return $this->handleException($passable$e);
  1.     {
  2.         $request::setTrustedProxies([], $this->getTrustedHeaderNames());
  3.         $this->setTrustedProxyIpAddresses($request);
  4.         return $next($request);
  5.     }
  6.     /**
  7.      * Sets the trusted proxies on the request.
  8.      *
  1.                         // since the object we're given was already a fully instantiated object.
  2.                         $parameters = [$passable$stack];
  3.                     }
  4.                     $carry method_exists($pipe$this->method)
  5.                                     ? $pipe->{$this->method}(...$parameters)
  6.                                     : $pipe(...$parameters);
  7.                     return $this->handleCarry($carry);
  8.                 } catch (Throwable $e) {
  9.                     return $this->handleException($passable$e);
  1.     {
  2.         $pipeline array_reduce(
  3.             array_reverse($this->pipes()), $this->carry(), $this->prepareDestination($destination)
  4.         );
  5.         return $pipeline($this->passable);
  6.     }
  7.     /**
  8.      * Run the pipeline and return the result.
  9.      *
  1.         $this->bootstrap();
  2.         return (new Pipeline($this->app))
  3.                     ->send($request)
  4.                     ->through($this->app->shouldSkipMiddleware() ? [] : $this->middleware)
  5.                     ->then($this->dispatchToRouter());
  6.     }
  7.     /**
  8.      * Bootstrap the application for HTTP requests.
  9.      *
  1.     public function handle($request)
  2.     {
  3.         try {
  4.             $request->enableHttpMethodParameterOverride();
  5.             $response $this->sendRequestThroughRouter($request);
  6.         } catch (Throwable $e) {
  7.             $this->reportException($e);
  8.             $response $this->renderException($request$e);
  9.         }
  1. $app = require_once __DIR__.'/../bootstrap/app.php';
  2. $kernel $app->make(Kernel::class);
  3. $response tap($kernel->handle(
  4.     $request Request::capture()
  5. ))->send();
  6. $kernel->terminate($request$response);

PDOException

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 ')' at line 1

  1.             // For select statements, we'll simply execute the query and return an array
  2.             // of the database result set. Each element in the array will be a single
  3.             // row from the database table, and will either be an array or objects.
  4.             $statement $this->prepared(
  5.                 $this->getPdoForSelect($useReadPdo)->prepare($query)
  6.             );
  7.             $this->bindValues($statement$this->prepareBindings($bindings));
  8.             $statement->execute();
  1.             // For select statements, we'll simply execute the query and return an array
  2.             // of the database result set. Each element in the array will be a single
  3.             // row from the database table, and will either be an array or objects.
  4.             $statement $this->prepared(
  5.                 $this->getPdoForSelect($useReadPdo)->prepare($query)
  6.             );
  7.             $this->bindValues($statement$this->prepareBindings($bindings));
  8.             $statement->execute();
  1.     {
  2.         // To execute the statement, we'll simply call the callback, which will actually
  3.         // run the SQL against the PDO connection. Then we can calculate the time it
  4.         // took to execute and log the query SQL, bindings and time in our memory.
  5.         try {
  6.             return $callback($query$bindings);
  7.         }
  8.         // If an exception occurs when attempting to run a query, we'll format the error
  9.         // message to include the bindings with SQL, which will make this exception a
  10.         // lot more helpful to the developer instead of just the database's errors.
  1.         // Here we will run this query. If an exception occurs we'll determine if it was
  2.         // caused by a connection that has been lost. If that is the cause, we'll try
  3.         // to re-establish connection and re-run the query with a fresh connection.
  4.         try {
  5.             $result $this->runQueryCallback($query$bindings$callback);
  6.         } catch (QueryException $e) {
  7.             $result $this->handleQueryException(
  8.                 $e$query$bindings$callback
  9.             );
  10.         }
  1.             $this->bindValues($statement$this->prepareBindings($bindings));
  2.             $statement->execute();
  3.             return $statement->fetchAll();
  4.         });
  5.     }
  6.     /**
  7.      * Run a select statement against the database and returns a generator.
  8.      *
  1.      * @return array
  2.      */
  3.     protected function runSelect()
  4.     {
  5.         return $this->connection->select(
  6.             $this->toSql(), $this->getBindings(), ! $this->useWritePdo
  7.         );
  8.     }
  9.     /**
  10.      * Paginate the given query into a simple paginator.
  1.      * @return \Illuminate\Support\Collection
  2.      */
  3.     public function get($columns = ['*'])
  4.     {
  5.         return collect($this->onceWithColumns(Arr::wrap($columns), function () {
  6.             return $this->processor->processSelect($this$this->runSelect());
  7.         }));
  8.     }
  9.     /**
  10.      * Run the query as a "select" statement against the connection.
  1.         if (is_null($original)) {
  2.             $this->columns $columns;
  3.         }
  4.         $result $callback();
  5.         $this->columns $original;
  6.         return $result;
  7.     }
  1.      */
  2.     public function get($columns = ['*'])
  3.     {
  4.         return collect($this->onceWithColumns(Arr::wrap($columns), function () {
  5.             return $this->processor->processSelect($this$this->runSelect());
  6.         }));
  7.     }
  8.     /**
  9.      * Run the query as a "select" statement against the connection.
  10.      *
  1.      * @return \Illuminate\Database\Eloquent\Model[]|static[]
  2.      */
  3.     public function getModels($columns = ['*'])
  4.     {
  5.         return $this->model->hydrate(
  6.             $this->query->get($columns)->all()
  7.         )->all();
  8.     }
  9.     /**
  10.      * Eager load the relationships for the models.
  1.         $builder $this->applyScopes();
  2.         // If we actually found models we will also eager load any relationships that
  3.         // have been specified as needing to be eager loaded, which will solve the
  4.         // n+1 query issue for the developers to avoid running a lot of queries.
  5.         if (count($models $builder->getModels($columns)) > 0) {
  6.             $models $builder->eagerLoadRelations($models);
  7.         }
  8.         return $builder->getModel()->newCollection($models);
  9.     }
  1.             $navbar_res_array = [ $navbar_res->one_english$navbar_res->two_english$navbar_res->three_english$navbar_res->four_english$navbar_res->five_english$navbar_res->six_english$navbar_res->seven_english ];
  2.             $navbar_res_array array_unique($navbar_res_array);
  3.             if (($res_key array_search(13$navbar_res_array)) !== false) { unset($navbar_res_array[$res_key]); }
  4.             $res_service_lists Services::wherein('id'$navbar_res_array)->orderByRaw("field(id,".implode(',',$navbar_res_array).")")->get();
  5.             
  6.             return $res_service_lists;
  7.         }
  8.     }
  1.         }
  2.         // $education_nav = EducationCourses::where('site_frid', $site_frid)->get();
  3.                 $education_nav EducationCourses::whereDate('start_time''>='now())->where('site_frid'$site_frid)->orderBy('start_time''asc')->get();
  4.         $res_service_lists navigation_dropdown_res_english($site_frid);
  5.         $com_service_lists navigation_dropdown_com_english($site_frid);
  6.         $res_other_services_eng navigation_dropdown_res_other_english($site_frid$site_detail);
  7.         $com_other_services_eng navigation_dropdown_com_other_english($site_frid$site_detail);
  8.         $residential_custom_services OtherCustomServices::where('site_frid'$site_frid)->where('residential'true)->get();
  1.      * @param  array  $parameters
  2.      * @return \Symfony\Component\HttpFoundation\Response
  3.      */
  4.     public function callAction($method$parameters)
  5.     {
  6.         return $this->{$method}(...array_values($parameters));
  7.     }
  8.     /**
  9.      * Handle calls to missing methods on the controller.
  10.      *
  1.         $parameters $this->resolveClassMethodDependencies(
  2.             $route->parametersWithoutNulls(), $controller$method
  3.         );
  4.         if (method_exists($controller'callAction')) {
  5.             return $controller->callAction($method$parameters);
  6.         }
  7.         return $controller->{$method}(...array_values($parameters));
  8.     }
  1.      * @throws \Symfony\Component\HttpKernel\Exception\NotFoundHttpException
  2.      */
  3.     protected function runController()
  4.     {
  5.         return $this->controllerDispatcher()->dispatch(
  6.             $this$this->getController(), $this->getControllerMethod()
  7.         );
  8.     }
  9.     /**
  10.      * Get the controller instance for the route.
  1.     {
  2.         $this->container $this->container ?: new Container;
  3.         try {
  4.             if ($this->isControllerAction()) {
  5.                 return $this->runController();
  6.             }
  7.             return $this->runCallable();
  8.         } catch (HttpResponseException $e) {
  9.             return $e->getResponse();
  1.         return (new Pipeline($this->container))
  2.                         ->send($request)
  3.                         ->through($middleware)
  4.                         ->then(function ($request) use ($route) {
  5.                             return $this->prepareResponse(
  6.                                 $request$route->run()
  7.                             );
  8.                         });
  9.     }
  10.     /**
  1.      */
  2.     protected function prepareDestination(Closure $destination)
  3.     {
  4.         return function ($passable) use ($destination) {
  5.             try {
  6.                 return $destination($passable);
  7.             } catch (Throwable $e) {
  8.                 return $this->handleException($passable$e);
  9.             }
  10.         };
  11.     }
  1.             }
  2.             throw $exception;
  3.         }
  4.         return $next($request);
  5.     }
  6. }
  1.                         // since the object we're given was already a fully instantiated object.
  2.                         $parameters = [$passable$stack];
  3.                     }
  4.                     $carry method_exists($pipe$this->method)
  5.                                     ? $pipe->{$this->method}(...$parameters)
  6.                                     : $pipe(...$parameters);
  7.                     return $this->handleCarry($carry);
  8.                 } catch (Throwable $e) {
  9.                     return $this->handleException($passable$e);
  1.             $this->isReading($request) ||
  2.             $this->runningUnitTests() ||
  3.             $this->inExceptArray($request) ||
  4.             $this->tokensMatch($request)
  5.         ) {
  6.             return tap($next($request), function ($response) use ($request) {
  7.                 if ($this->shouldAddXsrfTokenCookie()) {
  8.                     $this->addCookieToResponse($request$response);
  9.                 }
  10.             });
  11.         }
  1.                         // since the object we're given was already a fully instantiated object.
  2.                         $parameters = [$passable$stack];
  3.                     }
  4.                     $carry method_exists($pipe$this->method)
  5.                                     ? $pipe->{$this->method}(...$parameters)
  6.                                     : $pipe(...$parameters);
  7.                     return $this->handleCarry($carry);
  8.                 } catch (Throwable $e) {
  9.                     return $this->handleException($passable$e);
  1.         // Putting the errors in the view for every view allows the developer to just
  2.         // assume that some errors are always available, which is convenient since
  3.         // they don't have to continually run checks for the presence of errors.
  4.         return $next($request);
  5.     }
  6. }
  1.                         // since the object we're given was already a fully instantiated object.
  2.                         $parameters = [$passable$stack];
  3.                     }
  4.                     $carry method_exists($pipe$this->method)
  5.                                     ? $pipe->{$this->method}(...$parameters)
  6.                                     : $pipe(...$parameters);
  7.                     return $this->handleCarry($carry);
  8.                 } catch (Throwable $e) {
  9.                     return $this->handleException($passable$e);
  1.             $this->startSession($request$session)
  2.         );
  3.         $this->collectGarbage($session);
  4.         $response $next($request);
  5.         $this->storeCurrentUrl($request$session);
  6.         $this->addCookieToResponse($response$session);
  1.         if ($this->manager->shouldBlock() ||
  2.             ($request->route() instanceof Route && $request->route()->locksFor())) {
  3.             return $this->handleRequestWhileBlocking($request$session$next);
  4.         }
  5.         return $this->handleStatefulRequest($request$session$next);
  6.     }
  7.     /**
  8.      * Handle the given request within session state.
  9.      *
  1.                         // since the object we're given was already a fully instantiated object.
  2.                         $parameters = [$passable$stack];
  3.                     }
  4.                     $carry method_exists($pipe$this->method)
  5.                                     ? $pipe->{$this->method}(...$parameters)
  6.                                     : $pipe(...$parameters);
  7.                     return $this->handleCarry($carry);
  8.                 } catch (Throwable $e) {
  9.                     return $this->handleException($passable$e);
  1.      * @param  \Closure  $next
  2.      * @return mixed
  3.      */
  4.     public function handle($requestClosure $next)
  5.     {
  6.         $response $next($request);
  7.         foreach ($this->cookies->getQueuedCookies() as $cookie) {
  8.             $response->headers->setCookie($cookie);
  9.         }
  1.                         // since the object we're given was already a fully instantiated object.
  2.                         $parameters = [$passable$stack];
  3.                     }
  4.                     $carry method_exists($pipe$this->method)
  5.                                     ? $pipe->{$this->method}(...$parameters)
  6.                                     : $pipe(...$parameters);
  7.                     return $this->handleCarry($carry);
  8.                 } catch (Throwable $e) {
  9.                     return $this->handleException($passable$e);
  1.      * @param  \Closure  $next
  2.      * @return \Symfony\Component\HttpFoundation\Response
  3.      */
  4.     public function handle($requestClosure $next)
  5.     {
  6.         return $this->encrypt($next($this->decrypt($request)));
  7.     }
  8.     /**
  9.      * Decrypt the cookies on the request.
  10.      *
  1.                         // since the object we're given was already a fully instantiated object.
  2.                         $parameters = [$passable$stack];
  3.                     }
  4.                     $carry method_exists($pipe$this->method)
  5.                                     ? $pipe->{$this->method}(...$parameters)
  6.                                     : $pipe(...$parameters);
  7.                     return $this->handleCarry($carry);
  8.                 } catch (Throwable $e) {
  9.                     return $this->handleException($passable$e);
  1.     {
  2.         $pipeline array_reduce(
  3.             array_reverse($this->pipes()), $this->carry(), $this->prepareDestination($destination)
  4.         );
  5.         return $pipeline($this->passable);
  6.     }
  7.     /**
  8.      * Run the pipeline and return the result.
  9.      *
  1.                         ->through($middleware)
  2.                         ->then(function ($request) use ($route) {
  3.                             return $this->prepareResponse(
  4.                                 $request$route->run()
  5.                             );
  6.                         });
  7.     }
  8.     /**
  9.      * Gather the middleware for the given route with resolved class names.
  10.      *
  1.         });
  2.         $this->events->dispatch(new RouteMatched($route$request));
  3.         return $this->prepareResponse($request,
  4.             $this->runRouteWithinStack($route$request)
  5.         );
  6.     }
  7.     /**
  8.      * Run the given route within a Stack "onion" instance.
  1.      * @param  \Illuminate\Http\Request  $request
  2.      * @return \Symfony\Component\HttpFoundation\Response
  3.      */
  4.     public function dispatchToRoute(Request $request)
  5.     {
  6.         return $this->runRoute($request$this->findRoute($request));
  7.     }
  8.     /**
  9.      * Find the route matching a given request.
  10.      *
  1.      */
  2.     public function dispatch(Request $request)
  3.     {
  4.         $this->currentRequest $request;
  5.         return $this->dispatchToRoute($request);
  6.     }
  7.     /**
  8.      * Dispatch the request to a route and return the response.
  9.      *
  1.     protected function dispatchToRouter()
  2.     {
  3.         return function ($request) {
  4.             $this->app->instance('request'$request);
  5.             return $this->router->dispatch($request);
  6.         };
  7.     }
  8.     /**
  9.      * Call the terminate method on any terminable middleware.
  1.      */
  2.     protected function prepareDestination(Closure $destination)
  3.     {
  4.         return function ($passable) use ($destination) {
  5.             try {
  6.                 return $destination($passable);
  7.             } catch (Throwable $e) {
  8.                 return $this->handleException($passable$e);
  9.             }
  10.         };
  11.     }
  1.      */
  2.     public function handle($requestClosure $next)
  3.     {
  4.         $this->clean($request);
  5.         return $next($request);
  6.     }
  7.     /**
  8.      * Clean the request's data.
  9.      *
  1.             if ($callback($request)) {
  2.                 return $next($request);
  3.             }
  4.         }
  5.         return parent::handle($request$next);
  6.     }
  7.     /**
  8.      * Transform the given value.
  9.      *
  1.                         // since the object we're given was already a fully instantiated object.
  2.                         $parameters = [$passable$stack];
  3.                     }
  4.                     $carry method_exists($pipe$this->method)
  5.                                     ? $pipe->{$this->method}(...$parameters)
  6.                                     : $pipe(...$parameters);
  7.                     return $this->handleCarry($carry);
  8.                 } catch (Throwable $e) {
  9.                     return $this->handleException($passable$e);
  1.      */
  2.     public function handle($requestClosure $next)
  3.     {
  4.         $this->clean($request);
  5.         return $next($request);
  6.     }
  7.     /**
  8.      * Clean the request's data.
  9.      *
  1.             if ($callback($request)) {
  2.                 return $next($request);
  3.             }
  4.         }
  5.         return parent::handle($request$next);
  6.     }
  7.     /**
  8.      * Transform the given value.
  9.      *
  1.                         // since the object we're given was already a fully instantiated object.
  2.                         $parameters = [$passable$stack];
  3.                     }
  4.                     $carry method_exists($pipe$this->method)
  5.                                     ? $pipe->{$this->method}(...$parameters)
  6.                                     : $pipe(...$parameters);
  7.                     return $this->handleCarry($carry);
  8.                 } catch (Throwable $e) {
  9.                     return $this->handleException($passable$e);
  1.         if ($max && $request->server('CONTENT_LENGTH') > $max) {
  2.             throw new PostTooLargeException;
  3.         }
  4.         return $next($request);
  5.     }
  6.     /**
  7.      * Determine the server 'post_max_size' as bytes.
  8.      *
  1.                         // since the object we're given was already a fully instantiated object.
  2.                         $parameters = [$passable$stack];
  3.                     }
  4.                     $carry method_exists($pipe$this->method)
  5.                                     ? $pipe->{$this->method}(...$parameters)
  6.                                     : $pipe(...$parameters);
  7.                     return $this->handleCarry($carry);
  8.                 } catch (Throwable $e) {
  9.                     return $this->handleException($passable$e);
  1.                 null,
  2.                 $this->getHeaders($data)
  3.             );
  4.         }
  5.         return $next($request);
  6.     }
  7.     /**
  8.      * Determine if the incoming request has a maintenance mode bypass cookie.
  9.      *
  1.                         // since the object we're given was already a fully instantiated object.
  2.                         $parameters = [$passable$stack];
  3.                     }
  4.                     $carry method_exists($pipe$this->method)
  5.                                     ? $pipe->{$this->method}(...$parameters)
  6.                                     : $pipe(...$parameters);
  7.                     return $this->handleCarry($carry);
  8.                 } catch (Throwable $e) {
  9.                     return $this->handleException($passable$e);
  1.      */
  2.     public function handle($requestClosure $next)
  3.     {
  4.         // Check if we're dealing with CORS and if we should handle it
  5.         if (! $this->shouldRun($request)) {
  6.             return $next($request);
  7.         }
  8.         // For Preflight, return the Preflight response
  9.         if ($this->cors->isPreflightRequest($request)) {
  10.             $response $this->cors->handlePreflightRequest($request);
  1.                         // since the object we're given was already a fully instantiated object.
  2.                         $parameters = [$passable$stack];
  3.                     }
  4.                     $carry method_exists($pipe$this->method)
  5.                                     ? $pipe->{$this->method}(...$parameters)
  6.                                     : $pipe(...$parameters);
  7.                     return $this->handleCarry($carry);
  8.                 } catch (Throwable $e) {
  9.                     return $this->handleException($passable$e);
  1.     {
  2.         $request::setTrustedProxies([], $this->getTrustedHeaderNames());
  3.         $this->setTrustedProxyIpAddresses($request);
  4.         return $next($request);
  5.     }
  6.     /**
  7.      * Sets the trusted proxies on the request.
  8.      *
  1.                         // since the object we're given was already a fully instantiated object.
  2.                         $parameters = [$passable$stack];
  3.                     }
  4.                     $carry method_exists($pipe$this->method)
  5.                                     ? $pipe->{$this->method}(...$parameters)
  6.                                     : $pipe(...$parameters);
  7.                     return $this->handleCarry($carry);
  8.                 } catch (Throwable $e) {
  9.                     return $this->handleException($passable$e);
  1.     {
  2.         $pipeline array_reduce(
  3.             array_reverse($this->pipes()), $this->carry(), $this->prepareDestination($destination)
  4.         );
  5.         return $pipeline($this->passable);
  6.     }
  7.     /**
  8.      * Run the pipeline and return the result.
  9.      *
  1.         $this->bootstrap();
  2.         return (new Pipeline($this->app))
  3.                     ->send($request)
  4.                     ->through($this->app->shouldSkipMiddleware() ? [] : $this->middleware)
  5.                     ->then($this->dispatchToRouter());
  6.     }
  7.     /**
  8.      * Bootstrap the application for HTTP requests.
  9.      *
  1.     public function handle($request)
  2.     {
  3.         try {
  4.             $request->enableHttpMethodParameterOverride();
  5.             $response $this->sendRequestThroughRouter($request);
  6.         } catch (Throwable $e) {
  7.             $this->reportException($e);
  8.             $response $this->renderException($request$e);
  9.         }
  1. $app = require_once __DIR__.'/../bootstrap/app.php';
  2. $kernel $app->make(Kernel::class);
  3. $response tap($kernel->handle(
  4.     $request Request::capture()
  5. ))->send();
  6. $kernel->terminate($request$response);

Stack Traces 2

[2/2] QueryException
Illuminate\Database\QueryException:
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 ')' at line 1 (SQL: select * from `services` where 0 = 1 and `services`.`deleted_at` is null order by field(id,))

  at /home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Database/Connection.php:712
  at Illuminate\Database\Connection->runQueryCallback('select * from `services` where 0 = 1 and `services`.`deleted_at` is null order by field(id,)', array(), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Database/Connection.php:672)
  at Illuminate\Database\Connection->run('select * from `services` where 0 = 1 and `services`.`deleted_at` is null order by field(id,)', array(), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Database/Connection.php:376)
  at Illuminate\Database\Connection->select('select * from `services` where 0 = 1 and `services`.`deleted_at` is null order by field(id,)', array(), true)
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2414)
  at Illuminate\Database\Query\Builder->runSelect()
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2402)
  at Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2936)
  at Illuminate\Database\Query\Builder->onceWithColumns(array('*'), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2403)
  at Illuminate\Database\Query\Builder->get(array('*'))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:625)
  at Illuminate\Database\Eloquent\Builder->getModels(array('*'))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:609)
  at Illuminate\Database\Eloquent\Builder->get()
     (/home/svmserver/public_html/service-master-restore/releases/11/app/CustomFunctions/navigations_dropdown.php:20)
  at navigation_dropdown_res_english(7209)
     (/home/svmserver/public_html/service-master-restore/releases/11/app/Http/Controllers/ServicesResidentialController.php:1166)
  at App\Http\Controllers\ServicesResidentialController->other()
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54)
  at Illuminate\Routing\Controller->callAction('other', array())
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45)
  at Illuminate\Routing\ControllerDispatcher->dispatch(object(Route), object(ServicesResidentialController), 'other')
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Routing/Route.php:262)
  at Illuminate\Routing\Route->runController()
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Routing/Route.php:205)
  at Illuminate\Routing\Route->run()
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Routing/Router.php:721)
  at Illuminate\Routing\Router->Illuminate\Routing\{closure}(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:128)
  at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50)
  at Illuminate\Routing\Middleware\SubstituteBindings->handle(object(Request), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167)
  at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:78)
  at Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(object(Request), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167)
  at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49)
  at Illuminate\View\Middleware\ShareErrorsFromSession->handle(object(Request), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167)
  at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:121)
  at Illuminate\Session\Middleware\StartSession->handleStatefulRequest(object(Request), object(Store), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:64)
  at Illuminate\Session\Middleware\StartSession->handle(object(Request), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167)
  at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37)
  at Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(object(Request), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167)
  at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:67)
  at Illuminate\Cookie\Middleware\EncryptCookies->handle(object(Request), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167)
  at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:103)
  at Illuminate\Pipeline\Pipeline->then(object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Routing/Router.php:723)
  at Illuminate\Routing\Router->runRouteWithinStack(object(Route), object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Routing/Router.php:698)
  at Illuminate\Routing\Router->runRoute(object(Request), object(Route))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Routing/Router.php:662)
  at Illuminate\Routing\Router->dispatchToRoute(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Routing/Router.php:651)
  at Illuminate\Routing\Router->dispatch(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:167)
  at Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:128)
  at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21)
  at Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(object(Request), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php:31)
  at Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle(object(Request), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167)
  at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21)
  at Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(object(Request), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php:40)
  at Illuminate\Foundation\Http\Middleware\TrimStrings->handle(object(Request), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167)
  at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27)
  at Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(object(Request), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167)
  at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php:86)
  at Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle(object(Request), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167)
  at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/fruitcake/laravel-cors/src/HandleCors.php:38)
  at Fruitcake\Cors\HandleCors->handle(object(Request), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167)
  at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php:39)
  at Illuminate\Http\Middleware\TrustProxies->handle(object(Request), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167)
  at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:103)
  at Illuminate\Pipeline\Pipeline->then(object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:142)
  at Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:111)
  at Illuminate\Foundation\Http\Kernel->handle(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/public/index.php:52)                
[1/2] PDOException
PDOException:
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 ')' at line 1

  at /home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Database/Connection.php:368
  at PDO->prepare('select * from `services` where 0 = 1 and `services`.`deleted_at` is null order by field(id,)')
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Database/Connection.php:368)
  at Illuminate\Database\Connection->Illuminate\Database\{closure}('select * from `services` where 0 = 1 and `services`.`deleted_at` is null order by field(id,)', array())
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Database/Connection.php:705)
  at Illuminate\Database\Connection->runQueryCallback('select * from `services` where 0 = 1 and `services`.`deleted_at` is null order by field(id,)', array(), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Database/Connection.php:672)
  at Illuminate\Database\Connection->run('select * from `services` where 0 = 1 and `services`.`deleted_at` is null order by field(id,)', array(), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Database/Connection.php:376)
  at Illuminate\Database\Connection->select('select * from `services` where 0 = 1 and `services`.`deleted_at` is null order by field(id,)', array(), true)
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2414)
  at Illuminate\Database\Query\Builder->runSelect()
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2402)
  at Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2936)
  at Illuminate\Database\Query\Builder->onceWithColumns(array('*'), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2403)
  at Illuminate\Database\Query\Builder->get(array('*'))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:625)
  at Illuminate\Database\Eloquent\Builder->getModels(array('*'))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:609)
  at Illuminate\Database\Eloquent\Builder->get()
     (/home/svmserver/public_html/service-master-restore/releases/11/app/CustomFunctions/navigations_dropdown.php:20)
  at navigation_dropdown_res_english(7209)
     (/home/svmserver/public_html/service-master-restore/releases/11/app/Http/Controllers/ServicesResidentialController.php:1166)
  at App\Http\Controllers\ServicesResidentialController->other()
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54)
  at Illuminate\Routing\Controller->callAction('other', array())
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45)
  at Illuminate\Routing\ControllerDispatcher->dispatch(object(Route), object(ServicesResidentialController), 'other')
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Routing/Route.php:262)
  at Illuminate\Routing\Route->runController()
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Routing/Route.php:205)
  at Illuminate\Routing\Route->run()
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Routing/Router.php:721)
  at Illuminate\Routing\Router->Illuminate\Routing\{closure}(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:128)
  at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50)
  at Illuminate\Routing\Middleware\SubstituteBindings->handle(object(Request), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167)
  at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:78)
  at Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(object(Request), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167)
  at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49)
  at Illuminate\View\Middleware\ShareErrorsFromSession->handle(object(Request), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167)
  at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:121)
  at Illuminate\Session\Middleware\StartSession->handleStatefulRequest(object(Request), object(Store), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:64)
  at Illuminate\Session\Middleware\StartSession->handle(object(Request), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167)
  at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37)
  at Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(object(Request), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167)
  at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:67)
  at Illuminate\Cookie\Middleware\EncryptCookies->handle(object(Request), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167)
  at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:103)
  at Illuminate\Pipeline\Pipeline->then(object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Routing/Router.php:723)
  at Illuminate\Routing\Router->runRouteWithinStack(object(Route), object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Routing/Router.php:698)
  at Illuminate\Routing\Router->runRoute(object(Request), object(Route))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Routing/Router.php:662)
  at Illuminate\Routing\Router->dispatchToRoute(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Routing/Router.php:651)
  at Illuminate\Routing\Router->dispatch(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:167)
  at Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:128)
  at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21)
  at Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(object(Request), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php:31)
  at Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle(object(Request), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167)
  at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21)
  at Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(object(Request), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php:40)
  at Illuminate\Foundation\Http\Middleware\TrimStrings->handle(object(Request), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167)
  at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27)
  at Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(object(Request), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167)
  at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php:86)
  at Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle(object(Request), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167)
  at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/fruitcake/laravel-cors/src/HandleCors.php:38)
  at Fruitcake\Cors\HandleCors->handle(object(Request), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167)
  at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php:39)
  at Illuminate\Http\Middleware\TrustProxies->handle(object(Request), object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167)
  at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:103)
  at Illuminate\Pipeline\Pipeline->then(object(Closure))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:142)
  at Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:111)
  at Illuminate\Foundation\Http\Kernel->handle(object(Request))
     (/home/svmserver/public_html/service-master-restore/releases/11/public/index.php:52)