View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - V9.2.0 Problem on global planning - ProjeQtOr
 
 

V9.2.0 Problem on global planning

More
30 Jun 2021 11:19 #1 by cedric.pache
Hi everybody ! 
I have an issue with the global planning view, which still empty. I'm on the 9.2 version but it was already like this on 9.1.
Here are logs.
Thank you by advance for your help !2021-06-30 11:18:53.714 ***** ERROR ***** [V9.2.0] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
2021-06-30 11:18:53.715 ***** ERROR ***** [V9.2.0] For query : SELECT planningelement.*
FROM
( SELECT cast(id as CHAR) COLLATE utf8mb4_general_ci as id,color,idProject,cast(refType AS CHAR) COLLATE utf8mb4_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 , null as paused
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 utf8mb4_general_ci,concat('Action','_',action.id)) as id, null as color, action.idProject as idProject, cast('Action' AS CHAR) COLLATE utf8mb4_general_ci as refType, action.id as refId, action.name as refName, null as topId, 'Project' as topRefType, action.idProject as topRefId,
null as priority, 1 as elementary, action.idle as idle, action.done as done, action.cancelled as cancelled, 8 as idPlanningMode, null as idBill,
null as initialStartDate, null as validatedStartDate, 0 as validatedStartFraction, action.actualDueDate as plannedStartDate, 0 as plannedStartFraction, action.handledDate as realStartDate,
null as initialEndDate, action.initialDueDate as validatedEndDate, 1 as validatedEndFraction, action.actualDueDate as plannedEndDate, 1 as plannedEndFraction, 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,'._#',action.id)) as wbs, coalesce(pex.wbsSortable,concat(pe.wbsSortable,'._#',action.id)) as wbsSortable, null as isOnCriticalPath, null as notPlannedWork, null as needReplan, action.idActionType as idType, action.idStatus as idStatus, action.idResource as idResource, 1 as isGlobal, null 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='3') ) and (action.idProject not in (0) or action.idProject is null or (action.idUser='3') )) and action.idProject not in (0)
UNION
SELECT coalesce(cast( (pex.id+1000000000) AS CHAR) COLLATE utf8mb4_general_ci,concat('Decision','_',decision.id)) as id, null as color, decision.idProject as idProject, cast('Decision' AS CHAR) COLLATE utf8mb4_general_ci as refType, decision.id as refId, decision.name as refName, null as topId, 'Project' as topRefType, decision.idProject as topRefId,
null as priority, 1 as elementary, decision.idle as idle, decision.done as done, decision.cancelled as cancelled, 8 as idPlanningMode, null as idBill,
null as initialStartDate, null as validatedStartDate, 0 as validatedStartFraction, decision.decisionDate as plannedStartDate, 0 as plannedStartFraction, decision.decisionDate as realStartDate,
null as initialEndDate, decision.decisionDate as validatedEndDate, 1 as validatedEndFraction, decision.decisionDate as plannedEndDate, 1 as plannedEndFraction, 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,'._#',decision.id)) as wbs, coalesce(pex.wbsSortable,concat(pe.wbsSortable,'._#',decision.id)) as wbsSortable, null as isOnCriticalPath, null as notPlannedWork, null as needReplan, decision.idDecisionType as idType, decision.idStatus as idStatus, decision.idResource as idResource, 1 as isGlobal, null 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='3') ) and (decision.idProject not in (0) or decision.idProject is null or (decision.idUser='3') )) and decision.idProject not in (0)
UNION
SELECT coalesce(cast( (pex.id+1000000000) AS CHAR) COLLATE utf8mb4_general_ci,concat('Incoming','_',deliverable.id)) as id, null as color, deliverable.idProject as idProject, cast('Incoming' AS CHAR) COLLATE utf8mb4_general_ci as refType, deliverable.id as refId, deliverable.name as refName, null as topId, 'Project' as topRefType, deliverable.idProject as topRefId,
null as priority, 1 as elementary, deliverable.idle as idle, deliverable.idle as done, deliverable.idle as cancelled, 8 as idPlanningMode, null as idBill,
null as initialStartDate, null as validatedStartDate, 0 as validatedStartFraction, deliverable.plannedDate as plannedStartDate, 0 as plannedStartFraction, deliverable.realDate as realStartDate,
null as initialEndDate, deliverable.initialDate as validatedEndDate, 1 as validatedEndFraction, deliverable.plannedDate as plannedEndDate, 1 as plannedEndFraction, deliverable.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,'._#',deliverable.id)) as wbs, coalesce(pex.wbsSortable,concat(pe.wbsSortable,'._#',deliverable.id)) as wbsSortable, null as isOnCriticalPath, null as notPlannedWork, null as needReplan, deliverable.idDeliverableType as idType, deliverable.idDeliverableStatus as idStatus, deliverable.idResource as idResource, 1 as isGlobal, null as paused
FROM deliverable LEFT JOIN planningelement AS pe ON pe.refType='Project' and pe.refId=deliverable.idProject LEFT JOIN planningelementextension as pex ON pex.refType='Incoming' and pex.refId=deliverable.id WHERE ((deliverable.idProject not in (0) or deliverable.idProject is null ) and (deliverable.idProject not in (0) or deliverable.idProject is null or (deliverable.idResource='3') ) and (deliverable.idProject not in (0) or deliverable.idProject is null or (deliverable.idUser='3') )) and deliverable.scope='Incoming'and deliverable.idProject not in (0)
UNION
SELECT coalesce(cast( (pex.id+1000000000) AS CHAR) COLLATE utf8mb4_general_ci,concat('Deliverable','_',deliverable.id)) as id, null as color, deliverable.idProject as idProject, cast('Deliverable' AS CHAR) COLLATE utf8mb4_general_ci as refType, deliverable.id as refId, deliverable.name as refName, null as topId, 'Project' as topRefType, deliverable.idProject as topRefId,
null as priority, 1 as elementary, deliverable.idle as idle, deliverable.idle as done, deliverable.idle as cancelled, 8 as idPlanningMode, null as idBill,
null as initialStartDate, null as validatedStartDate, 0 as validatedStartFraction, deliverable.plannedDate as plannedStartDate, 0 as plannedStartFraction, deliverable.realDate as realStartDate,
null as initialEndDate, deliverable.initialDate as validatedEndDate, 1 as validatedEndFraction, deliverable.plannedDate as plannedEndDate, 1 as plannedEndFraction, deliverable.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,'._#',deliverable.id)) as wbs, coalesce(pex.wbsSortable,concat(pe.wbsSortable,'._#',deliverable.id)) as wbsSortable, null as isOnCriticalPath, null as notPlannedWork, null as needReplan, deliverable.idDeliverableType as idType, deliverable.idDeliverableStatus as idStatus, deliverable.idResource as idResource, 1 as isGlobal, null as paused
FROM deliverable LEFT JOIN planningelement AS pe ON pe.refType='Project' and pe.refId=deliverable.idProject LEFT JOIN planningelementextension as pex ON pex.refType='Deliverable' and pex.refId=deliverable.id WHERE ((deliverable.idProject not in (0) or deliverable.idProject is null ) and (deliverable.idProject not in (0) or deliverable.idProject is null or (deliverable.idResource='3') ) and (deliverable.idProject not in (0) or deliverable.idProject is null or (deliverable.idUser='3') )) and deliverable.scope='Deliverable'and deliverable.idProject not in (0)
UNION
SELECT coalesce(cast( (pex.id+1000000000) AS CHAR) COLLATE utf8mb4_general_ci,concat('Delivery','_',delivery.id)) as id, null as color, delivery.idProject as idProject, cast('Delivery' AS CHAR) COLLATE utf8mb4_general_ci as refType, delivery.id as refId, delivery.name as refName, null as topId, 'Project' as topRefType, delivery.idProject as topRefId,
null as priority, 1 as elementary, delivery.idle as idle, delivery.done as done, delivery.cancelled as cancelled, 8 as idPlanningMode, null as idBill,
null as initialStartDate, null as validatedStartDate, 0 as validatedStartFraction, delivery.plannedDate as plannedStartDate, 0 as plannedStartFraction, delivery.handledDateTime as realStartDate,
null as initialEndDate, delivery.initialDate as validatedEndDate, 1 as validatedEndFraction, delivery.plannedDate as plannedEndDate, 1 as plannedEndFraction, 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,'._#',delivery.id)) as wbs, coalesce(pex.wbsSortable,concat(pe.wbsSortable,'._#',delivery.id)) as wbsSortable, null as isOnCriticalPath, null as notPlannedWork, null as needReplan, delivery.idDeliveryType as idType, delivery.idStatus as idStatus, delivery.idResource as idResource, 1 as isGlobal, null 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='3') ) and (delivery.idProject not in (0) or delivery.idProject is null or (delivery.idUser='3') )) and delivery.idProject not in (0)
UNION
SELECT coalesce(cast( (pex.id+1000000000) AS CHAR) COLLATE utf8mb4_general_ci,concat('Opportunity','_',opportunity.id)) as id, null as color, opportunity.idProject as idProject, cast('Opportunity' AS CHAR) COLLATE utf8mb4_general_ci as refType, opportunity.id as refId, opportunity.name as refName, null as topId, 'Project' as topRefType, opportunity.idProject as topRefId,
null as priority, 1 as elementary, opportunity.idle as idle, opportunity.done as done, opportunity.cancelled as cancelled, 8 as idPlanningMode, null as idBill,
null as initialStartDate, null as validatedStartDate, 0 as validatedStartFraction, opportunity.actualEndDate as plannedStartDate, 0 as plannedStartFraction, opportunity.handledDate as realStartDate,
null as initialEndDate, opportunity.initialEndDate as validatedEndDate, 1 as validatedEndFraction, opportunity.actualEndDate as plannedEndDate, 1 as plannedEndFraction, 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,'._#',opportunity.id)) as wbs, coalesce(pex.wbsSortable,concat(pe.wbsSortable,'._#',opportunity.id)) as wbsSortable, null as isOnCriticalPath, null as notPlannedWork, null as needReplan, opportunity.idOpportunityType as idType, opportunity.idStatus as idStatus, opportunity.idResource as idResource, 1 as isGlobal, null 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='3') ) and (opportunity.idProject not in (0) or opportunity.idProject is null or (opportunity.idUser='3') )) and opportunity.idProject not in (0)
UNION
SELECT coalesce(cast( (pex.id+1000000000) AS CHAR) COLLATE utf8mb4_general_ci,concat('Issue','_',issue.id)) as id, null as color, issue.idProject as idProject, cast('Issue' AS CHAR) COLLATE utf8mb4_general_ci as refType, issue.id as refId, issue.name as refName, null as topId, 'Project' as topRefType, issue.idProject as topRefId,
null as priority, 1 as elementary, issue.idle as idle, issue.done as done, issue.cancelled as cancelled, 8 as idPlanningMode, null as idBill,
null as initialStartDate, null as validatedStartDate, 0 as validatedStartFraction, issue.actualEndDate as plannedStartDate, 0 as plannedStartFraction, issue.handledDate as realStartDate,
null as initialEndDate, issue.initialEndDate as validatedEndDate, 1 as validatedEndFraction, issue.actualEndDate as plannedEndDate, 1 as plannedEndFraction, 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,'._#',issue.id)) as wbs, coalesce(pex.wbsSortable,concat(pe.wbsSortable,'._#',issue.id)) as wbsSortable, null as isOnCriticalPath, null as notPlannedWork, null as needReplan, issue.idIssueType as idType, issue.idStatus as idStatus, issue.idResource as idResource, 1 as isGlobal, null 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='3') ) and (issue.idProject not in (0) or issue.idProject is null or (issue.idUser='3') )) and issue.idProject not in (0)
UNION
SELECT coalesce(cast( (pex.id+1000000000) AS CHAR) COLLATE utf8mb4_general_ci,concat('Question','_',question.id)) as id, null as color, question.idProject as idProject, cast('Question' AS CHAR) COLLATE utf8mb4_general_ci as refType, question.id as refId, question.name as refName, null as topId, 'Project' as topRefType, question.idProject as topRefId,
null as priority, 1 as elementary, question.idle as idle, question.done as done, question.cancelled as cancelled, 8 as idPlanningMode, null as idBill,
null as initialStartDate, null as validatedStartDate, 0 as validatedStartFraction, question.actualDueDate as plannedStartDate, 0 as plannedStartFraction, question.handledDate as realStartDate,
null as initialEndDate, question.initialDueDate as validatedEndDate, 1 as validatedEndFraction, question.actualDueDate as plannedEndDate, 1 as plannedEndFraction, 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,'._#',question.id)) as wbs, coalesce(pex.wbsSortable,concat(pe.wbsSortable,'._#',question.id)) as wbsSortable, null as isOnCriticalPath, null as notPlannedWork, null as needReplan, question.idQuestionType as idType, question.idStatus as idStatus, question.idResource as idResource, 1 as isGlobal, null 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='3') ) and (question.idProject not in (0) or question.idProject is null or (question.idUser='3') )) and question.idProject not in (0)
UNION
SELECT coalesce(cast( (pex.id+1000000000) AS CHAR) COLLATE utf8mb4_general_ci,concat('Risk','_',risk.id)) as id, null as color, risk.idProject as idProject, cast('Risk' AS CHAR) COLLATE utf8mb4_general_ci as refType, risk.id as refId, risk.name as refName, null as topId, 'Project' as topRefType, risk.idProject as topRefId,
null as priority, 1 as elementary, risk.idle as idle, risk.done as done, risk.cancelled as cancelled, 8 as idPlanningMode, null as idBill,
null as initialStartDate, null as validatedStartDate, 0 as validatedStartFraction, risk.actualEndDate as plannedStartDate, 0 as plannedStartFraction, risk.handledDate as realStartDate,
null as initialEndDate, risk.initialEndDate as validatedEndDate, 1 as validatedEndFraction, risk.actualEndDate as plannedEndDate, 1 as plannedEndFraction, 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,'._#',risk.id)) as wbs, coalesce(pex.wbsSortable,concat(pe.wbsSortable,'._#',risk.id)) as wbsSortable, null as isOnCriticalPath, null as notPlannedWork, null as needReplan, risk.idRiskType as idType, risk.idStatus as idStatus, risk.idResource as idResource, 1 as isGlobal, null 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='3') ) and (risk.idProject not in (0) or risk.idProject is null or (risk.idUser='3') )) and risk.idProject not in (0)
UNION
SELECT coalesce(cast( (pex.id+1000000000) AS CHAR) COLLATE utf8mb4_general_ci,concat('Ticket','_',ticket.id)) as id, null as color, ticket.idProject as idProject, cast('Ticket' AS CHAR) COLLATE utf8mb4_general_ci as refType, ticket.id as refId, ticket.name as refName, null as topId, 'Project' as topRefType, ticket.idProject as topRefId,
null as priority, 1 as elementary, ticket.idle as idle, ticket.done as done, ticket.cancelled as cancelled, 8 as idPlanningMode, null as idBill,
null as initialStartDate, null as validatedStartDate, 0 as validatedStartFraction, ticket.actualDueDateTime as plannedStartDate, 0 as plannedStartFraction, ticket.handledDateTime as realStartDate,
null as initialEndDate, ticket.initialDueDateTime as validatedEndDate, 1 as validatedEndFraction, ticket.actualDueDateTime as plannedEndDate, 1 as plannedEndFraction, 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,'._#',ticket.id)) as wbs, coalesce(pex.wbsSortable,concat(pe.wbsSortable,'._#',ticket.id)) as wbsSortable, null as isOnCriticalPath, null as notPlannedWork, null as needReplan, ticket.idTicketType as idType, ticket.idStatus as idStatus, ticket.idResource as idResource, 1 as isGlobal, null 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='3') ) and (ticket.idProject not in (0) or ticket.idProject is null or (ticket.idUser='3') )) and ticket.idProject not in (0)) as planningelement
WHERE planningelement.idle=0 and (1=1) and planningelement.idProject in (0, 10) and planningelement.idProject not in (0)
ORDER BY planningelement.wbsSortable
2021-06-30 11:18:53.715 ***** ERROR ***** [V9.2.0] Strack trace :
2021-06-30 11:18:53.716 ***** ERROR ***** [V9.2.0] #0 Sql->query called at [C:\xampp\htdocs\projeqtor\tool\jsonPlanning.php:292]
2021-06-30 11:18:53.716 ***** ERROR ***** [V9.2.0] #1 include called at [C:\xampp\htdocs\projeqtor\view\globalPlanningList.php:297]
2021-06-30 11:18:53.716 ***** ERROR ***** [V9.2.0] #2 include called at [C:\xampp\htdocs\projeqtor\view\globalPlanningMain.php:98]

 

Please Log in or Create an account to join the conversation.

More
01 Jul 2021 15:07 #2 by babynus
You DB is encoded in 'utf8mb4'
ProjeQtOr supports only utf8

You can try and play with parameter $paramDbCollation that you can add in your parameters.php file
Try 

$paramDbCollation='utf8_general_ci';

or 

$paramDbCollation='utf8mb4_general_ci';


Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: fsouliers

Please Log in or Create an account to join the conversation.

More
03 Aug 2021 08:42 #3 by fsouliers
First one worked for me, many thanks Babynus ! :)

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.044 seconds

Cookies settings

×

Functional Cookies

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

Please login to see yours activities!

Other cookies

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