Ask Your Question

Installation error while migrate askbot

asked 2012-04-15 18:18:08 -0600

anonymous user


I install askbot (askbot-0.7.40-py2.6) according documentation.

Everything was going ok. But i have many strange output errors while command run:

python migrate askbot

like this

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

And last this:

 > askbot:0032_auto__del_field_badgedata_multiple__del_field_badgedata_description__d
FATAL ERROR - The following SQL query failed: ALTER TABLE "askbot_badgedata" ADD CONSTRAINT "askbot_badgedata_56ae2a2a" UNIQUE ("slug")
The error was: relation "askbot_badgedata_56ae2a2a" already exists

Is it bug or not?

edit retag flag offensive close merge delete

2 Answers

Sort by ยป oldest newest most voted

answered 2012-04-15 18:25:52 -0600

Evgeny gravatar image

It is a bug related to specific versions of databases - which database are you using?

This post suggests a possible solution (seems to work for postgresql 9).

We might not be able to really fix this for a week or two due to vacations.

edit flag offensive delete link more


I have PostgreSQL 8.3.17

elgans gravatar imageelgans ( 2012-04-16 05:19:46 -0600 )edit

Yes, I have seen this post and I tryed it. However I did it on installed database. Right now I do it again on new database instanse and all pathes is done, some with errors. But it help me and now site is up. Thanks!

elgans gravatar imageelgans ( 2012-04-16 06:15:04 -0600 )edit

answered 2012-07-24 05:22:30 -0600

bgenevaux gravatar image

I had a similar error.

In fact, I had

FATAL ERROR - The following SQL query failed: ALTER TABLE "auth_user" ADD COLUMN ...

The error was: column "..." of relation "auth_user" already exists

for each migrations which add a column to the auth_user model; and at the end of the installation, I can't create any question without an error saying that the column "is_private" doesn't exist in the table askbot_post. (Besides, I tried to install askbot with both mysql 5.0 an postgresql 9.1, and the problem was here only with postgresql.)

When I looked up a little, it seems that initially, when db is synced, the auth_user model is already correct, and all the migrations modifying it failed, in particular the 0124 which add the column "is_private" to askbot_post (and because I use the last version of psycopg2, it was rolled back), so I tried to delete all the adding and modifying of auth_user, and this worked ! But this was ugly ...

Then I looked up some more, and it seems that you patched the auth_user only in the initial migration, and not in the next ones, so I tried to use the safe_add_column method (instead of add_column) for all these adding, and once again it worked and it is much nicer :-)

I still have a fatal error on the migration 0014 that I can't explain, but I will look it in a few days.

(Ah, and just to let you know, it worked with mysql because south doesn't work well with my version of mysql (isn't it funny ;-) ))

edit flag offensive delete link more


This error was fixed in the repository today, tested on postgres 8.4.11.

Evgeny gravatar imageEvgeny ( 2012-07-24 05:40:41 -0600 )edit

ok thanks.

bgenevaux gravatar imagebgenevaux ( 2012-07-24 05:58:20 -0600 )edit

I'm still getting the same error with MySQL 5.0, 5.1 and 5.5 (i tried all three)

randy gravatar imagerandy ( 2012-09-06 02:41:47 -0600 )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


Asked: 2012-04-15 18:18:08 -0600

Seen: 6,417 times

Last updated: Jul 24 '12