Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1055 'myream_db131.tests.category_id' isn't in GROUP BY (SQL: select tests.* from `tests` where `is_published` = 1 and exists (select * from `tests_d` where `tests`.`id` = `tests_d`.`test_id` and `title_url` is not null and `title_url` <> and `language_id` = 1) and `is_published` = 1 group by `id` order by `privatescore` desc, `created_at` desc limit 6 offset 0) in file /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 669 #0 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Database/Connection.php(629): Illuminate\Database\Connection->runQueryCallback('select tests.* ...', Array, Object(Closure)) #1 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Database/Connection.php(338): Illuminate\Database\Connection->run('select tests.* ...', Array, Object(Closure)) #2 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2149): Illuminate\Database\Connection->select('select tests.* ...', Array, true) #3 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2137): Illuminate\Database\Query\Builder->runSelect() #4 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2609): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #5 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2138): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure)) #6 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(537): Illuminate\Database\Query\Builder->get(Array) #7 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(521): Illuminate\Database\Eloquent\Builder->getModels(Array) #8 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(721): Illuminate\Database\Eloquent\Builder->get(Array) #9 /usr/www/users/myream/public/nicky/myrealpersonality/app/Http/Controllers/Frontend/FrontendController.php(27): Illuminate\Database\Eloquent\Builder->paginate(6) #10 [internal function]: App\Http\Controllers\Frontend\FrontendController->showTop(Object(App\Language)) #11 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): call_user_func_array(Array, Array) #12 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction('showTop', Array) #13 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\Frontend\FrontendController), 'showTop') #14 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\Routing\Route->runController() #15 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Routing/Router.php(681): Illuminate\Routing\Route->run() #16 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #17 /usr/www/users/myream/public/nicky/myrealpersonality/app/Http/Middleware/SetLocale.php(31): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #18 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): App\Http\Middleware\SetLocale->handle(Object(Illuminate\Http\Request), Object(Closure)) #19 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #20 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #21 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(76): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #22 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #23 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #24 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #25 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(56): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #26 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #27 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #28 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure)) #29 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(66): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #30 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure)) #31 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #32 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Routing/Router.php(683): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #33 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Routing/Router.php(658): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #34 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Routing/Router.php(624): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route)) #35 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Routing/Router.php(613): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #36 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(170): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #37 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #38 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #39 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #40 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #41 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #42 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #43 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure)) #44 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(63): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #45 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #46 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #47 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Fideloper\Proxy\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure)) #48 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #49 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(145): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #50 /usr/www/users/myream/public/nicky/myrealpersonality/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(110): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #51 /usr/www/users/myream/public/nicky/myrealpersonality/public/index.php(55): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #52 {main}