Tickets :: Comment on [#14508] DB schema update for Horde_Service

* Your Email Address
* Spam protection	Enter the letters below: .__.. . __ . . . [__]\|_/ / `\| \| \| \| \|\| \\__.\|__\|\__\|
Comment	> 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
Attachment
Watch this ticket

Saved Queries