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
Reply posted (also nedd DB backup)
Reply posted
OK, I installed an instance from your data.
I connected as admin and accessed to Kanban.
I first accessed "Kanban Activité", managing activities, where I could move items from "En cours" to "Terminé"
I could move some activities (for instance #7) from "Backlog" to "En cours", but not all as I got a blocking message "le champ 'date de fin validée' est obligatoire":
Then I accessed "Kanban", managing Tickets.
There, I could not move any item : when you get a ticket and move it over another column, header is always red showing that move is impossible. Header is green only when Ticket is over his own column.
This means that the Workflow forbids the move : You cannot move the items from their current status to the first status of any column.
If it is the behavior you get, this is normal, the definition of your Kanban doew not fit the definition of the workflow.
If your behavior is different, please explain it step by step, using ids :
- wich user is connection (id of user)
- which kanban is used
- which item (id) is moved, from where to where...
Thanks
PM sent with steps to reproduce issue
Hi,
I generated environment from your data : I could not reproduce the issue.
I sent you a PM with detail and acces to test platform.
Sure there is something wrong with your environment.
Please search for error, there must be something logged somewhere.
Possibly on Apache Error log or on Apache log or on PHP log (if any) or on Projeqtor log or on Browser console.
Possibly you may find syslog gathering all messages.
:woohoo: I GOT IT :woohoo:
I had to revert my dev env to PHP 5..3 (not easy as it required to revert also Apache from 2.4 to V2.2 in my Wamp)
Then I reproduced.
So it's a PHP 5.3 issue.
To fix it, replace line 38 in plugin/jkanban/kanbanUpdate.php from
$typeKanbanType=json_decode($Kanban->param,true)['typeData'];
to
$json=json_decode($Kanban->param,true); $typeKanbanType=$json['typeData'];
This should work then.
I hope there is no other such syntax that PHP 5.3 does not support.
Congrats !
Many thanks