First time here? Check out the FAQ!
0

Migrate askbot failed

I got error message when run the following cmd:

python manage.py migrate askbot


(1146, "Table 'askbot.askbot_badgedata' doesn't exist") Running migrations for askbot: - Migrating forwards to 0051_proxify_qa_rev_models.

askbot:0020_auto__add_field_repute_comment__chg_field_repute_question ! Error found during real run of migration! Aborting.

! Since you have a database that does not support running ! schema-altering statements in transactions, we have had ! to leave it in an interim state between migrations.

! You might be able to recover with: = ALTER TABLE repute DROP COLUMN comment CASCADE; []


anonymous user
asked 2012-02-14 19:44:06 -0600
edit flag offensive 0 remove flag close merge delete

Comments

1

I'm the Anonymous

northlander's avatar northlander (2012-02-14 20:48:31 -0600) edit

@northlander: the FBI will be happy to hear!

piskvorky's avatar piskvorky (2012-02-15 03:20:02 -0600) edit
add a comment see more comments

2 Answers

0

I fixed this problem with an --all option added. That is:

python manage.py syncdb --all

But got new problem:

python manage.py migrate askbot
Running migrations for askbot:
- Migrating forwards to 0051_proxify_qa_rev_models.
> askbot:0020_auto__add_field_repute_comment__chg_field_repute_question
! Error found during real run of migration! Aborting.

How can i fix this?

northlander's avatar
1
northlander
answered 2012-02-14 20:45:18 -0600
edit flag offensive 0 remove flag delete link

Comments

add a comment see more comments
0

You have to run all migrations, the syncdb --all will not work.

Which database are you using and what is the version of the database engine?

Evgeny's avatar
13.2k
Evgeny
answered 2012-02-14 21:07:38 -0600
edit flag offensive 0 remove flag delete link

Comments

It is mysql 5.5.20.

northlander's avatar northlander (2012-02-15 19:21:35 -0600) edit

Can you try with 5.1? there is an unsolved issue with MySQL 5.5. Tested with 5.1 recently.

Evgeny's avatar Evgeny (2012-02-15 19:22:56 -0600) edit

I need to find a new server to do that test. let me try....

northlander's avatar northlander (2012-02-20 04:48:39 -0600) edit
add a comment see more comments