Hello,
I have this erro when i create a kanban with activity:2021-02-02 19:40:43.639 ** ERROR ** [V9.0.2] Exception-[42703] SQLSTATE[42703]: Undefined column: 7 ERREUR: la colonne activity.idurgency n'existe pas
LINE 5: activity.idUrgency as idurgency,
^
2021-02-02 19:40:43.639 ** ERROR ** [V9.0.2] For query : SELECT activity.id as id,
activity.name as name,
activity.idActivityType as idtickettype,
activity.idStatus as idstatus,
activity.idUrgency as idurgency,
activity.idProject as idproject, 0 as idpriority, activity.idVersion as idtargetproductversion, activity.idActivity as idactivity, planningelement.plannedWork as plannedwork, planningelement.realWork as realwork, activity.description as description, planningelement.leftWork as leftwork, activity.idResource as iduser,
status.sortOrder,
resource.fullName as name4, version.name as name5 FROM planningelement, status, activity left join resource on activity.idresource=resource.id left join version on activity.idVersion=version.id WHERE status.id=activity.idStatus AND activity.idActivity is null AND planningelement.refType='Activity' AND planningelement.refId=activity.id and 1=1 and ((activity.idProject not in (0) or activity.idProject is null ) and (activity.idProject not in (0) or activity.idProject is null or (activity.idResource='3') ) and (activity.idProject not in (0) or activity.idProject is null or (activity.idUser='3') )) AND (activity.idProject in (0, 199)) AND activity.idle=0
I can create this column manually ?
Thanks and congratulation for this project ! (i repeat that allow 10 years now ...)
Hello,
indeed in 9.0.2 there is an issue , and it's fixed in v9.0.3.
If you don't want to change version here are the corrections to be madefor fixed this:
- in kanbanConstructPrinc.php (ligne 29)
replace "if($line )" to "if(isset($line )) "
- in KanBanview.php
delete "$tableName.idUrgency as idurgency," (ligne 694)
and add " if(property_exists($typeKanbanC, "idUrgency"))$query.="$tableName.idUrgency as idurgency,"; " (ligne 695)
Thanks for your answer
I have migrate to the last version and now i have this error:
2021-02-03 10:42:41.452 ** ERROR ** [V9.0.3] Exception-[42601] SQLSTATE[42601]: Syntax error: 7 ERREUR: erreur de syntaxe sur ou près de « ) »
LINE 1: ...where (predecessorRefType='' and predecessorRefId=) or (succ...
^
2021-02-03 10:42:41.452 ** ERROR ** [V9.0.3] For query : select count(*) as cpt from dependency where (predecessorRefType='' and predecessorRefId=) or (successorRefType='' and successorRefId=)
2021-02-03 10:42:41.452 ** ERROR ** [V9.0.3] Strack trace :
2021-02-03 10:42:41.452 ** ERROR ** [V9.0.3] #0 Sql->query called at [/home/projtma/public_html/model/persistence/SqlElement.php:2777]
2021-02-03 10:42:41.452 ** ERROR ** [V9.0.3] #1 SqlElement->countSqlElementsFromCriteria called at [/home/projtma/public_html/model/PlanningElementExtension.php:131]
2021-02-03 10:42:41.452 ** ERROR ** [V9.0.3] #2 PlanningElementExtension->checkDelete called at [/home/projtma/public_html/model/Dependency.php:252]
2021-02-03 10:42:41.452 ** ERROR ** [V9.0.3] #3 Dependency->delete called at [/home/projtma/public_html/tool/removeDependency.php:48]
2021-02-03 10:42:41.452 ** ERROR ** [V9.0.3] Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERREUR: la transaction est annulée, les commandes sont ignorées jusqu'à la fin du bloc
de la transaction
Issue fixed on V9.0.4
Thanks !