Forum

[SOLVED] Planning n...
 
Notifications
Retirer tout

[SOLVED] Planning not saved in 9.1.1

3 Posts
2 Utilisateurs
0 Reactions
2,126 Vu
(@pipobru)
Posts: 180
Active Member
Début du sujet
 
[#7484]

Hello,
when i would save a planning reference i have this error:2021-04-09 18:33:57.159 ** ERROR ** [V9.1.1] Exception-[42703] SQLSTATE[42703]: Undefined column: 7 ERREUR: la colonne « idleave » de la relation « plannedworkbaseline » n'existe pas
LINE 1: ...TO plannedworkbaseline (surbooked, surbookedWork, idLeave, m...
^
2021-04-09 18:33:57.159 ** ERROR ** [V9.1.1] For query : INSERT INTO plannedworkbaseline (surbooked, surbookedWork, idLeave, manual, idResource, idProject, refType, refId, idAssignment, work, workDate, day, week, month, year, dailyCost, cost, idBaseline)
SELECT surbooked, surbookedWork, idLeave, manual, idResource, idProject, refType, refId, idAssignment, work, workDate, day, week, month, year, dailyCost, cost, 91 FROM plannedwork as PlannedWork
where idProject in (0, 199)
2021-04-09 18:33:57.159 ** ERROR ** [V9.1.1] Strack trace :
2021-04-09 18:33:57.159 ** ERROR ** [V9.1.1] #0 Sql->query called at [/home/projtma/public_html/model/persistence/SqlDirectElement.php:83]
2021-04-09 18:33:57.159 ** ERROR ** [V9.1.1] #1 SqlDirectElement->execute called at [/home/projtma/public_html/model/Baseline.php:115]
2021-04-09 18:33:57.159 ** ERROR ** [V9.1.1] #2 Baseline->copyItem called at [/home/projtma/public_html/model/Baseline.php:77]
2021-04-09 18:33:57.159 ** ERROR ** [V9.1.1] #3 Baseline->saveWithPlanning called at [/home/projtma/public_html/tool/savePlanningBaseline.php:64]
2021-04-09 18:33:57.159 ** ERROR ** [V9.1.1] Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERREUR: la transaction est annulée, les commandes sont ignorées jusqu'à la fin du bloc
de la transaction
2021-04-09 18:33:57.159 ** ERROR ** [V9.1.1] For query : INSERT INTO plannedworkbaseline (surbooked, surbookedWork, idLeave, manual, idResource, idProject, refType, refId, idAssignment, work, workDate, day, week, month, year, dailyCost, cost, idBaseline, isRealWork)
SELECT 0, 0, idLeave, manual, idResource, idProject, refType, refId, idAssignment, work, workDate, day, week, month, year, dailyCost, cost, 91, 1 FROM work
where idProject in (0, 199)
2021-04-09 18:33:57.159 ** ERROR ** [V9.1.1] Strack trace :
2021-04-09 18:33:57.159 ** ERROR ** [V9.1.1] #0 Sql->query called at [/home/projtma/public_html/model/persistence/SqlDirectElement.php:83]
2021-04-09 18:33:57.159 ** ERROR ** [V9.1.1] #1 SqlDirectElement->execute called at [/home/projtma/public_html/model/Baseline.php:123]
2021-04-09 18:33:57.159 ** ERROR ** [V9.1.1] #2 Baseline->copyItem called at [/home/projtma/public_html/model/Baseline.php:77]
2021-04-09 18:33:57.159 ** ERROR ** [V9.1.1] #3 Baseline->saveWithPlanning called at [/home/projtma/public_html/tool/savePlanningBaseline.php:64]I work with postgresql database.

Very thanks for this tools, it is very very good and efficiant !

Bruno.


 
Posté : 9 Avr PM 20:044
(@babynus)
Posts: 14952
Membre Admin
 

This is fixed on V9.1.2


 
Posté : 9 Avr PM 21:044
(@pipobru)
Posts: 180
Active Member
Début du sujet
 

Thanks ! is perfect with the last update.


 
Posté : 14 Avr PM 13:044
Share:
Retour en haut