Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.
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