[SOLVED] Global planning error in 9.1.0

2021-03-16 08:24:10.481 ===== TRACE ===== DATABASE UPDATE COMPLETED TO VERSION V9.1.0
2021-03-16 08:24:10.481 ===== TRACE =====
2021-03-16 08:24:10.481 ===== TRACE ===== =====================================
2021-03-16 08:24:10.481 ===== TRACE =====
2021-03-16 08:24:12.715 ===== TRACE ===== NEW CONNECTED USER 'admin'
2021-03-16 08:24:21.122 ===== TRACE ===== Cron started at 16/03/2021 08:24:21
2021-03-16 08:27:00.498 ===== TRACE ===== DISCONNECTED USER 'admin'
2021-03-16 08:27:04.515 ===== TRACE ===== NEW CONNECTED USER 'admin'
2021-03-16 08:27:39.095 ===== TRACE ===== DISCONNECTED USER 'admin'
2021-03-16 08:27:43.359 ===== TRACE ===== NEW CONNECTED USER 'admin'
2021-03-16 08:29:49.341 ===== TRACE ===== DISCONNECTED USER 'admin'
2021-03-16 08:31:46.056 ===== TRACE ===== NEW CONNECTED USER 'admin'
2021-03-16 08:57:34.559 ***** ERROR ***** [V9.1.0] Exception-[21000] SQLSTATE[21000]: Cardinality violation: 1222 The used SELECT statements have a different number of columns
2021-03-16 08:57:34.559 ***** ERROR ***** [V9.1.0] For query : SELECT planningelement.*
FROM
( SELECT cast(id as CHAR) COLLATE utf8_general_ci as id,color,idProject,cast(refType AS CHAR) COLLATE utf8_general_ci as refType,refId,refName,topId,topRefType,topRefId,
priority,elementary,idle,done,cancelled,idPlanningMode,idBill,
initialStartDate,validatedStartDate,validatedStartFraction,plannedStartDate,plannedStartFraction,realStartDate,
initialEndDate,validatedEndDate,validatedEndFraction,plannedEndDate,plannedEndFraction,realEndDate,
latestStartDate,latestEndDate,
initialDuration,validatedDuration,plannedDuration,realDuration,
initialWork,validatedWork,assignedWork,plannedWork,leftWork,realWork,
validatedCost,assignedCost,plannedCost,leftCost,realCost,
progress,expectedProgress,wbs,wbsSortable,isOnCriticalPath,notPlannedWork, needReplan,
null as idType, null as idStatus, null as idResource, 0 as isGlobal
FROM planningelement
WHERE ((planningelement.idProject not in (0) or planningelement.idProject is null ) and (planningelement.idProject not in (0) or planningelement.idProject is null or (1=4) ) and (planningelement.idProject not in (0) or planningelement.idProject is null or (1=3) ))
UNION
SELECT coalesce(cast( (pex.id+1000000000) AS CHAR) COLLATE utf8_general_ci,concat('Action','_',action.id)) as id, null as color, action.idProject as idProject, cast('Action' AS CHAR) COLLATE utf8_general_ci as refType, action.id as refId, action.name as refName, null as topId, 'Project' as topRefType, action.idProject as topRefId,
'N/A' as priority, 1 as elementary, action.idle as idle, action.done as done, action.cancelled as cancelled, 8 as idPlanningMode, 'N/A' as idBill,
'N/A' as initialStartDate, 'N/A' as validatedStartDate, 0 as validatedStartFraction, action.actualDueDate as plannedStartDate, 0 as plannedStartFraction, action.handledDate as realStartDate,
'N/A' as initialEndDate, action.initialDueDate as validatedEndDate, 1 as validatedEndFraction, action.actualDueDate as plannedEndDate, 1 as plannedEndFraction, action.doneDate as realEndDate, 'N/A' as latestStartDate, 'N/A' as latestEndDate,
'N/A' as initialDuration, 1 as validatedDuration, 'N/A' as plannedDuration, 'N/A' as realDuration,
'N/A' as initialWork, 'N/A' as validatedWork, 'N/A' as assignedWork, 'N/A' as plannedWork, 'N/A' as leftWork, 'N/A' as realWork,
'N/A' as validatedCost, 'N/A' as assignedCost, 'N/A' as plannedCost, 'N/A' as leftCost, 'N/A' as realCost,
'N/A' as progress, 'N/A' as expectedProgress, coalesce(pex.wbs,concat(pe.wbs,'._#',action.id)) as wbs, coalesce(pex.wbsSortable,concat(pe.wbsSortable,'._#',action.id)) as wbsSortable, 'N/A' as isOnCriticalPath, 'N/A' as notPlannedWork, 'N/A' as needReplan, action.idActionType as idType, action.idStatus as idStatus, action.idResource as idResource, 1 as isGlobal, 'N/A' as paused
FROM action LEFT JOIN planningelement AS pe ON pe.refType='Project' and pe.refId=action.idProject LEFT JOIN planningelementextension as pex ON pex.refType='Action' and pex.refId=action.id WHERE ((action.idProject not in (0) or action.idProject is null ) and (action.idProject not in (0) or action.idProject is null or (action.idResource='1') ) and (action.idProject not in (0) or action.idProject is null or (action.idUser='1') )) and action.idProject not in (0)
UNION
SELECT coalesce(cast( (pex.id+1000000000) AS CHAR) COLLATE utf8_general_ci,concat('Decision','_',decision.id)) as id, null as color, decision.idProject as idProject, cast('Decision' AS CHAR) COLLATE utf8_general_ci as refType, decision.id as refId, decision.name as refName, null as topId, 'Project' as topRefType, decision.idProject as topRefId,
'N/A' as priority, 1 as elementary, decision.idle as idle, decision.done as done, decision.cancelled as cancelled, 8 as idPlanningMode, 'N/A' as idBill,
'N/A' as initialStartDate, 'N/A' as validatedStartDate, 0 as validatedStartFraction, decision.decisionDate as plannedStartDate, 0 as plannedStartFraction, decision.decisionDate as realStartDate,
'N/A' as initialEndDate, decision.decisionDate as validatedEndDate, 1 as validatedEndFraction, decision.decisionDate as plannedEndDate, 1 as plannedEndFraction, decision.decisionDate as realEndDate, 'N/A' as latestStartDate, 'N/A' as latestEndDate,
'N/A' as initialDuration, 1 as validatedDuration, 'N/A' as plannedDuration, 'N/A' as realDuration,
'N/A' as initialWork, 'N/A' as validatedWork, 'N/A' as assignedWork, 'N/A' as plannedWork, 'N/A' as leftWork, 'N/A' as realWork,
'N/A' as validatedCost, 'N/A' as assignedCost, 'N/A' as plannedCost, 'N/A' as leftCost, 'N/A' as realCost,
'N/A' as progress, 'N/A' as expectedProgress, coalesce(pex.wbs,concat(pe.wbs,'._#',decision.id)) as wbs, coalesce(pex.wbsSortable,concat(pe.wbsSortable,'._#',decision.id)) as wbsSortable, 'N/A' as isOnCriticalPath, 'N/A' as notPlannedWork, 'N/A' as needReplan, decision.idDecisionType as idType, decision.idStatus as idStatus, decision.idResource as idResource, 1 as isGlobal, 'N/A' as paused
FROM decision LEFT JOIN planningelement AS pe ON pe.refType='Project' and pe.refId=decision.idProject LEFT JOIN planningelementextension as pex ON pex.refType='Decision' and pex.refId=decision.id WHERE ((decision.idProject not in (0) or decision.idProject is null ) and (decision.idProject not in (0) or decision.idProject is null or (decision.idResource='1') ) and (decision.idProject not in (0) or decision.idProject is null or (decision.idUser='1') )) and decision.idProject not in (0)
UNION
SELECT coalesce(cast( (pex.id+1000000000) AS CHAR) COLLATE utf8_general_ci,concat('Delivery','_',delivery.id)) as id, null as color, delivery.idProject as idProject, cast('Delivery' AS CHAR) COLLATE utf8_general_ci as refType, delivery.id as refId, delivery.name as refName, null as topId, 'Project' as topRefType, delivery.idProject as topRefId,
'N/A' as priority, 1 as elementary, delivery.idle as idle, delivery.done as done, delivery.cancelled as cancelled, 8 as idPlanningMode, 'N/A' as idBill,
'N/A' as initialStartDate, 'N/A' as validatedStartDate, 0 as validatedStartFraction, delivery.plannedDate as plannedStartDate, 0 as plannedStartFraction, delivery.handledDateTime as realStartDate,
'N/A' as initialEndDate, delivery.initialDate as validatedEndDate, 1 as validatedEndFraction, delivery.plannedDate as plannedEndDate, 1 as plannedEndFraction, delivery.realDate as realEndDate, 'N/A' as latestStartDate, 'N/A' as latestEndDate,
'N/A' as initialDuration, 1 as validatedDuration, 'N/A' as plannedDuration, 'N/A' as realDuration,
'N/A' as initialWork, 'N/A' as validatedWork, 'N/A' as assignedWork, 'N/A' as plannedWork, 'N/A' as leftWork, 'N/A' as realWork,
'N/A' as validatedCost, 'N/A' as assignedCost, 'N/A' as plannedCost, 'N/A' as leftCost, 'N/A' as realCost,
'N/A' as progress, 'N/A' as expectedProgress, coalesce(pex.wbs,concat(pe.wbs,'._#',delivery.id)) as wbs, coalesce(pex.wbsSortable,concat(pe.wbsSortable,'._#',delivery.id)) as wbsSortable, 'N/A' as isOnCriticalPath, 'N/A' as notPlannedWork, 'N/A' as needReplan, delivery.idDeliveryType as idType, delivery.idStatus as idStatus, delivery.idResource as idResource, 1 as isGlobal, 'N/A' as paused
FROM delivery LEFT JOIN planningelement AS pe ON pe.refType='Project' and pe.refId=delivery.idProject LEFT JOIN planningelementextension as pex ON pex.refType='Delivery' and pex.refId=delivery.id WHERE ((delivery.idProject not in (0) or delivery.idProject is null ) and (delivery.idProject not in (0) or delivery.idProject is null or (delivery.idResource='1') ) and (delivery.idProject not in (0) or delivery.idProject is null or (delivery.idUser='1') )) and delivery.idProject not in (0)
UNION
SELECT coalesce(cast( (pex.id+1000000000) AS CHAR) COLLATE utf8_general_ci,concat('Issue','_',issue.id)) as id, null as color, issue.idProject as idProject, cast('Issue' AS CHAR) COLLATE utf8_general_ci as refType, issue.id as refId, issue.name as refName, null as topId, 'Project' as topRefType, issue.idProject as topRefId,
'N/A' as priority, 1 as elementary, issue.idle as idle, issue.done as done, issue.cancelled as cancelled, 8 as idPlanningMode, 'N/A' as idBill,
'N/A' as initialStartDate, 'N/A' as validatedStartDate, 0 as validatedStartFraction, issue.actualEndDate as plannedStartDate, 0 as plannedStartFraction, issue.handledDate as realStartDate,
'N/A' as initialEndDate, issue.initialEndDate as validatedEndDate, 1 as validatedEndFraction, issue.actualEndDate as plannedEndDate, 1 as plannedEndFraction, issue.doneDate as realEndDate, 'N/A' as latestStartDate, 'N/A' as latestEndDate,
'N/A' as initialDuration, 1 as validatedDuration, 'N/A' as plannedDuration, 'N/A' as realDuration,
'N/A' as initialWork, 'N/A' as validatedWork, 'N/A' as assignedWork, 'N/A' as plannedWork, 'N/A' as leftWork, 'N/A' as realWork,
'N/A' as validatedCost, 'N/A' as assignedCost, 'N/A' as plannedCost, 'N/A' as leftCost, 'N/A' as realCost,
'N/A' as progress, 'N/A' as expectedProgress, coalesce(pex.wbs,concat(pe.wbs,'._#',issue.id)) as wbs, coalesce(pex.wbsSortable,concat(pe.wbsSortable,'._#',issue.id)) as wbsSortable, 'N/A' as isOnCriticalPath, 'N/A' as notPlannedWork, 'N/A' as needReplan, issue.idIssueType as idType, issue.idStatus as idStatus, issue.idResource as idResource, 1 as isGlobal, 'N/A' as paused
FROM issue LEFT JOIN planningelement AS pe ON pe.refType='Project' and pe.refId=issue.idProject LEFT JOIN planningelementextension as pex ON pex.refType='Issue' and pex.refId=issue.id WHERE ((issue.idProject not in (0) or issue.idProject is null ) and (issue.idProject not in (0) or issue.idProject is null or (issue.idResource='1') ) and (issue.idProject not in (0) or issue.idProject is null or (issue.idUser='1') )) and issue.idProject not in (0)
UNION
SELECT coalesce(cast( (pex.id+1000000000) AS CHAR) COLLATE utf8_general_ci,concat('Opportunity','_',opportunity.id)) as id, null as color, opportunity.idProject as idProject, cast('Opportunity' AS CHAR) COLLATE utf8_general_ci as refType, opportunity.id as refId, opportunity.name as refName, null as topId, 'Project' as topRefType, opportunity.idProject as topRefId,
'N/A' as priority, 1 as elementary, opportunity.idle as idle, opportunity.done as done, opportunity.cancelled as cancelled, 8 as idPlanningMode, 'N/A' as idBill,
'N/A' as initialStartDate, 'N/A' as validatedStartDate, 0 as validatedStartFraction, opportunity.actualEndDate as plannedStartDate, 0 as plannedStartFraction, opportunity.handledDate as realStartDate,
'N/A' as initialEndDate, opportunity.initialEndDate as validatedEndDate, 1 as validatedEndFraction, opportunity.actualEndDate as plannedEndDate, 1 as plannedEndFraction, opportunity.doneDate as realEndDate, 'N/A' as latestStartDate, 'N/A' as latestEndDate,
'N/A' as initialDuration, 1 as validatedDuration, 'N/A' as plannedDuration, 'N/A' as realDuration,
'N/A' as initialWork, 'N/A' as validatedWork, 'N/A' as assignedWork, 'N/A' as plannedWork, 'N/A' as leftWork, 'N/A' as realWork,
'N/A' as validatedCost, 'N/A' as assignedCost, 'N/A' as plannedCost, 'N/A' as leftCost, 'N/A' as realCost,
'N/A' as progress, 'N/A' as expectedProgress, coalesce(pex.wbs,concat(pe.wbs,'._#',opportunity.id)) as wbs, coalesce(pex.wbsSortable,concat(pe.wbsSortable,'._#',opportunity.id)) as wbsSortable, 'N/A' as isOnCriticalPath, 'N/A' as notPlannedWork, 'N/A' as needReplan, opportunity.idOpportunityType as idType, opportunity.idStatus as idStatus, opportunity.idResource as idResource, 1 as isGlobal, 'N/A' as paused
FROM opportunity LEFT JOIN planningelement AS pe ON pe.refType='Project' and pe.refId=opportunity.idProject LEFT JOIN planningelementextension as pex ON pex.refType='Opportunity' and pex.refId=opportunity.id WHERE ((opportunity.idProject not in (0) or opportunity.idProject is null ) and (opportunity.idProject not in (0) or opportunity.idProject is null or (opportunity.idResource='1') ) and (opportunity.idProject not in (0) or opportunity.idProject is null or (opportunity.idUser='1') )) and opportunity.idProject not in (0)
UNION
SELECT coalesce(cast( (pex.id+1000000000) AS CHAR) COLLATE utf8_general_ci,concat('Question','_',question.id)) as id, null as color, question.idProject as idProject, cast('Question' AS CHAR) COLLATE utf8_general_ci as refType, question.id as refId, question.name as refName, null as topId, 'Project' as topRefType, question.idProject as topRefId,
'N/A' as priority, 1 as elementary, question.idle as idle, question.done as done, question.cancelled as cancelled, 8 as idPlanningMode, 'N/A' as idBill,
'N/A' as initialStartDate, 'N/A' as validatedStartDate, 0 as validatedStartFraction, question.actualDueDate as plannedStartDate, 0 as plannedStartFraction, question.handledDate as realStartDate,
'N/A' as initialEndDate, question.initialDueDate as validatedEndDate, 1 as validatedEndFraction, question.actualDueDate as plannedEndDate, 1 as plannedEndFraction, question.doneDate as realEndDate, 'N/A' as latestStartDate, 'N/A' as latestEndDate,
'N/A' as initialDuration, 1 as validatedDuration, 'N/A' as plannedDuration, 'N/A' as realDuration,
'N/A' as initialWork, 'N/A' as validatedWork, 'N/A' as assignedWork, 'N/A' as plannedWork, 'N/A' as leftWork, 'N/A' as realWork,
'N/A' as validatedCost, 'N/A' as assignedCost, 'N/A' as plannedCost, 'N/A' as leftCost, 'N/A' as realCost,
'N/A' as progress, 'N/A' as expectedProgress, coalesce(pex.wbs,concat(pe.wbs,'._#',question.id)) as wbs, coalesce(pex.wbsSortable,concat(pe.wbsSortable,'._#',question.id)) as wbsSortable, 'N/A' as isOnCriticalPath, 'N/A' as notPlannedWork, 'N/A' as needReplan, question.idQuestionType as idType, question.idStatus as idStatus, question.idResource as idResource, 1 as isGlobal, 'N/A' as paused
FROM question LEFT JOIN planningelement AS pe ON pe.refType='Project' and pe.refId=question.idProject LEFT JOIN planningelementextension as pex ON pex.refType='Question' and pex.refId=question.id WHERE ((question.idProject not in (0) or question.idProject is null ) and (question.idProject not in (0) or question.idProject is null or (question.idResource='1') ) and (question.idProject not in (0) or question.idProject is null or (question.idUser='1') )) and question.idProject not in (0)
UNION
SELECT coalesce(cast( (pex.id+1000000000) AS CHAR) COLLATE utf8_general_ci,concat('Risk','_',risk.id)) as id, null as color, risk.idProject as idProject, cast('Risk' AS CHAR) COLLATE utf8_general_ci as refType, risk.id as refId, risk.name as refName, null as topId, 'Project' as topRefType, risk.idProject as topRefId,
'N/A' as priority, 1 as elementary, risk.idle as idle, risk.done as done, risk.cancelled as cancelled, 8 as idPlanningMode, 'N/A' as idBill,
'N/A' as initialStartDate, 'N/A' as validatedStartDate, 0 as validatedStartFraction, risk.actualEndDate as plannedStartDate, 0 as plannedStartFraction, risk.handledDate as realStartDate,
'N/A' as initialEndDate, risk.initialEndDate as validatedEndDate, 1 as validatedEndFraction, risk.actualEndDate as plannedEndDate, 1 as plannedEndFraction, risk.doneDate as realEndDate, 'N/A' as latestStartDate, 'N/A' as latestEndDate,
'N/A' as initialDuration, 1 as validatedDuration, 'N/A' as plannedDuration, 'N/A' as realDuration,
'N/A' as initialWork, 'N/A' as validatedWork, 'N/A' as assignedWork, 'N/A' as plannedWork, 'N/A' as leftWork, 'N/A' as realWork,
'N/A' as validatedCost, 'N/A' as assignedCost, 'N/A' as plannedCost, 'N/A' as leftCost, 'N/A' as realCost,
'N/A' as progress, 'N/A' as expectedProgress, coalesce(pex.wbs,concat(pe.wbs,'._#',risk.id)) as wbs, coalesce(pex.wbsSortable,concat(pe.wbsSortable,'._#',risk.id)) as wbsSortable, 'N/A' as isOnCriticalPath, 'N/A' as notPlannedWork, 'N/A' as needReplan, risk.idRiskType as idType, risk.idStatus as idStatus, risk.idResource as idResource, 1 as isGlobal, 'N/A' as paused
FROM risk LEFT JOIN planningelement AS pe ON pe.refType='Project' and pe.refId=risk.idProject LEFT JOIN planningelementextension as pex ON pex.refType='Risk' and pex.refId=risk.id WHERE ((risk.idProject not in (0) or risk.idProject is null ) and (risk.idProject not in (0) or risk.idProject is null or (risk.idResource='1') ) and (risk.idProject not in (0) or risk.idProject is null or (risk.idUser='1') )) and risk.idProject not in (0)
UNION
SELECT coalesce(cast( (pex.id+1000000000) AS CHAR) COLLATE utf8_general_ci,concat('Ticket','_',ticket.id)) as id, null as color, ticket.idProject as idProject, cast('Ticket' AS CHAR) COLLATE utf8_general_ci as refType, ticket.id as refId, ticket.name as refName, null as topId, 'Project' as topRefType, ticket.idProject as topRefId,
'N/A' as priority, 1 as elementary, ticket.idle as idle, ticket.done as done, ticket.cancelled as cancelled, 8 as idPlanningMode, 'N/A' as idBill,
'N/A' as initialStartDate, 'N/A' as validatedStartDate, 0 as validatedStartFraction, ticket.actualDueDateTime as plannedStartDate, 0 as plannedStartFraction, ticket.handledDateTime as realStartDate,
'N/A' as initialEndDate, ticket.initialDueDateTime as validatedEndDate, 1 as validatedEndFraction, ticket.actualDueDateTime as plannedEndDate, 1 as plannedEndFraction, ticket.doneDateTime as realEndDate, 'N/A' as latestStartDate, 'N/A' as latestEndDate,
'N/A' as initialDuration, 1 as validatedDuration, 'N/A' as plannedDuration, 'N/A' as realDuration,
'N/A' as initialWork, we.plannedWork as validatedWork, 'N/A' as assignedWork, we.leftWork+we.realWork as plannedWork, we.leftWork as leftWork, we.realWork as realWork,
'N/A' as validatedCost, 'N/A' as assignedCost, 'N/A' as plannedCost, 'N/A' as leftCost, 'N/A' as realCost,
'N/A' as progress, 'N/A' as expectedProgress, coalesce(pex.wbs,concat(pe.wbs,'._#',ticket.id)) as wbs, coalesce(pex.wbsSortable,concat(pe.wbsSortable,'._#',ticket.id)) as wbsSortable, 'N/A' as isOnCriticalPath, 'N/A' as notPlannedWork, 'N/A' as needReplan, ticket.idTicketType as idType, ticket.idStatus as idStatus, ticket.idResource as idResource, 1 as isGlobal, 'N/A' as paused
FROM ticket LEFT JOIN planningelement AS pe ON pe.refType='Project' and pe.refId=ticket.idProject LEFT JOIN planningelementextension as pex ON pex.refType='Ticket' and pex.refId=ticket.id
LEFT JOIN workelement AS we ON we.refType='Ticket' AND we.refId=ticket.id WHERE ((ticket.idProject not in (0) or ticket.idProject is null ) and (ticket.idProject not in (0) or ticket.idProject is null or (ticket.idResource='1') ) and (ticket.idProject not in (0) or ticket.idProject is null or (ticket.idUser='1') )) and ticket.idProject not in (0)) as planningelement
WHERE (1=1) and planningelement.idProject in (0, 9) and planningelement.idProject not in (0, 1)
ORDER BY planningelement.wbsSortable
2021-03-16 08:57:34.559 ***** ERROR ***** [V9.1.0] Strack trace :
2021-03-16 08:57:34.559 ***** ERROR ***** [V9.1.0] #0 Sql->query called at [/var/www/html/projeqtor/tool/jsonPlanning.php:292]
2021-03-16 08:57:34.559 ***** ERROR ***** [V9.1.0] #1 include called at [/var/www/html/projeqtor/view/globalPlanningList.php:279]
2021-03-16 08:57:34.559 ***** ERROR ***** [V9.1.0] #2 include called at [/var/www/html/projeqtor/view/globalPlanningMain.php:79]

Yes, that's it. Thanks,
one more issue: Planning and Global Plannig display closed projects even when archive mode is not checked.

Ok, thanks.
But I can't help feeling that something is different and incosistent in this version; for instance, in this version, a project leader can see projects, in "project selector", he hasn't been allocated to; is this intended behaviour?