michaeldrennen/Geonames

laravel geonames:install

Closed this issue · 4 comments

When i try and install i get

The database connection name was set to: mysql
Testing database connection...
Undefined offset: 1001

Facing the same issue when installing. Can someone please help us with this?

php artisan geonames:install --country=US --language=en

The database connection name was set to: mysql
Testing database connection...
Undefined offset: 1001

Was facing same issue, fixed by changing config/database.php:
'options' => extension_loaded('pdo_mysql') ? array_filter([ PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA') ]) : [],
to
'options' => extension_loaded('pdo_mysql') ? array_filter([ PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'), PDO::MYSQL_ATTR_LOCAL_INFILE => true ]) : [],

In the database.php config file, Put this code "PDO::MYSQL_ATTR_LOCAL_INFILE => true,"
like the below:
'mysql' => [
'options' => extension_loaded('pdo_mysql') ? array_filter([
PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
PDO::MYSQL_ATTR_LOCAL_INFILE => true,
]) : [],
],

Change made in most recent commit.