Project

General

Profile

Anomalie #22166

Clean install KO

Added by Alex ORLUC 2 months ago. Updated about 2 months ago.

Status:
Développé / Analysé (S)
Priority:
1-Majeur
Target version:
Start date:
09/20/2022
Due date:
09/29/2022
Tags Courrier:
21.03.24

Description

Les ajouts de données sql on été mis dans les sql de base et dans les script de migration ce qui provoque des erreurs sql.

Il faut le mettre uniquement dans les script de migration (après installation, il se chargera de mettre à niveau la base de données).


Related issues

Related to Backlog Courrier - Anomalie #22189: Script de migration : Erreur SQL de déploiement du tag 21.03.23Développé / Analysé (S)2022-09-152022-09-29

History

#1 Updated by Emmanuel DILLARD 2 months ago

  • Due date set to 09/23/2022
  • Status changed from A traiter to En cours de dev (S)

#2 Updated by Jean-Laurent DUZANT 2 months ago

  • Assignee changed from Emmanuel DILLARD to Jean-Laurent DUZANT

#4 Updated by GIT LAB 2 months ago

Commit ajouté sur la branche fix/22166/21.03_TMA7 de MaarchCourrier par Jean-Laurent jean-laurent.duzant@xelians.fr
FIX #22166 TIME 0 remove certified_response and suggest_links_n_days_ago from data_en.sql data_fr.sql since migration 21.03.22
https://labs.maarch.org/maarch/MaarchCourrier/commit/964a11634c2f3735d65198fa67e666d0cbf3419b

#5 Updated by GIT LAB 2 months ago

Commit ajouté sur la branche fix/22166/21.03 de MaarchCourrier par Jean-Laurent jean-laurent.duzant@xelians.fr
FIX #22166 TIME 0 remove suggest_links_n_days_ago from data_en.sql data_fr.sql since migration 21.03.22
https://labs.maarch.org/maarch/MaarchCourrier/commit/c018f7639322c6fc0c5fcc282dc324a1671b40cb

#6 Updated by Jean-Laurent DUZANT 2 months ago

  • Status changed from En cours de dev (S) to A tester (S)

#7 Updated by Emmanuel DILLARD 2 months ago

  • Related to Anomalie #22189: Script de migration : Erreur SQL de déploiement du tag 21.03.23 added

#8 Updated by Emmanuel DILLARD 2 months ago

  • Due date changed from 09/23/2022 to 09/29/2022

Contournement :

Exécuter la commande :

UPDATE parameters SET param_value_string = '21.03.22' WHERE id = 'database_version';

vérifie le tag du code avec un git branch --show-current, ça doit être 21.03.23

#9 Updated by Emmanuel DILLARD 2 months ago

  • Priority changed from 0-Bloquant to 1-Majeur

#10 Updated by Hamza HRAMCHI 2 months ago

  • Status changed from A tester (S) to Développé / Analysé (S)

#11 Updated by GIT LAB 2 months ago

#13 Updated by Alex ORLUC 2 months ago

  • Status changed from Développé / Analysé (S) to En cours de dev (S)

#15 Updated by GIT LAB 2 months ago

Commit ajouté sur la branche fix/22166/21.03/part_2 de MaarchCourrier par Alex ORLUC alex.orluc@maarch.org
FIX #22166 TIME 2 fix set sequences + add missing ones + remove address_sector in structure (add in tag 21.03.5)
https://labs.maarch.org/maarch/MaarchCourrier/commit/f21dc4c8b3961dbe89bdfed11148b10826d95b2a

#16 Updated by GIT LAB 2 months ago

Commit ajouté sur la branche fix/22166/develop de MaarchCourrier par Jean-Laurent jean-laurent.duzant@xelians.fr
FIX #22166 TIME 0 fix set sequences + add missing
https://labs.maarch.org/maarch/MaarchCourrier/commit/50860f0344c2e6432af32c89d47879b2d8728913

#17 Updated by GIT LAB 2 months ago

Commit ajouté sur la branche fix/22166/21.03_TMA7 de MaarchCourrier par Jean-Laurent jean-laurent.duzant@xelians.fr
FIX #22166 TIME 0 fix set sequences + add missing ones + remove address_sector in structure (add in tag 21.03.5)
https://labs.maarch.org/maarch/MaarchCourrier/commit/21fb74ecac61772ea730d082daa2d8bdb99862b0

#18 Updated by GIT LAB 2 months ago

Commit ajouté sur la branche fix/22166/21.03/part_2 de MaarchCourrier par Alex ORLUC alex.orluc@maarch.org
FIX #22166 TIME 0:10 clean sql
https://labs.maarch.org/maarch/MaarchCourrier/commit/bee2e41ce5563543c8e57603dc8c6934394a8fc6

#19 Updated by GIT LAB 2 months ago

Commit ajouté sur la branche fix/22166/develop de MaarchCourrier par Alex ORLUC alex.orluc@maarch.org
FIX #22166 TIME 0:30 fix missing upgrade sql
https://labs.maarch.org/maarch/MaarchCourrier/commit/27276619bd5f0abc70b95b0ab51e27e2a9497499

#20 Updated by Jean-Laurent DUZANT 2 months ago

  • Status changed from En cours de dev (S) to A tester (S)

#21 Updated by Quentin RIBAC 2 months ago

  • Tags Courrier 21.03.24 added

#22 Updated by GIT LAB 2 months ago

Commit ajouté sur la branche fix/22166/21.03/part_2 de MaarchCourrier par Alex ORLUC alex.orluc@maarch.org
FIX #22166 TIME 0:10 revert sql
https://labs.maarch.org/maarch/MaarchCourrier/commit/470736dcd4d66797b44c532f53a0676c278f4dda

#23 Updated by GIT LAB 2 months ago

Commit ajouté sur la branche fix/22166/21.03/part_2 de MaarchCourrier par Quentin RIBAC quentin.ribac@xelians.fr
FIX #22166 TIME 0:10 add useSectorsForAddresses parameter
https://labs.maarch.org/maarch/MaarchCourrier/commit/7b4f0a40e6f217ddf5df9a330ff8a8880915b62a

#24 Updated by GIT LAB 2 months ago

Commit ajouté sur la branche fix/22166/21.03/part_2 de MaarchCourrier par Quentin RIBAC quentin.ribac@xelians.fr
FIX #22166 TIME 0:05 SQL: always DELETE before INSERT in migration scripts
https://labs.maarch.org/maarch/MaarchCourrier/commit/e36a93df84faf6a71bb079ca91e97c5e4aeefb88

#26 Updated by GIT LAB 2 months ago

Commit ajouté sur la branche fix/22166/develop de MaarchCourrier par Quentin RIBAC quentin.ribac@xelians.fr
FIX #22166 TIME 0:30 SQL default data: insert useSectorsForAddresses into parameters
https://labs.maarch.org/maarch/MaarchCourrier/commit/66c47778e9534bf88aa99b2c93114cb357725057

#27 Updated by Hamza HRAMCHI about 2 months ago

  • Status changed from A tester (S) to Développé / Analysé (S)

#29 Updated by GIT LAB about 2 months ago

Also available in: Atom PDF