Hello on the last version, when i would save planning reference i have this trace:
2019-09-24 11:10:51.033 ***** ERROR ***** [V8.2.1] Exception-[42703] SQLSTATE[42703]: Undefined column: 7 ERROR: column "minimumthreshold" of relation "planningelementbaseline" does not exist
LINE 1: ...lementary, idle, done, cancelled, idPlanningMode, minimumThr...
^
2019-09-24 11:10:51.033 ***** ERROR ***** [V8.2.1] For query : INSERT INTO planningelementbaseline (idProject, refType, refId, refName, initialStartDate, validatedStartDate, validatedStartFraction, plannedStartDate, plannedStartFraction, realStartDate, initialEndDate, validatedEndDate, validatedEndFraction, plannedEndDate, plannedEndFraction, realEndDate, initialDuration, validatedDuration, plannedDuration, realDuration, initialWork, validatedWork, assignedWork, plannedWork, leftWork, realWork, progress, validatedCost, assignedCost, plannedCost, leftCost, realCost, expectedProgress, wbs, wbsSortable, topId, topRefType, topRefId, priority, elementary, idle, done, cancelled, idPlanningMode, minimumThreshold, indivisibility, idBill, validatedCalculated, validatedExpenseCalculated, latestStartDate, latestEndDate, isOnCriticalPath, notPlannedWork, isManualProgress, surbooked, idBaseline)
SELECT idProject, refType, refId, refName, initialStartDate, validatedStartDate, validatedStartFraction, plannedStartDate, plannedStartFraction, realStartDate, initialEndDate, validatedEndDate, validatedEndFraction, plannedEndDate, plannedEndFraction, realEndDate, initialDuration, validatedDuration, plannedDuration, realDuration, initialWork, validatedWork, assignedWork, plannedWork, leftWork, realWork, progress, validatedCost, assignedCost, plannedCost, leftCost, realCost, expectedProgress, wbs, wbsSortable, topId, topRefType, topRefId, priority, elementary, idle, done, cancelled, idPlanningMode, minimumThreshold, indivisibility, idBill, validatedCalculated, validatedExpenseCalculated, latestStartDate, latestEndDate, isOnCriticalPath, notPlannedWork, isManualProgress, surbooked, 11 FROM planningelement as PlanningElement
where idProject in (56, 59, 60)
2019-09-24 11:10:51.033 ***** ERROR ***** [V8.2.1] Strack trace :
2019-09-24 11:10:51.033 ***** ERROR ***** [V8.2.1] #0 Sql->query called at [/var/www/html/model/persistence/SqlDirectElement.php:83]
2019-09-24 11:10:51.033 ***** ERROR ***** [V8.2.1] #1 SqlDirectElement->execute called at [/var/www/html/model/Baseline.php:115]
2019-09-24 11:10:51.033 ***** ERROR ***** [V8.2.1] #2 Baseline->copyItem called at [/var/www/html/model/Baseline.php:76]
2019-09-24 11:10:51.033 ***** ERROR ***** [V8.2.1] #3 Baseline->saveWithPlanning called at [/var/www/html/tool/savePlanningBaseline.php:64]
2019-09-24 11:10:51.034 ***** ERROR ***** [V8.2.1] Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-09-24 11:10:51.034 ***** ERROR ***** [V8.2.1] For query : select * from project where id=56
2019-09-24 11:10:51.034 ***** ERROR ***** [V8.2.1] Strack trace :
2019-09-24 11:10:51.034 ***** ERROR ***** [V8.2.1] #0 Sql->query called at [/var/www/html/model/persistence/SqlElement.php:2939]
2019-09-24 11:10:51.034 ***** ERROR ***** [V8.2.1] #1 SqlElement->getSqlElement called at [/var/www/html/model/persistence/SqlElement.php:672]
2019-09-24 11:10:51.034 ***** ERROR ***** [V8.2.1] #2 SqlElement->__construct called at [/var/www/html/model/ProjectMain.php:188]
2019-09-24 11:10:51.034 ***** ERROR ***** [V8.2.1] #3 ProjectMain->__construct called at [/var/www/html/model/Project.php:40]
2019-09-24 11:10:51.034 ***** ERROR ***** [V8.2.1] #4 Project->__construct called at [/var/www/html/model/Baseline.php:111]
2019-09-24 11:10:51.034 ***** ERROR ***** [V8.2.1] #5 Baseline->copyItem called at [/var/www/html/model/Baseline.php:77]
2019-09-24 11:10:51.034 ***** ERROR ***** [V8.2.1] #6 Baseline->saveWithPlanning called at [/var/www/html/tool/savePlanningBaseline.php:64]
2019-09-24 11:10:51.034 ***** ERROR ***** [V8.2.1] Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-09-24 11:10:51.034 ***** ERROR ***** [V8.2.1] For query : select * from project where project.idProject is null and project.idle=0
2019-09-24 11:10:51.034 ***** ERROR ***** [V8.2.1] Strack trace :
2019-09-24 11:10:51.034 ***** ERROR ***** [V8.2.1] #0 Sql->query called at [/var/www/html/model/persistence/SqlElement.php:2480]
2019-09-24 11:10:51.034 ***** ERROR ***** [V8.2.1] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/html/model/ProjectMain.php:502]
2019-09-24 11:10:51.034 ***** ERROR ***** [V8.2.1] #2 ProjectMain->getRecursiveSubProjects called at [/var/www/html/model/ProjectMain.php:530]
2019-09-24 11:10:51.034 ***** ERROR ***** [V8.2.1] #3 ProjectMain->getRecursiveSubProjectsFlatList called at [/var/www/html/model/Baseline.php:114]
2019-09-24 11:10:51.034 ***** ERROR ***** [V8.2.1] #4 Baseline->copyItem called at [/var/www/html/model/Baseline.php:77]
2019-09-24 11:10:51.034 ***** ERROR ***** [V8.2.1] #5 Baseline->saveWithPlanning called at [/var/www/html/tool/savePlanningBaseline.php:64]
2019-09-24 11:10:51.034 ***** ERROR ***** [V8.2.1] Exception-[42601] SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near ")"
LINE 3: where idProject in ()
^
2019-09-24 11:10:51.034 ***** ERROR ***** [V8.2.1] For query : INSERT INTO plannedworkbaseline (surbooked, surbookedWork, idResource, idProject, refType, refId, idAssignment, work, workDate, day, week, month, year, dailyCost, cost, idBaseline)
SELECT surbooked, surbookedWork, idResource, idProject, refType, refId, idAssignment, work, workDate, day, week, month, year, dailyCost, cost, 11 FROM plannedwork as PlannedWork
where idProject in ()
2019-09-24 11:10:51.034 ***** ERROR ***** [V8.2.1] Strack trace :
2019-09-24 11:10:51.034 ***** ERROR ***** [V8.2.1] #0 Sql->query called at [/var/www/html/model/persistence/SqlDirectElement.php:83]
2019-09-24 11:10:51.034 ***** ERROR ***** [V8.2.1] #1 SqlDirectElement->execute called at [/var/www/html/model/Baseline.php:115]
2019-09-24 11:10:51.034 ***** ERROR ***** [V8.2.1] #2 Baseline->copyItem called at [/var/www/html/model/Baseline.php:77]
2019-09-24 11:10:51.034 ***** ERROR ***** [V8.2.1] #3 Baseline->saveWithPlanning called at [/var/www/html/tool/savePlanningBaseline.php:64]
2019-09-24 11:10:51.034 ***** ERROR ***** [V8.2.1] Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-09-24 11:10:51.035 ***** ERROR ***** [V8.2.1] For query : select * from project where project.idProject is null and project.idle=0
2019-09-24 11:10:51.035 ***** ERROR ***** [V8.2.1] Strack trace :
2019-09-24 11:10:51.035 ***** ERROR ***** [V8.2.1] #0 Sql->query called at [/var/www/html/model/persistence/SqlElement.php:2480]
2019-09-24 11:10:51.035 ***** ERROR ***** [V8.2.1] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/html/model/ProjectMain.php:502]
2019-09-24 11:10:51.035 ***** ERROR ***** [V8.2.1] #2 ProjectMain->getRecursiveSubProjects called at [/var/www/html/model/ProjectMain.php:530]
2019-09-24 11:10:51.035 ***** ERROR ***** [V8.2.1] #3 ProjectMain->getRecursiveSubProjectsFlatList called at [/var/www/html/model/Baseline.php:122]
2019-09-24 11:10:51.035 ***** ERROR ***** [V8.2.1] #4 Baseline->copyItem called at [/var/www/html/model/Baseline.php:77]
2019-09-24 11:10:51.035 ***** ERROR ***** [V8.2.1] #5 Baseline->saveWithPlanning called at [/var/www/html/tool/savePlanningBaseline.php:64]
2019-09-24 11:10:51.035 ***** ERROR ***** [V8.2.1] Exception-[42601] SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near ")"
Thanks for your help !