View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - any modification are available on specific project - 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)

  

 

 
 

any modification are available on specific project

More
27 Avr 2017 15:16 #1 by pipobru
any modification are available on specific project was created by pipobru
After 6.2.2 migration on a specific project i have this log and any record are possible:

2017-04-27 13:38:43.612 ***** ERROR ***** [V6.2.2] Exception-[42703] SQLSTATE[42703]: Undefined column: 7 ERROR: column "Project" does not exist
LINE 1: ... from planningelement where (refId=42 and refType="Project")...
^
HINT: Perhaps you meant to reference the column "planningelement.idproject".
2017-04-27 13:38:43.612 ***** ERROR ***** [V6.2.2] For query : select sum(validatedWork) as sumvalidatedwork, sum(assignedWork) as sumassignedwork, sum(realWork) as sumrealwork, sum(leftWork) as sumleftwork, sum(plannedWork) as sumplannedwork, sum(validatedCost) as sumvalidatedcost, sum(assignedCost) as sumassignedcost, sum(realCost) as sumrealcost, sum(leftCost) as sumleftcost, sum(plannedCost) as sumplannedcost, sum(expenseValidatedAmount) as sumexpensevalidatedamount, sum(expenseAssignedAmount) as sumexpenseassignedamount, sum(expenseRealAmount) as sumexpenserealamount, sum(expenseLeftAmount) as sumexpenseleftamount, sum(expensePlannedAmount) as sumexpenseplannedamount, sum(reserveAmount) as sumreserveamount, sum(totalValidatedCost) as sumtotalvalidatedcost, sum(totalAssignedCost) as sumtotalassignedcost, sum(totalRealCost) as sumtotalrealcost, sum(totalLeftCost) as sumtotalleftcost, sum(totalPlannedCost) as sumtotalplannedcost from planningelement where (refId=42 and refType="Project") and (
(idle=1 and
(
(isnull(realStartDate) and isnull(realEndDate)) or
(isnull(realStartDate) and year(realEndDate)=0) OR
(isnull(realEndDate)) OR
(year(realStartDate)=0 or year(realEndDate)=0)
)
) or
(idle=0 and
(
(isnull(validatedStartDate) and isnull(validatedEndDate)) or
(isnull(validatedStartDate) and year(validatedEndDate)=0) OR
(isnull(validatedEndDate)) OR
(year(validatedStartDate)=0 or year(validatedEndDate)=0)
)
)
)
2017-04-27 13:38:43.612 ***** ERROR ***** [V6.2.2] Strack trace :
2017-04-27 13:38:43.612 ***** ERROR ***** [V6.2.2] #0 Sql->query called at [/var/www/html/model/persistence/SqlElement.php:2063]
2017-04-27 13:38:43.612 ***** ERROR ***** [V6.2.2] #1 SqlElement->sumSqlElementsFromCriteria called at [/var/www/html/model/OrganizationMain.php:991]
2017-04-27 13:38:43.612 ***** ERROR ***** [V6.2.2] #2 OrganizationMain->updateSynthesis called at [/var/www/html/model/ProjectPlanningElementMain.php:199]
2017-04-27 13:38:43.612 ***** ERROR ***** [V6.2.2] #3 ProjectPlanningElementMain->save called at [/var/www/html/model/persistence/SqlElement.php:1227]
2017-04-27 13:38:43.612 ***** ERROR ***** [V6.2.2] #4 SqlElement->saveDependantObjects called at [/var/www/html/model/persistence/SqlElement.php:1168]
2017-04-27 13:38:43.612 ***** ERROR ***** [V6.2.2] #5 SqlElement->updateSqlElement called at [/var/www/html/model/persistence/SqlElement.php:704]
2017-04-27 13:38:43.612 ***** ERROR ***** [V6.2.2] #6 SqlElement->saveSqlElement called at [/var/www/html/model/persistence/SqlElement.php:542]
2017-04-27 13:38:43.612 ***** ERROR ***** [V6.2.2] #7 SqlElement->save called at [/var/www/html/model/ProjectMain.php:662]
2017-04-27 13:38:43.612 ***** ERROR ***** [V6.2.2] #8 ProjectMain->save called at [/var/www/html/tool/saveObject.php:78]
2017-04-27 13:38:43.612 ***** ERROR ***** [V6.2.2] Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block
2017-04-27 13:38:43.613 ***** ERROR ***** [V6.2.2] For query : select sum(work) as sumwork, sum(cost) as sumcost from work where year<=0 and idProject=42
2017-04-27 13:38:43.613 ***** ERROR ***** [V6.2.2] Strack trace :
2017-04-27 13:38:43.613 ***** ERROR ***** [V6.2.2] #0 Sql->query called at [/var/www/html/model/persistence/SqlElement.php:2063]
2017-04-27 13:38:43.613 ***** ERROR ***** [V6.2.2] #1 SqlElement->sumSqlElementsFromCriteria called at [/var/www/html/model/OrganizationMain.php:1030]
2017-04-27 13:38:43.613 ***** ERROR ***** [V6.2.2] #2 OrganizationMain->updateSynthesis called at [/var/www/html/model/ProjectPlanningElementMain.php:199]
2017-04-27 13:38:43.613 ***** ERROR ***** [V6.2.2] #3 ProjectPlanningElementMain->save called at [/var/www/html/model/persistence/SqlElement.php:1227]
2017-04-27 13:38:43.613 ***** ERROR ***** [V6.2.2] #4 SqlElement->saveDependantObjects called at [/var/www/html/model/persistence/SqlElement.php:1168]
2017-04-27 13:38:43.613 ***** ERROR ***** [V6.2.2] #5 SqlElement->updateSqlElement called at [/var/www/html/model/persistence/SqlElement.php:704]
2017-04-27 13:38:43.613 ***** ERROR ***** [V6.2.2] #6 SqlElement->saveSqlElement called at [/var/www/html/model/persistence/SqlElement.php:542]
2017-04-27 13:38:43.613 ***** ERROR ***** [V6.2.2] #7 SqlElement->save called at [/var/www/html/model/ProjectMain.php:662]
2017-04-27 13:38:43.613 ***** ERROR ***** [V6.2.2] #8 ProjectMain->save called at [/var/www/html/tool/saveObject.php:78]
2017-04-27 13:38:43.613 ***** ERROR ***** [V6.2.2] Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block
2017-04-27 13:38:43.613 ***** ERROR ***** [V6.2.2] For query : select * from expensedetail where expensedetail.idExpense is null order by expenseDate
2017-04-27 13:38:43.613 ***** ERROR ***** [V6.2.2] Strack trace :
2017-04-27 13:38:43.613 ***** ERROR ***** [V6.2.2] #0 Sql->query called at [/var/www/html/model/persistence/SqlElement.php:1943]
2017-04-27 13:38:43.613 ***** ERROR ***** [V6.2.2] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/html/model/Expense.php:220]
2017-04-27 13:38:43.613 ***** ERROR ***** [V6.2.2] #2 Expense->getExpenseDetail called at [/var/www/html/model/Expense.php:92]
2017-04-27 13:38:43.613 ***** ERROR ***** [V6.2.2] #3 Expense->__construct called at [/var/www/html/model/OrganizationMain.php:1036]
2017-04-27 13:38:43.613 ***** ERROR ***** [V6.2.2] #4 OrganizationMain->updateSynthesis called at [/var/www/html/model/ProjectPlanningElementMain.php:199]
2017-04-27 13:38:43.613 ***** ERROR ***** [V6.2.2] #5 ProjectPlanningElementMain->save called at [/var/www/html/model/persistence/SqlElement.php:1227]
2017-04-27 13:38:43.613 ***** ERROR ***** [V6.2.2] #6 SqlElement->saveDependantObjects called at [/var/www/html/model/persistence/SqlElement.php:1168]
2017-04-27 13:38:43.613 ***** ERROR ***** [V6.2.2] #7 SqlElement->updateSqlElement called at [/var/www/html/model/persistence/SqlElement.php:704]
2017-04-27 13:38:43.613 ***** ERROR ***** [V6.2.2] #8 SqlElement->saveSqlElement called at [/var/www/html/model/persistence/SqlElement.php:542]
2017-04-27 13:38:43.613 ***** ERROR ***** [V6.2.2] #9 SqlElement->save called at [/var/www/html/model/ProjectMain.php:662]
2017-04-27 13:38:43.613 ***** ERROR ***** [V6.2.2] #10 ProjectMain->save called at [/var/www/html/tool/saveObject.php:78]
2017-04-27 13:38:43.614 ***** ERROR ***** [V6.2.2] Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block
2017-04-27 13:38:43.614 ***** ERROR ***** [V6.2.2] For query : select * from expensedetail where expensedetail.idExpense is null order by expenseDate
2017-04-27 13:38:43.614 ***** ERROR ***** [V6.2.2] Strack trace :
2017-04-27 13:38:43.614 ***** ERROR ***** [V6.2.2] #0 Sql->query called at [/var/www/html/model/persistence/SqlElement.php:1943]
2017-04-27 13:38:43.614 ***** ERROR ***** [V6.2.2] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/html/model/Expense.php:220]
2017-04-27 13:38:43.614 ***** ERROR ***** [V6.2.2] #2 Expense->getExpenseDetail called at [/var/www/html/model/Expense.php:92]
2017-04-27 13:38:43.614 ***** ERROR ***** [V6.2.2] #3 Expense->__construct called at [/var/www/html/model/persistence/SqlElement.php:2040]
2017-04-27 13:38:43.614 ***** ERROR ***** [V6.2.2] #4 SqlElement->sumSqlElementsFromCriteria called at [/var/www/html/model/OrganizationMain.php:1038]
2017-04-27 13:38:43.614 ***** ERROR ***** [V6.2.2] #5 OrganizationMain->updateSynthesis called at [/var/www/html/model/ProjectPlanningElementMain.php:199]
2017-04-27 13:38:43.614 ***** ERROR ***** [V6.2.2] #6 ProjectPlanningElementMain->save called at [/var/www/html/model/persistence/SqlElement.php:1227]
2017-04-27 13:38:43.614 ***** ERROR ***** [V6.2.2] #7 SqlElement->saveDependantObjects called at [/var/www/html/model/persistence/SqlElement.php:1168]
2017-04-27 13:38:43.614 ***** ERROR ***** [V6.2.2] #8 SqlElement->updateSqlElement called at [/var/www/html/model/persistence/SqlElement.php:704]
2017-04-27 13:38:43.614 ***** ERROR ***** [V6.2.2] #9 SqlElement->saveSqlElement called at [/var/www/html/model/persistence/SqlElement.php:542]
2017-04-27 13:38:43.614 ***** ERROR ***** [V6.2.2] #10 SqlElement->save called at [/var/www/html/model/ProjectMain.php:662]
2017-04-27 13:38:43.614 ***** ERROR ***** [V6.2.2] #11 ProjectMain->save called at [/var/www/html/tool/saveObject.php:78]
2017-04-27 13:38:43.614 ***** ERROR ***** [V6.2.2] Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block
2017-04-27 13:38:43.614 ***** ERROR ***** [V6.2.2] For query : select sum(plannedAmount) as sumplannedamount, sum(realAmount) as sumrealamount from expense where year<=0 and idProject=42
2017-04-27 13:38:43.614 ***** ERROR ***** [V6.2.2] Strack trace :
2017-04-27 13:38:43.614 ***** ERROR ***** [V6.2.2] #0 Sql->query called at [/var/www/html/model/persistence/SqlElement.php:2063]
2017-04-27 13:38:43.614 ***** ERROR ***** [V6.2.2] #1 SqlElement->sumSqlElementsFromCriteria called at [/var/www/html/model/OrganizationMain.php:1038]
2017-04-27 13:38:43.614 ***** ERROR ***** [V6.2.2] #2 OrganizationMain->updateSynthesis called at [/var/www/html/model/ProjectPlanningElementMain.php:199]
2017-04-27 13:38:43.614 ***** ERROR ***** [V6.2.2] #3 ProjectPlanningElementMain->save called at [/var/www/html/model/persistence/SqlElement.php:1227]
2017-04-27 13:38:43.614 ***** ERROR ***** [V6.2.2] #4 SqlElement->saveDependantObjects called at [/var/www/html/model/persistence/SqlElement.php:1168]
2017-04-27 13:38:43.614 ***** ERROR ***** [V6.2.2] #5 SqlElement->updateSqlElement called at [/var/www/html/model/persistence/SqlElement.php:704]
2017-04-27 13:38:43.614 ***** ERROR ***** [V6.2.2] #6 SqlElement->saveSqlElement called at [/var/www/html/model/persistence/SqlElement.php:542]
2017-04-27 13:38:43.614 ***** ERROR ***** [V6.2.2] #7 SqlElement->save called at [/var/www/html/model/ProjectMain.php:662]
2017-04-27 13:38:43.614 ***** ERROR ***** [V6.2.2] #8 ProjectMain->save called at [/var/www/html/tool/saveObject.php:78]
2017-04-27 13:38:43.614 ***** ERROR ***** [V6.2.2] Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block
2017-04-27 13:38:43.614 ***** ERROR ***** [V6.2.2] For query : select * from project where id=42
2017-04-27 13:38:43.614 ***** ERROR ***** [V6.2.2] Strack trace :
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] #0 Sql->query called at [/var/www/html/model/persistence/SqlElement.php:2260]
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] #1 SqlElement->getSqlElement called at [/var/www/html/model/persistence/SqlElement.php:513]
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] #2 SqlElement->__construct called at [/var/www/html/model/ProjectMain.php:165]
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] #3 ProjectMain->__construct called at [/var/www/html/model/Project.php:39]
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] #4 Project->__construct called at [/var/www/html/model/OrganizationMain.php:1045]
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] #5 OrganizationMain->updateSynthesis called at [/var/www/html/model/ProjectPlanningElementMain.php:199]
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] #6 ProjectPlanningElementMain->save called at [/var/www/html/model/persistence/SqlElement.php:1227]
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] #7 SqlElement->saveDependantObjects called at [/var/www/html/model/persistence/SqlElement.php:1168]
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] #8 SqlElement->updateSqlElement called at [/var/www/html/model/persistence/SqlElement.php:704]
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] #9 SqlElement->saveSqlElement called at [/var/www/html/model/persistence/SqlElement.php:542]
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] #10 SqlElement->save called at [/var/www/html/model/ProjectMain.php:662]
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] #11 ProjectMain->save called at [/var/www/html/tool/saveObject.php:78]
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] ERROR *****
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] on file '/var/www/html/model/persistence/SqlElement.php' at line (2320)
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] cause = array_key_exists() expects parameter 2 to be array, boolean given
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] ERROR *****
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] on file '/var/www/html/model/persistence/SqlElement.php' at line (2322)
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] cause = array_key_exists() expects parameter 2 to be array, boolean given
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] Error on SqlElement to get 'id' for Class 'Project' : field 'id' not found in Database.
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] ERROR *****
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] on file '/var/www/html/model/persistence/SqlElement.php' at line (2320)
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] cause = array_key_exists() expects parameter 2 to be array, boolean given
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] ERROR *****
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] on file '/var/www/html/model/persistence/SqlElement.php' at line (2322)
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] cause = array_key_exists() expects parameter 2 to be array, boolean given
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] Error on SqlElement to get 'name' for Class 'Project' : field 'name' not found in Database.
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] ERROR *****
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] on file '/var/www/html/model/persistence/SqlElement.php' at line (2320)
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] cause = array_key_exists() expects parameter 2 to be array, boolean given
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] ERROR *****
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] on file '/var/www/html/model/persistence/SqlElement.php' at line (2322)
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] cause = array_key_exists() expects parameter 2 to be array, boolean given
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] Error on SqlElement to get 'idProjectType' for Class 'Project' : field 'idProjectType' not found in Database.
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] ERROR *****
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] on file '/var/www/html/model/persistence/SqlElement.php' at line (2320)
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] cause = array_key_exists() expects parameter 2 to be array, boolean given
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] ERROR *****
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] on file '/var/www/html/model/persistence/SqlElement.php' at line (2322)
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] cause = array_key_exists() expects parameter 2 to be array, boolean given
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] Error on SqlElement to get 'idOrganization' for Class 'Project' : field 'idOrganization' not found in Database.
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] ERROR *****
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] on file '/var/www/html/model/persistence/SqlElement.php' at line (2320)
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] cause = array_key_exists() expects parameter 2 to be array, boolean given
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] ERROR *****
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] on file '/var/www/html/model/persistence/SqlElement.php' at line (2322)
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] cause = array_key_exists() expects parameter 2 to be array, boolean given
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] Error on SqlElement to get 'idCategory' for Class 'Project' : field 'idCategory' not found in Database.
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] ERROR *****
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] on file '/var/www/html/model/persistence/SqlElement.php' at line (2320)
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] cause = array_key_exists() expects parameter 2 to be array, boolean given
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] ERROR *****
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] on file '/var/www/html/model/persistence/SqlElement.php' at line (2322)
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] cause = array_key_exists() expects parameter 2 to be array, boolean given
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] Error on SqlElement to get 'organizationInherited' for Class 'Project' : field 'organizationInherited' not found in Database.
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] ERROR *****
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] on file '/var/www/html/model/persistence/SqlElement.php' at line (2320)
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] cause = array_key_exists() expects parameter 2 to be array, boolean given
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] ERROR *****
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] on file '/var/www/html/model/persistence/SqlElement.php' at line (2322)
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] cause = array_key_exists() expects parameter 2 to be array, boolean given
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] Error on SqlElement to get 'organizationElementary' for Class 'Project' : field 'organizationElementary' not found in Database.
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] ERROR *****
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] on file '/var/www/html/model/persistence/SqlElement.php' at line (2320)
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] cause = array_key_exists() expects parameter 2 to be array, boolean given
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] ERROR *****
2017-04-27 13:38:43.615 ***** ERROR ***** [V6.2.2] on file '/var/www/html/model/persistence/SqlElement.php' at line (2322)

