Illuminate\Database\QueryException: SQLSTATE[22032]: <<Unknown error>>: 3146 Invalid data type for JSON data in argument 1 to function json_search; a JSON string or JSON type is required. (Connection: mysql, SQL: select count(*) as aggregate from `courses` where `courses`.`category_id` = 6 and `courses`.`category_id` is not null or JSON_SEARCH(other_cats, 'one' ,'6') is not null and `status` = 1) in file /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 829 #0 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Database/Connection.php(783): Illuminate\Database\Connection->runQueryCallback('select count(*)...', Array, Object(Closure)) #1 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Database/Connection.php(414): Illuminate\Database\Connection->run('select count(*)...', Array, Object(Closure)) #2 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2913): Illuminate\Database\Connection->select('select count(*)...', Array, true) #3 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2902): Illuminate\Database\Query\Builder->runSelect() #4 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3456): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #5 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2901): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure)) #6 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3066): Illuminate\Database\Query\Builder->get() #7 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3025): Illuminate\Database\Query\Builder->runPaginationCountQuery(Array) #8 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(923): Illuminate\Database\Query\Builder->getCountForPagination() #9 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\Database\Eloquent\Builder->paginate(5) #10 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(52): Illuminate\Database\Eloquent\Relations\Relation->forwardCallTo(Object(Illuminate\Database\Eloquent\Builder), 'paginate', Array) #11 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(517): Illuminate\Database\Eloquent\Relations\Relation->forwardDecoratedCallTo(Object(Illuminate\Database\Eloquent\Builder), 'paginate', Array) #12 /home3/ngpldamy/public_html/xrayondoor.in/app/Http/Controllers/CategoriesController.php(288): Illuminate\Database\Eloquent\Relations\Relation->__call('paginate', Array) #13 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\Http\Controllers\CategoriesController->categoryPage(Object(Illuminate\Http\Request), 'health-fitness') #14 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\Routing\Controller->callAction('categorypage', Array) #15 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Routing/Route.php(259): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\CategoriesController), 'categorypage') #16 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\Routing\Route->runController() #17 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Routing/Router.php(806): Illuminate\Routing\Route->run() #18 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #19 /home3/ngpldamy/public_html/xrayondoor.in/app/Http/Middleware/SwitchLanguage.php(42): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #20 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\Http\Middleware\SwitchLanguage->handle(Object(Illuminate\Http\Request), Object(Closure)) #21 /home3/ngpldamy/public_html/xrayondoor.in/app/Http/Middleware/MaintananceMode.php(74): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #22 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\Http\Middleware\MaintananceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #23 /home3/ngpldamy/public_html/xrayondoor.in/app/Http/Middleware/Google2FAAuthenticator.php(35): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #24 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\Http\Middleware\Google2FAAuthenticator->handle(Object(Illuminate\Http\Request), Object(Closure)) #25 /home3/ngpldamy/public_html/xrayondoor.in/app/Http/Middleware/IsVerified.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #26 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\Http\Middleware\IsVerified->handle(Object(Illuminate\Http\Request), Object(Closure)) #27 /home3/ngpldamy/public_html/xrayondoor.in/vendor/inertiajs/inertia-laravel/src/Middleware.php(87): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #28 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Inertia\Middleware->handle(Object(Illuminate\Http\Request), Object(Closure)) #29 /home3/ngpldamy/public_html/xrayondoor.in/app/Http/Middleware/CheckReferral.php(30): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #30 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\Http\Middleware\CheckReferral->handle(Object(Illuminate\Http\Request), Object(Closure)) #31 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #32 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #33 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #34 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #35 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #36 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #37 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #38 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Session\Middleware\StartSession->handleStatefulRequest(Object(Illuminate\Http\Request), Object(Illuminate\Session\Store), Object(Closure)) #39 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #40 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #41 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure)) #42 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #43 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure)) #44 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #45 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Routing/Router.php(805): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #46 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Routing/Router.php(784): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #47 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Routing/Router.php(748): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route)) #48 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Routing/Router.php(737): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #49 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #50 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #51 /home3/ngpldamy/public_html/xrayondoor.in/vendor/fruitcake/laravel-cors/src/HandleCors.php(38): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #52 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Fruitcake\Cors\HandleCors->handle(Object(Illuminate\Http\Request), Object(Closure)) #53 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #54 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Http\Middleware\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure)) #55 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #56 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #57 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle(Object(Illuminate\Http\Request), Object(Closure)) #58 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #59 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #60 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\TrimStrings->handle(Object(Illuminate\Http\Request), Object(Closure)) #61 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #62 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure)) #63 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(99): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #64 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle(Object(Illuminate\Http\Request), Object(Closure)) #65 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #66 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #67 /home3/ngpldamy/public_html/xrayondoor.in/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #68 /home3/ngpldamy/public_html/xrayondoor.in/public/index.php(11): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #69 {main}