SQLSTATE[HY000] [2002] Connection refused (Connection: mysql, Host: perfect-database.cf4sk0a4ka4f.ap-south-1.rds.amazonaws.com, Port: 3306, Database: perfect_db, SQL: select count(*) as aggregate from `product` as `p` left join `productcategory` as `pc` on `pc`.`CategoryId` = `p`.`CategoryId` left join `productcategory` as `parent_pc` on `parent_pc`.`CategoryId` = `pc`.`ParentCategoryId` where `p`.`IsActive` = 1 and (`p`.`catalog_type_id` = 3))
Illuminate\Database\Connection->runQueryCallback(string, array, object(Closure))Illuminate\Database\Connection->runQueryCallback(string, array, object(Closure))Illuminate\Database\Connection->tryAgainIfCausedByLostConnection(object(Illuminate\Database\QueryException), string, array, object(Closure))Illuminate\Database\Connection->handleQueryException(object(Illuminate\Database\QueryException), string, array, object(Closure))Illuminate\Database\Connection->run(string, array, object(Closure))Illuminate\Database\Connection->select(string, array, boolean)Illuminate\Database\Query\Builder->runSelect()Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()Illuminate\Database\Query\Builder->onceWithColumns(array, object(Closure))Illuminate\Database\Query\Builder->get()Illuminate\Database\Query\Builder->runPaginationCountQuery(array)Illuminate\Database\Query\Builder->getCountForPagination()Illuminate\Database\Query\Builder->paginate(integer)183 $q->where('p.catalog_type_id', $category);184 185 });186 }187 188 $products = $query->orderBy('p.ProductName', 'asc')->paginate(50);189 190 $data['products'] = $products;191 $data['category'] = $category ?: 'all';192 193 return view('products_by_category_tabs', $data);194 }195}196197App\Http\Controllers\HomeController->products_page(string)Illuminate\Routing\Controller->callAction(string, array)Illuminate\Routing\ControllerDispatcher->dispatch(object(Illuminate\Routing\Route), object(App\Http\Controllers\HomeController), string)Illuminate\Routing\Route->runController()Illuminate\Routing\Route->run()Illuminate\Routing\Router->Illuminate\Routing\{closure}(object(Illuminate\Http\Request))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Routing\Middleware\SubstituteBindings->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\View\Middleware\ShareErrorsFromSession->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Session\Middleware\StartSession->handleStatefulRequest(object(Illuminate\Http\Request), object(Illuminate\Session\Store), object(Closure))Illuminate\Session\Middleware\StartSession->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Cookie\Middleware\EncryptCookies->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))38 }3940 // Lax lets the cookie ride same-site top-level POSTs (the login form submit).41 config(['session.same_site' => 'lax']);4243 return $next($request);44 }45}46App\Http\Middleware\ConfigureLiveSession->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Pipeline\Pipeline->then(object(Closure))Illuminate\Routing\Router->runRouteWithinStack(object(Illuminate\Routing\Route), object(Illuminate\Http\Request))Illuminate\Routing\Router->runRoute(object(Illuminate\Http\Request), object(Illuminate\Routing\Route))Illuminate\Routing\Router->dispatchToRoute(object(Illuminate\Http\Request))Illuminate\Routing\Router->dispatch(object(Illuminate\Http\Request))Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(object(Illuminate\Http\Request))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Foundation\Http\Middleware\TrimStrings->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Http\Middleware\ValidatePostSize->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Http\Middleware\HandleCors->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Http\Middleware\TrustProxies->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Foundation\Http\Middleware\InvokeDeferredCallbacks->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Http\Middleware\ValidatePathEncoding->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Pipeline\Pipeline->then(object(Closure))Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(object(Illuminate\Http\Request))Illuminate\Foundation\Http\Kernel->handle(object(Illuminate\Http\Request))Illuminate\Foundation\Application->handleRequest(object(Illuminate\Http\Request))1516// Bootstrap Laravel and handle the request...17/** @var Application $app */18$app = require_once __DIR__.'/../bootstrap/app.php';1920$app->handleRequest(Request::capture());21require(string)23/**4 * Root front controller so app works at /perfect-live-latest/5 * without requiring /public in the URL.6 */7require __DIR__.'/public/index.php';8{
"category": "3"
}