Trying to add new columns in Kanban board v6.5.7

Start
Prev
1
Next
End

caccia
Topic Author
Offline
Platinum Member

11 May 2018 18:45 #1 by caccia

Trying to add new columns in Kanban board v6.5.7 was created by caccia

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 ?

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

babynus
Offline
Administrator
Moderator

11 May 2018 19:42 #2 by babynus

Replied by babynus on topic Trying to add new columns in Kanban board v6.5.7

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

Babynus
Administrator of ProjeQtOr web site

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

caccia
Topic Author
Offline
Platinum Member

15 May 2018 11:35 #3 by caccia

Replied by caccia on topic Trying to add new columns in Kanban board v6.5.7

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

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

babynus
Offline
Administrator
Moderator

16 May 2018 09:31 #4 by babynus

Replied by babynus on topic Trying to add new columns in Kanban board v6.5.7

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 ?

Babynus
Administrator of ProjeQtOr web site

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

caccia
Topic Author
Offline
Platinum Member

11 Jun 2018 12:39 #5 by caccia

Replied by caccia on topic Trying to add new columns in Kanban board v6.5.7

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

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

Start
Prev
1
Next
End

Moderators: babynus, protion

Time to create page: 0.057 seconds

Trying to add new columns in Kanban board v6.5.7

Attachments:

Attachments:

Cookies settings

Functional Cookies

Session

Other cookies

Trying to add new columns in Kanban board v6.5.7

Attachments:

Attachments:

Cookies settings

Functional Cookies

Session

Other cookies

Login Form