First time here? Check out the FAQ!
1

Why does South migration 4 failed?

I'm new to askbot. Trying to set up askbot 0.6.79 with MySQL. When running python manage.py migrate askbot, at for 0040_delete_old_tag_filter_strategies. I'm getting this error:

.../MySQLdb/connections.py", line 36, in defaulterrorhandler _mysql_exceptions.OperationalError: (1214, "The used table type doesn't support FULLTEXT indexes")

What's wrong?

codedigger's avatar
41
codedigger
updated 2011-04-26 13:56:28 -0500, asked 2011-04-26 12:46:26 -0500
edit flag offensive 0 remove flag close merge delete

Comments

It is migration 40, the last one. In this case django runs migrations as one transaction, since one of the migrations failed, the whole transaction fails, therefore it reports an error on transaction 40.
Evgeny's avatar Evgeny (2011-04-26 14:08:40 -0500) edit
add a comment see more comments

1 Answer

0

Askbot will only work with MyISAM storage engine of MySQL, because it is the only one that supports full text search, looks like the engine you are using currently is different (probably InnoDB).

If at all possible - please use postgresql, it is much better.

Evgeny's avatar
13.2k
Evgeny
answered 2011-04-26 13:37:27 -0500
edit flag offensive 0 remove flag delete link

Comments

Ah, thanks for the quick response. What if I have a Django site already using MySQL InnoDB with 100+ tables? Should I keep askbot in a different db, or you still strongly recommend I migrate the whole db to Postgre?
codedigger's avatar codedigger (2011-04-26 13:59:40 -0500) edit
It will be better to migrate to postgres, if your existing site will work with postgresql. Is it possible?
Evgeny's avatar Evgeny (2011-04-26 14:03:55 -0500) edit
add a comment see more comments