Illuminate\Database\QueryException {#169
#sql: "select count(*) as aggregate from `users` where exists (select * from `roles` inner join `user_role` on `roles`.`id` = `user_role`.`role_id` where `users`.`id` = `user_role`.`user_id` and `role_id` = ?) and `deleted_status` != ? and `test_user` != ? and (`status` = ? and `confirmed` = ?)"
#bindings: array:5 [
0 => 3
1 => 1
2 => 1
3 => 1
4 => 1
]
#message: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'test_user' in 'where clause' (SQL: select count(*) as aggregate from `users` where exists (select * from `roles` inner join `user_role` on `roles`.`id` = `user_role`.`role_id` where `users`.`id` = `user_role`.`user_id` and `role_id` = 3) and `deleted_status` != 1 and `test_user` != 1 and (`status` = 1 and `confirmed` = 1))"
#code: "42S22"
#file: "/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Database/Connection.php"
#line: 664
-previous: PDOException {#3416
#message: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'test_user' in 'where clause'"
#code: "42S22"
#file: "/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Database/Connection.php"
#line: 326
+errorInfo: array:3 [
0 => "42S22"
1 => 1054
2 => "Unknown column 'test_user' in 'where clause'"
]
trace: {
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Database/Connection.php:326 {
Illuminate\Database\Connection->Illuminate\Database\{closure} …
› $statement = $this->prepared($this->getPdoForSelect($useReadPdo)
› ->prepare($query));
›
arguments: {
$statement: "select count(*) as aggregate from `users` where exists (select * from `roles` inner join `user_role` on `roles`.`id` = `user_role`.`role_id` where `users`.`id` = `user_role`.`user_id` and `role_id` = ?) and `deleted_status` != ? and `test_user` != ? and (`status` = ? and `confirmed` = ?)"
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Database/Connection.php:657 {
Illuminate\Database\Connection->runQueryCallback($query, $bindings, Closure $callback) …
› try {
› $result = $callback($query, $bindings);
› }
arguments: {
"select count(*) as aggregate from `users` where exists (select * from `roles` inner join `user_role` on `roles`.`id` = `user_role`.`role_id` where `users`.`id` = `user_role`.`user_id` and `role_id` = ?) and `deleted_status` != ? and `test_user` != ? and (`status` = ? and `confirmed` = ?)"
array:5 [ …5]
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624 {
Illuminate\Database\Connection->run($query, $bindings, Closure $callback) …
› try {
› $result = $this->runQueryCallback($query, $bindings, $callback);
› } catch (QueryException $e) {
arguments: {
$query: "select count(*) as aggregate from `users` where exists (select * from `roles` inner join `user_role` on `roles`.`id` = `user_role`.`role_id` where `users`.`id` = `user_role`.`user_id` and `role_id` = ?) and `deleted_status` != ? and `test_user` != ? and (`status` = ? and `confirmed` = ?)"
$bindings: array:5 [ …5]
$callback: Closure($query, $bindings) {#3429 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Database/Connection.php:333 {
Illuminate\Database\Connection->select($query, $bindings = [], $useReadPdo = true) …
› return $statement->fetchAll();
› });
› }
arguments: {
$query: "select count(*) as aggregate from `users` where exists (select * from `roles` inner join `user_role` on `roles`.`id` = `user_role`.`role_id` where `users`.`id` = `user_role`.`user_id` and `role_id` = ?) and `deleted_status` != ? and `test_user` != ? and (`status` = ? and `confirmed` = ?)"
$bindings: array:5 [ …5]
$callback: Closure($query, $bindings) {#3429 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2095 {
Illuminate\Database\Query\Builder->runSelect() …
› return $this->connection->select(
› $this->toSql(), $this->getBindings(), ! $this->useWritePdo
› );
arguments: {
$query: "select count(*) as aggregate from `users` where exists (select * from `roles` inner join `user_role` on `roles`.`id` = `user_role`.`role_id` where `users`.`id` = `user_role`.`user_id` and `role_id` = ?) and `deleted_status` != ? and `test_user` != ? and (`status` = ? and `confirmed` = ?)"
$bindings: array:5 [ …5]
$useReadPdo: true
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2083 {
Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure} …
› return collect($this->onceWithColumns($columns, function () {
› return $this->processor->processSelect($this, $this->runSelect());
› }));
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2569 {
Illuminate\Database\Query\Builder->onceWithColumns($columns, $callback) …
›
› $result = $callback();
›
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2084 {
Illuminate\Database\Query\Builder->get($columns = […1]) …
› return $this->processor->processSelect($this, $this->runSelect());
› }));
› }
arguments: {
$columns: array:1 [ …1]
$callback: Closure() {#3412 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2182 {
Illuminate\Database\Query\Builder->runPaginationCountQuery($columns = […1]) …
› ->setAggregate('count', $this->withoutSelectAliases($columns))
› ->get()->all();
› }
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2153 {
Illuminate\Database\Query\Builder->getCountForPagination($columns = […1]) …
› {
› $results = $this->runPaginationCountQuery($columns);
›
arguments: {
$columns: array:1 [ …1]
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:748 {
Illuminate\Database\Eloquent\Builder->paginate($perPage = null, $columns = […1], $pageName = 'page', $page = null) …
›
› $results = ($total = $this->toBase()->getCountForPagination())
› ? $this->forPage($page, $perPage)->get($columns)
}
/home/examvote/public_html/asportcoach/app/Http/Controllers/Frontend/FrontendController.php:160 {
App\Http\Controllers\Frontend\FrontendController->fetchCoachList(Request $request) …
› ->orderBy('username','ASC')\r
› ->paginate(25);\r
› // echo "<pre>"; print_r($coaches->total()); exit;\r
arguments: {
$perPage: 25
}
}
App\Http\Controllers\Frontend\FrontendController->fetchCoachList() {}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 {
Illuminate\Routing\Controller->callAction($method, $parameters) …
› {
› return call_user_func_array([$this, $method], $parameters);
› }
arguments: {
$function_name: array:2 [ …2]
$parameters: array:1 [ …1]
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 {
Illuminate\Routing\ControllerDispatcher->dispatch(Route $route, $controller, $method) …
› if (method_exists($controller, 'callAction')) {
› return $controller->callAction($method, $parameters);
› }
arguments: {
$method: "fetchCoachList"
$parameters: array:1 [ …1]
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 {
Illuminate\Routing\Route->runController() …
› return $this->controllerDispatcher()->dispatch(
› $this, $this->getController(), $this->getControllerMethod()
› );
arguments: {
$route: Illuminate\Routing\Route {#2273 …}
$controller: App\Http\Controllers\Frontend\FrontendController {#2316 …}
$method: "fetchCoachList"
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 {
Illuminate\Routing\Route->run() …
› if ($this->isControllerAction()) {
› return $this->runController();
› }
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Router.php:682 {
Illuminate\Routing\Router->Illuminate\Routing\{closure} …
› return $this->prepareResponse(
› $request, $route->run()
› );
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 {
Illuminate\Routing\Pipeline->Illuminate\Routing\{closure} …
› try {
› return $destination($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:41 {
Illuminate\Routing\Middleware\SubstituteBindings->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $response = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#42 …}
$next: Closure($passable) {#1054 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 {
Illuminate\Routing\Pipeline->Illuminate\Routing\{closure} …
›
› return $callable($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 {
Illuminate\View\Middleware\ShareErrorsFromSession->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $response = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#42 …}
$next: Closure($passable) {#1054 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 {
Illuminate\Routing\Pipeline->Illuminate\Routing\{closure} …
›
› return $callable($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63 {
Illuminate\Session\Middleware\StartSession->handle($request, Closure $next) …
›
› $response = $next($request);
›
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $response = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#42 …}
$next: Closure($passable) {#1054 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 {
Illuminate\Routing\Pipeline->Illuminate\Routing\{closure} …
›
› return $callable($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 {
Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle($request, Closure $next) …
› {
› $response = $next($request);
›
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $response = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#42 …}
$next: Closure($passable) {#1054 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 {
Illuminate\Routing\Pipeline->Illuminate\Routing\{closure} …
›
› return $callable($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66 {
Illuminate\Cookie\Middleware\EncryptCookies->handle($request, Closure $next) …
› {
› return $this->encrypt($next($this->decrypt($request)));
› }
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $response = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#42 …}
$next: Closure($passable) {#1054 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 {
Illuminate\Routing\Pipeline->Illuminate\Routing\{closure} …
›
› return $callable($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:104 {
Illuminate\Pipeline\Pipeline->then(Closure $destination) …
›
› return $pipeline($this->passable);
› }
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Router.php:684 {
Illuminate\Routing\Router->runRouteWithinStack(Route $route, Request $request) …
› );
› });
› }
arguments: {
$destination: Closure($request) {#2311 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Router.php:659 {
Illuminate\Routing\Router->runRoute(Request $request, Route $route) …
› return $this->prepareResponse($request,
› $this->runRouteWithinStack($route, $request)
› );
arguments: {
$route: Illuminate\Routing\Route {#2273 …}
$request: Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Router.php:625 {
Illuminate\Routing\Router->dispatchToRoute(Request $request) …
› {
› return $this->runRoute($request, $this->findRoute($request));
› }
arguments: {
$request: Illuminate\Http\Request {#42 …}
$route: Illuminate\Routing\Route {#2273 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Router.php:614 {
Illuminate\Routing\Router->dispatch(Request $request) …
›
› return $this->dispatchToRoute($request);
› }
arguments: {
$request: Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:176 {
Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure} …
›
› return $this->router->dispatch($request);
› };
arguments: {
$request: Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 {
Illuminate\Routing\Pipeline->Illuminate\Routing\{closure} …
› try {
› return $destination($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/fideloper/proxy/src/TrustProxies.php:57 {
Fideloper\Proxy\TrustProxies->handle(Request $request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $response = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#42 …}
$next: Closure($passable) {#1054 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 {
Illuminate\Routing\Pipeline->Illuminate\Routing\{closure} …
›
› return $callable($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:31 {
Illuminate\Foundation\Http\Middleware\TransformsRequest->handle($request, Closure $next, ...$attributes) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $response = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#42 …}
$next: Closure($passable) {#1054 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 {
Illuminate\Routing\Pipeline->Illuminate\Routing\{closure} …
›
› return $callable($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:31 {
Illuminate\Foundation\Http\Middleware\TransformsRequest->handle($request, Closure $next, ...$attributes) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $response = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#42 …}
$next: Closure($passable) {#1054 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 {
Illuminate\Routing\Pipeline->Illuminate\Routing\{closure} …
›
› return $callable($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27 {
Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $response = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#42 …}
$next: Closure($passable) {#1054 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 {
Illuminate\Routing\Pipeline->Illuminate\Routing\{closure} …
›
› return $callable($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:62 {
Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $response = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#42 …}
$next: Closure($passable) {#1054 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 {
Illuminate\Routing\Pipeline->Illuminate\Routing\{closure} …
›
› return $callable($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:104 {
Illuminate\Pipeline\Pipeline->then(Closure $destination) …
›
› return $pipeline($this->passable);
› }
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:151 {
Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter($request) …
› ->through($this->app->shouldSkipMiddleware() ? [] : $this->middleware)
› ->then($this->dispatchToRouter());
› }
arguments: {
$destination: Closure($request) {#184 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:116 {
Illuminate\Foundation\Http\Kernel->handle($request) …
›
› $response = $this->sendRequestThroughRouter($request);
› } catch (Exception $e) {
arguments: {
$request: Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/public/index.php:55 {
require_once …
› $response = $kernel->handle(\r
› $request = Illuminate\Http\Request::capture()\r
› );\r
arguments: {
$request: Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/index.php:21 {
› \r
› require_once __DIR__.'/public/index.php';\r
›
arguments: {
"/home/examvote/public_html/asportcoach/public/index.php"
}
}
}
}
+errorInfo: array:3 [
0 => "42S22"
1 => 1054
2 => "Unknown column 'test_user' in 'where clause'"
]
trace: {
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664 {
Illuminate\Database\Connection->runQueryCallback($query, $bindings, Closure $callback) …
› catch (Exception $e) {
› throw new QueryException(
› $query, $this->prepareBindings($bindings), $e
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624 {
Illuminate\Database\Connection->run($query, $bindings, Closure $callback) …
› try {
› $result = $this->runQueryCallback($query, $bindings, $callback);
› } catch (QueryException $e) {
arguments: {
$query: "select count(*) as aggregate from `users` where exists (select * from `roles` inner join `user_role` on `roles`.`id` = `user_role`.`role_id` where `users`.`id` = `user_role`.`user_id` and `role_id` = ?) and `deleted_status` != ? and `test_user` != ? and (`status` = ? and `confirmed` = ?)"
$bindings: array:5 [ …5]
$callback: Closure($query, $bindings) {#3429 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Database/Connection.php:333 {
Illuminate\Database\Connection->select($query, $bindings = [], $useReadPdo = true) …
› return $statement->fetchAll();
› });
› }
arguments: {
$query: "select count(*) as aggregate from `users` where exists (select * from `roles` inner join `user_role` on `roles`.`id` = `user_role`.`role_id` where `users`.`id` = `user_role`.`user_id` and `role_id` = ?) and `deleted_status` != ? and `test_user` != ? and (`status` = ? and `confirmed` = ?)"
$bindings: array:5 [ …5]
$callback: Closure($query, $bindings) {#3429 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2095 {
Illuminate\Database\Query\Builder->runSelect() …
› return $this->connection->select(
› $this->toSql(), $this->getBindings(), ! $this->useWritePdo
› );
arguments: {
$query: "select count(*) as aggregate from `users` where exists (select * from `roles` inner join `user_role` on `roles`.`id` = `user_role`.`role_id` where `users`.`id` = `user_role`.`user_id` and `role_id` = ?) and `deleted_status` != ? and `test_user` != ? and (`status` = ? and `confirmed` = ?)"
$bindings: array:5 [ …5]
$useReadPdo: true
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2083 {
Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure} …
› return collect($this->onceWithColumns($columns, function () {
› return $this->processor->processSelect($this, $this->runSelect());
› }));
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2569 {
Illuminate\Database\Query\Builder->onceWithColumns($columns, $callback) …
›
› $result = $callback();
›
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2084 {
Illuminate\Database\Query\Builder->get($columns = […1]) …
› return $this->processor->processSelect($this, $this->runSelect());
› }));
› }
arguments: {
$columns: array:1 [ …1]
$callback: Closure() {#3412 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2182 {
Illuminate\Database\Query\Builder->runPaginationCountQuery($columns = […1]) …
› ->setAggregate('count', $this->withoutSelectAliases($columns))
› ->get()->all();
› }
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2153 {
Illuminate\Database\Query\Builder->getCountForPagination($columns = […1]) …
› {
› $results = $this->runPaginationCountQuery($columns);
›
arguments: {
$columns: array:1 [ …1]
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:748 {
Illuminate\Database\Eloquent\Builder->paginate($perPage = null, $columns = […1], $pageName = 'page', $page = null) …
›
› $results = ($total = $this->toBase()->getCountForPagination())
› ? $this->forPage($page, $perPage)->get($columns)
}
/home/examvote/public_html/asportcoach/app/Http/Controllers/Frontend/FrontendController.php:160 {
App\Http\Controllers\Frontend\FrontendController->fetchCoachList(Request $request) …
› ->orderBy('username','ASC')\r
› ->paginate(25);\r
› // echo "<pre>"; print_r($coaches->total()); exit;\r
arguments: {
$perPage: 25
}
}
App\Http\Controllers\Frontend\FrontendController->fetchCoachList() {}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 {
Illuminate\Routing\Controller->callAction($method, $parameters) …
› {
› return call_user_func_array([$this, $method], $parameters);
› }
arguments: {
$function_name: array:2 [ …2]
$parameters: array:1 [ …1]
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 {
Illuminate\Routing\ControllerDispatcher->dispatch(Route $route, $controller, $method) …
› if (method_exists($controller, 'callAction')) {
› return $controller->callAction($method, $parameters);
› }
arguments: {
$method: "fetchCoachList"
$parameters: array:1 [ …1]
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 {
Illuminate\Routing\Route->runController() …
› return $this->controllerDispatcher()->dispatch(
› $this, $this->getController(), $this->getControllerMethod()
› );
arguments: {
$route: Illuminate\Routing\Route {#2273 …}
$controller: App\Http\Controllers\Frontend\FrontendController {#2316 …}
$method: "fetchCoachList"
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 {
Illuminate\Routing\Route->run() …
› if ($this->isControllerAction()) {
› return $this->runController();
› }
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Router.php:682 {
Illuminate\Routing\Router->Illuminate\Routing\{closure} …
› return $this->prepareResponse(
› $request, $route->run()
› );
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 {
Illuminate\Routing\Pipeline->Illuminate\Routing\{closure} …
› try {
› return $destination($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:41 {
Illuminate\Routing\Middleware\SubstituteBindings->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $response = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#42 …}
$next: Closure($passable) {#1054 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 {
Illuminate\Routing\Pipeline->Illuminate\Routing\{closure} …
›
› return $callable($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 {
Illuminate\View\Middleware\ShareErrorsFromSession->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $response = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#42 …}
$next: Closure($passable) {#1054 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 {
Illuminate\Routing\Pipeline->Illuminate\Routing\{closure} …
›
› return $callable($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63 {
Illuminate\Session\Middleware\StartSession->handle($request, Closure $next) …
›
› $response = $next($request);
›
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $response = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#42 …}
$next: Closure($passable) {#1054 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 {
Illuminate\Routing\Pipeline->Illuminate\Routing\{closure} …
›
› return $callable($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 {
Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle($request, Closure $next) …
› {
› $response = $next($request);
›
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $response = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#42 …}
$next: Closure($passable) {#1054 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 {
Illuminate\Routing\Pipeline->Illuminate\Routing\{closure} …
›
› return $callable($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66 {
Illuminate\Cookie\Middleware\EncryptCookies->handle($request, Closure $next) …
› {
› return $this->encrypt($next($this->decrypt($request)));
› }
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $response = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#42 …}
$next: Closure($passable) {#1054 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 {
Illuminate\Routing\Pipeline->Illuminate\Routing\{closure} …
›
› return $callable($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:104 {
Illuminate\Pipeline\Pipeline->then(Closure $destination) …
›
› return $pipeline($this->passable);
› }
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Router.php:684 {
Illuminate\Routing\Router->runRouteWithinStack(Route $route, Request $request) …
› );
› });
› }
arguments: {
$destination: Closure($request) {#2311 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Router.php:659 {
Illuminate\Routing\Router->runRoute(Request $request, Route $route) …
› return $this->prepareResponse($request,
› $this->runRouteWithinStack($route, $request)
› );
arguments: {
$route: Illuminate\Routing\Route {#2273 …}
$request: Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Router.php:625 {
Illuminate\Routing\Router->dispatchToRoute(Request $request) …
› {
› return $this->runRoute($request, $this->findRoute($request));
› }
arguments: {
$request: Illuminate\Http\Request {#42 …}
$route: Illuminate\Routing\Route {#2273 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Router.php:614 {
Illuminate\Routing\Router->dispatch(Request $request) …
›
› return $this->dispatchToRoute($request);
› }
arguments: {
$request: Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:176 {
Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure} …
›
› return $this->router->dispatch($request);
› };
arguments: {
$request: Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 {
Illuminate\Routing\Pipeline->Illuminate\Routing\{closure} …
› try {
› return $destination($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/fideloper/proxy/src/TrustProxies.php:57 {
Fideloper\Proxy\TrustProxies->handle(Request $request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $response = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#42 …}
$next: Closure($passable) {#1054 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 {
Illuminate\Routing\Pipeline->Illuminate\Routing\{closure} …
›
› return $callable($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:31 {
Illuminate\Foundation\Http\Middleware\TransformsRequest->handle($request, Closure $next, ...$attributes) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $response = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#42 …}
$next: Closure($passable) {#1054 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 {
Illuminate\Routing\Pipeline->Illuminate\Routing\{closure} …
›
› return $callable($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:31 {
Illuminate\Foundation\Http\Middleware\TransformsRequest->handle($request, Closure $next, ...$attributes) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $response = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#42 …}
$next: Closure($passable) {#1054 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 {
Illuminate\Routing\Pipeline->Illuminate\Routing\{closure} …
›
› return $callable($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27 {
Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $response = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#42 …}
$next: Closure($passable) {#1054 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 {
Illuminate\Routing\Pipeline->Illuminate\Routing\{closure} …
›
› return $callable($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:62 {
Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $response = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#42 …}
$next: Closure($passable) {#1054 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 {
Illuminate\Routing\Pipeline->Illuminate\Routing\{closure} …
›
› return $callable($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:104 {
Illuminate\Pipeline\Pipeline->then(Closure $destination) …
›
› return $pipeline($this->passable);
› }
arguments: {
Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:151 {
Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter($request) …
› ->through($this->app->shouldSkipMiddleware() ? [] : $this->middleware)
› ->then($this->dispatchToRouter());
› }
arguments: {
$destination: Closure($request) {#184 …}
}
}
/home/examvote/public_html/asportcoach/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:116 {
Illuminate\Foundation\Http\Kernel->handle($request) …
›
› $response = $this->sendRequestThroughRouter($request);
› } catch (Exception $e) {
arguments: {
$request: Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/public/index.php:55 {
require_once …
› $response = $kernel->handle(\r
› $request = Illuminate\Http\Request::capture()\r
› );\r
arguments: {
$request: Illuminate\Http\Request {#42 …}
}
}
/home/examvote/public_html/asportcoach/index.php:21 {
› \r
› require_once __DIR__.'/public/index.php';\r
›
arguments: {
"/home/examvote/public_html/asportcoach/public/index.php"
}
}
}
}