coderholic/django-cities — Issue #19: import failure when manage.py cities
Author: mgom
Created: 2011-12-06 12:11:08+00:00
State: open

i have got this trace when i want to import datas

Downloading: countryInfo.txt
Importing country data
Downloading: admin1CodesASCII.txt
Building country index
Importing region 1 data
Traceback (most recent call last):
File "./manage.py", line 14, in
execute_manager(settings)
File "/Users/odin/Developer/Projects/Django/MA/venv/lib/python2.7/site-packages/django/core/management/__init__.py", line 438, in execute_manager
utility.execute()
File "/Users/odin/Developer/Projects/Django/MA/venv/lib/python2.7/site-packages/django/core/management/__init__.py", line 379, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/Users/odin/Developer/Projects/Django/MA/venv/lib/python2.7/site-packages/django/core/management/base.py", line 191, in run_from_argv
self.execute(*args, **options.__dict__)
File "/Users/odin/Developer/Projects/Django/MA/venv/lib/python2.7/site-packages/django/core/management/base.py", line 220, in execute
output = self.handle(*args, **options)
File "/Users/odin/Developer/Projects/Django/MA/venv/lib/python2.7/site-packages/cities/management/commands/cities.py", line 65, in handle
func()
File "/Users/odin/Developer/Projects/Django/MA/venv/lib/python2.7/site-packages/cities/management/commands/cities.py", line 164, in import_region
self.import_region_0()
File "/Users/odin/Developer/Projects/Django/MA/venv/lib/python2.7/site-packages/cities/management/commands/cities.py", line 218, in import_region_0
region.save()
File "/Users/odin/Developer/Projects/Django/MA/venv/lib/python2.7/site-packages/django/db/models/base.py", line 460, in save
self.save_base(using=using, force_insert=force_insert, force_update=force_update)
File "/Users/odin/Developer/Projects/Django/MA/venv/lib/python2.7/site-packages/django/db/models/base.py", line 526, in save_base
rows = manager.using(using).filter(pk=pk_val)._update(values)
File "/Users/odin/Developer/Projects/Django/MA/venv/lib/python2.7/site-packages/django/db/models/query.py", line 491, in _update
return query.get_compiler(self.db).execute_sql(None)
File "/Users/odin/Developer/Projects/Django/MA/venv/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 869, in execute_sql
cursor = super(SQLUpdateCompiler, self).execute_sql(result_type)
File "/Users/odin/Developer/Projects/Django/MA/venv/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 735, in execute_sql
cursor.execute(sql, params)
File "/Users/odin/Developer/Projects/Django/MA/venv/lib/python2.7/site-packages/django/db/backends/util.py", line 34, in execute
return self.cursor.execute(sql, params)
File "/Users/odin/Developer/Projects/Django/MA/venv/lib/python2.7/site-packages/django/db/backends/mysql/base.py", line 86, in execute
return self.cursor.execute(query, args)
File "/Users/odin/Developer/Projects/Django/MA/venv/lib/python2.7/site-packages/MySQLdb/cursors.py", line 176, in execute
if not self._defer_warnings: self._warning_check()
File "/Users/odin/Developer/Projects/Django/MA/venv/lib/python2.7/site-packages/MySQLdb/cursors.py", line 92, in _warning_check
warn(w[-1], self.Warning, 3)
_mysql_exceptions.Warning: Incorrect string value: '\xCA\xBCs al...' for column 'name_std' at row 1

thank you for help