Illuminate\Database\QueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'yilinadm_prod.avored_products' doesn't exist (SQL: select count(*) as aggregate from `avored_products` left join `avored_translations` as `avored_name` on `avored_name`.`table` = 'products' and `avored_name`.`locale` = 'zh' and `avored_name`.`field` = 'name' and `avored_name`.`ref_id` = `avored_products`.`id` where `status` = 1 and `company_id` = 1 and `avored_products`.`deleted_at` is null) in file /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 759 #0 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Database/Connection.php(719): Illuminate\Database\Connection->runQueryCallback() #1 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421): Illuminate\Database\Connection->run() #2 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2636): Illuminate\Database\Connection->select() #3 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2624): Illuminate\Database\Query\Builder->runSelect() #4 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3160): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #5 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2625): Illuminate\Database\Query\Builder->onceWithColumns() #6 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2774): Illuminate\Database\Query\Builder->get() #7 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2733): Illuminate\Database\Query\Builder->runPaginationCountQuery() #8 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(880): Illuminate\Database\Query\Builder->getCountForPagination() #9 /var/www/yilin-v9/app/Http/Controllers/SearchController.php(234): Illuminate\Database\Eloquent\Builder->paginate() #10 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\Http\Controllers\SearchController->result() #11 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction() #12 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Routing/Route.php(261): Illuminate\Routing\ControllerDispatcher->dispatch() #13 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Routing/Route.php(204): Illuminate\Routing\Route->runController() #14 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Routing/Router.php(725): Illuminate\Routing\Route->run() #15 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Routing\Router->Illuminate\Routing\{closure}() #16 /var/www/yilin-v9/app/Http/Middleware/Language.php(23): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #17 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\Language->handle() #18 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #19 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Routing\Middleware\SubstituteBindings->handle() #20 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #21 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle() #22 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #23 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\View\Middleware\ShareErrorsFromSession->handle() #24 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #25 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Session\Middleware\StartSession->handleStatefulRequest() #26 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Session\Middleware\StartSession->handle() #27 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #28 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle() #29 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #30 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Cookie\Middleware\EncryptCookies->handle() #31 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #32 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Routing/Router.php(726): Illuminate\Pipeline\Pipeline->then() #33 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Routing/Router.php(703): Illuminate\Routing\Router->runRouteWithinStack() #34 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Routing/Router.php(667): Illuminate\Routing\Router->runRoute() #35 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Routing/Router.php(656): Illuminate\Routing\Router->dispatchToRoute() #36 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(167): Illuminate\Routing\Router->dispatch() #37 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}() #38 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #39 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #40 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle() #41 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #42 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #43 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\TrimStrings->handle() #44 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #45 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle() #46 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #47 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle() #48 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #49 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Http\Middleware\HandleCors->handle() #50 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #51 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Http\Middleware\TrustProxies->handle() #52 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #53 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(142): Illuminate\Pipeline\Pipeline->then() #54 /var/www/yilin-v9/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(111): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter() #55 /var/www/yilin-v9/public/index.php(52): Illuminate\Foundation\Http\Kernel->handle() #56 {main}