Ask Your Question
1

Why does South migration 4 failed?

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

codedigger gravatar image

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

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?

edit retag flag offensive 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 gravatar imageEvgeny ( 2011-04-26 14:08:40 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted
0

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

Evgeny gravatar image

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

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 gravatar imagecodedigger ( 2011-04-26 13:59:40 -0600 )edit
It will be better to migrate to postgres, if your existing site will work with postgresql. Is it possible?
Evgeny gravatar imageEvgeny ( 2011-04-26 14:03:55 -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

Stats

Asked: 2011-04-26 12:46:26 -0600

Seen: 121 times

Last updated: Apr 26 '11