Revision history  [back]

I am using postgres, but looks like migration fails on auth_user table, and due to that when I run the server I get the following error:

DatabaseError at /questions/
relation "askbot_thread" does not exist
LINE 1: SELECT COUNT(DISTINCT "askbot_thread"."id") FROM "askbot_thr...
                                                         ^
Request Method: GET
Request URL:    http://localhost:8002/questions/
Django Version: 1.4.8
Exception Type: DatabaseError
Exception Value:    
relation "askbot_thread" does not exist
LINE 1: SELECT COUNT(DISTINCT "askbot_thread"."id") FROM "askbot_thr...

Here is the result from migration.

$python manage.py syncdb
Please run command

    python manage.py collectstatic
WARNING!!! You are using a 'locmem' (local memory) caching backend,
which is OK for a low volume site running on a single-process server.
For a multi-process configuration it is neccessary to have a production
cache system, such as redis or memcached.

With local memory caching and multi-process setup you might intermittently
see outdated content on your site.

current transaction is aborted, commands ignored until end of transaction block

Syncing...
Creating tables ...
Creating table auth_permission
Creating table auth_group_permissions
Creating table auth_group
Creating table auth_user_user_permissions
Creating table auth_user_groups
Creating table auth_user
Creating table auth_message
Creating table django_content_type
Creating table django_session
Creating table django_site
Creating table django_admin_log
Creating table south_migrationhistory
Creating table livesettings_setting
Creating table livesettings_longsetting
Creating table djkombu_queue
Creating table djkombu_message
Creating table followit_followuser

You just installed Django's auth system, which means you don't have any superusers defined.
Would you like to create one now? (yes/no): yes
Username (Leave blank to use 'anu'): 
E-mail address: auduwage@gmail.com
Password: 
Password (again): 
Askbot Superuser created successfully.
Installing custom SQL ...
Installing indexes ...
Installed 0 object(s) from 0 fixture(s)

Synced:
 > django.contrib.auth
 > django.contrib.contenttypes
 > django.contrib.sessions
 > django.contrib.sites
 > django.contrib.staticfiles
 > django.contrib.admin
 > django.contrib.humanize
 > django.contrib.sitemaps
 > south
 > askbot.deps.livesettings
 > keyedcache
 > django_countries
 > djkombu
 > followit
 > tinymce

Not synced (use migrations):
 - longerusername
 - askbot.deps.django_authopenid
 - robots
 - djcelery
 - group_messaging
 - askbot
(use ./manage.py migrate to migrate these)
[1]+  Done                    open -a /Applications/Emacs.app $1 settings.py
(vGA_Migration)anu@cmbmac:[~/code/vGA_Migration/gopheranswers]$python manage.py migrate askbot
Please run command

    python manage.py collectstatic
WARNING!!! You are using a 'locmem' (local memory) caching backend,
which is OK for a low volume site running on a single-process server.
For a multi-process configuration it is neccessary to have a production
cache system, such as redis or memcached.

With local memory caching and multi-process setup you might intermittently
see outdated content on your site.

relation "askbot_badgedata" does not exist
LINE 1: ..."."slug", "askbot_badgedata"."awarded_count" FROM "askbot_ba...
                                                             ^

Running migrations for askbot:
 - Migrating forwards to 0164_update_postgres_user_search.
 > askbot:0001_initial
FATAL ERROR - The following SQL query failed: ALTER TABLE "auth_user" ADD COLUMN "website" varchar(200) NULL;
The error was: column "website" of relation "auth_user" already exists

FATAL ERROR - The following SQL query failed: ALTER TABLE "auth_user" ADD COLUMN "about" text NULL;
The error was: column "about" of relation "auth_user" already exists

FATAL ERROR - The following SQL query failed: ALTER TABLE "auth_user" ADD COLUMN "gold" smallint NOT NULL DEFAULT 0;
The error was: column "gold" of relation "auth_user" already exists

FATAL ERROR - The following SQL query failed: ALTER TABLE "auth_user" ADD COLUMN "email_isvalid" boolean NOT NULL DEFAULT False;
The error was: column "email_isvalid" of relation "auth_user" already exists

FATAL ERROR - The following SQL query failed: ALTER TABLE "auth_user" ADD COLUMN "real_name" varchar(100) NULL;
The error was: column "real_name" of relation "auth_user" already exists

FATAL ERROR - The following SQL query failed: ALTER TABLE "auth_user" ADD COLUMN "location" varchar(100) NULL;
The error was: column "location" of relation "auth_user" already exists

