QueryException {#868
#sql: "select count(*) as aggregate from `payment` where `payment_status` = ? and DATE(created_at) = '2026-04-25' and `payment`.`deleted_at` is null"
#bindings: array:1 [
0 => "paid"
]
#message: "SQLSTATE[42S02]: Base table or view not found: 1146 Table 'testing_laravel8_pasigbsa.payment' doesn't exist (SQL: select count(*) as aggregate from `payment` where `payment_status` = paid and DATE(created_at) = '2026-04-25' and `payment`.`deleted_at` is null)"
#code: "42S02"
#file: "/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Database/Connection.php"
#line: 647
-previous: Exception {#168
-errorCode: 1146
-sqlState: "42S02"
#message: "SQLSTATE[42S02]: Base table or view not found: 1146 Table 'testing_laravel8_pasigbsa.payment' doesn't exist"
#code: "42S02"
#file: "/testing/php/pasig-san-antonio/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php"
#line: 18
-previous: PDOException {#865
#message: "SQLSTATE[42S02]: Base table or view not found: 1146 Table 'testing_laravel8_pasigbsa.payment' doesn't exist"
#code: "42S02"
#file: "/testing/php/pasig-san-antonio/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php"
#line: 82
+errorInfo: array:3 [
0 => "42S02"
1 => 1146
2 => "Table 'testing_laravel8_pasigbsa.payment' doesn't exist"
]
trace: {
/testing/php/pasig-san-antonio/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:82 {
› try {
› $statement = parent::prepare($sql, $driverOptions);
› assert($statement instanceof PDOStatement);
arguments: {
$statement: "select count(*) as aggregate from `payment` where `payment_status` = ? and DATE(created_at) = '2026-04-25' and `payment`.`deleted_at` is null"
$options: []
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Database/Connection.php:319 {
› $statement = $this->prepared($this->getPdoForSelect($useReadPdo)
› ->prepare($query));
›
arguments: {
$sql: "select count(*) as aggregate from `payment` where `payment_status` = ? and DATE(created_at) = '2026-04-25' and `payment`.`deleted_at` is null"
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Database/Connection.php:640 {
› try {
› $result = $callback($query, $bindings);
› }
arguments: {
"select count(*) as aggregate from `payment` where `payment_status` = ? and DATE(created_at) = '2026-04-25' and `payment`.`deleted_at` is null"
array:1 [ …1]
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Database/Connection.php:607 {
› try {
› $result = $this->runQueryCallback($query, $bindings, $callback);
› } catch (QueryException $e) {
arguments: {
$query: "select count(*) as aggregate from `payment` where `payment_status` = ? and DATE(created_at) = '2026-04-25' and `payment`.`deleted_at` is null"
$bindings: array:1 [ …1]
$callback: Closure {#870 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Database/Connection.php:326 {
› return $statement->fetchAll();
› });
› }
arguments: {
$query: "select count(*) as aggregate from `payment` where `payment_status` = ? and DATE(created_at) = '2026-04-25' and `payment`.`deleted_at` is null"
$bindings: array:1 [ …1]
$callback: Closure {#870 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:1705 {
› return $this->connection->select(
› $this->toSql(), $this->getBindings(), ! $this->useWritePdo
› );
arguments: {
$query: "select count(*) as aggregate from `payment` where `payment_status` = ? and DATE(created_at) = '2026-04-25' and `payment`.`deleted_at` is null"
$bindings: array:1 [ …1]
$useReadPdo: true
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:1690 {
›
› $results = $this->processor->processSelect($this, $this->runSelect());
›
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2025 {
› ->setAggregate($function, $columns)
› ->get($columns);
›
arguments: {
$columns: array:1 [ …1]
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:1953 {
› {
› return (int) $this->aggregate(__FUNCTION__, array_wrap($columns));
› }
arguments: {
$function: "count"
$columns: array:1 [ …1]
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:1251 {
› if (in_array($method, $this->passthru)) {
› return $this->toBase()->{$method}(...$parameters);
› }
}
/testing/php/pasig-san-antonio/app/Laravel/Controllers/System/Controller.php:49 {
› 'payment' => [
› \t'completed' => Payment::where('payment_status','paid')->whereRaw("DATE(created_at) = '{$this->data['date_today']}'")->count(),
› \t'pending' => Payment::where('payment_status','pending')->count()
arguments: {
$method: "count"
$parameters: []
}
}
/testing/php/pasig-san-antonio/app/Laravel/Controllers/System/Controller.php:29 {
› self::set_current_route();
› self::set_badges();
› self::set_expiring();
}
/testing/php/pasig-san-antonio/app/Laravel/Controllers/System/DashboardController.php:37 {
› $this->data = [];
› parent::__construct();
› array_merge($this->data, parent::get_data());
}
App\Laravel\Controllers\System\DashboardController->__construct() {}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Container/Container.php:762 {
›
› return $reflector->newInstanceArgs($instances);
› }
arguments: {
$args: []
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Container/Container.php:608 {
› if ($this->isBuildable($concrete, $abstract)) {
› $object = $this->build($concrete);
› } else {
arguments: {
$concrete: "App\Laravel\Controllers\System\DashboardController"
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Container/Container.php:575 {
› {
› return $this->resolve($abstract);
› }
arguments: {
$abstract: "App\Laravel\Controllers\System\DashboardController"
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Foundation/Application.php:728 {
›
› return parent::make($abstract);
› }
arguments: {
$abstract: "App\Laravel\Controllers\System\DashboardController"
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Route.php:217 {
› if (! $this->controller) {
› $this->controller = $this->container->make($class);
› }
arguments: {
$abstract: "App\Laravel\Controllers\System\DashboardController"
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Route.php:747 {
› return ControllerDispatcher::getMiddleware(
› $this->getController(), $this->getControllerMethod()
› );
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Route.php:708 {
› return $this->computedMiddleware = array_unique(array_merge(
› $this->middleware(), $this->controllerMiddleware()
› ), SORT_REGULAR);
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Router.php:585 {
› {
› $middleware = collect($route->gatherMiddleware())->map(function ($name) {
› return (array) MiddlewareNameResolver::resolve($name, $this->middleware, $this->middlewareGroups);
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Router.php:565 {
›
› $middleware = $shouldSkipMiddleware ? [] : $this->gatherRouteMiddleware($route);
›
arguments: {
$route: Route {#225 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Router.php:533 {
›
› $response = $this->runRouteWithinStack($route, $request);
›
arguments: {
$route: Route {#225 …}
$request: Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Router.php:511 {
›
› return $this->dispatchToRoute($request);
› }
arguments: {
$request: Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:176 {
›
› return $this->router->dispatch($request);
› };
arguments: {
$request: Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 {
› try {
› return $destination($passable);
› } catch (Exception $e) {
arguments: {
Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:30 {
›
› return $next($request);
› }
arguments: {
Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:148 {
›
› return $pipe->{$this->method}(...$parameters);
› };
arguments: {
$request: Request {#38 …}
$next: Closure {#818 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 {
›
› return $callable($passable);
› } catch (Exception $e) {
arguments: {
Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:30 {
›
› return $next($request);
› }
arguments: {
Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:148 {
›
› return $pipe->{$this->method}(...$parameters);
› };
arguments: {
$request: Request {#38 …}
$next: Closure {#818 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 {
›
› return $callable($passable);
› } catch (Exception $e) {
arguments: {
Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27 {
›
› return $next($request);
› }
arguments: {
Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:148 {
›
› return $pipe->{$this->method}(...$parameters);
› };
arguments: {
$request: Request {#38 …}
$next: Closure {#818 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 {
›
› return $callable($passable);
› } catch (Exception $e) {
arguments: {
Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:46 {
›
› return $next($request);
› }
arguments: {
Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:148 {
›
› return $pipe->{$this->method}(...$parameters);
› };
arguments: {
$request: Request {#38 …}
$next: Closure {#818 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 {
›
› return $callable($passable);
› } catch (Exception $e) {
arguments: {
Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:102 {
›
› return $pipeline($this->passable);
› }
arguments: {
Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:151 {
› ->through($this->app->shouldSkipMiddleware() ? [] : $this->middleware)
› ->then($this->dispatchToRouter());
› }
arguments: {
$destination: Closure {#37 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:116 {
›
› $response = $this->sendRequestThroughRouter($request);
› } catch (Exception $e) {
arguments: {
$request: Request {#38 …}
}
}
/testing/php/pasig-san-antonio/public/index.php:52 {
› $response = $kernel->handle(
› $request = Illuminate\Http\Request::capture()
› );
arguments: {
$request: Request {#38 …}
}
}
}
}
+errorInfo: array:3 [
0 => "42S02"
1 => 1146
2 => "Table 'testing_laravel8_pasigbsa.payment' doesn't exist"
]
trace: {
/testing/php/pasig-san-antonio/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18 {
› {
› return new self($exception);
› }
}
/testing/php/pasig-san-antonio/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:87 {
› } catch (PDOException $exception) {
› throw Exception::new($exception);
› }
arguments: {
$exception: PDOException {#865}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Database/Connection.php:319 {
› $statement = $this->prepared($this->getPdoForSelect($useReadPdo)
› ->prepare($query));
›
arguments: {
$sql: "select count(*) as aggregate from `payment` where `payment_status` = ? and DATE(created_at) = '2026-04-25' and `payment`.`deleted_at` is null"
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Database/Connection.php:640 {
› try {
› $result = $callback($query, $bindings);
› }
arguments: {
"select count(*) as aggregate from `payment` where `payment_status` = ? and DATE(created_at) = '2026-04-25' and `payment`.`deleted_at` is null"
array:1 [ …1]
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Database/Connection.php:607 {
› try {
› $result = $this->runQueryCallback($query, $bindings, $callback);
› } catch (QueryException $e) {
arguments: {
$query: "select count(*) as aggregate from `payment` where `payment_status` = ? and DATE(created_at) = '2026-04-25' and `payment`.`deleted_at` is null"
$bindings: array:1 [ …1]
$callback: Closure {#870 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Database/Connection.php:326 {
› return $statement->fetchAll();
› });
› }
arguments: {
$query: "select count(*) as aggregate from `payment` where `payment_status` = ? and DATE(created_at) = '2026-04-25' and `payment`.`deleted_at` is null"
$bindings: array:1 [ …1]
$callback: Closure {#870 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:1705 {
› return $this->connection->select(
› $this->toSql(), $this->getBindings(), ! $this->useWritePdo
› );
arguments: {
$query: "select count(*) as aggregate from `payment` where `payment_status` = ? and DATE(created_at) = '2026-04-25' and `payment`.`deleted_at` is null"
$bindings: array:1 [ …1]
$useReadPdo: true
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:1690 {
›
› $results = $this->processor->processSelect($this, $this->runSelect());
›
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2025 {
› ->setAggregate($function, $columns)
› ->get($columns);
›
arguments: {
$columns: array:1 [ …1]
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:1953 {
› {
› return (int) $this->aggregate(__FUNCTION__, array_wrap($columns));
› }
arguments: {
$function: "count"
$columns: array:1 [ …1]
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:1251 {
› if (in_array($method, $this->passthru)) {
› return $this->toBase()->{$method}(...$parameters);
› }
}
/testing/php/pasig-san-antonio/app/Laravel/Controllers/System/Controller.php:49 {
› 'payment' => [
› \t'completed' => Payment::where('payment_status','paid')->whereRaw("DATE(created_at) = '{$this->data['date_today']}'")->count(),
› \t'pending' => Payment::where('payment_status','pending')->count()
arguments: {
$method: "count"
$parameters: []
}
}
/testing/php/pasig-san-antonio/app/Laravel/Controllers/System/Controller.php:29 {
› self::set_current_route();
› self::set_badges();
› self::set_expiring();
}
/testing/php/pasig-san-antonio/app/Laravel/Controllers/System/DashboardController.php:37 {
› $this->data = [];
› parent::__construct();
› array_merge($this->data, parent::get_data());
}
App\Laravel\Controllers\System\DashboardController->__construct() {}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Container/Container.php:762 {
›
› return $reflector->newInstanceArgs($instances);
› }
arguments: {
$args: []
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Container/Container.php:608 {
› if ($this->isBuildable($concrete, $abstract)) {
› $object = $this->build($concrete);
› } else {
arguments: {
$concrete: "App\Laravel\Controllers\System\DashboardController"
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Container/Container.php:575 {
› {
› return $this->resolve($abstract);
› }
arguments: {
$abstract: "App\Laravel\Controllers\System\DashboardController"
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Foundation/Application.php:728 {
›
› return parent::make($abstract);
› }
arguments: {
$abstract: "App\Laravel\Controllers\System\DashboardController"
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Route.php:217 {
› if (! $this->controller) {
› $this->controller = $this->container->make($class);
› }
arguments: {
$abstract: "App\Laravel\Controllers\System\DashboardController"
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Route.php:747 {
› return ControllerDispatcher::getMiddleware(
› $this->getController(), $this->getControllerMethod()
› );
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Route.php:708 {
› return $this->computedMiddleware = array_unique(array_merge(
› $this->middleware(), $this->controllerMiddleware()
› ), SORT_REGULAR);
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Router.php:585 {
› {
› $middleware = collect($route->gatherMiddleware())->map(function ($name) {
› return (array) MiddlewareNameResolver::resolve($name, $this->middleware, $this->middlewareGroups);
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Router.php:565 {
›
› $middleware = $shouldSkipMiddleware ? [] : $this->gatherRouteMiddleware($route);
›
arguments: {
$route: Route {#225 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Router.php:533 {
›
› $response = $this->runRouteWithinStack($route, $request);
›
arguments: {
$route: Route {#225 …}
$request: Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Router.php:511 {
›
› return $this->dispatchToRoute($request);
› }
arguments: {
$request: Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:176 {
›
› return $this->router->dispatch($request);
› };
arguments: {
$request: Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 {
› try {
› return $destination($passable);
› } catch (Exception $e) {
arguments: {
Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:30 {
›
› return $next($request);
› }
arguments: {
Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:148 {
›
› return $pipe->{$this->method}(...$parameters);
› };
arguments: {
$request: Request {#38 …}
$next: Closure {#818 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 {
›
› return $callable($passable);
› } catch (Exception $e) {
arguments: {
Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:30 {
›
› return $next($request);
› }
arguments: {
Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:148 {
›
› return $pipe->{$this->method}(...$parameters);
› };
arguments: {
$request: Request {#38 …}
$next: Closure {#818 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 {
›
› return $callable($passable);
› } catch (Exception $e) {
arguments: {
Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27 {
›
› return $next($request);
› }
arguments: {
Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:148 {
›
› return $pipe->{$this->method}(...$parameters);
› };
arguments: {
$request: Request {#38 …}
$next: Closure {#818 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 {
›
› return $callable($passable);
› } catch (Exception $e) {
arguments: {
Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:46 {
›
› return $next($request);
› }
arguments: {
Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:148 {
›
› return $pipe->{$this->method}(...$parameters);
› };
arguments: {
$request: Request {#38 …}
$next: Closure {#818 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 {
›
› return $callable($passable);
› } catch (Exception $e) {
arguments: {
Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:102 {
›
› return $pipeline($this->passable);
› }
arguments: {
Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:151 {
› ->through($this->app->shouldSkipMiddleware() ? [] : $this->middleware)
› ->then($this->dispatchToRouter());
› }
arguments: {
$destination: Closure {#37 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:116 {
›
› $response = $this->sendRequestThroughRouter($request);
› } catch (Exception $e) {
arguments: {
$request: Request {#38 …}
}
}
/testing/php/pasig-san-antonio/public/index.php:52 {
› $response = $kernel->handle(
› $request = Illuminate\Http\Request::capture()
› );
arguments: {
$request: Request {#38 …}
}
}
}
}
+errorInfo: array:3 [
0 => "42S02"
1 => 1146
2 => "Table 'testing_laravel8_pasigbsa.payment' doesn't exist"
]
trace: {
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Database/Connection.php:647 {
› catch (Exception $e) {
› throw new QueryException(
› $query, $this->prepareBindings($bindings), $e
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Database/Connection.php:607 {
› try {
› $result = $this->runQueryCallback($query, $bindings, $callback);
› } catch (QueryException $e) {
arguments: {
$query: "select count(*) as aggregate from `payment` where `payment_status` = ? and DATE(created_at) = '2026-04-25' and `payment`.`deleted_at` is null"
$bindings: array:1 [ …1]
$callback: Closure {#870 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Database/Connection.php:326 {
› return $statement->fetchAll();
› });
› }
arguments: {
$query: "select count(*) as aggregate from `payment` where `payment_status` = ? and DATE(created_at) = '2026-04-25' and `payment`.`deleted_at` is null"
$bindings: array:1 [ …1]
$callback: Closure {#870 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:1705 {
› return $this->connection->select(
› $this->toSql(), $this->getBindings(), ! $this->useWritePdo
› );
arguments: {
$query: "select count(*) as aggregate from `payment` where `payment_status` = ? and DATE(created_at) = '2026-04-25' and `payment`.`deleted_at` is null"
$bindings: array:1 [ …1]
$useReadPdo: true
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:1690 {
›
› $results = $this->processor->processSelect($this, $this->runSelect());
›
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2025 {
› ->setAggregate($function, $columns)
› ->get($columns);
›
arguments: {
$columns: array:1 [ …1]
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:1953 {
› {
› return (int) $this->aggregate(__FUNCTION__, array_wrap($columns));
› }
arguments: {
$function: "count"
$columns: array:1 [ …1]
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:1251 {
› if (in_array($method, $this->passthru)) {
› return $this->toBase()->{$method}(...$parameters);
› }
}
/testing/php/pasig-san-antonio/app/Laravel/Controllers/System/Controller.php:49 {
› 'payment' => [
› \t'completed' => Payment::where('payment_status','paid')->whereRaw("DATE(created_at) = '{$this->data['date_today']}'")->count(),
› \t'pending' => Payment::where('payment_status','pending')->count()
arguments: {
$method: "count"
$parameters: []
}
}
/testing/php/pasig-san-antonio/app/Laravel/Controllers/System/Controller.php:29 {
› self::set_current_route();
› self::set_badges();
› self::set_expiring();
}
/testing/php/pasig-san-antonio/app/Laravel/Controllers/System/DashboardController.php:37 {
› $this->data = [];
› parent::__construct();
› array_merge($this->data, parent::get_data());
}
App\Laravel\Controllers\System\DashboardController->__construct() {}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Container/Container.php:762 {
›
› return $reflector->newInstanceArgs($instances);
› }
arguments: {
$args: []
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Container/Container.php:608 {
› if ($this->isBuildable($concrete, $abstract)) {
› $object = $this->build($concrete);
› } else {
arguments: {
$concrete: "App\Laravel\Controllers\System\DashboardController"
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Container/Container.php:575 {
› {
› return $this->resolve($abstract);
› }
arguments: {
$abstract: "App\Laravel\Controllers\System\DashboardController"
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Foundation/Application.php:728 {
›
› return parent::make($abstract);
› }
arguments: {
$abstract: "App\Laravel\Controllers\System\DashboardController"
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Route.php:217 {
› if (! $this->controller) {
› $this->controller = $this->container->make($class);
› }
arguments: {
$abstract: "App\Laravel\Controllers\System\DashboardController"
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Route.php:747 {
› return ControllerDispatcher::getMiddleware(
› $this->getController(), $this->getControllerMethod()
› );
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Route.php:708 {
› return $this->computedMiddleware = array_unique(array_merge(
› $this->middleware(), $this->controllerMiddleware()
› ), SORT_REGULAR);
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Router.php:585 {
› {
› $middleware = collect($route->gatherMiddleware())->map(function ($name) {
› return (array) MiddlewareNameResolver::resolve($name, $this->middleware, $this->middlewareGroups);
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Router.php:565 {
›
› $middleware = $shouldSkipMiddleware ? [] : $this->gatherRouteMiddleware($route);
›
arguments: {
$route: Route {#225 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Router.php:533 {
›
› $response = $this->runRouteWithinStack($route, $request);
›
arguments: {
$route: Route {#225 …}
$request: Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Router.php:511 {
›
› return $this->dispatchToRoute($request);
› }
arguments: {
$request: Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:176 {
›
› return $this->router->dispatch($request);
› };
arguments: {
$request: Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 {
› try {
› return $destination($passable);
› } catch (Exception $e) {
arguments: {
Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:30 {
›
› return $next($request);
› }
arguments: {
Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:148 {
›
› return $pipe->{$this->method}(...$parameters);
› };
arguments: {
$request: Request {#38 …}
$next: Closure {#818 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 {
›
› return $callable($passable);
› } catch (Exception $e) {
arguments: {
Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:30 {
›
› return $next($request);
› }
arguments: {
Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:148 {
›
› return $pipe->{$this->method}(...$parameters);
› };
arguments: {
$request: Request {#38 …}
$next: Closure {#818 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 {
›
› return $callable($passable);
› } catch (Exception $e) {
arguments: {
Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27 {
›
› return $next($request);
› }
arguments: {
Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:148 {
›
› return $pipe->{$this->method}(...$parameters);
› };
arguments: {
$request: Request {#38 …}
$next: Closure {#818 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 {
›
› return $callable($passable);
› } catch (Exception $e) {
arguments: {
Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:46 {
›
› return $next($request);
› }
arguments: {
Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:148 {
›
› return $pipe->{$this->method}(...$parameters);
› };
arguments: {
$request: Request {#38 …}
$next: Closure {#818 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 {
›
› return $callable($passable);
› } catch (Exception $e) {
arguments: {
Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:102 {
›
› return $pipeline($this->passable);
› }
arguments: {
Request {#38 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:151 {
› ->through($this->app->shouldSkipMiddleware() ? [] : $this->middleware)
› ->then($this->dispatchToRouter());
› }
arguments: {
$destination: Closure {#37 …}
}
}
/testing/php/pasig-san-antonio/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:116 {
›
› $response = $this->sendRequestThroughRouter($request);
› } catch (Exception $e) {
arguments: {
$request: Request {#38 …}
}
}
/testing/php/pasig-san-antonio/public/index.php:52 {
› $response = $kernel->handle(
› $request = Illuminate\Http\Request::capture()
› );
arguments: {
$request: Request {#38 …}
}
}
}
}