Ticket #1221 (closed improve feature: fixed)

Opened 3 years ago

Last modified 2 years ago

Find members feature needs alternate name

Reported by: jeanyves Owned by:
Priority: major Milestone: unassigned
Component: BW Search Keywords: geo
Cc: philipp

Description

I found out a mysterious problem with Find member, when I was seeking for Barcelona the place was found but not the member. Peter tried it and found the member.

In fact the reason is that because I have browser setup in french, my query was translated by some google app probably from Barcelona to Barcelonne (french name)

I have so changed the Findsearch model to have it looking in alterbates name (where Barcelonne can be found connected to Barcelona).

Alternates name were really very empty, so I uploaded from geonames today in a separated database ("geo") and after I run :

replace into geonames_alternate_names select geo.alternatename.* from geo.alternatename,geonames_cache where geo.alternatename.geonameid=geonames_cache.geonameid

This allowed bearcelonne, Londres, Moscou to exist

Now the point of this ticket: we need to load the values of AlternatesName? for what we have in geonames_cache and to keep them fresh. Apparently it was not the case

Change History

comment:1 Changed 2 years ago by fake51

  • Status changed from new to closed
  • Resolution set to fixed
Note: See TracTickets for help on using tickets.