Electronics & Programming

develissimo

Open Source electronics development and programming

  • You are not logged in.

#1 Jan. 21, 2011 21:41:17

n.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

mysql -> sqlite3 migration error


I'm trying migrate some tables for the first time and I'm not sure how
to resolve this error. It looks like things fail when this file is
called: films:0006_migrate_country, which in turn is failing to create
the films_filmdistribution table. Any thought on how to resolve this?

Thanks for any help.

Not synced (use migrations):
- quiz
- accounts
- purchasedstreams
- django_facebook
- gifts
- films
- mediadb
- store
- subscription
- testimonials
- majorfest
- juries
- members
- streamevents
- splash
- box
(use ./manage.py migrate to migrate these)
Exception TypeError: "'NoneType' object is not callable" in <bound
method GeoIP.__del__ of <django.contrib.gis.utils.geoip.GeoIP object
at 0x1019d1910>> ignored
(project_name)jason-neridas-macbook-4:project_name username$ ./
manage.py migrate --settings=stages.dev.settings
/Users/username/project_name/project/project_name/dependencies/
django_jsonapi/models.py:4: DeprecationWarning: the sha module is
deprecated; use the hashlib module instead
import sha, time
Running migrations for quiz:
- Migrating forwards to 0001_initial.
> quiz:0001_initial
- Loading initial data for quiz.
No fixtures found.
Running migrations for accounts:
- Migrating forwards to 0002_add_postal_and_country.
> accounts:0001_initial
> accounts:0002_add_postal_and_country
- Loading initial data for accounts.
No fixtures found.
Running migrations for purchasedstreams:
- Migrating forwards to 0002_import_from_films.
> purchasedstreams:0001_initial
> films:0001_initial
> purchasedstreams:0002_import_from_films
- Loading initial data for purchasedstreams.
No fixtures found.
Running migrations for django_facebook:
- Migrating forwards to 0004_bigger_tokens.
> django_facebook:0001_initial
> django_facebook:0002_add_permissions_request
> django_facebook:0003_update_permissions_request
> django_facebook:0004_bigger_tokens
- Loading initial data for django_facebook.
No fixtures found.
Running migrations for gifts:
- Migrating forwards to 0007_add_code_pools.
> gifts:0001_initial
> gifts:0002_modify_urls_to_noverify
> gifts:0003_add_code_pools
> gifts:0004_allow_blanks_in_codes
> gifts:0005_allow_blanks_in_coupon_desc
> gifts:0006_add_code_pools
> gifts:0007_add_code_pools
- Loading initial data for gifts.
No fixtures found.
Running migrations for films:
- Migrating forwards to 0013_drop_old_distributions.
> splash:0001_initial
> splash:0002_import_slides_from_films
> streamevents:0001_initial
> streamevents:0002_transfer_from_films
> films:0002_drop_streamlog
> films:0003_drop_stream
> films:0004_delete_slides
> films:0005_add_country
> films:0006_migrate_country
Traceback (most recent call last):
File "./manage.py", line 12, in <module>
execute_manager(settings)
File "/Users/username/project_name/project/django/core/management/
__init__.py", line 438, in execute_manager
utility.execute()
File "/Users/username/project_name/project/django/core/management/
__init__.py", line 379, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/Users/username/project_name/project/django/core/management/
base.py", line 191, in run_from_argv
self.execute(*args, **options.__dict__)
File "/Users/username/project_name/project/django/core/management/
base.py", line 218, in execute
output = self.handle(*args, **options)
File "/Users/username/src/south/south/management/commands/
migrate.py", line 105, in handle
ignore_ghosts = ignore_ghosts,
File "/Users/username/src/south/south/migration/__init__.py", line
191, in migrate_app
success = migrator.migrate_many(target, workplan, database)
File "/Users/username/src/south/south/migration/migrators.py", line
221, in migrate_many
result = migrator.__class__.migrate_many(migrator, target,
migrations, database)
File "/Users/username/src/south/south/migration/migrators.py", line
292, in migrate_many
result = self.migrate(migration, database)
File "/Users/username/src/south/south/migration/migrators.py", line
125, in migrate
result = self.run(migration)
File "/Users/username/src/south/south/migration/migrators.py", line
99, in run
return self.run_migration(migration)
File "/Users/username/src/south/south/migration/migrators.py", line
81, in run_migration
migration_function()
File "/Users/username/src/south/south/migration/migrators.py", line
57, in <lambda>
return (lambda: direction(orm))
File "/Users/username/project_name/project/django/db/
transaction.py", line 299, in _commit_on_success
res = func(*args, **kw)
File "/Users/username/project_name/project/project_name/modules/
films/migrations/0006_migrate_country.py", line 17, in forwards
for film in Film.objects.select_related('contact').all():
File "/Users/username/project_name/project/django/db/models/
query.py", line 106, in _result_iter
self._fill_cache()
File "/Users/username/project_name/project/django/db/models/
query.py", line 760, in _fill_cache
self._result_cache.append(self._iter.next())
File "/Users/username/project_name/project/django/db/models/
query.py", line 269, in iterator
for row in compiler.results_iter():
File "/Users/username/project_name/project/django/db/models/sql/
compiler.py", line 672, in results_iter
for rows in self.execute_sql(MULTI):
File "/Users/username/project_name/project/django/db/models/sql/
compiler.py", line 727, in execute_sql
cursor.execute(sql, params)
File "/Users/username/project_name/project/django/db/backends/
util.py", line 15, in execute
return self.cursor.execute(sql, params)
File "/Users/username/project_name/project/django/db/backends/
sqlite3/base.py", line 200, in execute
return Database.Cursor.execute(self, query, params)
django.db.utils.DatabaseError: no such column:
films_film.distribution_id
Exception TypeError: "'NoneType' object is not callable" in <bound
method GeoIP.__del__ of <django.contrib.gis.utils.geoip.GeoIP object
at 0x1019d1910>> ignored

--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group athttp://groups.google.com/group/django-users?hl=en.

Offline

Board footer

Moderator control

Enjoy the 19th of August
PoweredBy

The Forums are managed by develissimo stuff members, if you find any issues or misplaced content please help us to fix it. Thank you! Tell us via Contact Options
Leave a Message
Welcome to Develissimo Live Support