Anomalie #19450
UpdateVersionSQL en erreur sur le tag 21.03.14
Start date:
01/12/2022
Due date:
Tags Courrier:
21.03.15
Description
La création de nouvelle instance provoque l'erreur suivante :
{ "message": "Slim Application Error", "exception": [ { "type": "Exception", "code": 0, "message": "SQLSTATE[23505]: Unique violation: 7 ERROR: duplicate key value violates unique constraint \"attachment_types_unique_key\"\nDETAIL: Key (type_id)=(shipping_deposit_proof) already exists.", "file": "\/var\/www\/html\/MaarchCourrier\/src\/core\/models\/DatabasePDO.php", "line": 159, "trace": [ "#0 \/var\/www\/html\/MaarchCourrier\/src\/core\/models\/DatabaseModel.php(331): SrcCore\\models\\DatabasePDO->exec('-- ************...')", "#1 \/var\/www\/html\/MaarchCourrier\/src\/app\/versionUpdate\/controllers\/VersionUpdateController.php(263): SrcCore\\models\\DatabaseModel::exec('-- ************...')", "#2 \/var\/www\/html\/MaarchCourrier\/src\/app\/versionUpdate\/controllers\/VersionUpdateController.php(294): VersionUpdate\\controllers\\VersionUpdateController::executeSQLUpdate(Array)", "#3 [internal function]: VersionUpdate\\controllers\\VersionUpdateController->updateSQLVersion(Object(Slim\\Http\\Request), Object(Slim\\Http\\Response), Array)", "#4 \/var\/www\/html\/MaarchCourrier\/vendor\/slim\/slim\/Slim\/Handlers\/Strategies\/RequestResponse.php(40): call_user_func(Array, Object(Slim\\Http\\Request), Object(Slim\\Http\\Response), Array)", "#5 \/var\/www\/html\/MaarchCourrier\/vendor\/slim\/slim\/Slim\/Route.php(281): Slim\\Handlers\\Strategies\\RequestResponse->__invoke(Array, Object(Slim\\Http\\Request), Object(Slim\\Http\\Response), Array)", "#6 \/var\/www\/html\/MaarchCourrier\/vendor\/slim\/slim\/Slim\/MiddlewareAwareTrait.php(117): Slim\\Route->__invoke(Object(Slim\\Http\\Request), Object(Slim\\Http\\Response))", "#7 \/var\/www\/html\/MaarchCourrier\/vendor\/slim\/slim\/Slim\/Route.php(268): Slim\\Route->callMiddlewareStack(Object(Slim\\Http\\Request), Object(Slim\\Http\\Response))", "#8 \/var\/www\/html\/MaarchCourrier\/vendor\/slim\/slim\/Slim\/App.php(503): Slim\\Route->run(Object(Slim\\Http\\Request), Object(Slim\\Http\\Response))", "#9 \/var\/www\/html\/MaarchCourrier\/rest\/index.php(52): Slim\\App->__invoke(Object(Slim\\Http\\Request), Object(Slim\\Http\\Response))", "#10 [internal function]: Closure->{closure}(Object(Slim\\Http\\Request), Object(Slim\\Http\\Response), Object(Slim\\App))", "#11 \/var\/www\/html\/MaarchCourrier\/vendor\/slim\/slim\/Slim\/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array)", "#12 [internal function]: Slim\\DeferredCallable->__invoke(Object(Slim\\Http\\Request), Object(Slim\\Http\\Response), Object(Slim\\App))", "#13 \/var\/www\/html\/MaarchCourrier\/vendor\/slim\/slim\/Slim\/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\\DeferredCallable), Object(Slim\\Http\\Request), Object(Slim\\Http\\Response), Object(Slim\\App))", "#14 \/var\/www\/html\/MaarchCourrier\/vendor\/slim\/slim\/Slim\/MiddlewareAwareTrait.php(117): Slim\\App->Slim\\{closure}(Object(Slim\\Http\\Request), Object(Slim\\Http\\Response))", "#15 \/var\/www\/html\/MaarchCourrier\/vendor\/slim\/slim\/Slim\/App.php(392): Slim\\App->callMiddlewareStack(Object(Slim\\Http\\Request), Object(Slim\\Http\\Response))", "#16 \/var\/www\/html\/MaarchCourrier\/vendor\/slim\/slim\/Slim\/App.php(297): Slim\\App->process(Object(Slim\\Http\\Request), Object(Slim\\Http\\Response))", "#17 \/var\/www\/html\/MaarchCourrier\/rest\/index.php(729): Slim\\App->run()", "#18 {main}" ] } ] }
cet id a été ajouté dans la base de donnée, il faudrait le supprimer afin que le script d'update puisse continuer.
History
#1 Updated by Ines MKACHER 4 months ago
- Due date set to 01/17/2022
- Status changed from A traiter to A étudier
#3 Updated by Ines MKACHER 4 months ago
- Due date deleted (
01/17/2022) - Status changed from A étudier to Prêt à développer
- Target version set to 21.03 (stable)
#4 Updated by Ines MKACHER 4 months ago
- Status changed from Prêt à développer to En cours de dev (S)
- Priority changed from 2-Sérieux to 1-Majeur
#5 Updated by GIT LAB 4 months ago
Commit ajouté sur la branche fix/19450/21.03 de MaarchCourrier par Jean-Laurent jean-laurent.duzant@xelians.fr
FIX #19450 TIME 0:30 fix database version in data_fr.sql && data_en.sql - Jean-Laurent
https://labs.maarch.org/maarch/MaarchCourrier/commit/98fa19a6fbe81f53a3c9d858a169de3c72442902
#6 Updated by Jean-Laurent DUZANT 4 months ago
- Status changed from En cours de dev (S) to A tester (S)
#7 Updated by GIT LAB 4 months ago
[MERGE REQUEST] Mergé sur 21.03 (https://labs.maarch.org/maarch/MaarchCourrier/-/merge_requests/574)
#8 Updated by Hamza HRAMCHI 4 months ago
- Status changed from A tester (S) to Développé / Analysé (S)
#9 Updated by Ines MKACHER 3 months ago
- Tags Courrier 21.03.15 added