Opened 7 years ago

Closed 7 years ago

Last modified 7 years ago

#1601 closed bug (fixed)

Kosovo is not shown in places

Reported by: globetrotter_tt Owned by: planetcruiser
Priority: blocker Milestone: 0.5.9 - bugfixing
Component: BW Geo Keywords: kosovo, geonames, places
Cc: planetcruiser

Description (last modified by planetcruiser)

Issue:

Solution:

Note:

  • Apparently places in Kosovo are found during the signup process.

Related ticket:

Change History (7)

comment:1 Changed 7 years ago by planetcruiser

  • Description modified (diff)
  • Milestone changed from unassigned to 0.5.9 - bugfixing

added #1614 hint

comment:2 Changed 7 years ago by globetrotter_tt

I have added Kosvo in my local database:

INSERT INTO `bewelcome`.`geonames_countries` (
`iso_alpha2` ,
`name` ,
`continent` ,
`languages`
)
VALUES (
'XK', 'Kosovo', 'EU', 'sq,sr'
);

and

INSERT INTO `bewelcome`.`geonames_cache` (
`geonameid` ,
`latitude` ,
`longitude` ,
`name` ,
`population` ,
`fk_countrycode` ,
`fk_admincode` ,
`fclass` ,
`fcode` ,
`timezone` ,
`parentAdm1Id` ,
`parentCountryId`
)
VALUES (
'831053', '42.58333', '21', 'Republic of Kosovo', '1800000', 'XK', '00', 'A', 'PCLI', '0', '0', '0'
);

now it shows up in the list of countries.

comment:3 Changed 7 years ago by globetrotter_tt

  • Owner set to planetcruiser
  • Status changed from new to assigned

comment:4 follow-up: Changed 7 years ago by planetcruiser

  • Resolution set to fixed
  • Status changed from assigned to closed

yes, kosovo was present in geonames_cache, but not geonames_countries. that's why people could select it during sign-up.

i added XK to geonames_countries and now members in http://alpha.bewelcome.org/places/XK are shown (i briefly relocated myself to test).

i also added the xk flag via: http://gitorious.org/bewelcome/rox/commit/49c4edde4a16463e6095fc2afab19fa55014ed90

also see: #1621

comment:5 in reply to: ↑ 4 Changed 7 years ago by globetrotter_tt

comment:6 Changed 7 years ago by globetrotter_tt

ok nevermind, next time i will read the ticket before writing a reply ;-)

comment:7 Changed 7 years ago by planetcruiser

hehe.

oh, btw: the sprite (http://www.bewelcome.org/styles/css/minimal/images/places-sprites.png) needs to be updated, too!

Note: See TracTickets for help on using tickets.