Enregistrement d'un labdoc sur une report part supprimée
- Role : étudiant
- Page(s) / Url(s) :
report/<id_report>
- Comportement actuel (si besoin) : Un étudiant ouvre un rapport et démarre un LD sur une report part, un enseignant édite la mission du rapport et supprime cette report part, l'étudiant valide le LD : il obtient une erreur 500.
- Comportement attendu : Que faire ? Un message d'erreur clair, s'assurer que l'étudiant peut enregistrer le LD dans un autre RP, sauter à la RP la plus proche ?
- Proposition technique : Enregistrer dans la RP la plus proche (à définir), prévenir l'étudiant qu'il doit faire F5
- TODO :
-
Valider la solution -
Voir si dans l'état actuel l'étudiant peut faire quelque chose
-
Remontée automatique du 21/09/2023
Une erreur est survenue sur https://uga.labnbook.fr : SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (labnbook.labdoc, CONSTRAINT labdoc_ibfk_1 FOREIGN KEY (id_report_part) REFERENCES report_part (id_report_part) ON DELETE CASCADE ON UPDATE CASCADE) (SQL: insert into labdoc (id_report_part, id_report, type_labdoc, name, position, locked, last_editor, labdoc_data) values (10363, 81025, text, , 1, 1695303915, 20329, ))
Contexte
- Message :
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (labnbook.labdoc, CONSTRAINT labdoc_ibfk_1 FOREIGN KEY (id_report_part) REFERENCES report_part (id_report_part) ON DELETE CASCADE ON UPDATE CASCADE) (SQL: insert into labdoc (id_report_part, id_report, type_labdoc, name, position, locked, last_editor, labdoc_data) values (10363, 81025, text, , 1, 1695303915, 20329, ))
- Url : https://uga.labnbook.fr/report/81025/addLD
- Classe : Illuminate\Database\QueryException
- Code : 23000
- Id Utilisateur : 20329
Trace :
#0 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Database/Connection.php(719): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Database/Connection.php(545): Illuminate\Database\Connection->run()
#2 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Database/Connection.php(497): Illuminate\Database\Connection->statement()
#3 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/Processor.php(32): Illuminate\Database\Connection->insert()
#4 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3246): Illuminate\Database\Query\Processors\Processor->processInsertGetId()
#5 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1858): Illuminate\Database\Query\Builder->insertGetId()
#6 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1216): Illuminate\Database\Eloquent\Builder->__call()
#7 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1181): Illuminate\Database\Eloquent\Model->insertAndSetId()
#8 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1022): Illuminate\Database\Eloquent\Model->performInsert()
#9 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(975): Illuminate\Database\Eloquent\Model->save()
#10 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Support/helpers.php(302): Illuminate\Database\Eloquent\Builder->Illuminate\Database\Eloquent\{closure}()
#11 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(976): tap()
#12 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\Database\Eloquent\Builder->create()
#13 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2191): Illuminate\Database\Eloquent\Model->forwardCallTo()
#14 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2203): Illuminate\Database\Eloquent\Model->__call()
#15 /var/www/labnbook/app/Labdoc.php(249): Illuminate\Database\Eloquent\Model::__callStatic()
#16 /var/www/labnbook/app/Report.php(437): App\Labdoc::init()
#17 /var/www/labnbook/app/Http/Controllers/ReportController.php(446): App\Report->addLD()
#18 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\Http\Controllers\ReportController->addLD()
#19 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction()
#20 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Routing/Route.php(261): Illuminate\Routing\ControllerDispatcher->dispatch()
#21 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Routing/Route.php(204): Illuminate\Routing\Route->runController()
#22 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Routing/Router.php(725): Illuminate\Routing\Route->run()
#23 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Routing\Router->Illuminate\Routing\{closure}()
#24 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#25 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Routing\Middleware\SubstituteBindings->handle()
#26 /var/www/labnbook/app/Http/Middleware/Language.php(19): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#27 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\Language->handle()
#28 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(44): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#29 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Auth\Middleware\Authenticate->handle()
#30 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#31 /var/www/labnbook/app/Http/Middleware/VerifyCsrfToken.php(41): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle()
#32 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\VerifyCsrfToken->handle()
#33 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#34 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\View\Middleware\ShareErrorsFromSession->handle()
#35 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#36 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Session\Middleware\StartSession->handleStatefulRequest()
#37 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Session\Middleware\StartSession->handle()
#38 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#39 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle()
#40 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#41 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Cookie\Middleware\EncryptCookies->handle()
#42 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#43 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Routing/Router.php(726): Illuminate\Pipeline\Pipeline->then()
#44 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Routing/Router.php(703): Illuminate\Routing\Router->runRouteWithinStack()
#45 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Routing/Router.php(667): Illuminate\Routing\Router->runRoute()
#46 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Routing/Router.php(656): Illuminate\Routing\Router->dispatchToRoute()
#47 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(167): Illuminate\Routing\Router->dispatch()
#48 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}()
#49 /var/www/labnbook/vendor/fruitcake/laravel-cors/src/HandleCors.php(38): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#50 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Fruitcake\Cors\HandleCors->handle()
#51 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#52 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()
#53 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle()
#54 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#55 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()
#56 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\TrimStrings->handle()
#57 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#58 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle()
#59 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#60 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle()
#61 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#62 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Http\Middleware\TrustProxies->handle()
#63 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#64 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(142): Illuminate\Pipeline\Pipeline->then()
#65 /var/www/labnbook/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(111): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter()
#66 /var/www/labnbook/public/index.php(55): Illuminate\Foundation\Http\Kernel->handle()
#67 {main}
Informations supplémentaires
Requête
{
"id_rp": "10363",
"type": "text"
}
``
Edited by David Beniamine