Software » Web » Redmine plugins » Scrum

Hi,
i have deployed the 'Scrum' in redmine that deployed in tomcat, but when i click into 'Scrum', it display 'No data to display'.

i check the debuginfo. these is some puzzle: 'AND 1=0' will return no data 
  SELECT `issues`.* FROM `issues` WHERE `issues`.`sprint_id` = 2 AND 1=0 ORDER BY position ASC

DebugInfo:
24-Oct-2014 15:29:04.737 INFO [http-apr-9090-exec-3] org.apache.catalina.core.ApplicationContext.log Sprint Load (0.0ms) SELECT `sprints`.* FROM `sprints` WHERE `sprints`.`project_id` = 1 AND `sprints`.`is_product_backlog` = 0 ORDER BY start_date ASC, name ASC

24-Oct-2014 15:29:04.753 INFO [http-apr-9090-exec-3] org.apache.catalina.core.ApplicationContext.log Issue Load (0.0ms) SELECT `issues`.* FROM `issues` WHERE `issues`.`sprint_id` = 2 AND 1=0 ORDER BY position ASC

24-Oct-2014 15:29:04.768 INFO [http-apr-9090-exec-3] org.apache.catalina.core.ApplicationContext.log Issue Load (15.0ms) SELECT `issues`.* FROM `issues` WHERE `issues`.`sprint_id` = 2 AND 1=0

24-Oct-2014 15:29:04.768 INFO [http-apr-9090-exec-3] org.apache.catalina.core.ApplicationContext.log CACHE (0.0ms) SELECT `issues`.* FROM `issues` WHERE `issues`.`sprint_id` = 2 AND 1=0

24-Oct-2014 15:29:04.784 INFO [http-apr-9090-exec-3] org.apache.catalina.core.ApplicationContext.log SprintEffort Load (0.0ms) SELECT `sprint_efforts`.* FROM `sprint_efforts` WHERE `sprint_efforts`.`sprint_id` = 2

24-Oct-2014 15:29:04.784 INFO [http-apr-9090-exec-3] org.apache.catalina.core.ApplicationContext.log Rendered plugins/scrum/app/views/post_its/sprint_board/_head.html.erb (47.0ms)

24-Oct-2014 15:29:04.800 INFO [http-apr-9090-exec-3] org.apache.catalina.core.ApplicationContext.log CACHE (0.0ms) SELECT `issues`.* FROM `issues` WHERE `issues`.`sprint_id` = 2 AND 1=0 ORDER BY position ASC

24-Oct-2014 15:29:04.800 INFO [http-apr-9090-exec-3] org.apache.catalina.core.ApplicationContext.log Tracker Load (0.0ms) SELECT `trackers`.* FROM `trackers` WHERE 1=0

24-Oct-2014 15:29:04.800 INFO [http-apr-9090-exec-3] org.apache.catalina.core.ApplicationContext.log Rendered plugins/scrum/app/views/common/_scrum_footer.html.erb (0.0ms)

24-Oct-2014 15:29:04.800 INFO [http-apr-9090-exec-3] org.apache.catalina.core.ApplicationContext.log Rendered plugins/scrum/app/views/sprints/show.html.erb within layouts/base (79.0ms)

24-Oct-2014 15:29:04.815 INFO [http-apr-9090-exec-3] org.apache.catalina.core.ApplicationContext.log UserPreference Load (0.0ms) SELECT `user_preferences`.* FROM `user_preferences` WHERE `user_preferences`.`user_id` = 1 LIMIT 1

24-Oct-2014 15:29:04.831 INFO [http-apr-9090-exec-3] org.apache.catalina.core.ApplicationContext.log Rendered plugins/scrum/app/views/scrum_hooks/_head.html.erb (0.0ms)

24-Oct-2014 15:29:04.862 INFO [http-apr-9090-exec-3] org.apache.catalina.core.ApplicationContext.log SQL (0.0ms) SELECT `members`.`id` AS t0_r0, `members`.`user_id` AS t0_r1, `members`.`project_id` AS t0_r2, `members`.`created_on` AS t0_r3, `members`.`mail_notification` AS t0_r4, `projects`.`id` AS t1_r0, `projects`.`name` AS t1_r1, `projects`.`description` AS t1_r2, `projects`.`homepage` AS t1_r3, `projects`.`is_public` AS t1_r4, `projects`.`parent_id` AS t1_r5, `projects`.`created_on` AS t1_r6, `projects`.`updated_on` AS t1_r7, `projects`.`identifier` AS t1_r8, `projects`.`status` AS t1_r9, `projects`.`lft` AS t1_r10, `projects`.`rgt` AS t1_r11, `projects`.`inherit_members` AS t1_r12, `projects`.`product_backlog_id` AS t1_r13, `roles`.`id` AS t2_r0, `roles`.`name` AS t2_r1, `roles`.`position` AS t2_r2, `roles`.`assignable` AS t2_r3, `roles`.`builtin` AS t2_r4, `roles`.`permissions` AS t2_r5, `roles`.`issues_visibility` AS t2_r6 FROM `members` LEFT OUTER JOIN `projects` ON `projects`.`id` = `members`.`project_id` LEFT OUTER JOIN `member_roles` ON `member_roles`.`member_id` = `members`.`id` LEFT OUTER JOIN `roles` ON `roles`.`id` = `member_roles`.`role_id` WHERE `members`.`user_id` = 1 AND (projects.status<>9) ORDER BY projects.name

24-Oct-2014 15:29:04.878 INFO [http-apr-9090-exec-3] org.apache.catalina.core.ApplicationContext.log  (0.0ms) SELECT COUNT FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.`id` = `versions`.`project_id` WHERE (projects.id = 1 OR (projects.status <> 9 AND ( versions.sharing = 'system' OR (projects.lft >= 1 AND projects.rgt <= 2 AND versions.sharing = 'tree') OR (projects.lft < 1 AND projects.rgt > 2 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 1 AND projects.rgt < 2 AND versions.sharing = 'hierarchy'))))

24-Oct-2014 15:29:04.893 INFO [http-apr-9090-exec-3] org.apache.catalina.core.ApplicationContext.log Wiki Load (0.0ms) SELECT `wikis`.* FROM `wikis` WHERE `wikis`.`project_id` = 1 LIMIT 1

24-Oct-2014 15:29:04.909 INFO [http-apr-9090-exec-3] org.apache.catalina.core.ApplicationContext.log  (0.0ms) SELECT COUNT FROM `boards` WHERE `boards`.`project_id` = 1

24-Oct-2014 15:29:04.909 INFO [http-apr-9090-exec-3] org.apache.catalina.core.ApplicationContext.log Repository Load (0.0ms) SELECT `repositories`.* FROM `repositories` WHERE `repositories`.`project_id` = 1 AND (is_default = 1) LIMIT 1

24-Oct-2014 15:29:04.909 INFO [http-apr-9090-exec-3] org.apache.catalina.core.ApplicationContext.log Completed 200 OK in 250.0ms (Views: 173.0ms | ActiveRecord: 15.0ms)

Others:
Environment:
Redmine version 2.5.3.stable
Ruby version 1.9.3-p392 (2014-09-25) [java]
Rails version 3.2.19
Environment production
Database adapter MySQL
SCM:
Filesystem
Redmine plugins:
scrum 0.7.0