Illuminate\Database\QueryException {#1033
#sql: "select tw_technology_cate.*, 3E7trbLrdk.real_route AS banner_img_url, 3E7trbLrdk.alt AS banner_img_alt, QtSF2CaGQA.real_route AS banner_img_m_url, QtSF2CaGQA.alt AS banner_img_m_alt from `tw_technology_cate` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `3E7trbLrdk` on `tw_technology_cate`.`banner_img` = `3E7trbLrdk`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `QtSF2CaGQA` on `tw_technology_cate`.`banner_img_m` = `QtSF2CaGQA`.`file_key` where `branch_id` = ? and `is_visible` = ? and `url_title` = ? and exists (select * from `tw_technology_subcate` where `tw_technology_cate`.`id` = `tw_technology_subcate`.`f_id` and `branch_id` = ? and `is_visible` = ? and `branch_id` = ? and `is_visible` = ?) limit 1"
#bindings: array:7 [
0 => 1
1 => 1
2 => "自動化"
3 => 1
4 => 1
5 => 1
6 => 1
]
#message: "SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.real_route AS banner_img_url, 3E7trbLrdk.alt AS banner_img_alt, QtSF2CaGQA.real' at line 1 (SQL: select tw_technology_cate.*, 3E7trbLrdk.real_route AS banner_img_url, 3E7trbLrdk.alt AS banner_img_alt, QtSF2CaGQA.real_route AS banner_img_m_url, QtSF2CaGQA.alt AS banner_img_m_alt from `tw_technology_cate` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `3E7trbLrdk` on `tw_technology_cate`.`banner_img` = `3E7trbLrdk`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `QtSF2CaGQA` on `tw_technology_cate`.`banner_img_m` = `QtSF2CaGQA`.`file_key` where `branch_id` = 1 and `is_visible` = 1 and `url_title` = 自動化 and exists (select * from `tw_technology_subcate` where `tw_technology_cate`.`id` = `tw_technology_subcate`.`f_id` and `branch_id` = 1 and `is_visible` = 1 and `branch_id` = 1 and `is_visible` = 1) limit 1)"
#code: "42000"
#file: "/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php"
#line: 665
-previous: PDOException {#1034
#message: "SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.real_route AS banner_img_url, 3E7trbLrdk.alt AS banner_img_alt, QtSF2CaGQA.real' at line 1"
#code: "42000"
#file: "/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php"
#line: 327
+errorInfo: array:3 [
0 => "42000"
1 => 1064
2 => "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.real_route AS banner_img_url, 3E7trbLrdk.alt AS banner_img_alt, QtSF2CaGQA.real' at line 1"
]
trace: {
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:327 {
Illuminate\Database\Connection->Illuminate\Database\{closure} …
› $statement = $this->prepared($this->getPdoForSelect($useReadPdo)
› ->prepare($query));
›
arguments: {
$statement: "select tw_technology_cate.*, 3E7trbLrdk.real_route AS banner_img_url, 3E7trbLrdk.alt AS banner_img_alt, QtSF2CaGQA.real_route AS banner_img_m_url, QtSF2CaGQA.alt AS banner_img_m_alt from `tw_technology_cate` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `3E7trbLrdk` on `tw_technology_cate`.`banner_img` = `3E7trbLrdk`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `QtSF2CaGQA` on `tw_technology_cate`.`banner_img_m` = `QtSF2CaGQA`.`file_key` where `branch_id` = ? and `is_visible` = ? and `url_title` = ? and exists (select * from `tw_technology_subcate` where `tw_technology_cate`.`id` = `tw_technology_subcate`.`f_id` and `branch_id` = ? and `is_visible` = ? and `branch_id` = ? and `is_visible` = ?) limit 1"
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:658 {
Illuminate\Database\Connection->runQueryCallback($query, $bindings, Closure $callback) …
› try {
› $result = $callback($query, $bindings);
› }
arguments: {
"select tw_technology_cate.*, 3E7trbLrdk.real_route AS banner_img_url, 3E7trbLrdk.alt AS banner_img_alt, QtSF2CaGQA.real_route AS banner_img_m_url, QtSF2CaGQA.alt AS banner_img_m_alt from `tw_technology_cate` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `3E7trbLrdk` on `tw_technology_cate`.`banner_img` = `3E7trbLrdk`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `QtSF2CaGQA` on `tw_technology_cate`.`banner_img_m` = `QtSF2CaGQA`.`file_key` where `branch_id` = ? and `is_visible` = ? and `url_title` = ? and exists (select * from `tw_technology_subcate` where `tw_technology_cate`.`id` = `tw_technology_subcate`.`f_id` and `branch_id` = ? and `is_visible` = ? and `branch_id` = ? and `is_visible` = ?) limit 1"
array:7 [ …7]
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:625 {
Illuminate\Database\Connection->run($query, $bindings, Closure $callback) …
› try {
› $result = $this->runQueryCallback($query, $bindings, $callback);
› } catch (QueryException $e) {
arguments: {
$query: "select tw_technology_cate.*, 3E7trbLrdk.real_route AS banner_img_url, 3E7trbLrdk.alt AS banner_img_alt, QtSF2CaGQA.real_route AS banner_img_m_url, QtSF2CaGQA.alt AS banner_img_m_alt from `tw_technology_cate` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `3E7trbLrdk` on `tw_technology_cate`.`banner_img` = `3E7trbLrdk`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `QtSF2CaGQA` on `tw_technology_cate`.`banner_img_m` = `QtSF2CaGQA`.`file_key` where `branch_id` = ? and `is_visible` = ? and `url_title` = ? and exists (select * from `tw_technology_subcate` where `tw_technology_cate`.`id` = `tw_technology_subcate`.`f_id` and `branch_id` = ? and `is_visible` = ? and `branch_id` = ? and `is_visible` = ?) limit 1"
$bindings: array:7 [ …7]
$callback: Closure($query, $bindings) {#1023 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:334 {
Illuminate\Database\Connection->select($query, $bindings = [], $useReadPdo = true) …
› return $statement->fetchAll();
› });
› }
arguments: {
$query: "select tw_technology_cate.*, 3E7trbLrdk.real_route AS banner_img_url, 3E7trbLrdk.alt AS banner_img_alt, QtSF2CaGQA.real_route AS banner_img_m_url, QtSF2CaGQA.alt AS banner_img_m_alt from `tw_technology_cate` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `3E7trbLrdk` on `tw_technology_cate`.`banner_img` = `3E7trbLrdk`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `QtSF2CaGQA` on `tw_technology_cate`.`banner_img_m` = `QtSF2CaGQA`.`file_key` where `branch_id` = ? and `is_visible` = ? and `url_title` = ? and exists (select * from `tw_technology_subcate` where `tw_technology_cate`.`id` = `tw_technology_subcate`.`f_id` and `branch_id` = ? and `is_visible` = ? and `branch_id` = ? and `is_visible` = ?) limit 1"
$bindings: array:7 [ …7]
$callback: Closure($query, $bindings) {#1023 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2140 {
Illuminate\Database\Query\Builder->runSelect() …
› return $this->connection->select(
› $this->toSql(), $this->getBindings(), ! $this->useWritePdo
› );
arguments: {
$query: "select tw_technology_cate.*, 3E7trbLrdk.real_route AS banner_img_url, 3E7trbLrdk.alt AS banner_img_alt, QtSF2CaGQA.real_route AS banner_img_m_url, QtSF2CaGQA.alt AS banner_img_m_alt from `tw_technology_cate` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `3E7trbLrdk` on `tw_technology_cate`.`banner_img` = `3E7trbLrdk`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `QtSF2CaGQA` on `tw_technology_cate`.`banner_img_m` = `QtSF2CaGQA`.`file_key` where `branch_id` = ? and `is_visible` = ? and `url_title` = ? and exists (select * from `tw_technology_subcate` where `tw_technology_cate`.`id` = `tw_technology_subcate`.`f_id` and `branch_id` = ? and `is_visible` = ? and `branch_id` = ? and `is_visible` = ?) limit 1"
$bindings: array:7 [ …7]
$useReadPdo: true
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2128 {
Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure} …
› return collect($this->onceWithColumns(Arr::wrap($columns), function () {
› return $this->processor->processSelect($this, $this->runSelect());
› }));
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2572 {
Illuminate\Database\Query\Builder->onceWithColumns($columns, $callback) …
›
› $result = $callback();
›
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2129 {
Illuminate\Database\Query\Builder->get($columns = […1]) …
› return $this->processor->processSelect($this, $this->runSelect());
› }));
› }
arguments: {
$columns: array:1 [ …1]
$callback: Closure() {#1029 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:521 {
Illuminate\Database\Eloquent\Builder->getModels($columns = […1]) …
› return $this->model->hydrate(
› $this->query->get($columns)->all()
› )->all();
arguments: {
$columns: array:1 [ …1]
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:505 {
Illuminate\Database\Eloquent\Builder->get($columns = […1]) …
› // n+1 query issue for the developers to avoid running a lot of queries.
› if (count($models = $builder->getModels($columns)) > 0) {
› $models = $builder->eagerLoadRelations($models);
arguments: {
$columns: array:1 [ …1]
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php:143 {
Illuminate\Database\Eloquent\Builder->first($columns = […1]) …
› {
› return $this->take(1)->get($columns)->first();
› }
arguments: {
$columns: array:1 [ …1]
}
}
/home/hartford/public_html/app/Http/Controllers/Front/TechnologyController.php:47 {
App\Http\Controllers\Front\TechnologyController->list(Request $req) …
› \t\t\t\t->with(['subcates'])
› \t\t\t\t->first();
› // $cate=TechnologyCate::isVisible()
}
App\Http\Controllers\Front\TechnologyController->list() {}
/home/hartford/public_html/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:5 [ …5]
}
}
/home/hartford/public_html/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: "list"
$parameters: array:5 [ …5]
}
}
/home/hartford/public_html/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 {#454 …}
$controller: App\Http\Controllers\Front\TechnologyController {#486 …}
$method: "list"
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 {
Illuminate\Routing\Route->run() …
› if ($this->isControllerAction()) {
› return $this->runController();
› }
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 {
Illuminate\Routing\Router->Illuminate\Routing\{closure} …
› return $this->prepareResponse(
› $request, $route->run()
› );
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› try {
› return $destination($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/app/Http/Middleware/RedirectOldMiddleware.php:33 {
App\Http\Middleware\RedirectOldMiddleware->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/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 {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76 {
Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle($request, Closure $next) …
› ) {
› return tap($next($request), function ($response) use ($request) {
› if ($this->shouldAddXsrfTokenCookie()) {
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/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 {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/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 {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/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 {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105 {
Illuminate\Pipeline\Pipeline->then(Closure $destination) …
›
› return $pipeline($this->passable);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:682 {
Illuminate\Routing\Router->runRouteWithinStack(Route $route, Request $request) …
› );
› });
› }
arguments: {
$destination: Closure($request) {#480 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:657 {
Illuminate\Routing\Router->runRoute(Request $request, Route $route) …
› return $this->prepareResponse($request,
› $this->runRouteWithinStack($route, $request)
› );
arguments: {
$route: Illuminate\Routing\Route {#454 …}
$request: Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:623 {
Illuminate\Routing\Router->dispatchToRoute(Request $request) …
› {
› return $this->runRoute($request, $this->findRoute($request));
› }
arguments: {
$request: Illuminate\Http\Request {#51 …}
$route: Illuminate\Routing\Route {#454 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:612 {
Illuminate\Routing\Router->dispatch(Request $request) …
›
› return $this->dispatchToRoute($request);
› }
arguments: {
$request: Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/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 {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› try {
› return $destination($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/app/Http/Middleware/AddHeaders.php:54 {
App\Http\Middleware\AddHeaders->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56 {
Illuminate\Session\Middleware\StartSession->handle($request, Closure $next) …
›
› $response = $next($request);
›
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21 {
Illuminate\Foundation\Http\Middleware\TransformsRequest->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/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 {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/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 {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105 {
Illuminate\Pipeline\Pipeline->then(Closure $destination) …
›
› return $pipeline($this->passable);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/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) {#418 …}
}
}
/home/hartford/public_html/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 {#51 …}
}
}
/home/hartford/public_html/public/index.php:50 {
› $response = $kernel->handle(\r
› $request = Illuminate\Http\Request::capture()\r
› );\r
arguments: {
$request: Illuminate\Http\Request {#51 …}
}
}
}
}
+errorInfo: array:3 [
0 => "42000"
1 => 1064
2 => "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.real_route AS banner_img_url, 3E7trbLrdk.alt AS banner_img_alt, QtSF2CaGQA.real' at line 1"
]
trace: {
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:665 {
Illuminate\Database\Connection->runQueryCallback($query, $bindings, Closure $callback) …
› catch (Exception $e) {
› throw new QueryException(
› $query, $this->prepareBindings($bindings), $e
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:625 {
Illuminate\Database\Connection->run($query, $bindings, Closure $callback) …
› try {
› $result = $this->runQueryCallback($query, $bindings, $callback);
› } catch (QueryException $e) {
arguments: {
$query: "select tw_technology_cate.*, 3E7trbLrdk.real_route AS banner_img_url, 3E7trbLrdk.alt AS banner_img_alt, QtSF2CaGQA.real_route AS banner_img_m_url, QtSF2CaGQA.alt AS banner_img_m_alt from `tw_technology_cate` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `3E7trbLrdk` on `tw_technology_cate`.`banner_img` = `3E7trbLrdk`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `QtSF2CaGQA` on `tw_technology_cate`.`banner_img_m` = `QtSF2CaGQA`.`file_key` where `branch_id` = ? and `is_visible` = ? and `url_title` = ? and exists (select * from `tw_technology_subcate` where `tw_technology_cate`.`id` = `tw_technology_subcate`.`f_id` and `branch_id` = ? and `is_visible` = ? and `branch_id` = ? and `is_visible` = ?) limit 1"
$bindings: array:7 [ …7]
$callback: Closure($query, $bindings) {#1023 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:334 {
Illuminate\Database\Connection->select($query, $bindings = [], $useReadPdo = true) …
› return $statement->fetchAll();
› });
› }
arguments: {
$query: "select tw_technology_cate.*, 3E7trbLrdk.real_route AS banner_img_url, 3E7trbLrdk.alt AS banner_img_alt, QtSF2CaGQA.real_route AS banner_img_m_url, QtSF2CaGQA.alt AS banner_img_m_alt from `tw_technology_cate` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `3E7trbLrdk` on `tw_technology_cate`.`banner_img` = `3E7trbLrdk`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `QtSF2CaGQA` on `tw_technology_cate`.`banner_img_m` = `QtSF2CaGQA`.`file_key` where `branch_id` = ? and `is_visible` = ? and `url_title` = ? and exists (select * from `tw_technology_subcate` where `tw_technology_cate`.`id` = `tw_technology_subcate`.`f_id` and `branch_id` = ? and `is_visible` = ? and `branch_id` = ? and `is_visible` = ?) limit 1"
$bindings: array:7 [ …7]
$callback: Closure($query, $bindings) {#1023 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2140 {
Illuminate\Database\Query\Builder->runSelect() …
› return $this->connection->select(
› $this->toSql(), $this->getBindings(), ! $this->useWritePdo
› );
arguments: {
$query: "select tw_technology_cate.*, 3E7trbLrdk.real_route AS banner_img_url, 3E7trbLrdk.alt AS banner_img_alt, QtSF2CaGQA.real_route AS banner_img_m_url, QtSF2CaGQA.alt AS banner_img_m_alt from `tw_technology_cate` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `3E7trbLrdk` on `tw_technology_cate`.`banner_img` = `3E7trbLrdk`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `QtSF2CaGQA` on `tw_technology_cate`.`banner_img_m` = `QtSF2CaGQA`.`file_key` where `branch_id` = ? and `is_visible` = ? and `url_title` = ? and exists (select * from `tw_technology_subcate` where `tw_technology_cate`.`id` = `tw_technology_subcate`.`f_id` and `branch_id` = ? and `is_visible` = ? and `branch_id` = ? and `is_visible` = ?) limit 1"
$bindings: array:7 [ …7]
$useReadPdo: true
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2128 {
Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure} …
› return collect($this->onceWithColumns(Arr::wrap($columns), function () {
› return $this->processor->processSelect($this, $this->runSelect());
› }));
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2572 {
Illuminate\Database\Query\Builder->onceWithColumns($columns, $callback) …
›
› $result = $callback();
›
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2129 {
Illuminate\Database\Query\Builder->get($columns = […1]) …
› return $this->processor->processSelect($this, $this->runSelect());
› }));
› }
arguments: {
$columns: array:1 [ …1]
$callback: Closure() {#1029 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:521 {
Illuminate\Database\Eloquent\Builder->getModels($columns = […1]) …
› return $this->model->hydrate(
› $this->query->get($columns)->all()
› )->all();
arguments: {
$columns: array:1 [ …1]
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:505 {
Illuminate\Database\Eloquent\Builder->get($columns = […1]) …
› // n+1 query issue for the developers to avoid running a lot of queries.
› if (count($models = $builder->getModels($columns)) > 0) {
› $models = $builder->eagerLoadRelations($models);
arguments: {
$columns: array:1 [ …1]
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php:143 {
Illuminate\Database\Eloquent\Builder->first($columns = […1]) …
› {
› return $this->take(1)->get($columns)->first();
› }
arguments: {
$columns: array:1 [ …1]
}
}
/home/hartford/public_html/app/Http/Controllers/Front/TechnologyController.php:47 {
App\Http\Controllers\Front\TechnologyController->list(Request $req) …
› \t\t\t\t->with(['subcates'])
› \t\t\t\t->first();
› // $cate=TechnologyCate::isVisible()
}
App\Http\Controllers\Front\TechnologyController->list() {}
/home/hartford/public_html/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:5 [ …5]
}
}
/home/hartford/public_html/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: "list"
$parameters: array:5 [ …5]
}
}
/home/hartford/public_html/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 {#454 …}
$controller: App\Http\Controllers\Front\TechnologyController {#486 …}
$method: "list"
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 {
Illuminate\Routing\Route->run() …
› if ($this->isControllerAction()) {
› return $this->runController();
› }
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 {
Illuminate\Routing\Router->Illuminate\Routing\{closure} …
› return $this->prepareResponse(
› $request, $route->run()
› );
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› try {
› return $destination($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/app/Http/Middleware/RedirectOldMiddleware.php:33 {
App\Http\Middleware\RedirectOldMiddleware->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/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 {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76 {
Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle($request, Closure $next) …
› ) {
› return tap($next($request), function ($response) use ($request) {
› if ($this->shouldAddXsrfTokenCookie()) {
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/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 {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/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 {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/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 {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105 {
Illuminate\Pipeline\Pipeline->then(Closure $destination) …
›
› return $pipeline($this->passable);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:682 {
Illuminate\Routing\Router->runRouteWithinStack(Route $route, Request $request) …
› );
› });
› }
arguments: {
$destination: Closure($request) {#480 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:657 {
Illuminate\Routing\Router->runRoute(Request $request, Route $route) …
› return $this->prepareResponse($request,
› $this->runRouteWithinStack($route, $request)
› );
arguments: {
$route: Illuminate\Routing\Route {#454 …}
$request: Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:623 {
Illuminate\Routing\Router->dispatchToRoute(Request $request) …
› {
› return $this->runRoute($request, $this->findRoute($request));
› }
arguments: {
$request: Illuminate\Http\Request {#51 …}
$route: Illuminate\Routing\Route {#454 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:612 {
Illuminate\Routing\Router->dispatch(Request $request) …
›
› return $this->dispatchToRoute($request);
› }
arguments: {
$request: Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/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 {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› try {
› return $destination($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/app/Http/Middleware/AddHeaders.php:54 {
App\Http\Middleware\AddHeaders->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56 {
Illuminate\Session\Middleware\StartSession->handle($request, Closure $next) …
›
› $response = $next($request);
›
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21 {
Illuminate\Foundation\Http\Middleware\TransformsRequest->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/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 {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/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 {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105 {
Illuminate\Pipeline\Pipeline->then(Closure $destination) …
›
› return $pipeline($this->passable);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/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) {#418 …}
}
}
/home/hartford/public_html/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 {#51 …}
}
}
/home/hartford/public_html/public/index.php:50 {
› $response = $kernel->handle(\r
› $request = Illuminate\Http\Request::capture()\r
› );\r
arguments: {
$request: Illuminate\Http\Request {#51 …}
}
}
}
}