FATAL ERROR - The following SQL query failed: ALTER TABLE "auth_user" ADD COLUMN "email_key" varchar(32) NULL;
The error was: column "email_key" of relation "auth_user" already exists

FATAL ERROR - The following SQL query failed: ALTER TABLE "auth_user" ADD COLUMN "date_of_birth" date NULL;
The error was: column "date_of_birth" of relation "auth_user" already exists

FATAL ERROR - The following SQL query failed: ALTER TABLE "auth_user" ADD COLUMN "reputation" integer CHECK ("reputation" >= 0) NOT NULL DEFAULT 1;
The error was: column "reputation" of relation "auth_user" already exists

FATAL ERROR - The following SQL query failed: ALTER TABLE "auth_user" ADD COLUMN "gravatar" varchar(32) NULL;
The error was: column "gravatar" of relation "auth_user" already exists

FATAL ERROR - The following SQL query failed: ALTER TABLE "auth_user" ADD COLUMN "bronze" smallint NOT NULL DEFAULT 0;
The error was: column "bronze" of relation "auth_user" already exists

FATAL ERROR - The following SQL query failed: ALTER TABLE "auth_user" ADD COLUMN "last_seen" timestamp with time zone NOT NULL DEFAULT '2013-10-24 05:16:10.868188';
The error was: column "last_seen" of relation "auth_user" already exists

FATAL ERROR - The following SQL query failed: ALTER TABLE "auth_user" ADD COLUMN "silver" smallint NOT NULL DEFAULT 0;
The error was: column "silver" of relation "auth_user" already exists

FATAL ERROR - The following SQL query failed: ALTER TABLE "auth_user" ADD COLUMN "questions_per_page" smallint NOT NULL DEFAULT 10;
The error was: column "questions_per_page" of relation "auth_user" already exists

 > askbot:0002_auto__add_field_answer_text__chg_field_answer_html__add_field_question
 > askbot:0003_copy_denorm_text_record_to_posts_for_fulltext_search
 > askbot:0004_install_full_text_indexes_for_mysql
 > askbot:0005_install_badges
/Users/anu/code/vGA_Migration/gopheranswers/askbot/migrations/0005_install_badges.py:64: RuntimeWarning: Argument <type 'str'> is not an unicode object. Passing an encoded string will likely have unexpected results.
  print 'adding new badge %s' % unidecode(name)
adding new badge Disciplined
adding new badge Peer Pressure
adding new badge Nice answer
adding new badge Nice Question
adding new badge Pundit
adding new badge Popular Question
adding new badge Citizen patrol
adding new badge Cleanup
adding new badge Critic
adding new badge Editor
adding new badge Organizer
adding new badge Scholar
adding new badge Student
adding new badge Supporter
adding new badge Teacher
adding new badge Autobiographer
adding new badge Self-Learner
adding new badge Great Answer
adding new badge Great Question
adding new badge Stellar Question
adding new badge Famous question
adding new badge Alpha
adding new badge Good Answer
adding new badge Good Question
adding new badge Favorite Question
adding new badge Civic duty
adding new badge Strunk & White
adding new badge Generalist
adding new badge Expert
adding new badge Yearling
adding new badge Notable Question
adding new badge Enlightened
adding new badge Beta
adding new badge Guru
adding new badge Necromancer
adding new badge Taxonomist
 > askbot:0006_add_subscription_setting_for_comments_and_mentions

**************
Adding subscription on comment responses and name mentions for each user. 
frequency will be automatically set to the most frequent selection 
that user made for any other types of subscriptions

added '<django.utils.functional.__proxy__ object at 0x1027a4d10>' subscription for anu (1)
 > askbot:0007_install_mentions_model
 > askbot:0008_add_html_field_to_comments
 > askbot:0009_calculate_html_field_for_comments
 > askbot:0010_add_receiving_user_to_activity_model
 > askbot:0011_merge_mentions_into_activity
 > askbot:0012_delete_some_unused_models
 > askbot:0013_add_response_count__to_user
FATAL ERROR - The following SQL query failed: ALTER TABLE "auth_user" ADD COLUMN "response_count" integer NOT NULL DEFAULT 0;
The error was: column "response_count" of relation "auth_user" already exists

 > askbot:0014_rename_schema_from_forum_to_askbot
 > askbot:0015_rename_forum_contenttypes_to_askbot
 > askbot:0016_auto__del_validationhash
 > askbot:0017_add_group__moderators
 > askbot:0018_add___status__field_to_user_model
