[Tickets #14508] DB schema update for Horde_Service_Weather fails

[noreply at bugs.horde.org]

BITTE NICHT AUF DIESE NACHRICHT ANTWORTEN. NACHRICHTEN AN DIESE  
E-MAIL-ADRESSE WERDEN NICHT GELESEN.

Ticket-URL: https://bugs.horde.org/ticket/14508
------------------------------------------------------------------------------
  Ticket           | 14508
  Erstellt Von     | michael at bigmichi1.de
  Zusammenfassung  | DB schema update for Horde_Service_Weather fails
  Warteschlange    | Horde Framework Packages
  Typ              | Bug
  Status           | Unconfirmed
  Priorität        | 1. Low
  Milestone        |
  Patch            |
  Zuständige       |
------------------------------------------------------------------------------


michael at bigmichi1.de (2016-11-09 19:18) hat geschrieben:

First migration result:

[  INFO  ] Current Horde_Service_Weather schema version: 0
Migrating to HordeServiceWeatherAirports (1)
== 1 HordeServiceWeatherAirports: migrating  
===================================
-- createTable('horde_metar_airports', array('autoincrementKey' => array (
   0 => 'id',
)))
    -> 0.0000s
== 1 HordeServiceWeatherAirports: ERROR: Unable to populate METAR  
database. ===
== 1 HordeServiceWeatherAirports: migrated (0.4674s)  
==========================

Migrating to HordeServiceWeatherAirportsChange (2)
== 2 HordeServiceWeatherAirportsChange: migrating  
=============================
-- tables()
    -> 0.0024s
-- beginDbTransaction()
    -> 0.0001s
-- createTable('horde_metar_airports', array('autoincrementKey' => array (
   0 => 'id',
)))
    -> 0.0000s
== 2 HordeServiceWeatherAirportsChange: ERROR: SQLSTATE[22P02]:  
Invalid text representation: 7 ERROR:  invalid input syntax for type  
double precision: "elevation_ft"
LINE 1: ...iso_country', 'municipality', 0.000000, 0.000000, 'elevation...
                                                              ^
-- rollbackDbTransaction()
    -> 0.0001s
-- commitDbTransaction()
    -> 0.0000s
== 2 HordeServiceWeatherAirportsChange: migrated (0.1565s)  
====================

[  INFO  ] Ending Horde_Service_Weather schema version: 2




Second attemp when i delete the first line in the csv file:

[  INFO  ] Current Horde_Service_Weather schema version: 0
Migrating to HordeServiceWeatherAirports (1)
== 1 HordeServiceWeatherAirports: migrating  
===================================
-- createTable('horde_metar_airports', array('autoincrementKey' => array (
   0 => 'id',
)))
    -> 0.0000s
== 1 HordeServiceWeatherAirports: ERROR: Unable to populate METAR  
database. ===
== 1 HordeServiceWeatherAirports: migrated (0.4670s)  
==========================

Migrating to HordeServiceWeatherAirportsChange (2)
== 2 HordeServiceWeatherAirportsChange: migrating  
=============================
-- tables()
    -> 0.0020s
-- beginDbTransaction()
    -> 0.0001s
-- createTable('horde_metar_airports', array('autoincrementKey' => array (
   0 => 'id',
)))
    -> 0.0000s
== 2 HordeServiceWeatherAirportsChange: ERROR: SQLSTATE[22P02]:  
Invalid text representation: 7 ERROR:  invalid input syntax for type  
double precision: ""
LINE 1: ...e Base', 'MD', 'US', 'Annapolis', 38.999200, -76.456000, '')
                                                                     ^
-- rollbackDbTransaction()
    -> 0.0002s
-- commitDbTransaction()
    -> 0.0000s
== 2 HordeServiceWeatherAirportsChange: migrated (0.4519s)  
====================

[  INFO  ] Ending Horde_Service_Weather schema version: 2



I'm using Postgresql with php 7.0.8 and Horde_Service_Weather-2.5.0