2021-05-11 07:44:08.107 ===== TRACE ===== NEW CONNECTED USER 'admin'
2021-05-11 07:44:45.035 ===== TRACE ===== Cron started at 11/05/2021 07:44:45
2021-05-11 07:44:45.067 ===== TRACE ===== Automatic planning calculation : differential calculation - start - Projects : 3
2021-05-11 07:44:45.348 ===== TRACE ===== Automatic planning calculation : differential calculation - end - result = Planning correctly updated
2021-05-11 07:44:45.356 ===== TRACE ===== Automatic planning calculation : complete calculation - start - Projects : all
2021-05-11 07:44:45.961 ===== TRACE ===== Automatic planning calculation : complete calculation - end - result = Planning correctly updated
2021-05-11 07:44:46.029 ===== TRACE ===== generationImputationAlert() - No number of days defined - Exiting
2021-05-11 07:44:46.029 ===== TRACE ===== generationImputationAlert() - No number of days defined - Exiting
2021-05-11 07:44:46.029 ===== TRACE ===== Cron::run() - Calcul Imputation Alert for Resource
2021-05-11 07:44:46.030 ===== TRACE ===== generationImputationAlert() - No number of days defined - Exiting
2021-05-11 07:44:46.030 ===== TRACE ===== Cron::run() - Calcul Imputation Alert for ProjectLeader
2021-05-11 07:44:46.131 ===== TRACE ===== generationImputationAlert() - No number of days defined - Exiting
2021-05-11 07:44:46.131 ===== TRACE ===== Cron::run() - Calcul Imputation Alert for TeamManager
2021-05-11 07:44:46.225 ===== TRACE ===== generationImputationAlert() - No number of days defined - Exiting
2021-05-11 07:44:46.248 ===== TRACE ===== Cron::run() - generateImputationAlert for cronImputationAlertCronResource at 1619841600 MAIL MAIL MAIL NO
2021-05-11 07:44:46.325 ===== TRACE ===== generationImputationAlert() - No number of days defined - Exiting
2021-05-11 07:44:46.325 ===== TRACE ===== generationImputationAlert() - No number of days defined - Exiting
2021-05-11 07:44:46.325 ===== TRACE ===== generationImputationAlert() - No number of days defined - Exiting
2021-05-11 07:44:46.325 ===== TRACE ===== generationImputationAlert() - No number of days defined - Exiting
2021-05-11 07:44:46.325 ===== TRACE ===== generationImputationAlert() - No number of days defined - Exiting
2021-05-11 07:44:46.325 ===== TRACE ===== Cron::run() - Calcul Imputation Alert for OrganismManager
2021-05-11 07:44:46.346 ===== TRACE ===== Cron::run() - generateImputationAlert for cronImputationAlertCronOrganismManager at 1619820000 NO NO NO ALERT
2021-05-11 07:45:18.880 ***** ERROR ***** [V9.1.2] ERROR *****
2021-05-11 07:45:18.881 ***** ERROR ***** [V9.1.2] on file '/home/znkwsomc/public_html/projectsstaging/view/objectDetail.php' at line (9355)
2021-05-11 07:45:18.881 ***** ERROR ***** [V9.1.2] cause = ob_get_clean(): failed to discard buffer of zlib output compression (1)
2021-05-11 07:45:26.736 ***** ERROR ***** [V9.1.2] ERROR *****
2021-05-11 07:45:26.736 ***** ERROR ***** [V9.1.2] on file '/home/znkwsomc/public_html/projectsstaging/view/objectDetail.php' at line (9355)
2021-05-11 07:45:26.736 ***** ERROR ***** [V9.1.2] cause = ob_get_clean(): failed to discard buffer of zlib output compression (1)
2021-05-11 07:57:44.154 ***** ERROR ***** [V9.1.2] ERROR *****
2021-05-11 07:57:44.159 ***** ERROR ***** [V9.1.2] on file '/home/znkwsomc/public_html/projectsstaging/view/objectDetail.php' at line (9355)
2021-05-11 07:57:44.159 ***** ERROR ***** [V9.1.2] cause = ob_get_clean(): failed to discard buffer of zlib output compression (1)
2021-05-11 08:00:07.868 ===== TRACE ===== Automatic planning calculation : differential calculation - start - Projects : 3
2021-05-11 08:00:08.545 ===== TRACE ===== Automatic planning calculation : differential calculation - end - result = Planning correctly updated
2021-05-11 08:02:29.437 ***** ERROR ***** [V9.1.2] ERROR *****
2021-05-11 08:02:29.437 ***** ERROR ***** [V9.1.2] on file '/home/znkwsomc/public_html/projectsstaging/view/objectDetail.php' at line (9355)
2021-05-11 08:02:29.437 ***** ERROR ***** [V9.1.2] cause = ob_get_clean(): failed to discard buffer of zlib output compression (1)
2021-05-11 08:29:19.078 ***** ERROR ***** [V9.1.2] ERROR *****
2021-05-11 08:29:19.126 ***** ERROR ***** [V9.1.2] on file '/home/znkwsomc/public_html/projectsstaging/view/objectDetail.php' at line (9355)
2021-05-11 08:29:19.126 ***** ERROR ***** [V9.1.2] cause = ob_get_clean(): failed to discard buffer of zlib output compression (1)
2021-05-11 08:30:04.469 ***** ERROR ***** [V9.1.2] ERROR *****
2021-05-11 08:30:04.470 ***** ERROR ***** [V9.1.2] on file '/home/znkwsomc/public_html/projectsstaging/view/objectDetail.php' at line (9355)
2021-05-11 08:30:04.470 ***** ERROR ***** [V9.1.2] cause = ob_get_clean(): failed to discard buffer of zlib output compression (1)
2021-05-11 08:30:10.615 ***** ERROR ***** [V9.1.2] ERROR *****
2021-05-11 08:30:10.615 ***** ERROR ***** [V9.1.2] on file '/home/znkwsomc/public_html/projectsstaging/view/objectDetail.php' at line (9355)
2021-05-11 08:30:10.615 ***** ERROR ***** [V9.1.2] cause = ob_get_clean(): failed to discard buffer of zlib output compression (1)
2021-05-11 08:30:39.086 ***** ERROR ***** [V9.1.2] ERROR *****
2021-05-11 08:30:39.086 ***** ERROR ***** [V9.1.2] on file '/home/znkwsomc/public_html/projectsstaging/view/objectDetail.php' at line (9355)
2021-05-11 08:30:39.086 ***** ERROR ***** [V9.1.2] cause = ob_get_clean(): failed to discard buffer of zlib output compression (1)
2021-05-11 08:30:41.931 ***** ERROR ***** [V9.1.2] ERROR *****
2021-05-11 08:30:41.931 ***** ERROR ***** [V9.1.2] on file '/home/znkwsomc/public_html/projectsstaging/view/objectDetail.php' at line (9355)
2021-05-11 08:30:41.931 ***** ERROR ***** [V9.1.2] cause = ob_get_clean(): failed to discard buffer of zlib output compression (1)
2021-05-11 08:30:50.747 ===== TRACE ===== DISCONNECTED USER 'admin'
2021-05-11 09:00:07.919 ===== TRACE ===== Automatic planning calculation : differential calculation - start - Projects : 3
2021-05-11 09:00:09.714 ===== TRACE ===== Automatic planning calculation : differential calculation - end - result = Planning correctly updated
2021-05-11 10:00:05.589 ===== TRACE ===== Automatic planning calculation : differential calculation - start - Projects : 3
2021-05-11 10:00:07.131 ===== TRACE ===== Automatic planning calculation : differential calculation - end - result = Planning correctly updated
2021-05-11 11:00:00.883 ===== TRACE ===== Automatic planning calculation : differential calculation - start - Projects : 3
2021-05-11 11:00:01.162 ===== TRACE ===== Automatic planning calculation : differential calculation - end - result = Planning correctly updated
2021-05-11 12:00:06.539 ===== TRACE ===== Automatic planning calculation : differential calculation - start - Projects : 3
2021-05-11 12:00:07.921 ===== TRACE ===== Automatic planning calculation : differential calculation - end - result = Planning correctly updated
2021-05-11 13:00:02.014 ===== TRACE ===== Automatic planning calculation : differential calculation - start - Projects : 3
2021-05-11 13:00:03.855 ===== TRACE ===== Automatic planning calculation : differential calculation - end - result = Planning correctly updated
2021-05-11 14:00:07.932 ===== TRACE ===== Automatic planning calculation : differential calculation - start - Projects : 3
2021-05-11 14:00:08.677 ===== TRACE ===== Automatic planning calculation : differential calculation - end - result = Planning correctly updated
2021-05-11 15:00:05.206 ===== TRACE ===== Automatic planning calculation : differential calculation - start - Projects : 3
2021-05-11 15:00:06.112 ===== TRACE ===== Automatic planning calculation : differential calculation - end - result = Planning correctly updated
2021-05-11 15:53:47.852 ===== TRACE ===== NEW CONNECTED USER 'admin'
2021-05-11 15:54:59.059 ***** ERROR ***** [V9.1.2] ERROR *****
2021-05-11 15:54:59.060 ***** ERROR ***** [V9.1.2] on file '/home/znkwsomc/public_html/projectsstaging/view/objectDetail.php' at line (9355)
2021-05-11 15:54:59.060 ***** ERROR ***** [V9.1.2] cause = ob_get_clean(): failed to discard buffer of zlib output compression (1)
2021-05-11 15:55:15.628 ***** ERROR ***** [V9.1.2] ERROR *****
2021-05-11 15:55:15.628 ***** ERROR ***** [V9.1.2] on file '/home/znkwsomc/public_html/projectsstaging/view/objectDetail.php' at line (9355)
2021-05-11 15:55:15.628 ***** ERROR ***** [V9.1.2] cause = ob_get_clean(): failed to discard buffer of zlib output compression (1)
2021-05-11 15:55:41.296 ***** ERROR ***** [V9.1.2] ERROR *****
2021-05-11 15:55:41.296 ***** ERROR ***** [V9.1.2] on file '/home/znkwsomc/public_html/projectsstaging/view/objectDetail.php' at line (9355)
2021-05-11 15:55:41.296 ***** ERROR ***** [V9.1.2] cause = ob_get_clean(): failed to discard buffer of zlib output compression (1)
2021-05-11 15:56:48.241 ***** ERROR ***** [V9.1.2] ERROR *****
2021-05-11 15:56:48.241 ***** ERROR ***** [V9.1.2] on file '/home/znkwsomc/public_html/projectsstaging/view/objectDetail.php' at line (9355)
2021-05-11 15:56:48.242 ***** ERROR ***** [V9.1.2] cause = ob_get_clean(): failed to discard buffer of zlib output compression (1)
2021-05-11 15:56:57.287 ***** ERROR ***** [V9.1.2] ERROR *****
2021-05-11 15:56:57.287 ***** ERROR ***** [V9.1.2] on file '/home/znkwsomc/public_html/projectsstaging/view/objectDetail.php' at line (9355)
2021-05-11 15:56:57.287 ***** ERROR ***** [V9.1.2] cause = ob_get_clean(): failed to discard buffer of zlib output compression (1)
2021-05-11 15:57:20.338 ***** ERROR ***** [V9.1.2] ERROR *****
2021-05-11 15:57:20.338 ***** ERROR ***** [V9.1.2] on file '/home/znkwsomc/public_html/projectsstaging/view/objectDetail.php' at line (9355)
2021-05-11 15:57:20.338 ***** ERROR ***** [V9.1.2] cause = ob_get_clean(): failed to discard buffer of zlib output compression (1)
2021-05-11 15:58:58.439 ***** ERROR ***** [V9.1.2] ERROR *****
2021-05-11 15:58:58.439 ***** ERROR ***** [V9.1.2] on file '/home/znkwsomc/public_html/projectsstaging/view/objectDetail.php' at line (9355)
2021-05-11 15:58:58.439 ***** ERROR ***** [V9.1.2] cause = ob_get_clean(): failed to discard buffer of zlib output compression (1)
2021-05-11 16:00:09.599 ===== TRACE ===== Automatic planning calculation : differential calculation - start - Projects : 3
2021-05-11 16:00:09.877 ===== TRACE ===== Automatic planning calculation : differential calculation - end - result = Planning correctly updated
2021-05-11 16:01:36.943 ***** ERROR ***** [V9.1.2] ERROR *****
2021-05-11 16:01:36.943 ***** ERROR ***** [V9.1.2] on file '/home/znkwsomc/public_html/projectsstaging/view/objectDetail.php' at line (9355)
2021-05-11 16:01:36.943 ***** ERROR ***** [V9.1.2] cause = ob_get_clean(): failed to discard buffer of zlib output compression (1)
2021-05-11 16:02:22.134 ***** ERROR ***** [V9.1.2] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'latin1_swedish_ci' is not valid for CHARACTER SET 'utf8'
2021-05-11 16:02:22.135 ***** ERROR ***** [V9.1.2]    For query : SELECT prjk_planningelement.* 
 FROM 
  ( SELECT cast(id as CHAR) COLLATE latin1_swedish_ci as id,color,idProject,cast(refType AS CHAR) COLLATE latin1_swedish_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 , null as paused
      FROM prjk_planningelement
    WHERE  ((prjk_planningelement.idProject not in (0) or prjk_planningelement.idProject is null ) and (prjk_planningelement.idProject not in (0) or prjk_planningelement.idProject is null or (1=4) ) and (prjk_planningelement.idProject not in (0) or prjk_planningelement.idProject is null or (1=3) )) 
  UNION 
    SELECT coalesce(cast( (pex.id+1000000000) AS CHAR) COLLATE latin1_swedish_ci,concat('Action','_',prjk_action.id)) as id, null as color, prjk_action.idProject as idProject, cast('Action' AS CHAR) COLLATE latin1_swedish_ci as refType, prjk_action.id as refId, prjk_action.name as refName, null as topId, 'Project' as topRefType, prjk_action.idProject as topRefId, 
      null as priority, 1 as elementary, prjk_action.idle as idle, prjk_action.done as done, prjk_action.cancelled as cancelled, 8 as idPlanningMode, null as idBill, 
      null as initialStartDate, null as validatedStartDate, 0 as validatedStartFraction, prjk_action.actualDueDate as plannedStartDate, 0 as plannedStartFraction, prjk_action.handledDate as realStartDate, 
      null as initialEndDate, prjk_action.initialDueDate as validatedEndDate, 1 as validatedEndFraction, prjk_action.actualDueDate as plannedEndDate, 1 as plannedEndFraction, prjk_action.doneDate as realEndDate, null as latestStartDate, null as latestEndDate, 
      null as initialDuration, 1 as validatedDuration, null as plannedDuration, null as realDuration, 
      null as initialWork, null as validatedWork, null as assignedWork, null as plannedWork, null as leftWork, null as realWork, 
      null as validatedCost, null as assignedCost, null as plannedCost, null as leftCost, null as realCost, 
      null as progress, null as expectedProgress, coalesce(pex.wbs,concat(pe.wbs,'._#',prjk_action.id)) as wbs, coalesce(pex.wbsSortable,concat(pe.wbsSortable,'._#',prjk_action.id)) as wbsSortable, null as isOnCriticalPath, null as notPlannedWork, null as needReplan, prjk_action.idActionType as idType, prjk_action.idStatus as idStatus, prjk_action.idResource as idResource, 1 as isGlobal, null as paused
    FROM prjk_action LEFT JOIN prjk_planningelement AS pe ON pe.refType='Project' and pe.refId=prjk_action.idProject LEFT JOIN prjk_planningelementextension as pex ON pex.refType='Action' and pex.refId=prjk_action.id  WHERE  ((prjk_action.idProject not in (0) or prjk_action.idProject is null ) and (prjk_action.idProject not in (0) or prjk_action.idProject is null or (prjk_action.idResource='1') ) and (prjk_action.idProject not in (0) or prjk_action.idProject is null or (prjk_action.idUser='1') )) and prjk_action.idProject not in (0)
  UNION 
    SELECT coalesce(cast( (pex.id+1000000000) AS CHAR) COLLATE latin1_swedish_ci,concat('Decision','_',prjk_decision.id)) as id, null as color, prjk_decision.idProject as idProject, cast('Decision' AS CHAR) COLLATE latin1_swedish_ci as refType, prjk_decision.id as refId, prjk_decision.name as refName, null as topId, 'Project' as topRefType, prjk_decision.idProject as topRefId, 
      null as priority, 1 as elementary, prjk_decision.idle as idle, prjk_decision.done as done, prjk_decision.cancelled as cancelled, 8 as idPlanningMode, null as idBill, 
      null as initialStartDate, null as validatedStartDate, 0 as validatedStartFraction, prjk_decision.decisionDate as plannedStartDate, 0 as plannedStartFraction, prjk_decision.decisionDate as realStartDate, 
      null as initialEndDate, prjk_decision.decisionDate as validatedEndDate, 1 as validatedEndFraction, prjk_decision.decisionDate as plannedEndDate, 1 as plannedEndFraction, prjk_decision.decisionDate as realEndDate, null as latestStartDate, null as latestEndDate, 
      null as initialDuration, 1 as validatedDuration, null as plannedDuration, null as realDuration, 
      null as initialWork, null as validatedWork, null as assignedWork, null as plannedWork, null as leftWork, null as realWork, 
      null as validatedCost, null as assignedCost, null as plannedCost, null as leftCost, null as realCost, 
      null as progress, null as expectedProgress, coalesce(pex.wbs,concat(pe.wbs,'._#',prjk_decision.id)) as wbs, coalesce(pex.wbsSortable,concat(pe.wbsSortable,'._#',prjk_decision.id)) as wbsSortable, null as isOnCriticalPath, null as notPlannedWork, null as needReplan, prjk_decision.idDecisionType as idType, prjk_decision.idStatus as idStatus, prjk_decision.idResource as idResource, 1 as isGlobal, null as paused
    FROM prjk_decision LEFT JOIN prjk_planningelement AS pe ON pe.refType='Project' and pe.refId=prjk_decision.idProject LEFT JOIN prjk_planningelementextension as pex ON pex.refType='Decision' and pex.refId=prjk_decision.id  WHERE  ((prjk_decision.idProject not in (0) or prjk_decision.idProject is null ) and (prjk_decision.idProject not in (0) or prjk_decision.idProject is null or (prjk_decision.idResource='1') ) and (prjk_decision.idProject not in (0) or prjk_decision.idProject is null or (prjk_decision.idUser='1') )) and prjk_decision.idProject not in (0)
  UNION 
    SELECT coalesce(cast( (pex.id+1000000000) AS CHAR) COLLATE latin1_swedish_ci,concat('Delivery','_',prjk_delivery.id)) as id, null as color, prjk_delivery.idProject as idProject, cast('Delivery' AS CHAR) COLLATE latin1_swedish_ci as refType, prjk_delivery.id as refId, prjk_delivery.name as refName, null as topId, 'Project' as topRefType, prjk_delivery.idProject as topRefId, 
      null as priority, 1 as elementary, prjk_delivery.idle as idle, prjk_delivery.done as done, prjk_delivery.cancelled as cancelled, 8 as idPlanningMode, null as idBill, 
      null as initialStartDate, null as validatedStartDate, 0 as validatedStartFraction, prjk_delivery.plannedDate as plannedStartDate, 0 as plannedStartFraction, prjk_delivery.handledDateTime as realStartDate, 
      null as initialEndDate, prjk_delivery.initialDate as validatedEndDate, 1 as validatedEndFraction, prjk_delivery.plannedDate as plannedEndDate, 1 as plannedEndFraction, prjk_delivery.realDate as realEndDate, null as latestStartDate, null as latestEndDate, 
      null as initialDuration, 1 as validatedDuration, null as plannedDuration, null as realDuration, 
      null as initialWork, null as validatedWork, null as assignedWork, null as plannedWork, null as leftWork, null as realWork, 
      null as validatedCost, null as assignedCost, null as plannedCost, null as leftCost, null as realCost, 
      null as progress, null as expectedProgress, coalesce(pex.wbs,concat(pe.wbs,'._#',prjk_delivery.id)) as wbs, coalesce(pex.wbsSortable,concat(pe.wbsSortable,'._#',prjk_delivery.id)) as wbsSortable, null as isOnCriticalPath, null as notPlannedWork, null as needReplan, prjk_delivery.idDeliveryType as idType, prjk_delivery.idStatus as idStatus, prjk_delivery.idResource as idResource, 1 as isGlobal, null as paused
    FROM prjk_delivery LEFT JOIN prjk_planningelement AS pe ON pe.refType='Project' and pe.refId=prjk_delivery.idProject LEFT JOIN prjk_planningelementextension as pex ON pex.refType='Delivery' and pex.refId=prjk_delivery.id  WHERE  ((prjk_delivery.idProject not in (0) or prjk_delivery.idProject is null ) and (prjk_delivery.idProject not in (0) or prjk_delivery.idProject is null or (prjk_delivery.idResource='1') ) and (prjk_delivery.idProject not in (0) or prjk_delivery.idProject is null or (prjk_delivery.idUser='1') )) and prjk_delivery.idProject not in (0)
  UNION 
    SELECT coalesce(cast( (pex.id+1000000000) AS CHAR) COLLATE latin1_swedish_ci,concat('Issue','_',prjk_issue.id)) as id, null as color, prjk_issue.idProject as idProject, cast('Issue' AS CHAR) COLLATE latin1_swedish_ci as refType, prjk_issue.id as refId, prjk_issue.name as refName, null as topId, 'Project' as topRefType, prjk_issue.idProject as topRefId, 
      null as priority, 1 as elementary, prjk_issue.idle as idle, prjk_issue.done as done, prjk_issue.cancelled as cancelled, 8 as idPlanningMode, null as idBill, 
      null as initialStartDate, null as validatedStartDate, 0 as validatedStartFraction, prjk_issue.actualEndDate as plannedStartDate, 0 as plannedStartFraction, prjk_issue.handledDate as realStartDate, 
      null as initialEndDate, prjk_issue.initialEndDate as validatedEndDate, 1 as validatedEndFraction, prjk_issue.actualEndDate as plannedEndDate, 1 as plannedEndFraction, prjk_issue.doneDate as realEndDate, null as latestStartDate, null as latestEndDate, 
      null as initialDuration, 1 as validatedDuration, null as plannedDuration, null as realDuration, 
      null as initialWork, null as validatedWork, null as assignedWork, null as plannedWork, null as leftWork, null as realWork, 
      null as validatedCost, null as assignedCost, null as plannedCost, null as leftCost, null as realCost, 
      null as progress, null as expectedProgress, coalesce(pex.wbs,concat(pe.wbs,'._#',prjk_issue.id)) as wbs, coalesce(pex.wbsSortable,concat(pe.wbsSortable,'._#',prjk_issue.id)) as wbsSortable, null as isOnCriticalPath, null as notPlannedWork, null as needReplan, prjk_issue.idIssueType as idType, prjk_issue.idStatus as idStatus, prjk_issue.idResource as idResource, 1 as isGlobal, null as paused
    FROM prjk_issue LEFT JOIN prjk_planningelement AS pe ON pe.refType='Project' and pe.refId=prjk_issue.idProject LEFT JOIN prjk_planningelementextension as pex ON pex.refType='Issue' and pex.refId=prjk_issue.id  WHERE  ((prjk_issue.idProject not in (0) or prjk_issue.idProject is null ) and (prjk_issue.idProject not in (0) or prjk_issue.idProject is null or (prjk_issue.idResource='1') ) and (prjk_issue.idProject not in (0) or prjk_issue.idProject is null or (prjk_issue.idUser='1') )) and prjk_issue.idProject not in (0)
  UNION 
    SELECT coalesce(cast( (pex.id+1000000000) AS CHAR) COLLATE latin1_swedish_ci,concat('Opportunity','_',prjk_opportunity.id)) as id, null as color, prjk_opportunity.idProject as idProject, cast('Opportunity' AS CHAR) COLLATE latin1_swedish_ci as refType, prjk_opportunity.id as refId, prjk_opportunity.name as refName, null as topId, 'Project' as topRefType, prjk_opportunity.idProject as topRefId, 
      null as priority, 1 as elementary, prjk_opportunity.idle as idle, prjk_opportunity.done as done, prjk_opportunity.cancelled as cancelled, 8 as idPlanningMode, null as idBill, 
      null as initialStartDate, null as validatedStartDate, 0 as validatedStartFraction, prjk_opportunity.actualEndDate as plannedStartDate, 0 as plannedStartFraction, prjk_opportunity.handledDate as realStartDate, 
      null as initialEndDate, prjk_opportunity.initialEndDate as validatedEndDate, 1 as validatedEndFraction, prjk_opportunity.actualEndDate as plannedEndDate, 1 as plannedEndFraction, prjk_opportunity.doneDate as realEndDate, null as latestStartDate, null as latestEndDate, 
      null as initialDuration, 1 as validatedDuration, null as plannedDuration, null as realDuration, 
      null as initialWork, null as validatedWork, null as assignedWork, null as plannedWork, null as leftWork, null as realWork, 
      null as validatedCost, null as assignedCost, null as plannedCost, null as leftCost, null as realCost, 
      null as progress, null as expectedProgress, coalesce(pex.wbs,concat(pe.wbs,'._#',prjk_opportunity.id)) as wbs, coalesce(pex.wbsSortable,concat(pe.wbsSortable,'._#',prjk_opportunity.id)) as wbsSortable, null as isOnCriticalPath, null as notPlannedWork, null as needReplan, prjk_opportunity.idOpportunityType as idType, prjk_opportunity.idStatus as idStatus, prjk_opportunity.idResource as idResource, 1 as isGlobal, null as paused
    FROM prjk_opportunity LEFT JOIN prjk_planningelement AS pe ON pe.refType='Project' and pe.refId=prjk_opportunity.idProject LEFT JOIN prjk_planningelementextension as pex ON pex.refType='Opportunity' and pex.refId=prjk_opportunity.id  WHERE  ((prjk_opportunity.idProject not in (0) or prjk_opportunity.idProject is null ) and (prjk_opportunity.idProject not in (0) or prjk_opportunity.idProject is null or (prjk_opportunity.idResource='1') ) and (prjk_opportunity.idProject not in (0) or prjk_opportunity.idProject is null or (prjk_opportunity.idUser='1') )) and prjk_opportunity.idProject not in (0)
  UNION 
    SELECT coalesce(cast( (pex.id+1000000000) AS CHAR) COLLATE latin1_swedish_ci,concat('Question','_',prjk_question.id)) as id, null as color, prjk_question.idProject as idProject, cast('Question' AS CHAR) COLLATE latin1_swedish_ci as refType, prjk_question.id as refId, prjk_question.name as refName, null as topId, 'Project' as topRefType, prjk_question.idProject as topRefId, 
      null as priority, 1 as elementary, prjk_question.idle as idle, prjk_question.done as done, prjk_question.cancelled as cancelled, 8 as idPlanningMode, null as idBill, 
      null as initialStartDate, null as validatedStartDate, 0 as validatedStartFraction, prjk_question.actualDueDate as plannedStartDate, 0 as plannedStartFraction, prjk_question.handledDate as realStartDate, 
      null as initialEndDate, prjk_question.initialDueDate as validatedEndDate, 1 as validatedEndFraction, prjk_question.actualDueDate as plannedEndDate, 1 as plannedEndFraction, prjk_question.doneDate as realEndDate, null as latestStartDate, null as latestEndDate, 
      null as initialDuration, 1 as validatedDuration, null as plannedDuration, null as realDuration, 
      null as initialWork, null as validatedWork, null as assignedWork, null as plannedWork, null as leftWork, null as realWork, 
      null as validatedCost, null as assignedCost, null as plannedCost, null as leftCost, null as realCost, 
      null as progress, null as expectedProgress, coalesce(pex.wbs,concat(pe.wbs,'._#',prjk_question.id)) as wbs, coalesce(pex.wbsSortable,concat(pe.wbsSortable,'._#',prjk_question.id)) as wbsSortable, null as isOnCriticalPath, null as notPlannedWork, null as needReplan, prjk_question.idQuestionType as idType, prjk_question.idStatus as idStatus, prjk_question.idResource as idResource, 1 as isGlobal, null as paused
    FROM prjk_question LEFT JOIN prjk_planningelement AS pe ON pe.refType='Project' and pe.refId=prjk_question.idProject LEFT JOIN prjk_planningelementextension as pex ON pex.refType='Question' and pex.refId=prjk_question.id  WHERE  ((prjk_question.idProject not in (0) or prjk_question.idProject is null ) and (prjk_question.idProject not in (0) or prjk_question.idProject is null or (prjk_question.idResource='1') ) and (prjk_question.idProject not in (0) or prjk_question.idProject is null or (prjk_question.idUser='1') )) and prjk_question.idProject not in (0)
  UNION 
    SELECT coalesce(cast( (pex.id+1000000000) AS CHAR) COLLATE latin1_swedish_ci,concat('Risk','_',prjk_risk.id)) as id, null as color, prjk_risk.idProject as idProject, cast('Risk' AS CHAR) COLLATE latin1_swedish_ci as refType, prjk_risk.id as refId, prjk_risk.name as refName, null as topId, 'Project' as topRefType, prjk_risk.idProject as topRefId, 
      null as priority, 1 as elementary, prjk_risk.idle as idle, prjk_risk.done as done, prjk_risk.cancelled as cancelled, 8 as idPlanningMode, null as idBill, 
      null as initialStartDate, null as validatedStartDate, 0 as validatedStartFraction, prjk_risk.actualEndDate as plannedStartDate, 0 as plannedStartFraction, prjk_risk.handledDate as realStartDate, 
      null as initialEndDate, prjk_risk.initialEndDate as validatedEndDate, 1 as validatedEndFraction, prjk_risk.actualEndDate as plannedEndDate, 1 as plannedEndFraction, prjk_risk.doneDate as realEndDate, null as latestStartDate, null as latestEndDate, 
      null as initialDuration, 1 as validatedDuration, null as plannedDuration, null as realDuration, 
      null as initialWork, null as validatedWork, null as assignedWork, null as plannedWork, null as leftWork, null as realWork, 
      null as validatedCost, null as assignedCost, null as plannedCost, null as leftCost, null as realCost, 
      null as progress, null as expectedProgress, coalesce(pex.wbs,concat(pe.wbs,'._#',prjk_risk.id)) as wbs, coalesce(pex.wbsSortable,concat(pe.wbsSortable,'._#',prjk_risk.id)) as wbsSortable, null as isOnCriticalPath, null as notPlannedWork, null as needReplan, prjk_risk.idRiskType as idType, prjk_risk.idStatus as idStatus, prjk_risk.idResource as idResource, 1 as isGlobal, null as paused
    FROM prjk_risk LEFT JOIN prjk_planningelement AS pe ON pe.refType='Project' and pe.refId=prjk_risk.idProject LEFT JOIN prjk_planningelementextension as pex ON pex.refType='Risk' and pex.refId=prjk_risk.id  WHERE  ((prjk_risk.idProject not in (0) or prjk_risk.idProject is null ) and (prjk_risk.idProject not in (0) or prjk_risk.idProject is null or (prjk_risk.idResource='1') ) and (prjk_risk.idProject not in (0) or prjk_risk.idProject is null or (prjk_risk.idUser='1') )) and prjk_risk.idProject not in (0)
  UNION 
    SELECT coalesce(cast( (pex.id+1000000000) AS CHAR) COLLATE latin1_swedish_ci,concat('Ticket','_',prjk_ticket.id)) as id, null as color, prjk_ticket.idProject as idProject, cast('Ticket' AS CHAR) COLLATE latin1_swedish_ci as refType, prjk_ticket.id as refId, prjk_ticket.name as refName, null as topId, 'Project' as topRefType, prjk_ticket.idProject as topRefId, 
      null as priority, 1 as elementary, prjk_ticket.idle as idle, prjk_ticket.done as done, prjk_ticket.cancelled as cancelled, 8 as idPlanningMode, null as idBill, 
      null as initialStartDate, null as validatedStartDate, 0 as validatedStartFraction, prjk_ticket.actualDueDateTime as plannedStartDate, 0 as plannedStartFraction, prjk_ticket.handledDateTime as realStartDate, 
      null as initialEndDate, prjk_ticket.initialDueDateTime as validatedEndDate, 1 as validatedEndFraction, prjk_ticket.actualDueDateTime as plannedEndDate, 1 as plannedEndFraction, prjk_ticket.doneDateTime as realEndDate, null as latestStartDate, null as latestEndDate, 
      null as initialDuration, 1 as validatedDuration, null as plannedDuration, null as realDuration, 
      null as initialWork, we.plannedWork as validatedWork, null as assignedWork, we.leftWork+we.realWork as plannedWork, we.leftWork as leftWork, we.realWork as realWork, 
      null as validatedCost, null as assignedCost, null as plannedCost, null as leftCost, null as realCost, 
      null as progress, null as expectedProgress, coalesce(pex.wbs,concat(pe.wbs,'._#',prjk_ticket.id)) as wbs, coalesce(pex.wbsSortable,concat(pe.wbsSortable,'._#',prjk_ticket.id)) as wbsSortable, null as isOnCriticalPath, null as notPlannedWork, null as needReplan, prjk_ticket.idTicketType as idType, prjk_ticket.idStatus as idStatus, prjk_ticket.idResource as idResource, 1 as isGlobal, null as paused
    FROM prjk_ticket LEFT JOIN prjk_planningelement AS pe ON pe.refType='Project' and pe.refId=prjk_ticket.idProject LEFT JOIN prjk_planningelementextension as pex ON pex.refType='Ticket' and pex.refId=prjk_ticket.id 
        LEFT JOIN prjk_workelement AS we ON we.refType='Ticket' AND we.refId=prjk_ticket.id  WHERE  ((prjk_ticket.idProject not in (0) or prjk_ticket.idProject is null ) and (prjk_ticket.idProject not in (0) or prjk_ticket.idProject is null or (prjk_ticket.idResource='1') ) and (prjk_ticket.idProject not in (0) or prjk_ticket.idProject is null or (prjk_ticket.idUser='1') )) and prjk_ticket.idProject not in (0)) as prjk_planningelement
 WHERE prjk_planningelement.idle=0  and (1=1) and prjk_planningelement.idProject in (0, 1, 3) and prjk_planningelement.idProject not in (0, 2)
 ORDER BY prjk_planningelement.wbsSortable 
