View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Kanban plugin - error on moving tile on a kanban board based on activity status - ProjeQtOr
 

Kanban plugin - error on moving tile on a kanban board based on activity status

More
11 Dec 2018 10:11 #1 by lfrugere
When moving an activity from column "Backlog" (activity status id = 1) to column "En cours" (activity status id = 3) an SQL error occured (see below)

error in query is "AND activity.idStatus in ()"

Log :
2018-12-11 10:02:14.251 ***** ERROR ***** [V6.5.5] For query : SELECT activity.id as id,
activity.name as name,
activity.idActivityType as idtickettype,
activity.idStatus as idstatus,
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.idStatus in () AND planningelement.refType='Activity' AND planningelement.refId=activity.id and 1=1 AND activity.idProject in (0, 302) AND activity.idle=0
2018-12-11 10:02:14.251 ***** ERROR ***** [V6.5.5] Strack trace :
2018-12-11 10:02:14.251 ***** ERROR ***** [V6.5.5] #0 Sql->query called at [/var/www/projeqtor/plugin/kanban/kanbanView.php:664]
2018-12-11 10:02:14.251 ***** ERROR ***** [V6.5.5] #1 queryToDo called at [/var/www/projeqtor/plugin/kanban/kanbanView.php:280]
2018-12-11 10:02:14.251 ***** ERROR ***** [V6.5.5] #2 drawColumnKanban called at [/var/www/projeqtor/plugin/kanban/kanbanView.php:175]
2018-12-11 10:02:14.251 ***** ERROR ***** [V6.5.5] #3 include called at [/var/www/projeqtor/plugin/kanban/kanbanViewMain.php:27]

Adsitional informations
select * from plugin
id;description;name;zipFile;deploymentDate;isDeployed;deploymentVersion;compatibilityVersion;pluginVersion;idle;comment;uniqueCode
1;Translation of parameters values into french;translationFrench;../plugin/translationFrench.zip;2016-03-21;1;V5.2.4;V5.2.0;1.0;0;[NULL];100002
2];Customization of screens;screenCustomization;../plugin/screenCustomization_V2.1.zip;2017-01-03;1;V5.5.4;V5.2.3;2.1;1;[NULL];100004
3;Customization of screens;screenCustomization;../plugin/screenCustomization_V3.1.zip;2017-01-24;1;V6.0.5;V6.0.6;3.1;1;[NULL];100004
4;Customization of screens;screenCustomization;../plugin/screenCustomization_V5.1.zip;2018-02-15;1;V6.5.5;V6.4.4;5.1;0;[NULL];100004
5;Kanban;kanban;../plugin/kanban_V3.5.zip;2018-12-10;1;V6.5.5;V6.3.7;3.5;0;[NULL];100006

select * from kanban
id;idUser;isShared;name;type;param
1;1;0;Kanban;Status;{"column":[{"from":"1","name":"Backlog","cantDelete":true},{"from":"10","name":"Pris en charge"},{"from":"5","name":"Fait"},{"from":"7","name":"Clos"}],"typeData":"Ticket"}
3;3;1;Kanban Activités;Status;{"column":[{"from":"1","name":"Backlog","cantDelete":true},{"from":"3","name":"En cours"},{"from":"7","name":"Termin\u00e9"},{"from":"9","name":"Annul\u00e9"}],"typeData":"Activity"}

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

More
11 Dec 2018 11:13 #2 by Damian.sd
Hello,
Have you the last version of kanban plugin ?
if it not case try to update this.

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

More
11 Dec 2018 13:36 #3 by lfrugere
Yes,
Plugin was bought, downloaded and installed yesterday.

5;Kanban;kanban;../plugin/kanban_V3.5.zip;2018-12-10;1;V6.5.5;V6.3.7;3.5;0;[NULL];100006

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

More
11 Dec 2018 14:44 #4 by babynus
Hi,

This issue seems to occur with older versions of projeqtor.
It does not occur on most recent version (V7.2).
If you have the opportunity, migration to newer version will fix the issue.

I've recorded ticket #3718 to fix this on Kanban and preserve compatibility with V6.5

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

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

More
11 Dec 2018 15:57 #5 by babynus
Hi,
I could not reproduce your issue but think I have the fix.
Could you please try and install attached patch (unzip it at root, like a new version of projeqtor) and tell us if it fixes your issue ?
Thanks

Babynus
Administrator of ProjeQtOr web site
Attachments:

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

More
11 Dec 2018 16:25 #6 by lfrugere
Same error but no logs now !

RequestError: Unable to load ../plugin/kanban/kanbanUpdate.php?idTicket=1317&type=Status&newStatut=3&idKanban=3 status: 500
Contactez votre administrateur
(l'erreur détaillée est consignée dans le fichier de log)

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

Moderators: babynusprotion
Time to create page: 0.042 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.