https://www.redmine.org/https://www.redmine.org/favicon.ico?16793021292009-12-02T17:51:59ZRedmineRedmine - Defect #4314: Broken issue list pagination in 0.8.7https://www.redmine.org/issues/4314?journal_id=126292009-12-02T17:51:59ZJean-Philippe Langjp_lang@yahoo.fr
<ul></ul><p>I can't reproduce.<br />Please take a few seconds to describe your problem.</p> Redmine - Defect #4314: Broken issue list pagination in 0.8.7https://www.redmine.org/issues/4314?journal_id=128542009-12-09T06:19:04ZCraig Hawkes
<ul></ul><p>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:</p>
<pre>
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)
</pre> Redmine - Defect #4314: Broken issue list pagination in 0.8.7https://www.redmine.org/issues/4314?journal_id=129352009-12-14T08:51:06ZVinod Singh
<ul></ul><p>The output of 'ruby script/about' is-</p>
<pre>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</pre>
<p>Though above output shows environment as development with mysql while it is <strong><code>production with postgresql</code></strong>. The OS is Fedora 11 with kernel 2.6.30.9</p>
<p>The issue list pagination works fine on same machine in Redmine v0.8.4</p> Redmine - Defect #4314: Broken issue list pagination in 0.8.7https://www.redmine.org/issues/4314?journal_id=130212009-12-17T05:00:27ZCraig Hawkes
<ul></ul><p>Does pagination work for you on the mysql database, or not?<br />I have a problem (see) <a class="external" href="http://www.redmine.org/boards/2/topics/10132">http://www.redmine.org/boards/2/topics/10132</a> 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</p> Redmine - Defect #4314: Broken issue list pagination in 0.8.7https://www.redmine.org/issues/4314?journal_id=130222009-12-17T05:04:09ZVinod Singh
<ul></ul><p>Craig Hawkes wrote:</p>
<blockquote>
<p>Does pagination work for you on the mysql database, or not?<br />I have a problem (see) <a class="external" href="http://www.redmine.org/boards/2/topics/10132">http://www.redmine.org/boards/2/topics/10132</a> 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</p>
</blockquote>
<p>I did not tried MySQL. We are using PostgreSQL 8.4.</p> Redmine - Defect #4314: Broken issue list pagination in 0.8.7https://www.redmine.org/issues/4314?journal_id=130302009-12-17T16:51:19ZCraig Hawkes
<ul></ul><p>In that case - can you try changing a line of code in the issues_controller - are you comforable making Rails changes?<br />in the issues_controller file, there is a index method, can you try:<br /><pre>
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)
</pre></p> Redmine - Defect #4314: Broken issue list pagination in 0.8.7https://www.redmine.org/issues/4314?journal_id=130392009-12-17T22:22:47ZCraig Hawkes
<ul></ul><p>Hi</p>
<p>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</p> Redmine - Defect #4314: Broken issue list pagination in 0.8.7https://www.redmine.org/issues/4314?journal_id=130682009-12-18T14:27:52ZJean-Philippe Langjp_lang@yahoo.fr
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Closed</i></li><li><strong>Resolution</strong> set to <i>Wont fix</i></li></ul><p>Never had this problem with mysql or Postgres 8.3.<br />Please reopen if upgrading to Postgres 8.4.2 does not fix the problem.</p>