Illuminate\Database\QueryException: 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 ') and `post`.`deleted_at` is null' at line 1 (SQL: select count(*) as aggregate from `post` left join `post_content` on `post`.`id` = `post_content`.`post_id` left join `post_category` on `post_category`.`post_id` = `post`.`id` left join `category` on `category`.`id` = `post_category`.`category_id` left join `category_content` on `category_content`.`category_id` = `category`.`id` where 1=1 AND post.published_at <= "2024-03-29 07:51:36" AND post_content.lang = "Vietnamese" AND category.id in () and `post`.`deleted_at` is null) in file /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671 #0 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback('select count(*)...', Array, Object(Closure)) #1 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Database/Connection.php(339): Illuminate\Database\Connection->run('select count(*)...', Array, Object(Closure)) #2 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2260): Illuminate\Database\Connection->select('select count(*)...', Array, true) #3 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2248): Illuminate\Database\Query\Builder->runSelect() #4 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2743): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #5 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2249): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure)) #6 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2359): Illuminate\Database\Query\Builder->get() #7 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2318): Illuminate\Database\Query\Builder->runPaginationCountQuery(Array) #8 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(730): Illuminate\Database\Query\Builder->getCountForPagination() #9 /var/www/src/admin-manager/app/Repositories/PostRepository.php(489): Illuminate\Database\Eloquent\Builder->paginate(6) #10 /var/www/src/admin-manager/app/Repositories/PostRepository.php(384): App\Repositories\PostRepository->dataQueryByParams(Array, Array, true, NULL, 6, NULL, true) #11 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Cache/Repository.php(383): App\Repositories\PostRepository->App\Repositories\{closure}() #12 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php(383): Illuminate\Cache\Repository->remember('rPBC::page:1', 3600, Object(Closure)) #13 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(261): Illuminate\Cache\CacheManager->__call('remember', Array) #14 /var/www/src/admin-manager/app/Repositories/PostRepository.php(385): Illuminate\Support\Facades\Facade::__callStatic('remember', Array) #15 /var/www/src/admin-manager/app/Repositories/PostRepository.php(337): App\Repositories\PostRepository->dataQueryByParamsWithCache('rPBC::page:1', 3600, Array, Array, true, NULL, 6) #16 /var/www/src/admin-manager/app/Http/Controllers/PostController.php(27): App\Repositories\PostRepository->relatedPostByCategory('') #17 [internal function]: App\Http\Controllers\PostController->index('ufo-project-blu...', '46559', Object(Illuminate\Http\Request)) #18 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): call_user_func_array(Array, Array) #19 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction('index', Array) #20 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Routing/Route.php(239): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\PostController), 'index') #21 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Routing/Route.php(196): Illuminate\Routing\Route->runController() #22 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Routing/Router.php(685): Illuminate\Routing\Route->run() #23 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #24 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #25 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #26 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(77): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #27 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #28 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #29 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #30 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #31 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(62): Illuminate\Session\Middleware\StartSession->handleStatefulRequest(Object(Illuminate\Http\Request), Object(Illuminate\Session\Store), Object(Closure)) #32 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #33 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #34 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure)) #35 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #36 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure)) #37 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #38 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Routing/Router.php(687): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #39 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Routing/Router.php(662): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #40 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Routing/Router.php(628): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route)) #41 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Routing/Router.php(617): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #42 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(165): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #43 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #44 /var/www/src/admin-manager/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #45 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Fideloper\Proxy\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure)) #46 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #47 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #48 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #49 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #50 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #51 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure)) #52 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(63): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #53 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #54 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #55 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(140): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #56 /var/www/src/admin-manager/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(109): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #57 /var/www/src/admin-manager/public/index.php(54): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #58 {main}