SQLSTATE[42S22]: Column not found: 1054 Unknown column 'playlists.year' in 'SELECT' (SQL: select count(*) as aggregate from (select `playlists`.`playlist_id`, `playlists`.`title`, `playlists`.`year`, CONCAT('https://imagedelivery.net/RWNGqXhAb9XWtiHQaeSrCw/', playlists.image, '/artwork') as image, COALESCE(SUM(playlist_plays.total_plays), 0) as streams from `playlists` left join `playlist_plays` on `playlist_plays`.`playlist_id` = `playlists`.`playlist_id` group by `playlists`.`playlist_id`, `playlists`.`title`, `playlists`.`year`, `playlists`.`image`) as `aggregate

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'playlists.year' in 'SELECT' (SQL: select count(*) as aggregate from (select `playlists`.`playlist_id`, `playlists`.`title`, `playlists`.`year`, CONCAT('https://imagedelivery.net/RWNGqXhAb9XWtiHQaeSrCw/', playlists.image, '/artwork') as image, COALESCE(SUM(playlist_plays.total_plays), 0) as streams from `playlists` left join `playlist_plays` on `playlist_plays`.`playlist_id` = `playlists`.`playlist_id` group by `playlists`.`playlist_id`, `playlists`.`title`, `playlists`.`year`, `playlists`.`image`) as `aggregate_table`)

Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'playlists.year' in 'SELECT' (SQL: select count(*) as aggregate from (select `playlists`.`playlist_id`, `playlists`.`title`, `playlists`.`year`, CONCAT('https://imagedelivery.net/RWNGqXhAb9XWtiHQaeSrCw/', playlists.image, '/artwork') as image, COALESCE(SUM(playlist_plays.total_plays), 0) as streams from `playlists` left join `playlist_plays` on `playlist_plays`.`playlist_id` = `playlists`.`playlist_id` group by `playlists`.`playlist_id`, `playlists`.`title`, `playlists`.`year`, `playlists`.`image`) as `aggregate_table`) in file /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 760 #0 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback('select count(*)...', Array, Object(Closure)) #1 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run('select count(*)...', Array, Object(Closure)) #2 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select('select count(*)...', Array, true) #3 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect() #4 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #5 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure)) #6 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2836): Illuminate\Database\Query\Builder->get() #7 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2803): Illuminate\Database\Query\Builder->runPaginationCountQuery(Array) #8 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(891): Illuminate\Database\Query\Builder->getCountForPagination() #9 /home/malagpfc/api.malawisongs.com/app/Http/Controllers/NuxtAPI/NuxtAPIPlaylistController.php(186): Illuminate\Database\Eloquent\Builder->paginate('24') #10 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\Http\Controllers\NuxtAPI\NuxtAPIPlaylistController->getPlayListsDataAPINuxt(Object(Illuminate\Http\Request)) #11 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\Routing\Controller->callAction('getPlayListsDat...', Array) #12 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\NuxtAPI\NuxtAPIPlaylistController), 'getPlayListsDat...') #13 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\Routing\Route->runController() #14 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\Routing\Route->run() #15 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #16 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #17 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #18 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #19 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(102): Illuminate\Routing\Middleware\ThrottleRequests->handleRequest(Object(Illuminate\Http\Request), Object(Closure), Array) #20 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(54): Illuminate\Routing\Middleware\ThrottleRequests->handleRequestUsingNamedLimiter(Object(Illuminate\Http\Request), Object(Closure), 'api', Object(Closure)) #21 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Routing\Middleware\ThrottleRequests->handle(Object(Illuminate\Http\Request), Object(Closure), 'api') #22 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #23 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #24 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #25 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route)) #26 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #27 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(190): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #28 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #29 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #30 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #31 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle(Object(Illuminate\Http\Request), Object(Closure)) #32 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #33 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #34 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\TrimStrings->handle(Object(Illuminate\Http\Request), Object(Closure)) #35 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #36 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure)) #37 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #38 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle(Object(Illuminate\Http\Request), Object(Closure)) #39 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #40 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Http\Middleware\HandleCors->handle(Object(Illuminate\Http\Request), Object(Closure)) #41 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #42 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Http\Middleware\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure)) #43 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #44 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(165): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #45 /home/malagpfc/api.malawisongs.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(134): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #46 /home/malagpfc/api.malawisongs.com/public/index.php(19): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #47 {main}

Browse playlists

No data found