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.