View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] save planning reference (on 8.2.1) - ProjeQtOr

Prochaines sessions de formation

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Mardi 23 avril (10h30-12h)

Jeudi 16 mai (16h-17h30)

Jeudi 13 juin (10h30-12h)

 
 

Planifiez avec ProjeQtOr

3 et 4 avril (9h - 12h30)

 
 

Administrez avec ProjeQtOr

10 et 11 avril (9h - 12h30)

 

 

 
 

[SOLVED] save planning reference (on 8.2.1)

More
29 Aoû 2019 14:04 #1 by pipobru
Hello, on last version (8.1.5) when i would save planning reference i have this sql error:

2019-08-29 13:41:55.798 ***** ERROR ***** [V8.1.5] Exception-[42703] SQLSTATE[42703]: Undefined column: 7 ERROR: column "surbooked" does not exist
LINE 2: SELECT surbooked, surbookedWork, idResource, idProject, refT...
^
HINT: There is a column named "surbooked" in table "plannedworkbaseline", but it cannot be referenced from this part of the query.
2019-08-29 13:41:55.798 ***** ERROR ***** [V8.1.5] For query : INSERT INTO plannedworkbaseline (surbooked, surbookedWork, idResource, idProject, refType, refId, idAssignment, work, workDate, day, week, month, year, dailyCost, cost, idBaseline, isRealWork)
SELECT surbooked, surbookedWork, idResource, idProject, refType, refId, idAssignment, work, workDate, day, week, month, year, dailyCost, cost, 9, 1 FROM work
where idProject in (41, 55)
2019-08-29 13:41:55.798 ***** ERROR ***** [V8.1.5] Strack trace :
2019-08-29 13:41:55.798 ***** ERROR ***** [V8.1.5] #0 Sql->query called at [/var/www/html/model/persistence/SqlDirectElement.php:83]
2019-08-29 13:41:55.798 ***** ERROR ***** [V8.1.5] #1 SqlDirectElement->execute called at [/var/www/html/model/Baseline.php:122]
2019-08-29 13:41:55.798 ***** ERROR ***** [V8.1.5] #2 Baseline->copyItem called at [/var/www/html/model/Baseline.php:77]
2019-08-29 13:41:55.798 ***** ERROR ***** [V8.1.5] #3 Baseline->saveWithPlanning called at [/var/www/html/tool/savePlanningBaseline.php:64]
2019-08-29 13:44:24.046 ***** ERROR ***** [V8.1.5] Exception-[42703] SQLSTATE[42703]: Undefined column: 7 ERROR: column "surbooked" does not exist
LINE 2: SELECT surbooked, surbookedWork, idResource, idProject, refT...

My databe is postgresql

VEry thanks for your answer

Please Connexion or Create an account to join the conversation.

More
04 Sep 2019 18:27 #2 by babynus
Replied by babynus on topic save planning reference
Hi,

Issue confirmed...
..and fixed.

Fix is to replace in Baline.php lines 116+ from
    if ($itemFrom=='PlannedWork') { // Also include existing real work
      $objFrom=new Work();
      $tableFrom=$objFrom->getDatabaseTableName();
      $colListWork=str_replace(array('surbookedWork','surbooked'), array('0','0'), $colList);
      $query="INSERT INTO $tableTo ($colList idBaseline, isRealWork)\n"
      ."SELECT $colListWork $idBaseline, 1 FROM $tableFrom \n"
      ." where idProject in ".transformListIntoInClause($proj->getRecursiveSubProjectsFlatList(true, true));
      $res=SqlDirectElement::execute($query);
    }
to
    if ($itemFrom=='PlannedWork') { // Also include existing real work
      $objFrom=new Work();
      $tableFrom=$objFrom->getDatabaseTableName();
      $colListWork=str_replace(array('surbookedWork','surbooked'), array('0','0'), $colList);
      $query="INSERT INTO $tableTo ($colList idBaseline, isRealWork)\n"
      ."SELECT $colListWork $idBaseline, 1 FROM $tableFrom \n"
      ." where idProject in ".transformListIntoInClause($proj->getRecursiveSubProjectsFlatList(true, true));
      $res=SqlDirectElement::execute($query);
    }

Fix will be included in patch V8.1.6

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
24 Sep 2019 11:15 #3 by pipobru
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 !

Please Connexion or Create an account to join the conversation.

More
26 Sep 2019 12:02 #4 by babynus
Issue recorded as Ticket #4224

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.048 seconds

Paramétrages de cookies

×

Cookies fonctionnels

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Veuillez vous connecter pour voir vos activités!

Autres cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.