Illuminate\Database\QueryException {#9096 +errorInfo: array:3 [ 0 => "42S22" 1 => 1054 2 => "Unknown column 'jobs.job_id' in 'field list'" ] +connectionName: "mysql" #sql: "select `jobs`.`id`, `cities`.`name`, `cities`.`total_jobs`, `cities`.`lat`, `cities`.`lon`, `jobs`.`slug`, `jobs`.`title`, `jobs`.`salary_schedule`, `jobs`.`description`, `jobs`.`salary_min`, `salary_max`, `recruiters`.`company_name`, `recruiters`.`company_logo`, `jobs`.`is_external`, `jobs`.`location_string`, `jobs`.`salary_string`, `jobs`.`company`, `jobs`.`job_website`, `jobs`.`category_string`, `jobs`.`job_industry`, `jobs`.`job_status`, `jobs`.`job_id`, `industries`.`name` as `industry_name`, `industries`.`industry_slug`, `jobs`.`addition_params` from `matchguru_medicaljobs`.`jobs` left join `matchguru_medicaljobs`.`cities` on `matchguru_medicaljobs`.`jobs`.`city` = `matchguru_medicaljobs`.`cities`.`id` left join `matchguru_medicaljobs`.`recruiters` on `matchguru_medicaljobs`.`jobs`.`recruiter_id` = `matchguru_medicaljobs`.`recruiters`.`id` left join `matchguru_medicaljobs`.`industries` on `matchguru_medicaljobs`.`jobs`.`job_industry` = `matchguru_medicaljobs`.`industries`.`id` where ( LOWER(cities.name) LIKE LOWER('%al4%') OR LOWER(jobs.location_string) LIKE LOWER('%al4%') ) AND (jobs.job_status = 'active') limit 21 offset 0" #bindings: [] }
throw new UniqueConstraintViolationException(
$this->getName(), $query, $this->prepareBindings($bindings), $e
);
}
throw new QueryException(
$this->getName(), $query, $this->prepareBindings($bindings), $e
);
}
}
// Here we will run this query. If an exception occurs we'll determine if it was
// caused by a connection that has been lost. If that is the cause, we'll try
// to re-establish connection and re-run the query with a fresh connection.
try {
$result = $this->runQueryCallback($query, $bindings, $callback);
} catch (QueryException $e) {
$result = $this->handleQueryException(
$e, $query, $bindings, $callback
);
}
$this->bindValues($statement, $this->prepareBindings($bindings));
$statement->execute();
return $statement->fetchAll();
});
}
/**
* Run a select statement against the database and returns all of the result sets.
*
* @return array
*/
protected function runSelect()
{
return $this->connection->select(
$this->toSql(), $this->getBindings(), ! $this->useWritePdo
);
}
/**
* Paginate the given query into a simple paginator.
* @return \Illuminate\Support\Collection
*/
public function get($columns = ['*'])
{
return collect($this->onceWithColumns(Arr::wrap($columns), function () {
return $this->processor->processSelect($this, $this->runSelect());
}));
}
/**
* Run the query as a "select" statement against the connection.
if (is_null($original)) {
$this->columns = $columns;
}
$result = $callback();
$this->columns = $original;
return $result;
}
*/
public function get($columns = ['*'])
{
return collect($this->onceWithColumns(Arr::wrap($columns), function () {
return $this->processor->processSelect($this, $this->runSelect());
}));
}
/**
* Run the query as a "select" statement against the connection.
*
{
$page = $page ?: Paginator::resolveCurrentPage($pageName);
$this->offset(($page - 1) * $perPage)->limit($perPage + 1);
return $this->simplePaginator($this->get($columns), $perPage, $page, [
'path' => Paginator::resolveCurrentPath(),
'pageName' => $pageName,
]);
}
}
// dd( $query->toSql() );
$jobs = $query->simplePaginate(20);
$request = Request::capture();
$cities = City::orderBy('total_jobs', 'DESC')->select("city_slug","name", "total_jobs")->paginate(12);
$industries = Industry::orderBy('total_jobs', 'DESC')->select("industry_slug", "name", "total_jobs")->paginate(12);
* @param array $parameters
* @return \Symfony\Component\HttpFoundation\Response
*/
public function callAction($method, $parameters)
{
return $this->{$method}(...array_values($parameters));
}
/**
* Handle calls to missing methods on the controller.
*
public function dispatch(Route $route, $controller, $method)
{
$parameters = $this->resolveParameters($route, $controller, $method);
if (method_exists($controller, 'callAction')) {
return $controller->callAction($method, $parameters);
}
return $controller->{$method}(...array_values($parameters));
}
* @throws \Symfony\Component\HttpKernel\Exception\NotFoundHttpException
*/
protected function runController()
{
return $this->controllerDispatcher()->dispatch(
$this, $this->getController(), $this->getControllerMethod()
);
}
/**
* Get the controller instance for the route.
{
$this->container = $this->container ?: new Container;
try {
if ($this->isControllerAction()) {
return $this->runController();
}
return $this->runCallable();
} catch (HttpResponseException $e) {
return $e->getResponse();
return (new Pipeline($this->container))
->send($request)
->through($middleware)
->then(fn ($request) => $this->prepareResponse(
$request, $route->run()
));
}
/**
* Gather the middleware for the given route with resolved class names.
*/
protected function prepareDestination(Closure $destination)
{
return function ($passable) use ($destination) {
try {
return $destination($passable);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
}
};
}
}
throw $exception;
}
return $next($request);
}
}
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
$this->isReading($request) ||
$this->runningUnitTests() ||
$this->inExceptArray($request) ||
$this->tokensMatch($request)
) {
return tap($next($request), function ($response) use ($request) {
if ($this->shouldAddXsrfTokenCookie()) {
$this->addCookieToResponse($request, $response);
}
});
}
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
// Putting the errors in the view for every view allows the developer to just
// assume that some errors are always available, which is convenient since
// they don't have to continually run checks for the presence of errors.
return $next($request);
}
}
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
$this->startSession($request, $session)
);
$this->collectGarbage($session);
$response = $next($request);
$this->storeCurrentUrl($request, $session);
$this->addCookieToResponse($response, $session);
if ($this->manager->shouldBlock() ||
($request->route() instanceof Route && $request->route()->locksFor())) {
return $this->handleRequestWhileBlocking($request, $session, $next);
}
return $this->handleStatefulRequest($request, $session, $next);
}
/**
* Handle the given request within session state.
*
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
* @param \Closure $next
* @return mixed
*/
public function handle($request, Closure $next)
{
$response = $next($request);
foreach ($this->cookies->getQueuedCookies() as $cookie) {
$response->headers->setCookie($cookie);
}
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
// $visitor->domain = getsubDomain();
// $visitor->save();
// }
return $next($request);
}
}
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
{
$pipeline = array_reduce(
array_reverse($this->pipes()), $this->carry(), $this->prepareDestination($destination)
);
return $pipeline($this->passable);
}
/**
* Run the pipeline and return the result.
*
return (new Pipeline($this->container))
->send($request)
->through($middleware)
->then(fn ($request) => $this->prepareResponse(
$request, $route->run()
));
}
/**
* Gather the middleware for the given route with resolved class names.
*
$request->setRouteResolver(fn () => $route);
$this->events->dispatch(new RouteMatched($route, $request));
return $this->prepareResponse($request,
$this->runRouteWithinStack($route, $request)
);
}
/**
* Run the given route within a Stack "onion" instance.
* @param \Illuminate\Http\Request $request
* @return \Symfony\Component\HttpFoundation\Response
*/
public function dispatchToRoute(Request $request)
{
return $this->runRoute($request, $this->findRoute($request));
}
/**
* Find the route matching a given request.
*
*/
public function dispatch(Request $request)
{
$this->currentRequest = $request;
return $this->dispatchToRoute($request);
}
/**
* Dispatch the request to a route and return the response.
*
protected function dispatchToRouter()
{
return function ($request) {
$this->app->instance('request', $request);
return $this->router->dispatch($request);
};
}
/**
* Call the terminate method on any terminable middleware.
*/
protected function prepareDestination(Closure $destination)
{
return function ($passable) use ($destination) {
try {
return $destination($passable);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
}
};
}
$this->debugbar->boot();
try {
/** @var \Illuminate\Http\Response $response */
$response = $next($request);
} catch (Throwable $e) {
$response = $this->handleException($request, $e);
}
// Modify the response to add the Debugbar
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
*/
public function handle($request, Closure $next)
{
$this->clean($request);
return $next($request);
}
/**
* Clean the request's data.
*
if ($callback($request)) {
return $next($request);
}
}
return parent::handle($request, $next);
}
/**
* Transform the given value.
*
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
*/
public function handle($request, Closure $next)
{
$this->clean($request);
return $next($request);
}
/**
* Clean the request's data.
*
if ($callback($request)) {
return $next($request);
}
}
return parent::handle($request, $next);
}
/**
* Transform the given value.
*
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
if ($max > 0 && $request->server('CONTENT_LENGTH') > $max) {
throw new PostTooLargeException;
}
return $next($request);
}
/**
* Determine the server 'post_max_size' as bytes.
*
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
null,
$this->getHeaders($data)
);
}
return $next($request);
}
/**
* Determine if the incoming request has a maintenance mode bypass cookie.
*
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
{
$pipeline = array_reduce(
array_reverse($this->pipes()), $this->carry(), $this->prepareDestination($destination)
);
return $pipeline($this->passable);
}
/**
* Run the pipeline and return the result.
*
$this->bootstrap();
return (new Pipeline($this->app))
->send($request)
->through($this->app->shouldSkipMiddleware() ? [] : $this->middleware)
->then($this->dispatchToRouter());
}
/**
* Bootstrap the application for HTTP requests.
*
$this->requestStartedAt = Carbon::now();
try {
$request->enableHttpMethodParameterOverride();
$response = $this->sendRequestThroughRouter($request);
} catch (Throwable $e) {
$this->reportException($e);
$response = $this->renderException($request, $e);
}
|
*/
$kernel = $app->make(Illuminate\Contracts\Http\Kernel::class);
$response = $kernel->handle( $request = Illuminate\Http\Request::capture() );
$response->send();
$kernel->terminate($request, $response);
// For select statements, we'll simply execute the query and return an array
// of the database result set. Each element in the array will be a single
// row from the database table, and will either be an array or objects.
$statement = $this->prepared(
$this->getPdoForSelect($useReadPdo)->prepare($query)
);
$this->bindValues($statement, $this->prepareBindings($bindings));
$statement->execute();
// For select statements, we'll simply execute the query and return an array
// of the database result set. Each element in the array will be a single
// row from the database table, and will either be an array or objects.
$statement = $this->prepared(
$this->getPdoForSelect($useReadPdo)->prepare($query)
);
$this->bindValues($statement, $this->prepareBindings($bindings));
$statement->execute();
{
// To execute the statement, we'll simply call the callback, which will actually
// run the SQL against the PDO connection. Then we can calculate the time it
// took to execute and log the query SQL, bindings and time in our memory.
try {
return $callback($query, $bindings);
}
// If an exception occurs when attempting to run a query, we'll format the error
// message to include the bindings with SQL, which will make this exception a
// lot more helpful to the developer instead of just the database's errors.
// Here we will run this query. If an exception occurs we'll determine if it was
// caused by a connection that has been lost. If that is the cause, we'll try
// to re-establish connection and re-run the query with a fresh connection.
try {
$result = $this->runQueryCallback($query, $bindings, $callback);
} catch (QueryException $e) {
$result = $this->handleQueryException(
$e, $query, $bindings, $callback
);
}
$this->bindValues($statement, $this->prepareBindings($bindings));
$statement->execute();
return $statement->fetchAll();
});
}
/**
* Run a select statement against the database and returns all of the result sets.
*
* @return array
*/
protected function runSelect()
{
return $this->connection->select(
$this->toSql(), $this->getBindings(), ! $this->useWritePdo
);
}
/**
* Paginate the given query into a simple paginator.
* @return \Illuminate\Support\Collection
*/
public function get($columns = ['*'])
{
return collect($this->onceWithColumns(Arr::wrap($columns), function () {
return $this->processor->processSelect($this, $this->runSelect());
}));
}
/**
* Run the query as a "select" statement against the connection.
if (is_null($original)) {
$this->columns = $columns;
}
$result = $callback();
$this->columns = $original;
return $result;
}
*/
public function get($columns = ['*'])
{
return collect($this->onceWithColumns(Arr::wrap($columns), function () {
return $this->processor->processSelect($this, $this->runSelect());
}));
}
/**
* Run the query as a "select" statement against the connection.
*
{
$page = $page ?: Paginator::resolveCurrentPage($pageName);
$this->offset(($page - 1) * $perPage)->limit($perPage + 1);
return $this->simplePaginator($this->get($columns), $perPage, $page, [
'path' => Paginator::resolveCurrentPath(),
'pageName' => $pageName,
]);
}
}
// dd( $query->toSql() );
$jobs = $query->simplePaginate(20);
$request = Request::capture();
$cities = City::orderBy('total_jobs', 'DESC')->select("city_slug","name", "total_jobs")->paginate(12);
$industries = Industry::orderBy('total_jobs', 'DESC')->select("industry_slug", "name", "total_jobs")->paginate(12);
* @param array $parameters
* @return \Symfony\Component\HttpFoundation\Response
*/
public function callAction($method, $parameters)
{
return $this->{$method}(...array_values($parameters));
}
/**
* Handle calls to missing methods on the controller.
*
public function dispatch(Route $route, $controller, $method)
{
$parameters = $this->resolveParameters($route, $controller, $method);
if (method_exists($controller, 'callAction')) {
return $controller->callAction($method, $parameters);
}
return $controller->{$method}(...array_values($parameters));
}
* @throws \Symfony\Component\HttpKernel\Exception\NotFoundHttpException
*/
protected function runController()
{
return $this->controllerDispatcher()->dispatch(
$this, $this->getController(), $this->getControllerMethod()
);
}
/**
* Get the controller instance for the route.
{
$this->container = $this->container ?: new Container;
try {
if ($this->isControllerAction()) {
return $this->runController();
}
return $this->runCallable();
} catch (HttpResponseException $e) {
return $e->getResponse();
return (new Pipeline($this->container))
->send($request)
->through($middleware)
->then(fn ($request) => $this->prepareResponse(
$request, $route->run()
));
}
/**
* Gather the middleware for the given route with resolved class names.
*/
protected function prepareDestination(Closure $destination)
{
return function ($passable) use ($destination) {
try {
return $destination($passable);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
}
};
}
}
throw $exception;
}
return $next($request);
}
}
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
$this->isReading($request) ||
$this->runningUnitTests() ||
$this->inExceptArray($request) ||
$this->tokensMatch($request)
) {
return tap($next($request), function ($response) use ($request) {
if ($this->shouldAddXsrfTokenCookie()) {
$this->addCookieToResponse($request, $response);
}
});
}
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
// Putting the errors in the view for every view allows the developer to just
// assume that some errors are always available, which is convenient since
// they don't have to continually run checks for the presence of errors.
return $next($request);
}
}
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
$this->startSession($request, $session)
);
$this->collectGarbage($session);
$response = $next($request);
$this->storeCurrentUrl($request, $session);
$this->addCookieToResponse($response, $session);
if ($this->manager->shouldBlock() ||
($request->route() instanceof Route && $request->route()->locksFor())) {
return $this->handleRequestWhileBlocking($request, $session, $next);
}
return $this->handleStatefulRequest($request, $session, $next);
}
/**
* Handle the given request within session state.
*
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
* @param \Closure $next
* @return mixed
*/
public function handle($request, Closure $next)
{
$response = $next($request);
foreach ($this->cookies->getQueuedCookies() as $cookie) {
$response->headers->setCookie($cookie);
}
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
// $visitor->domain = getsubDomain();
// $visitor->save();
// }
return $next($request);
}
}
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
{
$pipeline = array_reduce(
array_reverse($this->pipes()), $this->carry(), $this->prepareDestination($destination)
);
return $pipeline($this->passable);
}
/**
* Run the pipeline and return the result.
*
return (new Pipeline($this->container))
->send($request)
->through($middleware)
->then(fn ($request) => $this->prepareResponse(
$request, $route->run()
));
}
/**
* Gather the middleware for the given route with resolved class names.
*
$request->setRouteResolver(fn () => $route);
$this->events->dispatch(new RouteMatched($route, $request));
return $this->prepareResponse($request,
$this->runRouteWithinStack($route, $request)
);
}
/**
* Run the given route within a Stack "onion" instance.
* @param \Illuminate\Http\Request $request
* @return \Symfony\Component\HttpFoundation\Response
*/
public function dispatchToRoute(Request $request)
{
return $this->runRoute($request, $this->findRoute($request));
}
/**
* Find the route matching a given request.
*
*/
public function dispatch(Request $request)
{
$this->currentRequest = $request;
return $this->dispatchToRoute($request);
}
/**
* Dispatch the request to a route and return the response.
*
protected function dispatchToRouter()
{
return function ($request) {
$this->app->instance('request', $request);
return $this->router->dispatch($request);
};
}
/**
* Call the terminate method on any terminable middleware.
*/
protected function prepareDestination(Closure $destination)
{
return function ($passable) use ($destination) {
try {
return $destination($passable);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
}
};
}
$this->debugbar->boot();
try {
/** @var \Illuminate\Http\Response $response */
$response = $next($request);
} catch (Throwable $e) {
$response = $this->handleException($request, $e);
}
// Modify the response to add the Debugbar
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
*/
public function handle($request, Closure $next)
{
$this->clean($request);
return $next($request);
}
/**
* Clean the request's data.
*
if ($callback($request)) {
return $next($request);
}
}
return parent::handle($request, $next);
}
/**
* Transform the given value.
*
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
*/
public function handle($request, Closure $next)
{
$this->clean($request);
return $next($request);
}
/**
* Clean the request's data.
*
if ($callback($request)) {
return $next($request);
}
}
return parent::handle($request, $next);
}
/**
* Transform the given value.
*
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
if ($max > 0 && $request->server('CONTENT_LENGTH') > $max) {
throw new PostTooLargeException;
}
return $next($request);
}
/**
* Determine the server 'post_max_size' as bytes.
*
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
null,
$this->getHeaders($data)
);
}
return $next($request);
}
/**
* Determine if the incoming request has a maintenance mode bypass cookie.
*
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
{
$pipeline = array_reduce(
array_reverse($this->pipes()), $this->carry(), $this->prepareDestination($destination)
);
return $pipeline($this->passable);
}
/**
* Run the pipeline and return the result.
*
$this->bootstrap();
return (new Pipeline($this->app))
->send($request)
->through($this->app->shouldSkipMiddleware() ? [] : $this->middleware)
->then($this->dispatchToRouter());
}
/**
* Bootstrap the application for HTTP requests.
*
$this->requestStartedAt = Carbon::now();
try {
$request->enableHttpMethodParameterOverride();
$response = $this->sendRequestThroughRouter($request);
} catch (Throwable $e) {
$this->reportException($e);
$response = $this->renderException($request, $e);
}
|
*/
$kernel = $app->make(Illuminate\Contracts\Http\Kernel::class);
$response = $kernel->handle( $request = Illuminate\Http\Request::capture() );
$response->send();
$kernel->terminate($request, $response);
[2/2]
QueryException
|
---|
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'jobs.job_id' in 'field list' (Connection: mysql, SQL: select `jobs`.`id`, `cities`.`name`, `cities`.`total_jobs`, `cities`.`lat`, `cities`.`lon`, `jobs`.`slug`, `jobs`.`title`, `jobs`.`salary_schedule`, `jobs`.`description`, `jobs`.`salary_min`, `salary_max`, `recruiters`.`company_name`, `recruiters`.`company_logo`, `jobs`.`is_external`, `jobs`.`location_string`, `jobs`.`salary_string`, `jobs`.`company`, `jobs`.`job_website`, `jobs`.`category_string`, `jobs`.`job_industry`, `jobs`.`job_status`, `jobs`.`job_id`, `industries`.`name` as `industry_name`, `industries`.`industry_slug`, `jobs`.`addition_params` from `matchguru_medicaljobs`.`jobs` left join `matchguru_medicaljobs`.`cities` on `matchguru_medicaljobs`.`jobs`.`city` = `matchguru_medicaljobs`.`cities`.`id` left join `matchguru_medicaljobs`.`recruiters` on `matchguru_medicaljobs`.`jobs`.`recruiter_id` = `matchguru_medicaljobs`.`recruiters`.`id` left join `matchguru_medicaljobs`.`industries` on `matchguru_medicaljobs`.`jobs`.`job_industry` = `matchguru_medicaljobs`.`industries`.`id` where ( LOWER(cities.name) LIKE LOWER('%al4%') OR LOWER(jobs.location_string) LIKE LOWER('%al4%') ) AND (jobs.job_status = 'active') limit 21 offset 0) at /home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Database/Connection.php:801 at Illuminate\Database\Connection->runQueryCallback('select `jobs`.`id`, `cities`.`name`, `cities`.`total_jobs`, `cities`.`lat`, `cities`.`lon`, `jobs`.`slug`, `jobs`.`title`, `jobs`.`salary_schedule`, `jobs`.`description`, `jobs`.`salary_min`, `salary_max`, `recruiters`.`company_name`, `recruiters`.`company_logo`, `jobs`.`is_external`, `jobs`.`location_string`, `jobs`.`salary_string`, `jobs`.`company`, `jobs`.`job_website`, `jobs`.`category_string`, `jobs`.`job_industry`, `jobs`.`job_status`, `jobs`.`job_id`, `industries`.`name` as `industry_name`, `industries`.`industry_slug`, `jobs`.`addition_params` from `matchguru_medicaljobs`.`jobs` left join `matchguru_medicaljobs`.`cities` on `matchguru_medicaljobs`.`jobs`.`city` = `matchguru_medicaljobs`.`cities`.`id` left join `matchguru_medicaljobs`.`recruiters` on `matchguru_medicaljobs`.`jobs`.`recruiter_id` = `matchguru_medicaljobs`.`recruiters`.`id` left join `matchguru_medicaljobs`.`industries` on `matchguru_medicaljobs`.`jobs`.`job_industry` = `matchguru_medicaljobs`.`industries`.`id` where ( LOWER(cities.name) LIKE LOWER(\'%al4%\') OR LOWER(jobs.location_string) LIKE LOWER(\'%al4%\') ) AND (jobs.job_status = \'active\') limit 21 offset 0', array(), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Database/Connection.php:755) at Illuminate\Database\Connection->run('select `jobs`.`id`, `cities`.`name`, `cities`.`total_jobs`, `cities`.`lat`, `cities`.`lon`, `jobs`.`slug`, `jobs`.`title`, `jobs`.`salary_schedule`, `jobs`.`description`, `jobs`.`salary_min`, `salary_max`, `recruiters`.`company_name`, `recruiters`.`company_logo`, `jobs`.`is_external`, `jobs`.`location_string`, `jobs`.`salary_string`, `jobs`.`company`, `jobs`.`job_website`, `jobs`.`category_string`, `jobs`.`job_industry`, `jobs`.`job_status`, `jobs`.`job_id`, `industries`.`name` as `industry_name`, `industries`.`industry_slug`, `jobs`.`addition_params` from `matchguru_medicaljobs`.`jobs` left join `matchguru_medicaljobs`.`cities` on `matchguru_medicaljobs`.`jobs`.`city` = `matchguru_medicaljobs`.`cities`.`id` left join `matchguru_medicaljobs`.`recruiters` on `matchguru_medicaljobs`.`jobs`.`recruiter_id` = `matchguru_medicaljobs`.`recruiters`.`id` left join `matchguru_medicaljobs`.`industries` on `matchguru_medicaljobs`.`jobs`.`job_industry` = `matchguru_medicaljobs`.`industries`.`id` where ( LOWER(cities.name) LIKE LOWER(\'%al4%\') OR LOWER(jobs.location_string) LIKE LOWER(\'%al4%\') ) AND (jobs.job_status = \'active\') limit 21 offset 0', array(), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Database/Connection.php:424) at Illuminate\Database\Connection->select('select `jobs`.`id`, `cities`.`name`, `cities`.`total_jobs`, `cities`.`lat`, `cities`.`lon`, `jobs`.`slug`, `jobs`.`title`, `jobs`.`salary_schedule`, `jobs`.`description`, `jobs`.`salary_min`, `salary_max`, `recruiters`.`company_name`, `recruiters`.`company_logo`, `jobs`.`is_external`, `jobs`.`location_string`, `jobs`.`salary_string`, `jobs`.`company`, `jobs`.`job_website`, `jobs`.`category_string`, `jobs`.`job_industry`, `jobs`.`job_status`, `jobs`.`job_id`, `industries`.`name` as `industry_name`, `industries`.`industry_slug`, `jobs`.`addition_params` from `matchguru_medicaljobs`.`jobs` left join `matchguru_medicaljobs`.`cities` on `matchguru_medicaljobs`.`jobs`.`city` = `matchguru_medicaljobs`.`cities`.`id` left join `matchguru_medicaljobs`.`recruiters` on `matchguru_medicaljobs`.`jobs`.`recruiter_id` = `matchguru_medicaljobs`.`recruiters`.`id` left join `matchguru_medicaljobs`.`industries` on `matchguru_medicaljobs`.`jobs`.`job_industry` = `matchguru_medicaljobs`.`industries`.`id` where ( LOWER(cities.name) LIKE LOWER(\'%al4%\') OR LOWER(jobs.location_string) LIKE LOWER(\'%al4%\') ) AND (jobs.job_status = \'active\') limit 21 offset 0', array(), true) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2752) at Illuminate\Database\Query\Builder->runSelect() (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2740) at Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3294) at Illuminate\Database\Query\Builder->onceWithColumns(array('*'), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2741) at Illuminate\Database\Query\Builder->get(array('*')) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2799) at Illuminate\Database\Query\Builder->simplePaginate(20) (/home/matchguru/public_html/www/medicaljobs.org.uk/app/Http/Controllers/Front/JobsController.php:799) at App\Http\Controllers\Front\JobsController->jobs_seo('in-al4') (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54) at Illuminate\Routing\Controller->callAction('jobs_seo', array('slug' => 'in-al4')) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43) at Illuminate\Routing\ControllerDispatcher->dispatch(object(Route), object(JobsController), 'jobs_seo') (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Routing/Route.php:260) at Illuminate\Routing\Route->runController() (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Routing/Route.php:205) at Illuminate\Routing\Route->run() (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Routing/Router.php:799) at Illuminate\Routing\Router->Illuminate\Routing\{closure}(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:141) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50) at Illuminate\Routing\Middleware\SubstituteBindings->handle(object(Request), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:78) at Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(object(Request), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49) at Illuminate\View\Middleware\ShareErrorsFromSession->handle(object(Request), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:121) at Illuminate\Session\Middleware\StartSession->handleStatefulRequest(object(Request), object(Store), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:64) at Illuminate\Session\Middleware\StartSession->handle(object(Request), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37) at Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/app/Http/Middleware/EncryptCookies.php:30) at App\Http\Middleware\EncryptCookies->handle(object(Request), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:116) at Illuminate\Pipeline\Pipeline->then(object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Routing/Router.php:800) at Illuminate\Routing\Router->runRouteWithinStack(object(Route), object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Routing/Router.php:777) at Illuminate\Routing\Router->runRoute(object(Request), object(Route)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Routing/Router.php:741) at Illuminate\Routing\Router->dispatchToRoute(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Routing/Router.php:730) at Illuminate\Routing\Router->dispatch(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:200) at Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:141) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/barryvdh/laravel-debugbar/src/Middleware/InjectDebugbar.php:66) at Barryvdh\Debugbar\Middleware\InjectDebugbar->handle(object(Request), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21) at Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(object(Request), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php:31) at Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle(object(Request), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21) at Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(object(Request), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php:40) at Illuminate\Foundation\Http\Middleware\TrimStrings->handle(object(Request), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27) at Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(object(Request), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php:99) at Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle(object(Request), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:116) at Illuminate\Pipeline\Pipeline->then(object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:175) at Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:144) at Illuminate\Foundation\Http\Kernel->handle(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/public/index.php:54) |
[1/2]
PDOException
|
---|
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'jobs.job_id' in 'field list' at /home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Database/Connection.php:416 at PDO->prepare('select `jobs`.`id`, `cities`.`name`, `cities`.`total_jobs`, `cities`.`lat`, `cities`.`lon`, `jobs`.`slug`, `jobs`.`title`, `jobs`.`salary_schedule`, `jobs`.`description`, `jobs`.`salary_min`, `salary_max`, `recruiters`.`company_name`, `recruiters`.`company_logo`, `jobs`.`is_external`, `jobs`.`location_string`, `jobs`.`salary_string`, `jobs`.`company`, `jobs`.`job_website`, `jobs`.`category_string`, `jobs`.`job_industry`, `jobs`.`job_status`, `jobs`.`job_id`, `industries`.`name` as `industry_name`, `industries`.`industry_slug`, `jobs`.`addition_params` from `matchguru_medicaljobs`.`jobs` left join `matchguru_medicaljobs`.`cities` on `matchguru_medicaljobs`.`jobs`.`city` = `matchguru_medicaljobs`.`cities`.`id` left join `matchguru_medicaljobs`.`recruiters` on `matchguru_medicaljobs`.`jobs`.`recruiter_id` = `matchguru_medicaljobs`.`recruiters`.`id` left join `matchguru_medicaljobs`.`industries` on `matchguru_medicaljobs`.`jobs`.`job_industry` = `matchguru_medicaljobs`.`industries`.`id` where ( LOWER(cities.name) LIKE LOWER(\'%al4%\') OR LOWER(jobs.location_string) LIKE LOWER(\'%al4%\') ) AND (jobs.job_status = \'active\') limit 21 offset 0') (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Database/Connection.php:416) at Illuminate\Database\Connection->Illuminate\Database\{closure}('select `jobs`.`id`, `cities`.`name`, `cities`.`total_jobs`, `cities`.`lat`, `cities`.`lon`, `jobs`.`slug`, `jobs`.`title`, `jobs`.`salary_schedule`, `jobs`.`description`, `jobs`.`salary_min`, `salary_max`, `recruiters`.`company_name`, `recruiters`.`company_logo`, `jobs`.`is_external`, `jobs`.`location_string`, `jobs`.`salary_string`, `jobs`.`company`, `jobs`.`job_website`, `jobs`.`category_string`, `jobs`.`job_industry`, `jobs`.`job_status`, `jobs`.`job_id`, `industries`.`name` as `industry_name`, `industries`.`industry_slug`, `jobs`.`addition_params` from `matchguru_medicaljobs`.`jobs` left join `matchguru_medicaljobs`.`cities` on `matchguru_medicaljobs`.`jobs`.`city` = `matchguru_medicaljobs`.`cities`.`id` left join `matchguru_medicaljobs`.`recruiters` on `matchguru_medicaljobs`.`jobs`.`recruiter_id` = `matchguru_medicaljobs`.`recruiters`.`id` left join `matchguru_medicaljobs`.`industries` on `matchguru_medicaljobs`.`jobs`.`job_industry` = `matchguru_medicaljobs`.`industries`.`id` where ( LOWER(cities.name) LIKE LOWER(\'%al4%\') OR LOWER(jobs.location_string) LIKE LOWER(\'%al4%\') ) AND (jobs.job_status = \'active\') limit 21 offset 0', array()) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Database/Connection.php:788) at Illuminate\Database\Connection->runQueryCallback('select `jobs`.`id`, `cities`.`name`, `cities`.`total_jobs`, `cities`.`lat`, `cities`.`lon`, `jobs`.`slug`, `jobs`.`title`, `jobs`.`salary_schedule`, `jobs`.`description`, `jobs`.`salary_min`, `salary_max`, `recruiters`.`company_name`, `recruiters`.`company_logo`, `jobs`.`is_external`, `jobs`.`location_string`, `jobs`.`salary_string`, `jobs`.`company`, `jobs`.`job_website`, `jobs`.`category_string`, `jobs`.`job_industry`, `jobs`.`job_status`, `jobs`.`job_id`, `industries`.`name` as `industry_name`, `industries`.`industry_slug`, `jobs`.`addition_params` from `matchguru_medicaljobs`.`jobs` left join `matchguru_medicaljobs`.`cities` on `matchguru_medicaljobs`.`jobs`.`city` = `matchguru_medicaljobs`.`cities`.`id` left join `matchguru_medicaljobs`.`recruiters` on `matchguru_medicaljobs`.`jobs`.`recruiter_id` = `matchguru_medicaljobs`.`recruiters`.`id` left join `matchguru_medicaljobs`.`industries` on `matchguru_medicaljobs`.`jobs`.`job_industry` = `matchguru_medicaljobs`.`industries`.`id` where ( LOWER(cities.name) LIKE LOWER(\'%al4%\') OR LOWER(jobs.location_string) LIKE LOWER(\'%al4%\') ) AND (jobs.job_status = \'active\') limit 21 offset 0', array(), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Database/Connection.php:755) at Illuminate\Database\Connection->run('select `jobs`.`id`, `cities`.`name`, `cities`.`total_jobs`, `cities`.`lat`, `cities`.`lon`, `jobs`.`slug`, `jobs`.`title`, `jobs`.`salary_schedule`, `jobs`.`description`, `jobs`.`salary_min`, `salary_max`, `recruiters`.`company_name`, `recruiters`.`company_logo`, `jobs`.`is_external`, `jobs`.`location_string`, `jobs`.`salary_string`, `jobs`.`company`, `jobs`.`job_website`, `jobs`.`category_string`, `jobs`.`job_industry`, `jobs`.`job_status`, `jobs`.`job_id`, `industries`.`name` as `industry_name`, `industries`.`industry_slug`, `jobs`.`addition_params` from `matchguru_medicaljobs`.`jobs` left join `matchguru_medicaljobs`.`cities` on `matchguru_medicaljobs`.`jobs`.`city` = `matchguru_medicaljobs`.`cities`.`id` left join `matchguru_medicaljobs`.`recruiters` on `matchguru_medicaljobs`.`jobs`.`recruiter_id` = `matchguru_medicaljobs`.`recruiters`.`id` left join `matchguru_medicaljobs`.`industries` on `matchguru_medicaljobs`.`jobs`.`job_industry` = `matchguru_medicaljobs`.`industries`.`id` where ( LOWER(cities.name) LIKE LOWER(\'%al4%\') OR LOWER(jobs.location_string) LIKE LOWER(\'%al4%\') ) AND (jobs.job_status = \'active\') limit 21 offset 0', array(), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Database/Connection.php:424) at Illuminate\Database\Connection->select('select `jobs`.`id`, `cities`.`name`, `cities`.`total_jobs`, `cities`.`lat`, `cities`.`lon`, `jobs`.`slug`, `jobs`.`title`, `jobs`.`salary_schedule`, `jobs`.`description`, `jobs`.`salary_min`, `salary_max`, `recruiters`.`company_name`, `recruiters`.`company_logo`, `jobs`.`is_external`, `jobs`.`location_string`, `jobs`.`salary_string`, `jobs`.`company`, `jobs`.`job_website`, `jobs`.`category_string`, `jobs`.`job_industry`, `jobs`.`job_status`, `jobs`.`job_id`, `industries`.`name` as `industry_name`, `industries`.`industry_slug`, `jobs`.`addition_params` from `matchguru_medicaljobs`.`jobs` left join `matchguru_medicaljobs`.`cities` on `matchguru_medicaljobs`.`jobs`.`city` = `matchguru_medicaljobs`.`cities`.`id` left join `matchguru_medicaljobs`.`recruiters` on `matchguru_medicaljobs`.`jobs`.`recruiter_id` = `matchguru_medicaljobs`.`recruiters`.`id` left join `matchguru_medicaljobs`.`industries` on `matchguru_medicaljobs`.`jobs`.`job_industry` = `matchguru_medicaljobs`.`industries`.`id` where ( LOWER(cities.name) LIKE LOWER(\'%al4%\') OR LOWER(jobs.location_string) LIKE LOWER(\'%al4%\') ) AND (jobs.job_status = \'active\') limit 21 offset 0', array(), true) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2752) at Illuminate\Database\Query\Builder->runSelect() (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2740) at Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3294) at Illuminate\Database\Query\Builder->onceWithColumns(array('*'), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2741) at Illuminate\Database\Query\Builder->get(array('*')) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2799) at Illuminate\Database\Query\Builder->simplePaginate(20) (/home/matchguru/public_html/www/medicaljobs.org.uk/app/Http/Controllers/Front/JobsController.php:799) at App\Http\Controllers\Front\JobsController->jobs_seo('in-al4') (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54) at Illuminate\Routing\Controller->callAction('jobs_seo', array('slug' => 'in-al4')) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43) at Illuminate\Routing\ControllerDispatcher->dispatch(object(Route), object(JobsController), 'jobs_seo') (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Routing/Route.php:260) at Illuminate\Routing\Route->runController() (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Routing/Route.php:205) at Illuminate\Routing\Route->run() (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Routing/Router.php:799) at Illuminate\Routing\Router->Illuminate\Routing\{closure}(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:141) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50) at Illuminate\Routing\Middleware\SubstituteBindings->handle(object(Request), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:78) at Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(object(Request), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49) at Illuminate\View\Middleware\ShareErrorsFromSession->handle(object(Request), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:121) at Illuminate\Session\Middleware\StartSession->handleStatefulRequest(object(Request), object(Store), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:64) at Illuminate\Session\Middleware\StartSession->handle(object(Request), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37) at Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/app/Http/Middleware/EncryptCookies.php:30) at App\Http\Middleware\EncryptCookies->handle(object(Request), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:116) at Illuminate\Pipeline\Pipeline->then(object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Routing/Router.php:800) at Illuminate\Routing\Router->runRouteWithinStack(object(Route), object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Routing/Router.php:777) at Illuminate\Routing\Router->runRoute(object(Request), object(Route)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Routing/Router.php:741) at Illuminate\Routing\Router->dispatchToRoute(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Routing/Router.php:730) at Illuminate\Routing\Router->dispatch(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:200) at Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:141) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/barryvdh/laravel-debugbar/src/Middleware/InjectDebugbar.php:66) at Barryvdh\Debugbar\Middleware\InjectDebugbar->handle(object(Request), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21) at Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(object(Request), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php:31) at Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle(object(Request), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21) at Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(object(Request), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php:40) at Illuminate\Foundation\Http\Middleware\TrimStrings->handle(object(Request), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27) at Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(object(Request), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php:99) at Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle(object(Request), object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:116) at Illuminate\Pipeline\Pipeline->then(object(Closure)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:175) at Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:144) at Illuminate\Foundation\Http\Kernel->handle(object(Request)) (/home/matchguru/public_html/www/medicaljobs.org.uk/public/index.php:54) |