0

Initialization of AskBot database: `python manage.py migrate askbot` fails?
 

I am trying to install AskBot.

I follow the instructions until "Initialization and upgrade of the database for Askbot"

I execute this step:

$ python manage.py syncdb

and it completes without error.

I then execute this step:

$ python manage.py migrate askbot

and I get several pages of errors. Can someone tell me what the problem is? I include the output of python manage.py migrate askbot below:

$ 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 0161_add_field__user_languages.
 > 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-02-18 20:19:07.317870';
The error was: column "last_seen" of relation "auth_user" already exists

FATAL ERROR - The following SQL query failed: ALTER TABLE "auth_user" ADD ...
(more)

To enter a block of code:

  • enter empty line after your previous text
  • paste or type the code
  • select the code and press the button above
Preview: (hide)
user1131467's avatar
1
user1131467
asked 12 years ago

Comments

Are you on MySQL?

Evgeny's avatar Evgeny (12 years ago)

@Evgeny: No, Postgresql 9.1 on Ubuntu 12.10 64. I've also tried it with MySQL but I get the same error. I start from a totally clean install of Ubuntu 12.10 and followed the instructions on the site precisely.

user1131467's avatar user1131467 (12 years ago)

I was going to deploy this step to the problem

hincent's avatar hincent (7 years ago)
see more comments

1 Answer

0

Are you using the release from pypi? this error is fixed on the github repo

To enter a block of code:

  • enter empty line after your previous text
  • paste or type the code
  • select the code and press the button above
Preview: (hide)
Fitoria's avatar
1.1k
Fitoria
answered 12 years ago
link

Comments

Yes I was using pip install askbot as per the instructions. I now changed to use the development version, and now I don't get the final error, but I sill get all of the other ones. Should I just ignore the other errors? All the already exists errors?

user1131467's avatar user1131467 (12 years ago)

Yes just ignore them there are question similar to this one with longer details on why this happens ;-)

Fitoria's avatar Fitoria (12 years ago)
see more comments