2021-05-11 16:02:22.135 ***** ERROR ***** [V9.1.2]    Strack trace :
2021-05-11 16:02:22.135 ***** ERROR ***** [V9.1.2]    #0 Sql->query called at [/home/znkwsomc/public_html/projectsstaging/tool/jsonPlanning.php:292]
2021-05-11 16:02:22.135 ***** ERROR ***** [V9.1.2]    #1 include called at [/home/znkwsomc/public_html/projectsstaging/view/globalPlanningList.php:279]
2021-05-11 16:02:22.135 ***** ERROR ***** [V9.1.2]    #2 include called at [/home/znkwsomc/public_html/projectsstaging/view/globalPlanningMain.php:79]
2021-05-11 16:02:30.066 ***** ERROR ***** [V9.1.2] ERROR *****
2021-05-11 16:02:30.066 ***** ERROR ***** [V9.1.2] on file '/home/znkwsomc/public_html/projectsstaging/view/objectDetail.php' at line (9355)
2021-05-11 16:02:30.066 ***** ERROR ***** [V9.1.2] cause = ob_get_clean(): failed to discard buffer of zlib output compression (1)
2021-05-11 16:02:44.369 ===== TRACE ===== DISCONNECTED USER 'admin'
2021-05-11 17:00:03.102 ===== TRACE ===== Automatic planning calculation : differential calculation - start - Projects : 3
2021-05-11 17:00:04.203 ===== TRACE ===== Automatic planning calculation : differential calculation - end - result = Planning correctly updated
2021-05-11 18:00:07.459 ===== TRACE ===== Automatic planning calculation : differential calculation - start - Projects : 3
2021-05-11 18:00:08.462 ===== TRACE ===== Automatic planning calculation : differential calculation - end - result = Planning correctly updated
2021-05-11 19:00:01.779 ===== TRACE ===== Automatic planning calculation : differential calculation - start - Projects : 3
2021-05-11 19:00:02.362 ===== TRACE ===== Automatic planning calculation : differential calculation - end - result = Planning correctly updated
2021-05-11 20:00:07.546 ===== TRACE ===== Automatic planning calculation : differential calculation - start - Projects : 3
2021-05-11 20:00:09.080 ===== TRACE ===== Automatic planning calculation : differential calculation - end - result = Planning correctly updated
2021-05-11 21:00:05.407 ===== TRACE ===== Automatic planning calculation : differential calculation - start - Projects : 3
2021-05-11 21:00:06.451 ===== TRACE ===== Automatic planning calculation : differential calculation - end - result = Planning correctly updated
2021-05-11 22:00:02.025 ===== TRACE ===== Automatic planning calculation : differential calculation - start - Projects : 3
2021-05-11 22:00:04.171 ===== TRACE ===== Automatic planning calculation : differential calculation - end - result = Planning correctly updated
2021-05-11 23:00:03.488 ===== TRACE ===== Automatic planning calculation : differential calculation - start - Projects : 3
2021-05-11 23:00:04.379 ===== TRACE ===== Automatic planning calculation : differential calculation - end - result = Planning correctly updated