Migrate askbot failed

migrate
database
retag add tags

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; []

asked 2012-02-14 19:44:06 -0600

edit flag offensive 0 remove flag close merge delete

Comments

I'm the Anonymous

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

@northlander: the FBI will be happy to hear!

piskvorky (2012-02-15 03:20:02 -0600) edit

add a comment see more comments

2 Answers

Sort by

oldest

newest

most voted

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?

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 (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 (2012-02-15 19:22:56 -0600) edit

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

northlander (2012-02-20 04:48:39 -0600) edit

add a comment see more comments

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

answered 2012-02-14 20:45:18 -0600

edit flag offensive 0 remove flag delete link

Comments

add a comment see more comments

Migrate askbot failed edit

Comments

2 Answers

Comments

Comments

Migrate askbot failed