dr5hn / countries-states-cities-database

🌍 Discover our global repository of countries, states, and cities! 🏙️ Get comprehensive data in JSON, SQL, PSQL, XML, YAML, and CSV formats. Access ISO2, ISO3 codes, country code, capital, native language, timezones (for countries), and more. #countries #states #cities
https://dr5hn.github.io/countries-states-cities-database/
Open Data Commons Open Database License v1.0
7.28k stars 2.54k forks source link

Error SQL world.sql #692

Closed Machou closed 1 year ago

Machou commented 1 year ago

hi

when i import world.sql, i have this error : ERROR at line 156634: Unknown command '\"'.

INSERT INTO `subregions` (`id`, `name`, `translations`, `region_id`, `created_at`, `updated_at`, `flag`, `wikiDataId`) VALUES
(1, 'Northern Africa', '{\"korean\":\"북아프리카\",\"portuguese\":\"Norte de África\",\"dutch\":\"Noord-Afrika\",\"croatian\":\"Sjeverna Afrika\",\"persian\":\"شمال آفریقا\",\"german\":\"Nordafrika\",\"spanish\":\"Norte de África\",\"french\":\"Afrique du Nord\",\"japanese\":\"北アフリカ\",\"italian\":\"Nordafrica\",\"chinese\":\"北部非洲\"}', 1, '2023-08-14 07:11:03', '2023-08-24 20:10:23', 1, 'Q27381'),
(2, 'Middle Africa', '{\"korean\":\"중앙아프리카\",\"portuguese\":\"África Central\",\"dutch\":\"Centraal-Afrika\",\"croatian\":\"Srednja Afrika\",\"persian\":\"مرکز آفریقا\",\"german\":\"Zentralafrika\",\"spanish\":\"África Central\",\"french\":\"Afrique centrale\",\"japanese\":\"中部アフリカ\",\"italian\":\"Africa centrale\",\"chinese\":\"中部非洲\"}', 1, '2023-08-14 07:11:03', '2023-08-24 20:22:09', 1, 'Q27433'),
(3, 'Western Africa', '{\"korean\":\"서아프리카\",\"portuguese\":\"África Ociden…

Erreur dans la requête (1064): Syntax error near 'Ouest\",\"japanese\":\"西アフリカ\",\"italian\":\"Africa occidentale\",\...' at line 4

dr5hn commented 1 year ago

@Machou Thanks for reporting.

Resolved in #693