labia

Tuesday 19 August 2003

The find within distance function on OpenGuides London stopped working today. Eek! It was returning the error message:

  DBD::Pg::st execute failed: ERROR:  pg_atoi: error in "174448 ": can't
  parse " " at lib/CGI/Wiki/Plugin/Locator/UK.pm line 203.

Turns out that version 5 of the Heathrow Airport node had a trailing space in its OS Y co-ordinate, and postgres was choking on this when it tried to turn that entry into an integer for comparison with the supplied co-ordinates. (The metadata is all stored as varchar, since it's defined by the user of the module, and hence can be anything.)

Guess I need to add some post-processing on that field.

< Tuesday 26 August 2003 Friday 15 August 2003 >

foo

HTML generated from pod with podblog