Error in migration: askbot:0018_add___status__field_to_user_model
Traceback (most recent call last):
  File "manage.py", line 11, in <module>
    execute_manager(settings)
  File "/Users/anu/code/vGA_Migration/lib/python2.7/site-packages/Django-1.4.8-py2.7.egg/django/core/management/__init__.py", line 459, in execute_manager
    utility.execute()
  File "/Users/anu/code/vGA_Migration/lib/python2.7/site-packages/Django-1.4.8-py2.7.egg/django/core/management/__init__.py", line 382, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/Users/anu/code/vGA_Migration/lib/python2.7/site-packages/Django-1.4.8-py2.7.egg/django/core/management/base.py", line 196, in run_from_argv
    self.execute(*args, **options.__dict__)
  File "/Users/anu/code/vGA_Migration/lib/python2.7/site-packages/Django-1.4.8-py2.7.egg/django/core/management/base.py", line 232, in execute
    output = self.handle(*args, **options)
  File "/usr/local/lib/python2.7/site-packages/South-0.8.2-py2.7.egg/south/management/commands/migrate.py", line 111, in handle
    ignore_ghosts = ignore_ghosts,
  File "/usr/local/lib/python2.7/site-packages/South-0.8.2-py2.7.egg/south/migration/__init__.py", line 220, in migrate_app
    success = migrator.migrate_many(target, workplan, database)
  File "/usr/local/lib/python2.7/site-packages/South-0.8.2-py2.7.egg/south/migration/migrators.py", line 229, in migrate_many
    result = migrator.__class__.migrate_many(migrator, target, migrations, database)
  File "/usr/local/lib/python2.7/site-packages/South-0.8.2-py2.7.egg/south/migration/migrators.py", line 304, in migrate_many
    result = self.migrate(migration, database)
  File "/usr/local/lib/python2.7/site-packages/South-0.8.2-py2.7.egg/south/migration/migrators.py", line 129, in migrate
    result = self.run(migration, database)
  File "/usr/local/lib/python2.7/site-packages/South-0.8.2-py2.7.egg/south/migration/migrators.py", line 113, in run
    return self.run_migration(migration, database)
  File "/usr/local/lib/python2.7/site-packages/South-0.8.2-py2.7.egg/south/migration/migrators.py", line 83, in run_migration
    migration_function()
  File "/usr/local/lib/python2.7/site-packages/South-0.8.2-py2.7.egg/south/migration/migrators.py", line 59, in <lambda>
    return (lambda: direction(orm))
  File "/Users/anu/code/vGA_Migration/gopheranswers/askbot/migrations/0018_add___status__field_to_user_model.py", line 16, in forwards
    self.gf('django.db.models.fiedls.CharField')(default = 'w', max_length = 2),
  File "/usr/local/lib/python2.7/site-packages/South-0.8.2-py2.7.egg/south/v2.py", line 12, in gf
    return ask_for_it_by_name(field_name)
  File "/usr/local/lib/python2.7/site-packages/South-0.8.2-py2.7.egg/south/utils/__init__.py", line 27, in ask_for_it_by_name
    ask_for_it_by_name.cache[name] = _ask_for_it_by_name(name)
  File "/usr/local/lib/python2.7/site-packages/South-0.8.2-py2.7.egg/south/utils/__init__.py", line 16, in _ask_for_it_by_name
    module = __import__(modulename, {}, {}, bits[-1])
ImportError: No module named fiedls
(vGA_Migration)anu@cmbmac:[~/code/vGA_Migration/gopheranswers]$python manage.py migrate django_authopenid
Please run command

    python manage.py collectstatic
WARNING!!! You are using a 'locmem' (local memory) caching backend,
which is OK for a low volume site running on a single-process server.
For a multi-process configuration it is neccessary to have a production
cache system, such as redis or memcached.

With local memory caching and multi-process setup you might intermittently
see outdated content on your site.

relation "askbot_badgedata" does not exist
LINE 1: ..."."slug", "askbot_badgedata"."awarded_count" FROM "askbot_ba...
                                                             ^

Running migrations for django_authopenid:
 - Migrating forwards to 0005_auto__del_externallogindata.
 > django_authopenid:0001_initial
 > django_authopenid:0002_make_multiple_openids_possible
 > django_authopenid:0003_fill_in_provider_names
 > django_authopenid:0004_auto__add_field_userassociation_last_used_timestamp__add_unique_useras
 > django_authopenid:0005_auto__del_externallogindata
 - Loading initial data for django_authopenid.
Installed 0 object(s) from 0 fixture(s)

It would be great if anyone could provide some helpful information on this.