Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1055 'icfmindia_live.tbl_blog_news.type' isn't in GROUP BY (Connection: mysql, SQL: select count(*) as aggregate from (select `tbl_blog_news`.*, `tbl_likes`.`user_id` as `liked_user`, COALESCE(tbl_admin.name, CONCAT(tbl_students.first_name, " ", tbl_students.last_name)) as author_name, COALESCE(tbl_admin.image, tbl_students.profile) as author_image, COUNT(tbl_likes.id) as total_like, COALESCE(tbl_admin.id, tbl_students.id) as author_id from `tbl_blog_news` left join `tbl_admin` on `tbl_admin`.`id` = `tbl_blog_news`.`created_by` left join `tbl_likes` on `tbl_likes`.`post_id` = `tbl_blog_news`.`id` and `tbl_likes`.`post_category` = blog left join `tbl_students` on `tbl_students`.`id` = `tbl_blog_news`.`created_by` where (`tbl_blog_news`.`status` = 1 and `tbl_blog_news`.`type` = blog and `tbl_blog_news`.`publish_type` = admin) and `tbl_blog_news`.`created_by` = 14 group by `tbl_blog_news`.`id`, `tbl_likes`.`user_id`, `tbl_admin`.`id`, `tbl_students`.`id`) as `aggregate_table`) in file /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 825 #0 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\Database\Connection->runQueryCallback() #1 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(398): Illuminate\Database\Connection->run() #2 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3088): Illuminate\Database\Connection->select() #3 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3073): Illuminate\Database\Query\Builder->runSelect() #4 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3661): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #5 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3072): Illuminate\Database\Query\Builder->onceWithColumns() #6 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3259): Illuminate\Database\Query\Builder->get() #7 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3226): Illuminate\Database\Query\Builder->runPaginationCountQuery() #8 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(977): Illuminate\Database\Query\Builder->getCountForPagination() #9 /home/icfmindia/public_html/app/Http/Controllers/IndexController.php(1031): Illuminate\Database\Eloquent\Builder->paginate() #10 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(46): App\Http\Controllers\IndexController->faculty_profile() #11 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\Routing\ControllerDispatcher->dispatch() #12 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Routing/Route.php(206): Illuminate\Routing\Route->runController() #13 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(808): Illuminate\Routing\Route->run() #14 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\Routing\Router->Illuminate\Routing\{closure}() #15 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(51): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #16 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Routing\Middleware\SubstituteBindings->handle() #17 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(88): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #18 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle() #19 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #20 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\View\Middleware\ShareErrorsFromSession->handle() #21 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #22 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Session\Middleware\StartSession->handleStatefulRequest() #23 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Session\Middleware\StartSession->handle() #24 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #25 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle() #26 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(75): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #27 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Cookie\Middleware\EncryptCookies->handle() #28 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #29 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(807): Illuminate\Pipeline\Pipeline->then() #30 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(786): Illuminate\Routing\Router->runRouteWithinStack() #31 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(750): Illuminate\Routing\Router->runRoute() #32 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(739): Illuminate\Routing\Router->dispatchToRoute() #33 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(201): Illuminate\Routing\Router->dispatch() #34 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}() #35 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #36 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #37 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle() #38 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #39 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(51): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #40 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\TrimStrings->handle() #41 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #42 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Http\Middleware\ValidatePostSize->handle() #43 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(110): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #44 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle() #45 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #46 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Http\Middleware\HandleCors->handle() #47 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(57): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #48 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Http\Middleware\TrustProxies->handle() #49 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #50 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\Pipeline\Pipeline->then() #51 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(145): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter() #52 /home/icfmindia/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1188): Illuminate\Foundation\Http\Kernel->handle() #53 /home/icfmindia/public_html/public/index.php(16): Illuminate\Foundation\Application->handleRequest() #54 /home/icfmindia/public_html/server.php(21): require_once('/home/icfmindia...') #55 {main}