Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

[SOLVED] Planning n...
 
Notifications
Clear all

[SOLVED] Planning not saved in 9.1.1

3 Posts
2 Users
0 Reactions
2,162 Views
(@pipobru)
Posts: 180
Active Member
Topic starter
 
[#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.


 
Posted : 09 Apr 2021 20H57
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

This is fixed on V9.1.2


 
Posted : 09 Apr 2021 21H02
(@pipobru)
Posts: 180
Active Member
Topic starter
 

Thanks ! is perfect with the last update.


 
Posted : 14 Apr 2021 13H55
Share:

Scroll to Top