Which Redmine version, any plugins, etc. ?

See [[SubmittingBugs]] for required details.
--------------------------------------------------------------------------------
Information
* Redmine version: 1.2.0.devel.5969
* Database version: MySql 5.0.51a-3ubuntu5.5
* Ruby version: ruby 1.8.7 (2009-12-24 patchlevel 248) [i686-linux], MBARI 0x8770, Ruby Enterprise Edition 2010.01
* Rails version: rails-2.3.11

Plugins:
* Bulk Time Entry
* Customer plugin
* Redmine Graphs
* Knowledgebase

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
Strange, it shouldn't happen, but it's difficult to debug it without knowing the particularities of your database. If it doesn't contain top secret informations, you can send me a dump jeanbaptiste.barth [at] gmail.com, I'll see if I can reproduce and find out where the problem is.
--------------------------------------------------------------------------------
Just two things more :
* please precise if it occurs only on some projects or on the cross-project view (and detailed steps to reproduce if needed)
* if you send me the dump, please mention the URL to this issue in your email so it rings a bell for me
--------------------------------------------------------------------------------
Jean-Baptiste Barth wrote:
> Just two things more :
> * please precise if it occurs only on some projects or on the cross-project view (and detailed steps to reproduce if needed)
> * if you send me the dump, please mention the URL to this issue in your email so it rings a bell for me

Jean-Baptiste, the information is confidencial, so i can't send it. Structure the project is:

main project 1 (is being queried)
sub-project 1.1
sub-project 1.2
sub-project 1.3
sub-project 1.3.1 (archived)
sub-project 1.3.2
sub-project 1.3.3
sub-project 1.3.4 (archived)
sub-project 1.3.5 (archived)
sub-project 1.3.6
sub-project 1.3.7
sub-project 1.3.8 (archived)
sub-project 1.3.9 (archived)
sub-project 1.3.10
sub-project 1.3.11
sub-project 1.3.12
sub-project 1.4
sub-project 1.5
sub-project 1.6 (archived)
sub-project 1.7 (archived)
sub-project 1.8
sub-project 1.9
--------------------------------------------------------------------------------
Jean, i can send more information? you need i execute any test?

Thank

Rodrigo
--------------------------------------------------------------------------------
It's ok, I'll have a look at it but maybe not right now. I already saw some problems counting paginated results, don't know if they're related.
--------------------------------------------------------------------------------
Hi Jean-Baptiste, I update the last version and the problem persist. You have any patch to test?

Thank
--------------------------------------------------------------------------------
Could you please try to remove (temporarily) your plugins and restart the application ?
--------------------------------------------------------------------------------
Etienne Massip wrote:
> Could you please try to remove (temporarily) your plugins and restart the application ?

Hi Etiene, I remove the plugins and the problem persist.

Show me:

> 1 2 3 4 Next » (1-100/347) | Per page: 25, 50, 100

but in the page 3 show me: "No data to display"

Plugins:

> Migrating action_mailer_optional_tls...
> Migrating acts_as_activity_provider...
> Migrating acts_as_attachable...
> Migrating acts_as_customizable...
> Migrating acts_as_event...
> Migrating acts_as_list...
> Migrating acts_as_searchable...
> Migrating acts_as_tree...
> Migrating acts_as_versioned...
> Migrating acts_as_watchable...
> Migrating attachment_fu...
> Migrating awesome_nested_set...
> Migrating classic_pagination...
> Migrating gravatar...
> Migrating open_id_authentication...
> Migrating prepend_engine_views...
> Migrating rfpdf...
> Migrating ruby-net-ldap-0.0.4...

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
#8848 tell us it is due to archived projects.
--------------------------------------------------------------------------------
@Query#issue_count@ (source:/trunk/app/models/query.rb#L504) returns:
<pre><code class="ruby">Issue.count(:include => [:status, :project], :conditions => statement)</code></pre>

Should be:
<pre><code class="ruby">Issue.visible.count(:include => [:status, :project], :conditions => statement)</code></pre>
--------------------------------------------------------------------------------
proposed patch
--------------------------------------------------------------------------------
Same with tests @issues_count@ and @issues_count_with_archived_issues@.

Please note that default test data includes issues which are not visible, so both tests would fail without the @Query@ fix.
--------------------------------------------------------------------------------
Patch applied in r6314, thanks.
--------------------------------------------------------------------------------
thanks!!! my problem was resolved!
--------------------------------------------------------------------------------
Can someone please create a link with #9411 (same bug but in roadmap with totals closed/open)? (Or cancel #9411 if it's corrected with this patch ?)
--------------------------------------------------------------------------------
Merged in r7765.
--------------------------------------------------------------------------------

relates,Closed,8815,Invalid search results with paging
relates,Closed,8943,Broken paginations on the view "all issues" page
relates,Closed,9411,Number of issues closed / open in Roadmap include private even on restricted accounts
duplicates,Closed,8848,Custom queries count, count also issue of archived projects