BUG: Delete team

[jdorel]

Additional context : user was an admin

Illuminate\Database\QueryException thrown with message "SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (integration.teams, CONSTRAINT teams_respo_id_foreign FOREIGN KEY (respo_id) REFERENCES users (id)) (SQL: delete from teams where id = 6)"

Possible solution : remove team owner before removing the team
Related file :

integration-UTT/app/Http/Controllers/Admin/TeamsController.php

Line 248 in 3f2bfe5

$team->delete();

Stacktrace:
#64 Illuminate\Database\QueryException in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664
#63 Doctrine\DBAL\Driver\PDOException in /opt/app-root/src/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:119
#62 PDOException in /opt/app-root/src/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
#61 PDOStatement:execute in /opt/app-root/src/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
#60 Doctrine\DBAL\Driver\PDOStatement:execute in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Database/Connection.php:483
#59 Illuminate\Database\Connection:Illuminate\Database\{closure} in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Database/Connection.php:657
#58 Illuminate\Database\Connection:runQueryCallback in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624
#57 Illuminate\Database\Connection:run in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Database/Connection.php:490
#56 Illuminate\Database\Connection:affectingStatement in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Database/Connection.php:435
#55 Illuminate\Database\Connection:delete in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2804
#54 Illuminate\Database\Query\Builder:delete in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:895
#53 Illuminate\Database\Eloquent\Builder:delete in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php:935
#52 Illuminate\Database\Eloquent\Model:performDeleteOnModel in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php:906
#51 Illuminate\Database\Eloquent\Model:delete in /opt/app-root/src/app/Http/Controllers/Admin/TeamsController.php:248
#50 App\Http\Controllers\Admin\TeamsController:adminDelete in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
#49 call_user_func_array in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
#48 Illuminate\Routing\Controller:callAction in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
#47 Illuminate\Routing\ControllerDispatcher:dispatch in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
#46 Illuminate\Routing\Route:runController in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
#45 Illuminate\Routing\Route:run in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
#44 Illuminate\Routing\Router:Illuminate\Routing\{closure} in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
#43 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in /opt/app-root/src/app/Http/Middleware/Authorize.php:47
#42 App\Http\Middleware\Authorize:handle in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
#41 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#40 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in /opt/app-root/src/app/Http/Middleware/OAuth.php:28
#39 App\Http\Middleware\OAuth:handle in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
#38 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#37 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in /opt/app-root/src/vendor/laravel/passport/src/Http/Middleware/CreateFreshApiToken.php:50
#36 Laravel\Passport\Http\Middleware\CreateFreshApiToken:handle in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
#35 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#34 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
#33 Illuminate\View\Middleware\ShareErrorsFromSession:handle in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
#32 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#31 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
#30 Illuminate\Session\Middleware\StartSession:handle in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
#29 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#28 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
#27 Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse:handle in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
#26 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#25 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
#24 Illuminate\Cookie\Middleware\EncryptCookies:handle in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
#23 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#22 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:104
#21 Illuminate\Pipeline\Pipeline:then in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Routing/Router.php:682
#20 Illuminate\Routing\Router:runRouteWithinStack in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Routing/Router.php:657
#19 Illuminate\Routing\Router:runRoute in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Routing/Router.php:623
#18 Illuminate\Routing\Router:dispatchToRoute in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Routing/Router.php:612
#17 Illuminate\Routing\Router:dispatch in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:176
#16 Illuminate\Foundation\Http\Kernel:Illuminate\Foundation\Http\{closure} in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
#15 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in /opt/app-root/src/vendor/barryvdh/laravel-debugbar/src/Middleware/InjectDebugbar.php:65
#14 Barryvdh\Debugbar\Middleware\InjectDebugbar:handle in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
#13 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#12 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in /opt/app-root/src/vendor/barryvdh/laravel-cors/src/HandleCors.php:36
#11 Barryvdh\Cors\HandleCors:handle in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
#10 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#9 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:62
#8 Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode:handle in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
#7 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#6 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in /opt/app-root/src/vendor/fideloper/proxy/src/TrustProxies.php:57
#5 Fideloper\Proxy\TrustProxies:handle in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
#4 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#3 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:104
#2 Illuminate\Pipeline\Pipeline:then in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:151
#1 Illuminate\Foundation\Http\Kernel:sendRequestThroughRouter in /opt/app-root/src/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:116
#0 Illuminate\Foundation\Http\Kernel:handle in /opt/app-root/src/public/index.php:71