Defect #4314

Broken issue list pagination in 0.8.7

Added by Vinod Singh almost 5 years ago. Updated almost 5 years ago.

Status:ClosedStart date:2009-12-01
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:Issues
Target version:-
Resolution:Wont fix Affected version:0.8.7

Description

The issue list pagination is broken in v0.8.7, which used to work fine in v0.8.4. See the screenshot for better understanding-

BrokenIssueListPagination.png (2.88 KB) Vinod Singh, 2009-12-01 04:59

History

#1 Updated by Jean-Philippe Lang almost 5 years ago

I can't reproduce.
Please take a few seconds to describe your problem.

#2 Updated by Craig Hawkes almost 5 years ago

This could be related to a problem I also have in the head version. To fix it I have changed the following in the issues controller within the index method:

commented this line
#      @issue_count = Issue.count(:include => [:status, :project], :conditions => @query.statement)

and replaced with:
      @issue_count = Issue.count(:include => [ :assigned_to, :status, :tracker, :project, :priority, :category, :fixed_version ],
                                 :conditions => @query.statement)

#3 Updated by Vinod Singh almost 5 years ago

The output of 'ruby script/about' is-

About your application's environment
Ruby version              1.8.7 (i686-linux)
RubyGems version          1.3.4
Rails version             2.1.2
Active Record version     2.1.2
Action Pack version       2.1.2
Active Resource version   2.1.2
Action Mailer version     2.1.2
Active Support version    2.1.2
Edge Rails revision       unknown
Application root          /opt/apps/redmine-0.8.7
Environment               development
Database adapter          mysql

About your Redmine plugins
Redmine Hudson plugin   1.0.1.1
Tab Plugin              0.3.1

Though above output shows environment as development with mysql while it is production with postgresql. The OS is Fedora 11 with kernel 2.6.30.9

The issue list pagination works fine on same machine in Redmine v0.8.4

#4 Updated by Craig Hawkes almost 5 years ago

Does pagination work for you on the mysql database, or not?
I have a problem (see) http://www.redmine.org/boards/2/topics/10132 where pagination is not working in Postgres, but I have ported the same data into mysql and it is working fine - This is on the truck version rather than v0.8.7 so it may be different to your problem

#5 Updated by Vinod Singh almost 5 years ago

Craig Hawkes wrote:

Does pagination work for you on the mysql database, or not?
I have a problem (see) http://www.redmine.org/boards/2/topics/10132 where pagination is not working in Postgres, but I have ported the same data into mysql and it is working fine - This is on the truck version rather than v0.8.7 so it may be different to your problem

I did not tried MySQL. We are using PostgreSQL 8.4.

#6 Updated by Craig Hawkes almost 5 years ago

In that case - can you try changing a line of code in the issues_controller - are you comforable making Rails changes?
in the issues_controller file, there is a index method, can you try:

commented this line
#      @issue_count = Issue.count(:include => [:status, :project], :conditions => @query.statement)

and replaced with:
      @issue_count = Issue.count(:include => [ :assigned_to, :status, :tracker, :project, :priority, :category, :fixed_version ],
                                 :conditions => @query.statement)

#7 Updated by Craig Hawkes almost 5 years ago

Hi

I think I have found the solution (well it is working for us, we still need to do more testing). It appears to be a problem in Postgres 8.4 and they have issued a fix. Can I suggest that you try and install Postgres 8.4.2 which is a patch which was released a few days ago. You should be able to install over the top, and just do a reindex

#8 Updated by Jean-Philippe Lang almost 5 years ago

  • Status changed from New to Closed
  • Resolution set to Wont fix

Never had this problem with mysql or Postgres 8.3.
Please reopen if upgrading to Postgres 8.4.2 does not fix the problem.

Also available in: Atom PDF