Opened 10 years ago

Closed 10 years ago

Last modified 6 years ago

#655 closed bug (fixed)

Members count in all US states shows 341

Reported by: timalsina Owned by:
Priority: major Milestone: Legacy Resolved
Component: BW Search Keywords: Members count
Cc:

Description

Total members count for each US states is defaulted to 341 instead of counting actual members number for each state. Tested on production site.

BW Rox version: r5670

user agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.0.1) Gecko/2008070206 Firefox/3.0.1 request uri: http://www.bewelcome.org/places/US

Change History (5)

comment:1 Changed 10 years ago by jeanyves

  • follow_up changed from test to release
  • Resolution set to fixed
  • Status changed from new to closed

I have fixed it by re-programming the query with also some perf improvments

Nota now, from time to time an update of the regions.NbMembers? need to be done the queries for volunteers can do this)

a dedicated cron for this will be needed

comment:2 Changed 10 years ago by philipp

This might change with the new geosystem but I am not absolutely sure

comment:3 Changed 10 years ago by philipp

  • follow_up changed from release to none

comment:4 Changed 10 years ago by jeanyves

I think we will find a way to avoid to "loose the feature"

when your work will be finished for the geo, we probably can consider creating some cities and regions views (instead of the current tables cities / regions)

This should allow all the previous code to work and will avoid data redudancies

comment:5 Changed 6 years ago by TimLoal

  • Milestone changed from unassigned to Legacy Resolved
Note: See TracTickets for help on using tickets.