Josiah / JJsGeonamesBundle

GeoNames.org geographical data and associated functionality
18 stars 15 forks source link

Longitude cannot be null #6

Open arkmuay opened 9 years ago

arkmuay commented 9 years ago

Hi,

When I import countries I have some issues like this :

[PDOException]
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'longitude' cannot be null

While it could be...

arkmuay commented 9 years ago

I think I can use migrations to change or overload it ?...

arkmuay commented 9 years ago

And migrations seems to doen't work because of simple quote : // Unique Keys $table->addUniqueIndex(['geoname_id'], 'UK_Geo{$locality}_geoname');

fails : [Doctrine\DBAL\Schema\SchemaException]
Invalid index-name UK_Geo{$locality}geoname given, has to be [a-zA-Z0-9]