Illuminate\Database\QueryException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation 'like' (SQL: select count(*) as tot from EIOJDB_GIACENZA ejg left join MERCATINI on (ejg.c_idmercatino=MERCATINI.c_idmercatino) WHERE (datediff(CURDATE(),c_datrinman)<=60 or c_ns18=1) and c_idvetrina=0 and c_flgmercatopoli=1 and c_lang='IT' and c_webactive=1 and ejg.c_idmercatino=479 and concat(c_desart,c_desagg,c_desagg1,c_webdes,c_isbn) like '%Una%' and concat(c_desart,c_desagg,c_desagg1,c_webdes,c_isbn) like '%giornata%' and concat(c_desart,c_desagg,c_desagg1,c_webdes,c_isbn) like '%eroica.%' and concat(c_desart,c_desagg,c_desagg1,c_webdes,c_isbn) like '%I%' and concat(c_desart,c_desagg,c_desagg1,c_webdes,c_isbn) like '%segreti%' and concat(c_desart,c_desagg,c_desagg1,c_webdes,c_isbn) like '%dell''orchestra%' and concat(c_desart,c_desagg,c_desagg1,c_webdes,c_isbn) like '%e%' and concat(c_desart,c_desagg,c_desagg1,c_webdes,c_isbn) like '%l''�Eroica�%' and concat(c_desart,c_desagg,c_desagg1,c_webdes,c_isbn) like '%di%' and concat(c_desart,c_desagg,c_desagg1,c_webdes,c_isbn) like '%Beethoven%' and concat(c_desart,c_desagg,c_desagg1,c_webdes,c_isbn) like '%raccontati%' and concat(c_desart,c_desagg,c_desagg1,c_webdes,c_isbn) like '%durante%') in file /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 705 #0 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Connection.php(665): Illuminate\Database\Connection->runQueryCallback() #1 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Connection.php(369): Illuminate\Database\Connection->run() #2 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(403): Illuminate\Database\Connection->select() #3 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(261): Illuminate\Database\DatabaseManager->__call() #4 /var/www/vhosts/mercatopoli.it/httpdocs/app/Http/Controllers/ShopController.php(764): Illuminate\Support\Facades\Facade::__callStatic() #5 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\Http\Controllers\ShopController->ricerca() #6 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction() #7 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Route.php(262): Illuminate\Routing\ControllerDispatcher->dispatch() #8 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\Routing\Route->runController() #9 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(695): Illuminate\Routing\Route->run() #10 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\Routing\Router->Illuminate\Routing\{closure}() #11 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #12 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Routing\Middleware\SubstituteBindings->handle() #13 /var/www/vhosts/mercatopoli.it/httpdocs/app/Http/Middleware/EioMiddleware.php(17): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #14 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): App\Http\Middleware\EioMiddleware->handle() #15 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #16 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle() #17 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #18 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\View\Middleware\ShareErrorsFromSession->handle() #19 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #20 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Session\Middleware\StartSession->handleStatefulRequest() #21 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Session\Middleware\StartSession->handle() #22 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #23 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle() #24 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #25 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Cookie\Middleware\EncryptCookies->handle() #26 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #27 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(697): Illuminate\Pipeline\Pipeline->then() #28 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(672): Illuminate\Routing\Router->runRouteWithinStack() #29 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(636): Illuminate\Routing\Router->runRoute() #30 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(625): Illuminate\Routing\Router->dispatchToRoute() #31 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(167): Illuminate\Routing\Router->dispatch() #32 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}() #33 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #34 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #35 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle() #36 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #37 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #38 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\TrimStrings->handle() #39 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #40 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle() #41 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #42 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle() #43 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/fruitcake/laravel-cors/src/HandleCors.php(38): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #44 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Fruitcake\Cors\HandleCors->handle() #45 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #46 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Http\Middleware\TrustProxies->handle() #47 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #48 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(142): Illuminate\Pipeline\Pipeline->then() #49 /var/www/vhosts/mercatopoli.it/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(111): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter() #50 /var/www/vhosts/mercatopoli.it/httpdocs/public/index.php(52): Illuminate\Foundation\Http\Kernel->handle() #51 {main}