Ask Your Question

Why does South migration 4 failed?

asked 2011-04-26 12:46:26 -0500

codedigger's avatar

updated 2011-04-26 13:56:28 -0500

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

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

What's wrong?

edit retag flag offensive close merge delete


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

1 Answer

Sort by ยป oldest newest most voted

answered 2011-04-26 13:37:27 -0500

Evgeny's avatar

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.

edit flag offensive delete link more


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

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: 2011-04-26 12:46:26 -0500

Seen: 227 times

Last updated: Apr 26 '11