Ubuntu Geonames

Ubuntu's geonames only knows about Hong Kong in Guyana, not in China

Bug #1150109 reported by Pete Graner
22
This bug affects 6 people
Affects Status Importance Assigned to Milestone
Ubuntu Geonames
Fix Released
Undecided
Dimitri John Ledkov

Bug Description

See attached screenshot.

The indicator is showing the Hong Kong time to be 1 hour off, additionally it should read 22:59 not 11:59 which should really be 23:59. I took a screen shot with the browser open to timeanddate.com with the "current" time for Hong Kong. The indicator doesn't show properly. This is the only timezone I have seen this behavior on. Also I have the clock set to display in 24 hour time.

ProblemType: Bug
DistroRelease: Ubuntu 13.04
Package: indicator-datetime 12.10.3daily13.02.06-0ubuntu1
ProcVersionSignature: Ubuntu 3.8.0-10.19-generic 3.8.2
Uname: Linux 3.8.0-10-generic x86_64
ApportVersion: 2.9-0ubuntu2
Architecture: amd64
Date: Wed Mar 6 13:25:05 2013
EcryptfsInUse: Yes
InstallationDate: Installed on 2013-02-22 (12 days ago)
InstallationMedia: Ubuntu 13.04 "Raring Ringtail" - Alpha amd64 (20130221)
MarkForUpload: True
ProcEnviron:
 TERM=xterm
 PATH=(custom, no user)
 XDG_RUNTIME_DIR=<set>
 LANG=en_US.UTF-8
 SHELL=/bin/bash
SourcePackage: indicator-datetime
UpgradeStatus: No upgrade log present (probably fresh install)

Related branches

lp:ubuntu-geonames
Revision history for this message
Pete Graner (pgraner) wrote :
Revision history for this message
Sebastien Bacher (seb128) wrote :

Thanks Pete, that's not a bug in the indicator but in the service:

http://geoname-lookup.ubuntu.com/?query=hong%20kong returns only "Hong Kong" in Guyana, it also explains why you have 11:59, it's not one hour off with the wrong 12/24 notation but it's 11 hours off from the China time...

affects: indicator-datetime (Ubuntu) → ubuntu-geoip
affects: ubuntu-geoip → ubuntu-geonames
summary: - Hong Kong Time zone shows wrong time
+ Ubuntu's geonames only knows about Hong Kong in Guyana, not in China
Revision history for this message
Sebastien Bacher (seb128) wrote :

Dmitrijs said he would have a look, assigning to him, thanks!

Changed in ubuntu-geonames:
assignee: nobody → Dmitrijs Ledkovs (xnox)
status: New → Confirmed
Revision history for this message
Sebastien Bacher (seb128) wrote :

bug #1099369 indicates the database doesn't know about "singapore" either, we should maybe have a look at updating the db

Revision history for this message
Dimitri John Ledkov (xnox) wrote :

Turns out our database does know about all of these locations, but our SQL query is buggy.
It was incorrectly joining and discarding locations which have administrative district set to NULL or '00', thus ignoring many locations which happen to be district by themself e.g. Hong Kong, Bangladesh, Mexico etc. Most of them are simply countries, e.g. "Ireland". Overall we were ignoring about 5% of location, but some of them are high profile in terms of population or by virtue of being a capital.

Changed in ubuntu-geonames:
status: Confirmed → In Progress
Dimitri John Ledkov (xnox)
Changed in ubuntu-geonames:
status: In Progress → Fix Committed
Revision history for this message
Dimitri John Ledkov (xnox) wrote :

Pending deployment in production https://portal.admin.canonical.com/60594

Revision history for this message
Dimitri John Ledkov (xnox) wrote :

Deployed.

Changed in ubuntu-geonames:
status: Fix Committed → Fix Released
Revision history for this message
Michael Doube (michael-doube) wrote :

(From Singapore/Singapore duplicate)

Fixed here, can add Singapore / Singapore to my list of timezones

Revision history for this message
Dimitri John Ledkov (xnox) wrote : Re: [Bug 1150109] Re: Ubuntu's geonames only knows about Hong Kong in Guyana, not in China

On 22 April 2013 10:06, Michael Doube <email address hidden> wrote:
> (From Singapore/Singapore duplicate)
>
> Fixed here, can add Singapore / Singapore to my list of timezones
>

Horay! Thanks for confirming =) \o/

Revision history for this message
O (okns) wrote :

Singapore cannot be selected. Ubuntu 16.04 LTS.

Revision history for this message
O (okns) wrote :

Hong Kong is similarly gone.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.