search

yurtesen / geonames

Importer/updater for geonames.org data into Eloquent ORM including Models with high efficiency
GNU General Public License v3.0
31 stars 8 forks source link

countryInfo.txt is not properly imported. #1

Closed hasandz closed 8 years ago

hasandz commented 8 years ago

Console Says: Seeding File: countryInfo.txt 252/252 ▓▓▓ 100% Remaining Time: < 1 sec -252

Mysql Says: SELECT count(*) FROM geonames.geonames_country_infos; -200

Where are the other 52 countries? I guess, something wrong with the import/seed.

For example TR|Turkey is in the file, but not in the database.

Thank you.

yurtesen commented 8 years ago

You are right, I think the script is forgetting to flush the last buffer. I will fix it ASAP.

yurtesen commented 8 years ago

It should be fixed now. Please update to latest commit. I found out that I had the continent codes wrong and also some error about foreign key checks which caused this problem when both combined. You shouldn't have any errors in your existing entries. If you want to truncate tables and make fresh inserts, use --refresh option of the seed command

php artisan geonames:seed --refresh

Please let me know if you are having any other problems. Thanks for using the package.

hasandz commented 8 years ago

Thank you for fast response.

Yes, it seems working right now.