<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "Error in allCountries.zip"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "Error in allCountries.zip"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>Error in allCountries.zip</title>
				<description><![CDATA[ Hi.
there are many errors in the script "allcountries.zip" when insert into database. For example:
Unknown column 'Asia' in 'field list' (1054)  -  INSERT INTO `all` VALUES (388770,'Razâ€yezd Kishlak','Raz\"yezd Kishlak\tRaz\"yezd Kishlak,Razâ€yezd Kishlak','39.10823','46.62413','S','RSD','AZ','','69','','','','0',NULL,523,Asia/Yerevan,'2013-01-11',NULL);

Appears that the file contains with data missing or malformed.
The file (allCountries.zip) was downloaded today.]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/4161.page#12315</guid>
				<link>http://forum.geonames.org/gforum/posts/list/4161.page#12315</link>
				<pubDate><![CDATA[Thu, 4 Apr 2013 06:51:26]]> GMT</pubDate>
				<author><![CDATA[ wall75]]></author>
			</item>
			<item>
				<title>Re:Error in allCountries.zip</title>
				<description><![CDATA[ Hi

must be an error in your import script. The field separater in the files is the tabulator.

Marc]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/4161.page#12356</guid>
				<link>http://forum.geonames.org/gforum/posts/list/4161.page#12356</link>
				<pubDate><![CDATA[Sat, 27 Apr 2013 22:00:42]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
	</channel>
</rss>