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":"Terminu00e9"},{"from":"9","name":"Annulu00e9"}],"typeData":"Activity"}
Hello,
Have you the last version of kanban plugin ?
if it not case try to update this.
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
The lasted version of kanban is v3.6 available on projeqtor v7.0.
1) Update projeqtor to the last version actually v7.3.1.
2) Update your kanban plugin to v3.6.
3) Clean your cache after update.
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
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
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)
Hi,
Error 500 means you muist have a log.
If it's not in ProjeQtOr log, it's in Apache error log.
Could you please have a look in Apache error log and post here errror at time of Kanban issue ?
Thanks
Hi,
In addition, I tried to reproduce the issue you're meeting with same configuration
ProjeQtOr V6.5.5 (NB : you should consider migrating to V6.5.7 a least)
Kanban V3.5
PHP V7.0.10
I defined a simple Kanban for Tickets with 2 cols : Backlog and "En cours" (status in progress)
(see attached file)
I don't face any issue.
Could you please give more information on configuration of your Kanban board so that I could reproduce the issue ?
I just updated to 6.5.7.
Same issue and no error in logs neither in projeqtor.log or in /var/log/apache2/error.log
PHP 5.3.10-1ubuntu3.23 with Suhosin-Patch (cli) (built: May 19 2016 20:22:56)
Copyright (c) 1997-2012 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2012 Zend Technologies
And I cannot upgrade PHP version because OS is too old 🙁
Is it possible to send you my projeqtor installation archive for further investigation ?
Lionel
Is it possible to send you my projeqtor installation archive for further investigation ?
PM message sent.
Can you check the browser console for any error ?
{…}message: "Unable to load ../plugin/kanban/kanbanUpdate.php?idTicket=1317&type=Status&newStatut=3&idKanban=3 status: 500"response: Object { url: "../plugin/kanban/kanbanUpdate.php?idTicket=1317&type=Status&newStatut=3&idKanban=3", options: {…}, status: 500, … }responseText: ""stack: "_4a8@ http://lxetudes01/projeqtor/external/dojo/dojo.js?version=V6.5.7.0190:2:126483n_31d@http://lxetudes01/projeqtor/external/dojo/dojo.js?version=V6.5.7.0190:2:85374n_32a@http://lxetudes01/projeqtor/external/dojo/dojo.js?version=V6.5.7.0190:2:85801 n"status: 500xhr: XMLHttpRequest { readyState: 4, timeout: 0, withCredentials: false, … }: Object { name: "RequestError", constructor: _4a8(), stack: "" } dojo.js:2:104011
Can you resend PM please ?
PM is always available (but not easy to access) and not sent as email.
Click on your avatar icon on right of forum menu
You'll be able to access private messages
It is very strange you don't get an error.
Result of request in browser concole is ERROR 500 : it means server error, so an error should be logger, at least in apache error log.
PM sent