Hello,
I'm testing Kanban plugin on my current version V6.5.7.
It is working nicely using the default board, but I'm having trouble creating a customized board.
On the default tickets status board, if I add new column I get the following error:
2018-05-11 18:36:53.938 => 0.022 ** ERROR ** [V6.5.7] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by t.sortOrder' at line 1 2018-05-11 18:36:53.938 => 0.000 ** ERROR ** [V6.5.7] For query : SELECT t.id as typen, t.sortOrder as sortorder FROM status t WHERE t.sortOrder>= order by t.sortOrder 2018-05-11 18:36:53.938 => 0.000 ** ERROR ** [V6.5.7] Strack trace : 2018-05-11 18:36:53.938 => 0.000 ** ERROR ** [V6.5.7] #0 Sql->query called at [/opt/ipmp/html/iPMP_purepjq/plugin/kanban/kanbanView.php:20] 2018-05-11 18:36:53.938 => 0.000 ** ERROR ** [V6.5.7] #1 getNextFrom called at [/opt/ipmp/html/iPMP_purepjq/plugin/kanban/kanbanView.php:20] 2018-05-11 18:36:53.938 => 0.000 ** ERROR ** [V6.5.7] #2 drawColumnKanban called at [/opt/ipmp/html/iPMP_purepjq/plugin/kanban/kanbanView.php:20] 2018-05-11 18:36:53.939 => 0.000 ** ERROR ** [V6.5.7] ERROR ** 2018-05-11 18:36:53.939 => 0.000 ** ERROR ** [V6.5.7] on file '/opt/ipmp/html/iPMP_purepjq/plugin/kanban/kanbanView.php' at line (20) 2018-05-11 18:36:53.939 => 0.000 ** ERROR ** [V6.5.7] cause = Undefined variable: listId 2018-05-11 18:36:53.939 => 0.000 ** ERROR ** [V6.5.7] ERROR ** 2018-05-11 18:36:53.939 => 0.000 ** ERROR ** [V6.5.7] on file '/opt/ipmp/html/iPMP_purepjq/plugin/kanban/kanbanView.php' at line (20) 2018-05-11 18:36:53.939 => 0.000 ** ERROR ** [V6.5.7] cause = Invalid argument supplied for foreach()
I had this on my standard test DB, but same error when starting from scratch on an empty DB.
Am I perhaps missing some parameter ?
Possibly default dashboard used status that don't exist any more on your instance.
Try and check existing columns.
Also try with brand new Kanban
Hi, sorry for the delay - I've been trying to make sure my environment is as clean as possible to reproduce.
My scenario:
- using Projeqtor v6.5.7 release
- start from empty database => all tables are created at first logon
- create one project "Test" and 2 tickets in that project
- install Kanban plugin
- disconnect and empty cache, then reconnect
- open default Kanban => everything looks OK
- click on "add new column" => there is a JS error :
dojo/parser::parse() error Error: Tried to register widget with id==kanbanName but that id is already registered
and the pop-up looks like this:
- create new Kanban board based on Ticket and status => created OK, both tickets are listed in default column "Backlog" (from recorded to cancelled)
- click on "add new column" => the same JS error appears
I left everything in default values (list of status, workflows, etc.) from the empty initialized database.
Any ideas are welcome 🙂
I cannot reproduce on Demo, with ProjeQtOr V7.0.7, Kanban V3.4.
Could you try on V.7.0.7 if it still reproduces ?
Which browser are you using ?
Which version of Kanban ?
Very long delay, sorry.
I've tried just now on v7.0.9, but can't manage to add new columns to a board.
My plugin version is 3.5.eval - perhaps something there.
My test scenario is:
- start off from empty database, let the application initialize the DB.
- Then create one project, one activity, one resource and two tickets.
- Open Kanban screen => default board is OK
- Create new board => all tickets appear in single column "Backlog (from recorded to cancelled)"
- Create new column : name = 'todo', status = 'in progress'
=> error For query : SELECT t.id as typen, t.sortOrder as sortorder FROM status t WHERE t.sortOrder>= order by t.sortOrder
Note that the pop-up window to create the new column looks odd (attached):
Regards