dataerror

dataerror

rake aborted!                                                                                                         
*** ERROR #import_data([]) : *** ERROR #import_geo_data([]) : *** ERROR #import([[:req, :table], [:req, :key], [:req, 
sql_source], [:opt, :opts]]) : *** ERROR #sql([[:req, :sqls], [:opt, :msg], [:key, :count]]) : Mysql2::Error: Duplicat
 entry '1-Anchorage' for key 'state_id__name': insert into city_aliases( city_id, name, state_id, state_name, city_nam
, city_alias_type_id, city_alias_type_name, city_alias_post_office_type_id, city_alias_post_office_type_name, abbrevia
ion, lat, lon, gmt_offset, is_mailable_name, created_at, updated_at) select src.city_id, src.name, src.state_id, src.s
ate_name, src.city_name, src.city_alias_type_id, src.city_alias_type_name, src.city_alias_post_office_type_id, src.cit
_alias_post_office_type_name, src.abbreviation, src.lat, src.lon, src.gmt_offset, src.is_mailable_name, src.created_at
 src.updated_at from _city_aliases src left outer join city_aliases trgt on src.city_id = trgt.city_id AND src.name = 
rgt.name where trgt.id is null;                                                                                       
/home/vagrant/auto-data/lib/import.rb:533:in `rescue in block in import_data'                                         
/home/vagrant/auto-data/lib/import.rb:513:in `block in import_data'                                                   
/home/vagrant/auto-data/lib/db.rb:28:in `block in timer'                                                              
/home/vagrant/auto-data/lib/db.rb:28:in `timer'                                                                       
/home/vagrant/auto-data/lib/import.rb:512:in `import_data'                                                            
/home/vagrant/auto-data/lib/tasks/db.rake:22:in `block (2 levels) in <top (required)>'                                
*** ERROR #import_geo_data([]) : *** ERROR #import([[:req, :table], [:req, :key], [:req, :sql_source], [:opt, :opts]])
: *** ERROR #sql([[:req, :sqls], [:opt, :msg], [:key, :count]]) : Mysql2::Error: Duplicate entry '1-Anchorage' for key
'state_id__name': insert into city_aliases( city_id, name, state_id, state_name, city_name, city_alias_type_id, city_a
ias_type_name, city_alias_post_office_type_id, city_alias_post_office_type_name, abbreviation, lat, lon, gmt_offset, i
_mailable_name, created_at, updated_at) select src.city_id, src.name, src.state_id, src.state_name, src.city_name, src
city_alias_type_id, src.city_alias_type_name, src.city_alias_post_office_type_id, src.city_alias_post_office_type_name
 src.abbreviation, src.lat, src.lon, src.gmt_offset, src.is_mailable_name, src.created_at, src.updated_at from _city_a
iases src left outer join city_aliases trgt on src.city_id = trgt.city_id AND src.name = trgt.name where trgt.id is nu
l;                                                                                                                    
/home/vagrant/auto-data/lib/import.rb:269:in `rescue in block in import_geo_data'                                     
/home/vagrant/auto-data/lib/import.rb:277:in `block in import_geo_data'                                               
/home/vagrant/auto-data/lib/db.rb:28:in `block in timer'                                                              
/home/vagrant/auto-data/lib/db.rb:28:in `timer'                                                                       
/home/vagrant/auto-data/lib/import.rb:249:in `import_geo_data'                                                        
/home/vagrant/auto-data/lib/import.rb:521:in `block in import_data'                                                   
/home/vagrant/auto-data/lib/db.rb:28:in `block in timer'                                                              
/home/vagrant/auto-data/lib/db.rb:28:in `timer'                                                                       
/home/vagrant/auto-data/lib/import.rb:512:in `import_data'                                                            
/home/vagrant/auto-data/lib/tasks/db.rake:22:in `block (2 levels) in <top (required)>'                                
*** ERROR #import([[:req, :table], [:req, :key], [:req, :sql_source], [:opt, :opts]]) : *** ERROR #sql([[:req, :sqls],
[:opt, :msg], [:key, :count]]) : Mysql2::Error: Duplicate entry '1-Anchorage' for key 'state_id__name': insert into ci
y_aliases( city_id, name, state_id, state_name, city_name, city_alias_type_id, city_alias_type_name, city_alias_post_o
fice_type_id, city_alias_post_office_type_name, abbreviation, lat, lon, gmt_offset, is_mailable_name, created_at, upda
ed_at) select src.city_id, src.name, src.state_id, src.state_name, src.city_name, src.city_alias_type_id, src.city_ali
s_type_name, src.city_alias_post_office_type_id, src.city_alias_post_office_type_name, src.abbreviation, src.lat, src.
on, src.gmt_offset, src.is_mailable_name, src.created_at, src.updated_at from _city_aliases src left outer join city_a
iases trgt on src.city_id = trgt.city_id AND src.name = trgt.name where trgt.id is null;                              
/home/vagrant/auto-data/lib/db.rb:212:in `rescue in block in import'                                                  
/home/vagrant/auto-data/lib/db.rb:157:in `block in import'                                                            
/home/vagrant/auto-data/lib/db.rb:28:in `block in timer'                                                              
/home/vagrant/auto-data/lib/db.rb:28:in `timer'                                                                       
/home/vagrant/auto-data/lib/db.rb:156:in `import'                                                                     
/home/vagrant/auto-data/app/models/city_alias.rb:115:in `import'                                                      
/home/vagrant/auto-data/lib/import.rb:256:in `block in import_geo_data'                                               
/home/vagrant/auto-data/lib/db.rb:28:in `block in timer'