Ticket #1571 (closed bug: fixed)
Browse by country member counters wrong
| Reported by: | planetcruiser | Owned by: | |
|---|---|---|---|
| Priority: | major | Milestone: | 0.5.7 - bugfixing |
| Component: | BW Search | Keywords: | |
| Cc: |
Description
Issue:
- The numbers stated behind the region and cities when browsing a country are almost always incorrect
Reproduce:
- Go to Find members -> browse countries ( http://www.bewelcome.org/places)
- Click "Lebanon (8)"
- 8 members are shown
- Click "Mohafazat Beyrouth (9)" -> this already is more than 8, duh ;)
- 5 members are shown
- Click "Beirut (9)"
- 5 members are shown
- Go back to "Libanon" ( http://www.bewelcome.org/places/LB)
- Click on "Mohafazat Liban-Nord (3)"
- 3 members are shown, member counters for Tripoli and Batroun are correct
Solution:
- Show the correct member number in brackets
Clues:
- The number of members in brackets when browsing regions and cities seems to be always higher than the number of actual members. Maybe deleted or deactivated members are also counted in the SQL query?
Change History
comment:1 Changed 4 months ago by planetcruiser
- Status changed from new to closed
- Resolution set to fixed
comment:2 Changed 4 months ago by planetcruiser
- Milestone changed from unassigned to 0.5.7 - bugfixing
comment:3 Changed 4 months ago by planetcruiser
note that members are now counted in real-time instead of read from the counter in regions.NbMembers?, because the regions table is being decommissioned. this might put some extra strain on database queries, but so far the counting queries execute very fast
see https://gitorious.org/bewelcome/rox/commit/cef3cf8e2244ba364b260ea7468663ba1221471e for a related commit
Note: See
TracTickets for help on using
tickets.



solved via #1591 :)