umang's profile - activity

TechStack: Django==1.4, askbot==0.7.49, (PostgreSQL) 9.1.9, psycopg2==2.4.5

When i try to start a fresh installation on a fresh DB the migrations are failing. It shows fatal error with alter table commands failing and migration halts in the middle.

Steps to reproduce: 1) Create a db in postgres: Create database askbot_test; 2) Create a virtualenv askbot 3) Install askbot and django 4) Configure the DB settings in the local django project created. 5) Run commands python manage.py syncdb ( successful ) python manage.py migrate askbot ( fails )

Error Stacktrace:

Running migrations for askbot: - Migrating forwards to 0170_auto__add_field_group_read_only.

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 "hide_ignored_questions" boolean NOT NULL DEFAULT False; The error was: column "hide_ignored_questions" 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 "tag_filter_setting" varchar(16) NOT NULL DEFAULT 'ignored'; The error was: column "tag_filter_setting" 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 '2014-02-04 15:45:25.071122'; The error was: column "last_seen" of relation "auth_user" already exists

FATAL ERROR - The following SQL query failed ... (more)

Hi,

I am using ASKBOT 0.7.48 and Django 1.4. DB is postgres

I am unable to run migrations successfully. The process exits in middle of migration raising an unexpected error.

There was a related issue question - 10912 but i am not sure if this has been fixed for postgres backend too. Please help me resolve the issue.

Stacktrace:

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__ 0x2a76650="" at="" object="">' subscription for admin (1)</django.utils.functional.__proxy__>

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

probably already have column User.response_count Error in migration: askbot:0013_add_response_count__to_user

Traceback (most recent call last):
  File "manage.py", line 22, in <module>
    execute_manager(settings)
  File "/home/ubuntu/.virtualenvs/forums/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 459, in execute_manager
    utility.execute()
  File "/home/ubuntu/.virtualenvs/forums/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/ubuntu/.virtualenvs/forums/local/lib/python2.7/site-packages/django/core/management/base.py", line 196, in run_from_argv
    self.execute(*args, **options.__dict__)
  File "/home/ubuntu/.virtualenvs/forums/local/lib/python2.7/site-packages/django/core/management/base.py", line 232, in execute
    output = self.handle(*args, **options)
  File "/home/ubuntu/.virtualenvs/forums/local/lib/python2.7/site-packages/south/management/commands/migrate.py", line 111, in handle
    ignore_ghosts = ignore_ghosts,
  File "/home/ubuntu/.virtualenvs/forums/local/lib/python2.7/site-packages/south/migration/__init__.py", line 220, in migrate_app
    success = migrator.migrate_many(target, workplan, database)
  File "/home/ubuntu/.virtualenvs/forums/local/lib/python2.7/site-packages/south/migration/migrators.py", line 232, in migrate_many
    result = migrator.__class__.migrate_many(migrator, target, migrations, database)
  File "/home/ubuntu/.virtualenvs/forums/local/lib/python2.7/site-packages/south/migration/migrators.py", line 307, in migrate_many
    result = self.migrate(migration, database)
  File "/home/ubuntu/.virtualenvs/forums/local/lib/python2.7/site-packages/south/migration/migrators.py", line 132, in migrate
    result = self.run(migration, database)
  File "/home/ubuntu/.virtualenvs/forums/local/lib/python2.7/site-packages/south/migration/migrators.py", line 116, in run
    return self.run_migration(migration, database)
  File "/home/ubuntu/.virtualenvs/forums/local/lib/python2.7/site-packages/south/migration/migrators.py", line 91, in run_migration
    self.record(migration, database)
  File "/home/ubuntu/.virtualenvs/forums/local/lib/python2.7/site-packages/south/migration/migrators.py", line 267, in record
    record = MigrationHistory.for_migration(migration, database)
  File "/home/ubuntu/.virtualenvs/forums/local/lib/python2.7/site-packages/south/models.py", line 21, in for_migration
    migration=migration.name(),
  File "/home/ubuntu/.virtualenvs/forums/local/lib/python2.7/site-packages/django/db/models ...

(more)