samchen2009 / ekanban

a kanban plugin for redmine
103 stars 42 forks source link

Status :No kanban pane associated with status 'New' #35

Open lawr opened 11 years ago

lawr commented 11 years ago

When creating an issue, I get the following error and the issue is never created:

"Status :No kanban pane associated with status 'New', contact redmine admin!"

I have successfully set up a state accepting new, linked to a stage, and in "Issue statuses and kanban states" associated "New" with my kanban_state.

I have also successfully created a Kanban board in my project as instructed in your main github page.

I have verified the mysql record

Here's the Kicker: I get the exact same error message when creating an issue on your demo Redmine server http://106.187.39.28/projects/mybloh/issues

eKanban version: git clone from 8/8/2013.

Redmine info: Environment: Redmine version 2.1.4.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.8 Environment production Database adapter Mysql2 Redmine plugins: ekanban 0.0.1

mysql> select * from kanban_panes;
+----+----------+-----------+-----------+-----------------+----------------+-------------+---------+-------------+----------+
| id | name     | kanban_id | wip_limit | kanban_state_id | wip_limit_auto | description | role_id | in_progress | position |
+----+----------+-----------+-----------+-----------------+----------------+-------------+---------+-------------+----------+
|  1 | pane_one |         3 |         1 |               5 |              1 |             |       2 |           0 |        1 |
+----+----------+-----------+-----------+-----------------+----------------+-------------+---------+-------------+----------+

mysql> select * from issue_status_kanban_states;
+----+-----------------+-----------------+
| id | issue_status_id | kanban_state_id |
+----+-----------------+-----------------+
|  7 |               1 |               5 |
+----+-----------------+-----------------+

mysql> select * from kanban_states;
+----+-----------+------------+------------+-----------+------------+----------+----------+-------------+
| id | name      | is_default | is_initial | is_closed | tracker_id | position | stage_id | description |
+----+-----------+------------+------------+-----------+------------+----------+----------+-------------+
|  5 | State_New |          0 |          1 |         0 |          1 |     NULL |        5 |             |
+----+-----------+------------+------------+-----------+------------+----------+----------+-------------+

mysql> select * from kanban_stages;
+----+-----------+-------------+
| id | name      | description |
+----+-----------+-------------+
|  5 | Stage_New |             |
+----+-----------+-------------+

mysql> select * from issue_statuses;
+----+-------------+-----------+------------+----------+--------------------+
| id | name        | is_closed | is_default | position | default_done_ratio |
+----+-------------+-----------+------------+----------+--------------------+
|  1 | New         |         0 |          1 |        1 |               NULL |
|  2 | In Progress |         0 |          0 |        2 |               NULL |
|  3 | Resolved    |         0 |          0 |        3 |               NULL |
|  4 | Feedback    |         0 |          0 |        4 |               NULL |
|  5 | Closed      |         1 |          0 |        5 |               NULL |
|  6 | Rejected    |         1 |          0 |        6 |               NULL |
+----+-------------+-----------+------------+----------+--------------------+
samchen2009 commented 11 years ago

The error was from "pane = KanbanPane.pane_by(state_id, kanban)" , could you show you 'kanban' table? I guess the pane doesn't belong to the proper kanban.

lawr commented 11 years ago
mysql> select * from kanbans;
+----+-------------+------------+------------+------------+---------------------+---------------------+----------+-------------+
| id | name        | project_id | tracker_id | created_by | created_on          | updated_on          | is_valid | description |
+----+-------------+------------+------------+------------+---------------------+---------------------+----------+-------------+
|  1 | Bugs_kanban |          1 |          1 |          1 | 2013-08-08 17:34:41 | 2013-08-08 17:37:44 |        0 |             |
|  2 | Tracker     |          1 |          1 |          1 | 2013-08-08 17:45:34 | 2013-08-08 18:02:04 |        0 |             |
|  3 | test_kanban |          1 |          1 |          1 | 2013-08-08 22:09:01 | 2013-08-09 13:54:36 |        0 |             |
|  4 | kanban      |          1 |          1 |          1 | 2013-08-09 14:08:45 | 2013-08-09 14:08:45 |        1 |             |
|  5 | Test Board  |          1 |          3 |          1 | 2013-08-09 19:02:49 | 2013-08-09 19:02:56 |        0 |             |
+----+-------------+------------+------------+------------+---------------------+---------------------+----------+-------------+
samchen2009 commented 11 years ago

Only kanban #4 is 'valid' but the only pane belongs to kanban #3, you can 'edit' the kanban #4 in 'Settings' and 'New Kanban Pane'.