Illuminate\Database\QueryException: SQLSTATE[HY000]: General error: 1034 Index for table 'users' is corrupt; try to repair it (SQL: select `u`.`id` from `subscriptions` inner join `users` as `u` on `subscriptions`.`user_id` = `u`.`id` where `u`.`email_verified_at` is not null and `u`.`user_suspended` = 0 and `subscriptions`.`subscription_end_date` is not null and `subscriptions`.`subscription_end_date` >= 2024-03-28) in file /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 669 #0 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Database/Connection.php(629): Illuminate\Database\Connection->runQueryCallback('select `u`.`id`...', Array, Object(Closure)) #1 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Database/Connection.php(338): Illuminate\Database\Connection->run('select `u`.`id`...', Array, Object(Closure)) #2 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2159): Illuminate\Database\Connection->select('select `u`.`id`...', Array, true) #3 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2311): Illuminate\Database\Query\Builder->runSelect() #4 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2619): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #5 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2313): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure)) #6 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(696): Illuminate\Database\Query\Builder->pluck('u.id', NULL) #7 /home/callchennai/public_html/laravel_project/app/Subscription.php(92): Illuminate\Database\Eloquent\Builder->pluck('u.id') #8 /home/callchennai/public_html/laravel_project/app/Http/Controllers/PagesController.php(1224): App\Subscription->getPaidUserIds() #9 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\Http\Controllers\PagesController->category(Object(Illuminate\Http\Request), 'automobiles') #10 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction('category', Array) #11 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\PagesController), 'category') #12 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\Routing\Route->runController() #13 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(681): Illuminate\Routing\Route->run() #14 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #15 /home/callchennai/public_html/laravel_project/app/Http/Middleware/Maintenance.php(75): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #16 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): App\Http\Middleware\Maintenance->handle(Object(Illuminate\Http\Request), Object(Closure)) #17 /home/callchennai/public_html/laravel_project/app/Http/Middleware/GlobalVariablesMiddleware.php(153): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #18 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): App\Http\Middleware\GlobalVariablesMiddleware->handle(Object(Illuminate\Http\Request), Object(Closure)) #19 /home/callchennai/public_html/laravel_project/app/Http/Middleware/DemoMiddleware.php(48): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #20 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): App\Http\Middleware\DemoMiddleware->handle(Object(Illuminate\Http\Request), Object(Closure)) #21 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #22 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #23 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #24 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #25 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #26 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #27 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(56): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #28 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #29 /home/callchennai/public_html/laravel_project/app/Http/Middleware/Installed.php(20): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #30 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): App\Http\Middleware\Installed->handle(Object(Illuminate\Http\Request), Object(Closure)) #31 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #32 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure)) #33 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #34 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure)) #35 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #36 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(683): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #37 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(658): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #38 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(624): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route)) #39 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(613): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #40 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(170): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #41 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #42 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #43 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #44 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #45 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #46 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #47 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure)) #48 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(63): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #49 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #50 /home/callchennai/public_html/laravel_project/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #51 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Fideloper\Proxy\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure)) #52 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #53 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(145): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #54 /home/callchennai/public_html/laravel_project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(110): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #55 /home/callchennai/public_html/index.php(57): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #56 {main}