Ask Your Question
0

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

asked 2013-02-18 20:27:56 -0500

user1131467 gravatar image

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)
edit retag flag offensive close merge delete

Comments

Are you on MySQL?

Evgeny gravatar imageEvgeny ( 2013-02-19 14:54:57 -0500 )edit

@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 gravatar imageuser1131467 ( 2013-02-19 15:02:30 -0500 )edit

I was going to deploy this step to the problem

hincent gravatar imagehincent ( 2017-07-10 04:56:34 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted
0

answered 2013-02-19 10:43:15 -0500

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

edit flag offensive delete link more

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 gravatar imageuser1131467 ( 2013-02-19 14:53:57 -0500 )edit

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

Fitoria gravatar imageFitoria ( 2013-02-19 17:11:58 -0500 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

Stats

Asked: 2013-02-18 20:27:56 -0500

Seen: 918 times

Last updated: Feb 19 '13