wall75
Joined: 03/04/2013 16:21:19
Messages: 1
Offline
|
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.
|
![[Search]](/gforum/templates/default/images/icon_mini_search.gif){kind=icon}
![[Recent Topics]](/gforum/templates/default/images/icon_mini_recentTopics.gif){kind=icon}
![[Groups]](/gforum/templates/default/images/icon_mini_groups.gif){kind=icon}
![[Register]](/gforum/templates/default/images/icon_mini_register.gif){kind=icon}
Register![[Login]](/gforum/templates/default/images/icon_mini_login.gif){kind=icon}
Login
![[Post New]](/gforum/templates/default/images/icon_minipost_new.gif){kind=icon}
![[Up]](/gforum/templates/default/images/icon_up.gif){kind=icon}
![[WWW]](/gforum/templates/default/images/icon_www.gif){kind=icon}