"PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'agency_id' in 'where clause' in D:\work\kurdis\Songa\songa-api\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:77↵Stack trace:↵#0 D:\work\kurdis\Songa\songa-api\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php(77): PDO->prepare('select * from `...', Array)↵#1 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Database\Connection.php(319): Doctrine\DBAL\Driver\PDOConnection->prepare('select * from `...')↵#2 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Database\Connection.php(640): Illuminate\Database\Connection->Illuminate\Database\{closure}('select * from `...', Array)↵#3 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Database\Connection.php(607): Illuminate\Database\Connection->runQueryCallback('select * from `...', Array, Object(Closure))↵#4 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Database\Connection.php(326): Illuminate\Database\Connection->run('select * from `...', Array, Object(Closure))↵#5 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(1705): Illuminate\Database\Connection->select('select * from `...', Array, true)↵#6 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(1690): Illuminate\Database\Query\Builder->runSelect()↵#7 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(462): Illuminate\Database\Query\Builder->get(Array)↵#8 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(446): Illuminate\Database\Eloquent\Builder->getModels(Array)↵#9 D:\work\kurdis\Songa\songa-api\api\Transactions\Repositories\TransactionRepository.php(87): Illuminate\Database\Eloquent\Builder->get()↵#10 D:\work\kurdis\Songa\songa-api\api\Transactions\Services\TransactionService.php(40): Api\Transactions\Repositories\TransactionRepository->getWithFiltersForProvider(Array, Object(Api\Users\Models\User))↵#11 D:\work\kurdis\Songa\songa-api\api\Transactions\Controllers\TransactionController.php(48): Api\Transactions\Services\TransactionService->getAllForProvider(Array, Object(Api\Users\Models\User))↵#12 [internal function]: Api\Transactions\Controllers\TransactionController->getAll(Object(Illuminate\Http\Request))↵#13 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Routing\Controller.php(55): call_user_func_array(Array, Array)↵#14 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('getAll', Array)↵#15 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Routing\Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Api\Transactions\Controllers\TransactionController), 'getAll')↵#16 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Routing\Route.php(160): Illuminate\Routing\Route->runController()↵#17 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Routing\Router.php(572): Illuminate\Routing\Route->run()↵#18 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))↵#19 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Auth\Middleware\Authenticate.php(43): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))↵#20 D:\work\kurdis\Songa\songa-api\infrastructure\Auth\Middleware\AccessTokenChecker.php(29): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure), 'api')↵#21 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): Infrastructure\Auth\Middleware\AccessTokenChecker->handle(Object(Illuminate\Http\Request), Object(Closure), 'api')↵#22 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))↵#23 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))↵#24 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Routing\Router.php(574): Illuminate\Pipeline\Pipeline->then(Object(Closure))↵#25 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Routing\Router.php(533): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))↵#26 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Routing\Router.php(511): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)…uminate\Http\Request))↵#20 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))↵#21 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Routing\Router.php(574): Illuminate\Pipeline\Pipeline->then(Object(Closure))↵#22 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Routing\Router.php(533): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))↵#23 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Routing\Router.php(511): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))↵#24 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(176): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))↵#25 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))↵#26 D:\work\kurdis\Songa\songa-api\vendor\barryvdh\laravel-cors\src\HandleCors.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))↵#27 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): Barryvdh\Cors\HandleCors->handle(Object(Illuminate\Http\Request), Object(Closure))↵#28 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))↵#29 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TransformsRequest.php(30): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))↵#30 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))↵#31 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))↵#32 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))↵#33 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))↵#34 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))↵#35 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))↵#36 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))↵#37 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))↵#38 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))↵#39 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))↵#40 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))↵#41 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))↵#42 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(151): Illuminate\Pipeline\Pipeline->then(Object(Closure))↵#43 D:\work\kurdis\Songa\songa-api\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))↵#44 D:\work\kurdis\Songa\songa-api\public\index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))↵#45 D:\work\kurdis\Songa\songa-api\server.php(21): require_once('D:\\work\\kurdis\\...')↵#46 {main}"