Illuminate\Database\QueryException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation '=' (SQL: select count(*) as aggregate from `StockVN` inner join `concesionarios` on `StockVN`.`id_concesionario` = `concesionarios`.`id_concesionario` inner join `concesionarios_data` on `concesionarios_data`.`id_concesionario` = `concesionarios_data`.`id_concesionario` and `concesionarios_data`.`id_concesionario` = 193 inner join `StockVN_data` on `StockVN`.`comision` = `StockVN_data`.`comision` inner join `datosTecnicos` on `StockVN`.`comision` = `datosTecnicos`.`comision` inner join `modelos` on `StockVN`.`modelo` = `modelos`.`name` left join `carroceria` on `StockVN`.`carroceria` = `carroceria`.`name` left join `grupo_colores` on `StockVN`.`codigo_color` = `grupo_colores`.`codigo_color` left join `colores_genericos` on `grupo_colores`.`id_color` = `colores_genericos`.`id_color` left join `etiquetas` on `StockVN_data`.`id_etiqueta` = `etiquetas`.`id_etiqueta` where `concesionarios_data`.`cookiesLegal` <> and `concesionarios_data`.`avisoLegal` <> and `concesionarios_data`.`proteccionDatos` <> and `concesionarios_data`.`proteccionDatos` <> and `concesionarios_data`.`modulo` is not null and `estado` = 1 and `concesionarios`.`id_concesionario` in (193, 217, 408, 409) and `modelos`.`id_modelo` = 18 and `modelos`.`id_modelo` = 18 and `datosTecnicos`.`tipoCombustible` = H��brido) in file /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 669 #0 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Database/Connection.php(629): Illuminate\Database\Connection->runQueryCallback() #1 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Database/Connection.php(338): Illuminate\Database\Connection->run() #2 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2132): Illuminate\Database\Connection->select() #3 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2120): Illuminate\Database\Query\Builder->runSelect() #4 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2586): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #5 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2121): Illuminate\Database\Query\Builder->onceWithColumns() #6 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2513): Illuminate\Database\Query\Builder->get() #7 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2441): Illuminate\Database\Query\Builder->aggregate() #8 /home/sftp/ltw_cms/cars/app/Http/Controllers/HomeController.php(620): Illuminate\Database\Query\Builder->count() #9 [internal function]: App\Http\Controllers\HomeController->modelos() #10 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): call_user_func_array() #11 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction() #12 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\Routing\ControllerDispatcher->dispatch() #13 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\Routing\Route->runController() #14 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Routing/Router.php(681): Illuminate\Routing\Route->run() #15 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\Routing\Router->Illuminate\Routing\{closure}() #16 /home/sftp/ltw_cms/cars/app/Http/Middleware/LocaleMiddleware.php(25): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #17 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): App\Http\Middleware\LocaleMiddleware->handle() #18 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #19 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Routing\Middleware\SubstituteBindings->handle() #20 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(76): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #21 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle() #22 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #23 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\View\Middleware\ShareErrorsFromSession->handle() #24 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(56): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #25 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Session\Middleware\StartSession->handle() #26 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #27 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle() #28 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(66): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #29 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Cookie\Middleware\EncryptCookies->handle() #30 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #31 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Routing/Router.php(683): Illuminate\Pipeline\Pipeline->then() #32 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Routing/Router.php(658): Illuminate\Routing\Router->runRouteWithinStack() #33 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Routing/Router.php(624): Illuminate\Routing\Router->runRoute() #34 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Routing/Router.php(613): Illuminate\Routing\Router->dispatchToRoute() #35 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(170): Illuminate\Routing\Router->dispatch() #36 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}() #37 /home/sftp/ltw_cms/cars/app/Http/Middleware/Cors.php(16): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #38 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): App\Http\Middleware\Cors->handle() #39 /home/sftp/ltw_cms/cars/vendor/mikefrancis/laravel-secureheaders/src/ApplySecureHeaders.php(48): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #40 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): MikeFrancis\LaravelSecureHeaders\ApplySecureHeaders->handle() #41 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #42 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #43 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #44 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #45 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #46 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle() #47 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(63): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #48 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle() #49 /home/sftp/ltw_cms/cars/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #50 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Fideloper\Proxy\TrustProxies->handle() #51 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #52 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(145): Illuminate\Pipeline\Pipeline->then() #53 /home/sftp/ltw_cms/cars/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(110): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter() #54 /home/sftp/ltw_cms/public/index.php(55): Illuminate\Foundation\Http\Kernel->handle() #55 {main}