Illuminate\Database\QueryException: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tok...
Sentry Issue: CATTR-CORE-4Z
PDOException: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens
File "/app/Models/Role.php", line 248, in App\Models\Role::can
])->first();
File "/app/Http/Controllers/Api/TaskController.php", line 415, in App\Http\Controllers\Api\TaskController::getQuery
$full_access = Role::can($user, 'tasks', 'full_access');
File "/app/Http/Controllers/Api/TaskController.php", line 92, in App\Http\Controllers\Api\TaskController::index
$this->getQuery(),
File "/app/Http/Middleware/RoleCheck.php", line 63, in App\Http\Middleware\RoleCheck::handle
return $next($request);
File "/app/Http/Middleware/Authenticate.php", line 48, in App\Http\Middleware\Authenticate::handle
return $next($request);
...
(51 additional frame(s) were not displayed)
Doctrine\DBAL\Driver\PDOException: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens
File "/app/Models/Role.php", line 248, in App\Models\Role::can
])->first();
File "/app/Http/Controllers/Api/TaskController.php", line 415, in App\Http\Controllers\Api\TaskController::getQuery
$full_access = Role::can($user, 'tasks', 'full_access');
File "/app/Http/Controllers/Api/TaskController.php", line 92, in App\Http\Controllers\Api\TaskController::index
$this->getQuery(),
File "/app/Http/Middleware/RoleCheck.php", line 63, in App\Http\Middleware\RoleCheck::handle
return $next($request);
File "/app/Http/Middleware/Authenticate.php", line 48, in App\Http\Middleware\Authenticate::handle
return $next($request);
...
(50 additional frame(s) were not displayed)
Illuminate\Database\QueryException: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens (SQL: select * from `projects_users` where (`project_id` = = and `user_id` = 15) limit 1)
File "/app/Models/Role.php", line 248, in App\Models\Role::can
])->first();
File "/app/Http/Controllers/Api/TaskController.php", line 415, in App\Http\Controllers\Api\TaskController::getQuery
$full_access = Role::can($user, 'tasks', 'full_access');
File "/app/Http/Controllers/Api/TaskController.php", line 92, in App\Http\Controllers\Api\TaskController::index
$this->getQuery(),
File "/app/Http/Middleware/RoleCheck.php", line 63, in App\Http\Middleware\RoleCheck::handle
return $next($request);
File "/app/Http/Middleware/Authenticate.php", line 48, in App\Http\Middleware\Authenticate::handle
return $next($request);
...
(48 additional frame(s) were not displayed)
[2020-10-18 16:22:58] production.ERROR: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens (SQL: select * from `projects_users` where (`project_id` = = and `user_id` = 15) limit 1) {"userId":38,"exception":"[object] (Illuminate\\Database\\QueryException(code: HY093): SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens (SQL: select * from `projects_users` where (`project_id` = = and `user_id` = 15) limit 1) at /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671)
[stacktrace]
#0 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\\Database\\Connection->runQueryCallback()
#1 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Database/Connection.php(339): Illuminate\\Database\\Connection->run()
#2 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2202): Illuminate\\Database\\Connection->select()
#3 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2190): Illuminate\\Database\\Query\\Builder->runSelect()
#4 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2685): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#5 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2191): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#6 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(539): Illuminate\\Database\\Query\\Builder->get()
#7 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(523): Illuminate\\Database\\Eloquent\\Builder->getModels()
#8 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(143): Illuminate\\Database\\Eloquent\\Builder->get()
#9 /opt/cattr/cattr/backend/app/Models/Role.php(248): Illuminate\\Database\\Eloquent\\Builder->first()
#10 /opt/cattr/cattr/backend/app/Http/Controllers/Api/TaskController.php(415): App\\Models\\Role::can()
#11 /opt/cattr/cattr/backend/app/Http/Controllers/Api/TaskController.php(92): App\\Http\\Controllers\\Api\\TaskController->getQuery()
#12 [internal function]: App\\Http\\Controllers\\Api\\TaskController->index()
#13 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): call_user_func_array()
#14 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction()
#15 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Routing/Route.php(239): Illuminate\\Routing\\ControllerDispatcher->dispatch()
#16 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Routing/Route.php(196): Illuminate\\Routing\\Route->runController()
#17 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Routing/Router.php(685): Illuminate\\Routing\\Route->run()
#18 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()
#19 /opt/cattr/cattr/backend/app/Http/Middleware/RoleCheck.php(63): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#20 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): App\\Http\\Middleware\\RoleCheck->handle()
#21 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#22 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle()
#23 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(59): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#24 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle()
#25 /opt/cattr/cattr/backend/app/Http/Middleware/Authenticate.php(48): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#26 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): App\\Http\\Middleware\\Authenticate->handle()
#27 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#28 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Routing/Router.php(687): Illuminate\\Pipeline\\Pipeline->then()
#29 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Routing/Router.php(662): Illuminate\\Routing\\Router->runRouteWithinStack()
#30 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Routing/Router.php(628): Illuminate\\Routing\\Router->runRoute()
#31 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Routing/Router.php(617): Illuminate\\Routing\\Router->dispatchToRoute()
#32 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(165): Illuminate\\Routing\\Router->dispatch()
#33 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()
#34 /opt/cattr/cattr/backend/app/Http/Middleware/SentryContext.php(35): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#35 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): App\\Http\\Middleware\\SentryContext->handle()
#36 /opt/cattr/cattr/backend/app/Http/Middleware/LockMiddleware.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#37 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): App\\Http\\Middleware\\LockMiddleware->handle()
#38 /opt/cattr/cattr/backend/vendor/fruitcake/laravel-cors/src/HandleCors.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#39 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Fruitcake\\Cors\\HandleCors->handle()
#40 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#41 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#42 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#43 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#44 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#45 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle()
#46 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(63): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#47 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle()
#48 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#49 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(140): Illuminate\\Pipeline\\Pipeline->then()
#50 /opt/cattr/cattr/backend/vendor/laravel/framework/src/Illumin...