Please Connexion or Create an account to join the conversation.

More
27 Avr 2017 22:45 #2 by babynus
Replied by babynus on topic any modification are available on specific project
Issue Recorded as ticket #2681
Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
27 Avr 2017 22:46 #3 by babynus
Replied by babynus on topic any modification are available on specific project
Fix is to replace line 943 in /model/OraganizationMain.php from
$whereClause='(refId='.$keyPrjOrga.' and refType="Project") and ';
to
$whereClause='(refId='.$keyPrjOrga.' and refType=\'Project\') and ';
Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
28 Avr 2017 09:26 - 28 Avr 2017 09:27 #4 by pipobru
Replied by pipobru on topic any modification are available on specific project
Thanks but is not sufficient. I have apply this other modifications for solve the problem :
//Modification pour ../model/OrganizationMain.php
Ligne 950
$whereClause .= '(
(idle=1 and
(
((realStartDate) is null and (realEndDate) is null) or
((realStartDate) is null and date_part(\'year\', realEndDate) =0) OR
((realEndDate)is null) OR
(date_part(\'year\', realStartDate)=0 or date_part(\'year\', realEndDate)=0)
)
) or
(idle=0 and
(
((validatedStartDate) is null and (validatedEndDate) is null) or
((validatedStartDate) is null and date_part(\'year\', validatedEndDate)=0) OR
((validatedEndDate) is null) OR
(date_part(\'year\', validatedStartDate)=0 or date_part(\'year\', validatedEndDate)=0)
)
)
)';

Ligne 1030
$whereClause = 'year<=\'.$periodValue.\' and idProject='.$keyPrjOrga;

Ligne 1037
$whereClause = 'year<=\'.$periodValue.\' and idProject='.$keyPrjOrga;

Ligne 1050
$whereClause = 'year<=\'.$periodValue.\' and idProject='.$keyPrj;

Ligne 1058
$whereClause = 'year<=\'.$periodValue.\' and idProject='.$keyPrj;
Last edit: 28 Avr 2017 09:27 by pipobru.

Please Connexion or Create an account to join the conversation.

More
28 Avr 2017 19:03 #5 by babynus
Replied by babynus on topic any modification are available on specific project
Not so easy !

1)
$whereClause = 'year<=\'.$periodValue.\' and idProject='.$keyPrjOrga;
=>
$whereClause = 'year<=\''.$periodValue.\'' and idProject='.$keyPrjOrga;
(quotes were missing)

2)
date_part is not a mySql function.
So your proposal will work on PostgreSql, but not any longer on MySql :(

3)
date_part(\'year\', realStartDate)=0
is not the same as
year(realStartDate)=YYYY
when YYYY is replaced by 2017
Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.043 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.

Login Form