Skip to content

Instantly share code, notes, and snippets.

@neilkimmett
Created March 13, 2013 14:57
Show Gist options
  • Save neilkimmett/5152917 to your computer and use it in GitHub Desktop.
Save neilkimmett/5152917 to your computer and use it in GitHub Desktop.
Running migrations for locations:
- Migrating forwards to 0004_auto__chg_field_location_modified_by.
> locations:0001_initial
FATAL ERROR - The following SQL query failed: CREATE TABLE "locations_location" ("id" serial NOT NULL PRIMARY KEY, "woeid" integer NULL, "longitude" double precision NULL, "latitude" double precision NULL, "zoom_level" integer NULL);
The error was: relation "locations_location" already exists
Error in migration: locations:0001_initial
Traceback (most recent call last):
File "/home/user/projects/world/bauhaus/manage.py", line 24, in <module>
execute_from_command_line(sys.argv)
File "/home/user/projects/world/ENV/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 443, in execute_from_command_line
utility.execute()
File "/home/user/projects/world/ENV/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 382, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/home/user/projects/world/ENV/local/lib/python2.7/site-packages/django/core/management/base.py", line 196, in run_from_argv
self.execute(*args, **options.__dict__)
File "/home/user/projects/world/ENV/local/lib/python2.7/site-packages/django/core/management/base.py", line 232, in execute
output = self.handle(*args, **options)
File "/home/user/projects/world/ENV/local/lib/python2.7/site-packages/south/management/commands/migrate.py", line 107, in handle
ignore_ghosts = ignore_ghosts,
File "/home/user/projects/world/ENV/local/lib/python2.7/site-packages/south/migration/__init__.py", line 219, in migrate_app
success = migrator.migrate_many(target, workplan, database)
File "/home/user/projects/world/ENV/local/lib/python2.7/site-packages/south/migration/migrators.py", line 235, in migrate_many
result = migrator.__class__.migrate_many(migrator, target, migrations, database)
File "/home/user/projects/world/ENV/local/lib/python2.7/site-packages/south/migration/migrators.py", line 310, in migrate_many
result = self.migrate(migration, database)
File "/home/user/projects/world/ENV/local/lib/python2.7/site-packages/south/migration/migrators.py", line 133, in migrate
result = self.run(migration)
File "/home/user/projects/world/ENV/local/lib/python2.7/site-packages/south/migration/migrators.py", line 107, in run
return self.run_migration(migration)
File "/home/user/projects/world/ENV/local/lib/python2.7/site-packages/south/migration/migrators.py", line 81, in run_migration
migration_function()
File "/home/user/projects/world/ENV/local/lib/python2.7/site-packages/south/migration/migrators.py", line 57, in <lambda>
return (lambda: direction(orm))
File "/home/user/projects/world/bauhaus/apps/locations/migrations/0001_initial.py", line 29, in forwards
('zoom_level', self.gf('django.db.models.fields.IntegerField')(null=True)),
File "/home/user/projects/world/ENV/local/lib/python2.7/site-packages/south/db/generic.py", line 44, in _cache_clear
return func(self, table, *args, **opts)
File "/home/user/projects/world/ENV/local/lib/python2.7/site-packages/south/db/generic.py", line 348, in create_table
', '.join([col for col in columns if col]),
File "/home/user/projects/world/ENV/local/lib/python2.7/site-packages/south/db/generic.py", line 273, in execute
cursor.execute(sql, params)
File "/home/user/projects/world/ENV/local/lib/python2.7/site-packages/django/db/backends/util.py", line 40, in execute
return self.cursor.execute(sql, params)
File "/home/user/projects/world/ENV/local/lib/python2.7/site-packages/django/db/backends/postgresql_psycopg2/base.py", line 52, in execute
return self.cursor.execute(query, args)
django.db.utils.DatabaseError: relation "locations_location" already exists
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment